Documentation

Granite

Github Amber

Search…

Granite

Documentation

Getting Started
Installation
Add this library to your projects dependencies along with the driver in your shard.yml. This can be used with any framework but was originally designed to work with the amber framework in mind. This library will work with Kemal or any other framework as well.
1
dependencies:
2
  granite:
3
    github: amberframework/granite
4
​
5
  # Pick your database
6
  mysql:
7
    github: crystal-lang/crystal-mysql
8
​
9
  sqlite3:
10
    github: crystal-lang/crystal-sqlite3
11
​
12
  pg:
13
    github: will/crystal-pg
Copied!
Register a Connection
Next you will need to register a connection. This should be one of the first things in your main Crystal file, before Granite is required.
1
Granite::Connections << Granite::Adapter::Mysql.new(name: "mysql", url: "YOUR_DATABASE_URL")
2
​
3
# Rest of code...
Copied!
Supported adapters include: Mysql, Pg, and Sqlite.
Example Model
Here is an example Granite model using the connection registered above.
1
require "granite/adapter/mysql"
2
​
3
class Post < Granite::Base
4
  connection mysql
5
  table posts # Name of the table to use for the model, defaults to class name snake cased
6
​
7
  column id : Int64, primary: true # Primary key, defaults to AUTO INCREMENT
8
  column name : String? # Nilable field
9
  column body : String # Not nil field
10
end
Copied!
Additional Documentation
​Models​
​CRUD​
​Querying​
​Relationships​
​Validation​
​Callbacks​
​Migrations​
​Imports​

docs

Model Usage

Last modified 2yr ago

Copy link

Contents

Getting Started

Installation

Example Model

Additional Documentation