6 releases (2 breaking)

1.0.0-rc.2 Jul 29, 2023
1.0.0-rc.1 Jul 28, 2023
0.3.0 Dec 2, 2022
0.2.0 Oct 31, 2022
0.1.2 Sep 19, 2022

#1829 in Database interfaces

Download history 56/week @ 2023-08-13 58/week @ 2023-08-20 33/week @ 2023-08-27 37/week @ 2023-09-03 50/week @ 2023-09-10 226/week @ 2023-09-17 121/week @ 2023-09-24 73/week @ 2023-10-01 44/week @ 2023-10-08 44/week @ 2023-10-15 47/week @ 2023-10-22 31/week @ 2023-10-29 52/week @ 2023-11-05 57/week @ 2023-11-12 30/week @ 2023-11-19 72/week @ 2023-11-26

211 downloads per month

MIT/Apache

2MB
4K SLoC

Seaography logo

🧭 A GraphQL framework and code generator for SeaORM

crate docs build status

Seaography

Seaography is a GraphQL framework for building GraphQL resolvers using SeaORM entities. It ships with a CLI tool that can generate ready-to-compile Rust GraphQL servers from existing MySQL, Postgres and SQLite databases.

Benefits

  • Quick and easy to get started
  • Generates readable code
  • Extensible project structure
  • Based on popular async libraries: async-graphql and SeaORM

Features

  • Relational query (1-to-1, 1-to-N)
  • Pagination for queries and relations (1-N)
  • Filtering with operators (e.g. gt, lt, eq)
  • Order by any column
  • Guard fields, queries or relations
  • Rename fields

(Right now there is no mutation, but it's on our plan!)

Quick start - ready to serve in 3 minutes!

Install

cargo install sea-orm-cli@^0.12 # used to generate entities
cargo install seaography-cli@1

MySQL

Setup the sakila sample database.

cd examples/mysql
sea-orm-cli generate entity -o src/entities -u mysql://user:pw@127.0.0.1/sakila --seaography
seaography-cli ./ src/entities mysql://user:pw@127.0.0.1/sakila seaography-mysql-example
cargo run

Go to http://localhost:8000/ and try out the following queries:

Fetch films and their actors

{
  film(pagination: { page: { limit: 10, page: 0 } }, orderBy: { title: ASC }) {
    nodes {
      title
      description
      releaseYear
      actor {
        nodes {
          firstName
          lastName
        }
      }
    }
  }
}

Fetch store and its employee

{
  store(filters: { storeId: { eq: 1 } }) {
    nodes {
      storeId
      address {
        address
        address2
      }
      staff {
        firstName
        lastName
      }
    }
  }
}

Fetch inactive customers with pagination

{
  customer(
    filters: { active: { eq: 0 } }
    pagination: { page: { page: 2, limit: 3 } }
  ) {
    nodes {
      customerId
      lastName
      email
    }
    paginationInfo {
      pages
      current
    }
  }
}

The query above using cursor pagination

{
  customer(
    filters: { active: { eq: 0 } }
    pagination: { cursor: { limit: 3, cursor: "Int[3]:271" } }
  ) {
    nodes {
      customerId
      lastName
      email
    }
    pageInfo {
      hasPreviousPage
      hasNextPage
      endCursor
    }
  }
}

Complex query with filters on relations

Find all inactive customers, include their address, and their payments with amount greater than 7 ordered by amount the second result

{
  customer(
    filters: { active: { eq: 0 } }
    pagination: { cursor: { limit: 3, cursor: "Int[3]:271" } }
  ) {
    nodes {
      customerId
      lastName
      email
      address {
        address
      }
      payment(
        filters: { amount: { gt: "7" } }
        orderBy: { amount: ASC }
        pagination: { page: { limit: 1, page: 1 } }
      ) {
        nodes {
          paymentId
          amount
        }
        paginationInfo {
          pages
          current
        }
        pageInfo {
          hasPreviousPage
          hasNextPage
        }
      }
    }
    pageInfo {
      hasPreviousPage
      hasNextPage
      endCursor
    }
  }
}

Filter using enumeration

{
  film(
    filters: { rating: { eq: NC17 } }
    pagination: { page: { page: 1, limit: 5 } }
  ) {
    nodes {
      filmId
      rating
    }
  }
}

Postgres

Setup the sakila sample database.

cd examples/postgres
sea-orm-cli generate entity -o src/entities -u postgres://user:pw@localhost/sakila --seaography
seaography-cli ./ src/entities postgres://user:pw@localhost/sakila seaography-postgres-example
cargo run

SQLite

cd examples/sqlite
sea-orm-cli generate entity -o src/entities -u sqlite://sakila.db --seaography
seaography-cli ./ src/entities sqlite://sakila.db seaography-sqlite-example
cargo run

Contribution

Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.

Seaography is a community driven project. We welcome you to participate, contribute and together build for Rust's future.

Dependencies

~17–32MB
~595K SLoC