Advanced-Database
Z1h has embedded database operations, the main ones include mysql andsqlite3
If you need to support Postgres / Tidb / MsSql / Oracle, please contact the author
Open
Refer to Run Configuration, and configure the db information, you can connect to the database
...
{
"db": {
"type": "mysql", // database type
"address": "" // database connection address, sqlite3 writable filename
}
}
...
there are two ways to perform database operations:SQL way and ORM way
SQL operation
by$ db can operate SQL
// Create table
assert ($ db (` CREATE TABLE test_db (name VARCHAR) `))
// Insert
assert ($ db (` INSERT INTO test_db (name) VALUES ("aaa") `))
// placeholder
assert ($ db (` INSERT INTO test_db (name) VALUES (?) `,"bbb"))
// delete
assert ($ db (`DELETE FROM test_db WHERE name =?`, "aaa"))
// query
assert ($ db (`SELECT * FROM test_db WHERE name! =?`, "aaa"))
// modify
assert ( $ db (`UPDATE test_db SET name =? WHERE name! =?`, "aaa", "aaa"))
// ...
// For more operations, please learn SQL
ORM
object relational mapping (Object Relational Mapping (ORM for short) is to automatically persist objects in an object-oriented language program into a relational database by using metadata describing the mapping between objects and databases.
go-xorm
If you are using the Go version of Z1h, built environment https://github.com/go-xorm/xorm third-party libraries
by $ xorm can be operated in a database ORM
// Build table
var table_struct = new ('struct', {
id: 0,
username:` `,
password:` `,
age: 0,
updateAt: now (),
createAt: now(),
}, {
id: `xorm:"not null pk autoincr INT(11)"`,
username: `xorm:"not null VARCHAR(64) unique(openid)"`,
password: `xorm:"not null VARCHAR(64)"`,
age: `xorm:"not null int(11) default 18"`,
updateAt: `xorm:"updated"`,
createAt: `xorm:"created"`,
});
assert($xorm.Table('test_db2').Sync2(table_struct))
// Insert
assert($xorm.Table('test_db2').Insert({
username: 'admin',
password: md5("Password").hex(),
age: 12,
}))
// Insert with datetime
assert($xorm.Table('test_db2').Insert(new(table_struct, {
username: 'admin2',
password: md5("Password2").hex(),
age: 12,
})))
// Delete
assert($xorm.Table('test_db2').Id(1).Delete(new(table_struct)))
assert($xorm.Table('test_db2').Where('username = ?', 'admin').Delete(new(table_struct)))
// Query
var results = &new(table_struct, '[]');
assert($xorm.Table('test_db2').Where('username = ?', 'admin1').Find(results));
results = *results;
print(results.map(e=>{e.username}).join(' and '));
// Update
assert($xorm.Table('test_db2').Id(2).Update(new(table_struct, {
username: 'hello',
})))
// ...
// More infomation via https://github.com/go-xorm/xorm