SQLModule

Code example

JavaScript

addEventHandler("OnResourceStart", () => {
    const db = sqlite3_open("test.db", SQLITE_OPEN_CREATE | SQLITE_OPEN_READWRITE);
    db.exec("CREATE TABLE IF NOT EXISTS test (id INT, model TEXT);");
    db.exec("INSERT INTO test VALUES (0, 'blabla')");
    const result = db.queryOne("SELECT * FROM test WHERE id = 0");
    if (result) {
        console.log("result: " + result.model);
    }
    else {
        console.error("no results to process!");
    }
    db.close();

    console.log(sqlite3_escape("this is an 'escaped 'string to prevent injection'"));
});

Lua

addEventHandler("OnResourceStart",
    function()
        local db = sqlite3_open("test.db", SQLITE_OPEN_CREATE | SQLITE_OPEN_READWRITE)
        db:exec("CREATE TABLE IF NOT EXISTS test (id INT, model TEXT);")
        db:exec("INSERT INTO test VALUES (0, 'blabla')")
        local result = db:queryOne("SELECT * FROM test WHERE id = 0")
        if result then
            print("result: " .. query.model)
        else
            print("no results!")
        end
        db:close()

        print(sqlite3_escape("this is an 'escaped 'string to prevent injection'"))
    end
)