数据库连接

支持的数据库

Sqlite
PostgreSQL
MySQL
MSSQL

启用特性

[dependencies]
ormer = { version = "0.1", features = ["sqlite"] }

连接字符串

Sqlite:

内存: :memory:
文件: file:test.db
远程: libsql://url.Sqlite.io?authToken=token

PostgreSQL:

postgresql://user:password@localhost/dbname

MySQL:

mysql://user:password@localhost/dbname

MSSQL:

mssql://user:password@localhost/dbname

示例

use ormer::{Database, DbType, Model};

#[derive(Debug, Model)]
#[table = "users"]
struct User {
    #[primary(auto)]
    id: i32,
    name: String,
}

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    let db = Database::connect(DbType::Sqlite, "file:test.db").await?;
    db.create_table::<User>().execute().await?;
    db.drop_table::<User>().execute().await?;
    Ok(())
}