31 lines
839 B
JavaScript
31 lines
839 B
JavaScript
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
|
|
}
|