Getting Started with Seaography

[dependencies]sea-orm = { version = "^0.9", features = [ ... ] }+ seaography = { version = "^0.1", features = [ "with-decimal", "with-chrono" ] }+ async-graphql = { version = "4.0.10", features = ["decimal", "chrono", "dataloader"] }+ async-graphql-poem = { version = "4.0.10" }

use sea_orm::entity::prelude::*;#[derive(    Clone,    Debug,    PartialEq,    DeriveEntityModel,+   async_graphql::SimpleObject,+   seaography::macros::Filter,)]+ #[graphql(complex)]+ #[graphql(name = "FilmActor")]#[sea_orm(table_name = "film_actor")]pub struct Model {    #[sea_orm(primary_key, auto_increment = false)]    pub actor_id: i32,    #[sea_orm(primary_key, auto_increment = false)]    pub film_id: i32,    pub last_update: DateTimeUtc,}#[derive(    Copy,    Clone,    Debug,    EnumIter,    DeriveRelation,+   seaography::macros::RelationsCompact,)]pub enum Relation {    #[sea_orm(        belongs_to = "super::film::Entity",        from = "Column::FilmId",        to = "super::film::Column::FilmId",        on_update = "Cascade",        on_delete = "NoAction"    )]    Film,    #[sea_orm(        belongs_to = "super::actor::Entity",        from = "Column::ActorId",        to = "super::actor::Column::ActorId",        on_update = "Cascade",        on_delete = "NoAction"    )]    Actor,}

#[derive(Debug, seaography::macros::QueryRoot)]#[seaography(entity = "crate::entities::actor")]#[seaography(entity = "crate::entities::film")]#[seaography(entity = "crate::entities::film_actor")]pub struct QueryRoot;

use sea_orm::prelude::*;pub mod entities;pub mod query_root;pub use query_root::QueryRoot;pub struct OrmDataloader {    pub db: DatabaseConnection,}

use async_graphql::{    dataloader::DataLoader,    http::{playground_source, GraphQLPlaygroundConfig},    EmptyMutation, EmptySubscription, Schema,};use async_graphql_poem::GraphQL;use poem::{handler, listener::TcpListener, web::Html, IntoResponse, Route, Server};use sea_orm::Database;use seaography_example_project::*;// ...#[handler]async fn graphql_playground() -> impl IntoResponse {    Html(playground_source(GraphQLPlaygroundConfig::new("/")))}#[tokio::main]async fn main() {    // ...    let database = Database::connect(db_url).await.unwrap();    let orm_dataloader: DataLoader<OrmDataloader> = DataLoader::new(        OrmDataloader { db: database.clone() },        tokio::spawn,    );    let schema = Schema::build(QueryRoot, EmptyMutation, EmptySubscription)        .data(database)        .data(orm_dataloader)        .finish();    let app = Route::new()        .at("/", get(graphql_playground)        .post(GraphQL::new(schema)));    Server::new(TcpListener::bind("0.0.0.0:8000"))        .run(app)        .await        .unwrap();}

cargo install seaography-cli

# The command take three argumentsseaography-cli <DATABASE_URL> <CRATE_NAME> <DESTINATION># MySQLseaography-cli mysql://root:root@localhost/sakila seaography-mysql-example examples/mysql# PostgreSQLseaography-cli postgres://root:root@localhost/sakila seaography-postgres-example examples/postgres# SQLiteseaography-cli sqlite://examples/sqlite/sakila.db seaography-sqlite-example examples/sqliteql

$ cargo runPlayground: http://localhost:8000

{  film(    pagination: { limit: 3, page: 0 }    filters: { releaseYear: { gte: "2006" } }    orderBy: { title: ASC }  ) {    data {      filmId      title      description      releaseYear      filmActor {        actor {          actorId          firstName          lastName        }      }    }    pages    current  }}

{  "data": {    "film": {      "data": [        {          "filmId": 1,          "title": "ACADEMY DINOSAUR",          "description": "An Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies",          "releaseYear": "2006",          "filmActor": [            {              "actor": {                "actorId": 1,                "firstName": "PENELOPE",                "lastName": "GUINESS"              }            },            {              "actor": {                "actorId": 10,                "firstName": "CHRISTIAN",                "lastName": "GABLE"              }            },            // ...          ]        },        {          "filmId": 2,          "title": "ACE GOLDFINGER",          "description": "A Astounding Epistle of a Database Administrator And a Explorer who must Find a Car in Ancient China",          "releaseYear": "2006",          "filmActor": [            // ...          ]        },        // ...      ],      "pages": 334,      "current": 0    }  }}

SELECT "film"."film_id",       "film"."title",       "film"."description",       "film"."release_year",       "film"."language_id",       "film"."original_language_id",       "film"."rental_duration",       "film"."rental_rate",       "film"."length",       "film"."replacement_cost",       "film"."rating",       "film"."special_features",       "film"."last_update"FROM "film"WHERE "film"."release_year" >= '2006'ORDER BY "film"."title" ASCLIMIT 3 OFFSET 0SELECT "film_actor"."actor_id", "film_actor"."film_id", "film_actor"."last_update"FROM "film_actor"WHERE "film_actor"."film_id" IN (1, 3, 2)SELECT "actor"."actor_id", "actor"."first_name", "actor"."last_name", "actor"."last_update"FROM "actor"WHERE "actor"."actor_id" IN (24, 162, 20, 160, 1, 188, 123, 30, 53, 40, 2, 64, 85, 198, 10, 19, 108, 90)