db/db_test.js

import db from 'apigo.cc/gojs/db'
import co from 'apigo.cc/gojs/console'

function main(testUserName) {
    db.setDefault('sqlite://test.db')
    db.make(`
        User            // {api} {select:isValid=1}
        id i AI
        name v100       // [i]
        password v100   // [p] {-}
        age i           // [n]
        sex v10         // [s:Female,Male]
        memo t          // [t]
        isValid b       // [c]
        version ubi     //
    `)
    db.insert('User', { name: testUserName })
    let user = db.query1('SELECT * FROM User').result

    let r = db.query1('SELECT * FROM User WHERE name = ?', testUserName)
    co.info(r)

    // db.delete('User', "name=?", testUserName)
    db.insert('_deleted', { table: 'User', id: r.result.id })

    r = db.query('SELECT * FROM _deleted')
    co.info(r)

    return user
}