rustorm

Rustorm

use rustorm::{DbError,FromDao,Pool,ToColumnNames,ToTableName,};#[derive(Debug,FromDao,ToColumnNames,ToTableName)]structActor{actor_id:i32,first_name:String,}#[cfg(any(feature="with-postgres", feature ="with-sqlite"))]fnmain(){letmut pool =Pool::new();#[cfg(feature ="with-sqlite")]let db_url ="sqlite://sakila.db";#[cfg(feature ="with-postgres")]let db_url ="postgres://postgres:p0stgr3s@localhost/sakila";let em = pool.em(db_url).unwrap();let sql ="SELECT * FROM actor LIMIT 10";let actors:Result<Vec<Actor>,DbError> =        em.execute_sql_with_return(sql,&[]);println!("Actor: {:#?}", actors);let actors = actors.unwrap();assert_eq!(actors.len(),10);for actorin actors{println!("actor: {:?}", actor);}}#[cfg(feature="with-mysql")]fnmain(){println!("see examples for mysql usage, mysql has a little difference in the api");}

use chrono::{    offset::Utc,DateTime,NaiveDate,};use rustorm::{DbError,FromDao,Pool,TableName,ToColumnNames,ToDao,ToTableName,};#[cfg(any(feature="with-postgres", feature ="with-sqlite"))]fnmain(){mod for_insert{usesuper::*;#[derive(Debug,PartialEq,ToDao,ToColumnNames,ToTableName)]pubstructActor{pubfirst_name:String,publast_name:String,}}mod for_retrieve{usesuper::*;#[derive(Debug,FromDao,ToColumnNames,ToTableName)]pubstructActor{pubactor_id:i32,pubfirst_name:String,publast_name:String,publast_update:DateTime<Utc>,}}letmut pool =Pool::new();#[cfg(feature ="with-sqlite")]let db_url ="sqlite://sakila.db";#[cfg(feature ="with-postgres")]let db_url ="postgres://postgres:p0stgr3s@localhost/sakila";let em = pool.em(db_url).unwrap();let tom_cruise = for_insert::Actor{first_name:"TOM".into(),last_name:"CRUISE".to_string(),};let tom_hanks = for_insert::Actor{first_name:"TOM".into(),last_name:"HANKS".to_string(),};let actors:Result<Vec<for_retrieve::Actor>,DbError> =        em.insert(&[&tom_cruise,&tom_hanks]);println!("Actor: {:#?}", actors);assert!(actors.is_ok());let actors = actors.unwrap();let today =Utc::now().date();assert_eq!(tom_cruise.first_name, actors[0].first_name);assert_eq!(tom_cruise.last_name, actors[0].last_name);assert_eq!(today, actors[0].last_update.date());assert_eq!(tom_hanks.first_name, actors[1].first_name);assert_eq!(tom_hanks.last_name, actors[1].last_name);assert_eq!(today, actors[1].last_update.date());}#[cfg(feature="with-mysql")]fnmain(){println!("see examples for mysql usage, mysql has a little difference in the api");}

Contributors

Code Contributors

Financial Contributors

Individuals

Organizations