# Aragog

aragog is a simple lightweight ODM and OGM library for ArangoDB using the arangors driver. The main concept is to provide behaviors allowing to synchronize documents and structs as simply an lightly as possible.

The crate provides a powerful AQL querying tool allowing complex graph queries in Rust

### Features

By now the available features are: * Creating a database connection pool from a defined schema.yaml * Structures can implement different behaviors: * Record: The structure can be written into a ArangoDB collection as well as retrieved, from its _key or other query arguments. * New: The structure can be initialized from an other type (a form for example). It allows to maintain a privacy level in the model and to use different data formats. * Update: The structure can be updated from an other type (a form for example). It allows to maintain a privacy level in the model and to use different data formats. * Validate: The structure can perform simple validations before being created or saved into the database. * Authenticate: The structure can define a authentication behaviour from a secret (a password for example) * AuthorizeAction: The structure can define authorization behavior on a target record with custom Action type. * Link: The structure can define relations with other models based on defined queries. * ForeignLink: The structure can define relations with other models based on defined foreign key. * Different operations can return a ServiceError error that can easily be transformed into a Http Error (can be used for the actix framework)

#### Cargo features

##### Async and Blocking

By default all aragog items are asynchronous, you can compile aragog in a synchronous build using the blocking feature:

toml aragog = { version = "0.7", features = ["blocking"], default-features = false }

You need to disable the default features. Don't forget to add the derive feature to use the derive macros.

##### Actix and Open API

If you use this crate with the actix-web framework, you may want the aragog errors to be usable as http errors. To do so you can add to your cargo.toml the following feature: actix. This will add Actix 3 dependency and compatibility

toml aragog = { version = "0.7", features = ["actix"] }

If you also want to be able to use paperclip, you may want aragog elements to be compatible. To do so you can add to your cargo.toml the following feature: open-api.

toml aragog = { version = "0.7", features = ["actix", "open-api"] }

##### Password hashing

You may want aragog to provide a more complete Authenticate trait allowing to hash and verify passwords. To do so you can add to your cargo.toml the following feature: password_hashing.

toml aragog = { version = "0.7", features = ["password_hashing"] }

It will add two functions in the Authenticate trait:

rust ignore fn hash_password(password: &str, secret_key: &str) -> Result<String, ServiceError>; fn verify_password(password: &str, password_hash: &str, secret_key: &str) -> Result<(), ServiceError>;

• hash_password will return a Argon2 encrypted password hash you can safely store to your database

• verify_password will check if the provided password matches the Argon2 encrypted hash you stored.

  The Argon2 encryption is based on the argonautica crate. That crate requires the clang lib, so if you deploy on docker you will need to install it or define a custom image.

  Schema and collections

  In order for everything to work you need a schema.yaml file. Use the aragog_cli to create migrations and generate the schema.

  Creating a pool

  To connect to the database and initialize a connection pool you may use the following builder pattern options:

  rust let db_pool = DatabaseConnectionPool::builder() // You can specify a host and credentials with this method. // Otherwise, the builder will look for the env vars: `DB_HOST`, `DB_NAME`, `DB_USER` and `DB_PASSWORD`. .with_credentials("http://localhost:8529", "db", "user", "password") // You can specify a authentication mode between `Basic` and `Jwt` // Otherwise the default value will be used (`Basic`). .with_auth_mode(AuthMode::Basic) // You can specify a schema path to initialize the database pool // Otherwise the env var `SCHEMA_PATH` or the default value `config/db/schema.yaml` will be used. .with_schema_path("config/db/schema.yaml") // If you prefer you can use your own custom schema .with_schema(DatabaseSchema::load("config/db/schema.yaml").unwrap()) // The schema wil silently apply to the database, useful only if you don't use the CLI and migrations .apply_schema() // You then need to build the pool .build() .await .unwrap(); None of these options are mandatory.

  Record

  The global architecture is simple, every model you define that can be synced with the database must implement serde::Serialize, serde::Deserialize and Clone. To declare a struct as a Model it must derive from aragog::Record (the collection name must be the same as the struct) or implement it.

  If you want any of the other behaviors you can implement the associated trait:

  The final model structure will be an Exact representation of the content of a ArangoDB document, so without its _key, _id and _rev. Your project should contain some models folder with every struct representation of your database documents.

  The real representation of a complete document is DatabaseRecord<T> where T is your model structure.

  Example:

  ```rust use aragog::{Record, DatabaseConnectionPool, DatabaseRecord, Validate, AuthMode}; use serde::{Serialize, Deserialize}; use tokio;

  [derive(Serialize, Deserialize, Clone, Record, Validate)]

  pub struct User { pub username: String, pub firstname: String, pub lastname: String, pub age: usize }

  [tokio::main]

  async fn main() { // Database connection Setup

  std::env::setvar("SCHEMAPATH", "tests/schema.yaml");

  let databasepool = DatabaseConnectionPool::builder() .build() .await .unwrap(); // Define a document let mut user = User { username: String::from("LeRevenant1234"), firstname: String::from("Robert"), lastname: String::from("Surcouf"), age: 18 }; // userrecord is a DatabaseRecord let mut userrecord = DatabaseRecord::create(user, &databasepool).await.unwrap(); // You can access and edit the document userrecord.record.username = String::from("LeRevenant1524356"); // And directly save it userrecord.save(&database_pool).await; } ```

  Edge Record

  You can declare Edge collection models by deriving from aragog::EdgeRecord, the structure requires two string fields: _from and _to. When deriving from EdgeRecord the struct will also automatically derive from Record so you'll need to implement Validate as well.

  Example:

  ```rust

  [derive(Serialize, Deserialize, Clone, Record, Validate)]

  pub struct Dish { pub name: String, pub price: usize }

  [derive(Serialize, Deserialize, Clone, Record, Validate)]

  pub struct Order { pub name: String, }

  [derive(Serialize, Deserialize, Clone, EdgeRecord, Validate)]

  pub struct PartOf { pub _from: String, pub _to: String, }

  [tokio::main]

  async fn main() { // Define a document let mut dish = DatabaseRecord::create(Dish { name: "Pizza".tostring(), price: 10, }, &databasepool).await.unwrap(); let mut order = DatabaseRecord::create(Order { name: "Order 1".tostring(), }, &databasepool).await.unwrap();

  let edge = DatabaseRecord::link(&dish, &order, &databasepool, |from, to| { PartOf { _from, _to } }).await.unwrap(); asserteq!(&edge.record.from(), &dish.id); asserteq!(&edge.record.to(), &order.id); asserteq!(&edge.record.fromkey(), &dish.key); asserteq!(&edge.record.to_key(), &order.key); } ```

  Querying

  You can retrieve a document from the database as simply as it gets, from the unique ArangoDB _key or from multiple conditions. The example below show different ways to retrieve records, look at each function documentation for more exhaustive exaplanations.

  Example ```rust // User creation let record = DatabaseRecord::create(user, &database_pool).await.unwrap();

  // Find with the primary key or.. let userrecord = User::find(&record.key, &databasepool).await.unwrap(); // .. Generate a query and.. let query = User::query().filter(Filter::new(Comparison::field("lastname").equalsstr("Surcouf")).and(Comparison::field("age").greaterthan(15))); // get the only record (fails if no or multiple records) let userrecord = User::get(query, &database_pool).await.unwrap().uniq().unwrap();

  // Find all users with multiple conditions let query = User::query().filter(Filter::new(Comparison::field("lastname").like("%Surc%")).and(Comparison::field("age").inarray(&[15,16,17,18]))); let clone_query = query.clone(); // we clone the query

  // This syntax is valid... let userrecords = User::get(query, &databasepool).await.unwrap(); // ... This one too let userrecords = clonequery.call(&databasepool).await.unwrap().getrecords::(); You can simplify the previous queries with some tweaks and macros: rust

  [macro_use]

  extern crate aragog;

  let record = DatabaseRecord::create(user, &database_pool).await.unwrap();

  // Find a user with a query let query = User::query().filter(compare!(field "lastname").equalsstr("Surcouf").and(compare!(field "age").greater_than(15)));

  // get the only record (fails if no or multiple records) let userrecord = User::get(query, &databasepool).await.unwrap().uniq().unwrap();

  // Find all users with multiple conditions let query = User::query().filter(compare!(field "lastname").like("%Surc%").and(compare!(field "age").inarray(&[15,16,17,18]))); let clonequery = query.clone(); // This syntax is valid... let userrecords = User::get(query, &databasepool).await.unwrap(); // ... This one too let userrecords = clonequery.call(&databasepool).await.unwrap().get_records::(); ```

  Query Object

  You can intialize a query in the following ways:

• Query::new("CollectionName")
• Object.query() (only works if Object implements Record)

• query!("CollectionName")

  You can customize the query with the following methods:

• filter() you can specify AQL comparisons
• prune() you can specify blocking AQL comparisons for traversal queries
• sort() you can specify fields to sort with
• limit() you can skip and limit the query results

• distinct() you can skip duplicate documents

  The order of operations will be respected in the rendered AQL query (except for distinct)

  you can then call a query in the following ways:

• query.call::<Object>(&database_connection_pool)

• Object::get(query, &database_connection_pool

  Which will return a JsonQueryResult containing a Vec of serde_json::Value. JsonQueryResult can return deserialized models as DatabaseRecord by calling .get_records::<T>()

  Filter

  You can initialize a Filter with Filter::new(comparison)

  Each comparison is a Comparison struct built via ComparisonBuilder: ```rust ignore // for a simple field comparison

  // Explicit Comparison::field("somefield").somecomparison("comparedvalue"); // Macro compare!(field "somefield").somecomparison("comparedvalue");

  // for field arrays (see ArangoDB operators)

  // Explicit Comparison::all("somefieldarray").somecomparison("comparedvalue"); // Macro compare!(all "somefieldarray").somecomparison("comparedvalue");

  // Explicit Comparison::any("somefieldarray").somecomparison("comparedvalue"); // Macro compare!(any "somefieldarray").somecomparison("comparedvalue");

  // Explicit Comparison::none("somefieldarray").somecomparison("comparedvalue"); // Macro compare!(none "somefieldarray").somecomparison("comparedvalue"); ``` All the currently implemented comparison methods are listed under ComparisonBuilder documentation page.

  Filters can be defined explicitely like this:

  ```rust

  use aragog::query::{Comparison, Filter};

  let filter = Filter::new(Comparison::field("name").equals_str("felix")); ```

  or

  ```rust

  use aragog::query::{Comparison, Filter};

  let filter :Filter = Comparison::field("name").equals_str("felix").into(); ```

  Traversal Querying

  You can use graph features with sub-queries with different ways:

  Straightforward Traversal query

• Explicit way rust let query = Query::outbound(1, 2, "edgeCollection", "User/123"); let query = Query::inbound(1, 2, "edgeCollection", "User/123"); let query = Query::any(1, 2, "edgeCollection", "User/123"); // Named graph let query = Query::outbound_graph(1, 2, "NamedGraph", "User/123"); let query = Query::inbound_graph(1, 2, "NamedGraph", "User/123"); let query = Query::any_graph(1, 2, "NamedGraph", "User/123");

• Implicit way from a DatabaseRecord<T>

  rust ignore let query = user_record.outbound_query(1, 2, "edgeCollection"); let query = user_record.inbound_query(1, 2, "edgeCollection"); // Named graph let query = user_record.outbound_graph(1, 2, "NamedGraph"); let query = user_record.inbound_graph(1, 2, "NamedGraph");

  Sub queries

  Queries can be joined together through

• Edge traversal:

  ```rust

  use aragog::query::Query;

  let query = Query::new("User") .join_inbound(1, 2, false, Query::new("edgeCollection")); ```

• Named Graph traversal:

  ```rust

  use aragog::query::Query;

  let query = Query::new("User") .join_inbound(1, 2, true, Query::new("SomeGraph")); ```

  It works with complex queries:

  ```rust

  use aragog::query::{Query, Comparison};

  let query = Query::new("User") .filter(Comparison::field("age").greaterthan(10).into()) .joininbound(1, 2, false, Query::new("edgeCollection") .sort("key", None) .joinoutbound(1, 5, true, Query::new("SomeGraph") .filter(Comparison::any("roles").like("%Manager%").into()) .distinct() ) ); ```

  TODO

• Query system:

  • [ ] Advanced query system supporting:
    • [X] Array variant querying (ANY, NONE, ALL)
    • [X] Sort, limit and distinct methods
    • [ ] Custom return system
    • [X] PRUNE operation
    • [ ] Procedural Macros for syntax simplification and field presence validation at compile time
    • [ ] ArangoDB functions (LENGTH, ABS, etc.)
• ORM and OGM
  • [X] Pundit like authorizations (authorize actions on model)
  • [X] Relations
  • [X] Named Graph handling
  • [ ] Handle key-value pair system (redis like)

• Middle and long term:

  • [ ] Handle revisions/concurrency correctly
  • [ ] Implement Transactions
  • [ ] Define possible async validations for database advance state check

  Arango db setup

  Installation (See official documentation [Here][arango_doc])

• [Download Link][arango_download]

• Run it with /usr/local/sbin/arangod The default installation contains one database _system and a user named root
• Create a user and database for the project with the arangosh shell rust arangosh> db._createDatabase("DB_NAME"); arangosh> var users = require("@arangodb/users"); arangosh> users.save("DB_USER", "DB_PASSWORD"); arangosh> users.grantDatabase("DB_USER", "DB_NAME"); > It is a good practice to create a test db and a development db.

• you can connect to the new created db with bash $> arangosh --server.username $DB_USER --server.database $DB_NAME

  License

  aragog is provided under the MIT license. See LICENSE. An simple lightweight ODM for ArangoDB based on arangors.

  Special thanks to fMeow creator of arangors and inzanez