rustdb 0.1.25

SQL database (in development)
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

use rustdb::{Database, SharedPagedData, SimpleFileStorage, WebQuery, INITSQL};
use std::net::TcpListener;
use std::sync::Arc;

fn main() {
    let sfs = Box::new(SimpleFileStorage::new(
        "c:\\Users\\pc\\rust\\sftest01.rustdb",
    ));
    let spd = Arc::new(SharedPagedData::new(sfs));
    let apd = spd.open_write();
    let db = Database::new(apd, INITSQL);

    let listener = TcpListener::bind("127.0.0.1:3000").unwrap();
    for tcps in listener.incoming() {
        if let Ok(mut tcps) = tcps {
            if let Ok(mut wq) = WebQuery::new(&tcps) {
                // wq.trace();
                let sql = "EXEC web.Main()";
                // Execute SQL. http response, SQL output, (status,headers,content) is accumulated in wq.
                db.run_timed(&sql, &mut wq);
                // Write the http response to the TCP stream.
                let _err = wq.write(&mut tcps);
                // Save database changes to disk.
                db.save();
            }
        }
    }
}