insert/
insert.rs

1use anyhow::Result;
2use flyer_orm::{DB, databases::sqlite::SQLite};
3use serde::Serialize;
4
5#[derive(Debug, sqlx::FromRow, Serialize)]
6pub struct User {
7    pub uuid: String,
8    pub created_at: String,
9    pub first_name: String,
10    pub last_name: String,
11    pub email: String,
12    pub password: String,
13}
14
15const TABLE: &'static str = "CREATE TABLE users (
16 `uuid` VARCHAR(65535) PRIMARY KEY NOT NULL UNIQUE,
17 `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
18 `first_name` VARCHAR(65535),
19 `last_name` VARCHAR(65535),
20 `email` VARCHAR(65535) NOT NULL,
21 `password` VARCHAR(65535) NOT NULL
22)";
23
24
25#[tokio::main]
26async fn main() -> Result<()> {
27    let db = DB::db_with_url::<SQLite>(":memory:").await;
28
29
30    // db.query()
31
32
33
34    return Ok(());
35}
insert/insert.rs

insert/
insert.rs
