school_server/
school_server.rs

1use easy_db::EasyDB;
2
3#[tokio::main]
4async fn main() -> anyhow::Result<()> {
5    println!("🔔 Starting School Server...");
6
7    // 1. Initialize a database named 'school_db'
8    let mut db = EasyDB::init("school_db").expect("Failed to create database");
9
10    // 2. Create Students Table
11    // Columns: id, name, school_number, class_grade, gpa
12    db.create_table(
13        "students",
14        "id INTEGER PRIMARY KEY, name TEXT, school_number INTEGER, class_grade TEXT, gpa REAL",
15    )?;
16
17    // 3. Create Grades Table
18    // Columns: id, school_number, lesson, score
19    db.create_table(
20        "grades",
21        "id INTEGER PRIMARY KEY, school_number INTEGER, lesson TEXT, score INTEGER",
22    )?;
23
24    // 4. Create Teachers Table
25    // Columns: id, name, branch
26    db.create_table("teachers", "id INTEGER PRIMARY KEY, name TEXT, branch TEXT")?;
27
28    // 5. Start the server on port 9000
29    println!("✅ Tables are ready. API is listening on port 9000.");
30    db.run_server(9000).await?;
31
32    Ok(())
33}
school_server/school_server.rs

school_server/
school_server.rs
