const * as orm, { FieldTypes } from "https://deno.land/x/dso/mod.ts";
// const * as orm, { FieldTypes } from "https://raw.githubusercontent.com/manyuanrong/dso/master/mod.ts";

// Define a database model
const User = orm.define("users", {
    id: { autoIncrement: true, length: 11, type: FieldTypes.INT, primary: true },
    name: { length: 30, type: FieldTypes.STRING },
    password: { length: 30, type: FieldTypes.STRING },
});

async function main(){
    // The database must be created before linking
    await orm.connect({
        hostname: "127.0.0.1",
        port: 3306,
        username: "root",
        passwod: "",
        db: "dbname"
    });

    // When installing or initializing a database, 
    // you can use sync to synchronize the database model to the database.

    // await orm.sync(false);

    // You can add records using insert method
    const insertId = await User.insert({name: "user1", password: "password"});

    // You can use the Model.findById method to get a record
    const user = await User.findById(1);
}
main();

await orm.connect({
    hostname: "127.0.0.1", // database hostname
    port: 3306, // database port
    username: "root", // database username
    passwod: "", // database password
    db: "dbname" // database name. (tips: The database must be created before linking)
});

const User = orm.define("users", {
    id: { autoIncrement: true, length: 11, type: FieldTypes.INT, primary: true },
    name: { length: 30, type: FieldTypes.STRING },
    password: { length: 30, type: FieldTypes.STRING },
});
// User.findById(...)
// User.findAll(...)
// User.findOne(...)
// User.insert(...)
// User.update(...)
// User.delete(...)

// If set to FORCE, tables will be deleted before they are created,
// otherwise only new models will be synchronized.
const force = true; // force 
await orm.sync(force);

console.log(orm.replaceParams("select ?? from ?? where id = ?", [["id","name"], "users", 1]));
// select (`id`,`name`) from `users` where id = 1