Popularity
8.4
Stable
Activity
0.0
Stable
90
6
7

Programming language: Crystal
License: MIT License
Tags: ORM/ODM Extensions    
Latest version: v0.9.0

core alternatives and similar shards

Based on the "ORM/ODM Extensions" category.
Alternatively, view core alternatives based on common mentions on social networks and blogs.

Do you think we are missing an alternative of core or a related project?

Add another 'ORM/ODM Extensions' Shard

README

Onyx::SQL

Built with Crystal Travis CI build Docs API docs Latest release

A deligtful SQL ORM.

About 👋

Onyx::SQL is a deligthful database-agnostic SQL ORM for Crystal language. It features a convenient schema definition DSL, type-safe SQL query builder, clean architecture with Repository and more!

Installation 📥

Add these lines to your application's shard.yml:

dependencies:
  onyx:
    github: onyxframework/onyx
    version: ~> 0.6.0
  onyx-sql:
    github: onyxframework/sql
    version: ~> 0.9.0

This shard follows Semantic Versioning v2.0.0, so check releases and change the version accordingly.

Note that until Crystal is officially released, this shard would be in beta state (0.*.*), with every minor release considered breaking. For example, 0.1.00.2.0 is breaking and 0.1.00.1.1 is not.

You'd also need to add a database dependency conforming to the crystal-db interface. For example, pg:

dependencies:
  onyx:
    github: onyxframework/onyx
    version: ~> 0.6.0
  onyx-sql:
    github: onyxframework/sql
    version: ~> 0.9.0
+ pg:
+   github: will/crystal-pg
+   version: ~> 0.18.0

Usage 💻

For this PostgreSQL table:

CREATE TABLE users (
  id          SERIAL      PRIMARY KEY,
  name        TEXT        NOT NULL
  created_at  TIMESTAMPTZ NOT NULL  DEFAULT now()
);

Define the user schema:

require "onyx/sql"

class User
  include Onyx::SQL::Model

  schema users do
    pkey id : Int32
    type name : String, not_null: true
    type created_at : Time, not_null: true, default: true
  end
end

Insert a new user instance:

user = User.new(name: "John")
user = Onyx::SQL.query(user.insert.returning("*")).first

pp user # => #<User @id=1, @name="John", @created_at=#<Time ...>>

Query the user:

user = Onyx::SQL.query(User.where(id: 1)).first?

With another PostgreSQL table:

CREATE TABLE posts (
  id          SERIAL      PRIMARY KEY,
  author_id   INT         NOT NULL  REFERENCES  users(id),
  content     TEXT        NOT NULL
  created_at  TIMESTAMPTZ NOT NULL  DEFAULT now()
);

Define the post schema:

class Post
  include Onyx::SQL::Model

  schema posts do
    pkey id : Int32
    type author : User, not_null: true, key: "author_id"
    type content : String, not_null: true
    type created_at : Time, not_null: true, default: true
  end
end

Add the posts reference to the user schema:

class User
  include Onyx::SQL::Model

  schema users do
    pkey id : Int32
    type name : String, not_null: true
    type created_at : Time, not_null: true, default: true
+   type authored_posts : Array(Post), foreign_key: "author_id"
  end
end

Create a new post:

user = User.new(id: 1)
post = Post.new(author: user, content: "Hello, world!")
Onyx::SQL.exec(post.insert)

Query all the posts by a user with name "John":

posts = Onyx::SQL.query(Post
  .join(author: true) do |x|
    x.select(:id, :name)
    x.where(name: "John")
  end
)

posts.first # => #<Post @id=1, @author=#<User @id=1 @name="John">, @content="Hello, world!">

Documentation 📚

The documentation is available online at docs.onyxframework.org/sql.

Community 🍪

There are multiple places to talk about Onyx:

Support 🕊

This shard is maintained by me, Vlad Faust, a passionate developer with years of programming and product experience. I love creating Open-Source and I want to be able to work full-time on Open-Source projects.

I will do my best to answer your questions in the free communication channels above, but if you want prioritized support, then please consider becoming my patron. Your issues will be labeled with your patronage status, and if you have a sponsor tier, then you and your team be able to communicate with me privately in Twist. There are other perks to consider, so please, don't hesistate to check my Patreon page:

You could also help me a lot if you leave a star to this GitHub repository and spread the word about Crystal and Onyx! 📣

Contributing

  1. Fork it ( https://github.com/onyxframework/sql/fork )
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'feat: some feature') using Angular style commits
  4. Push to the branch (git push origin my-new-feature)
  5. Create a new Pull Request

Contributors

Licensing

This software is licensed under [MIT License](LICENSE).

Open Source Initiative


*Note that all licence references and agreements mentioned in the core README section above are relevant to that project's source code only.