function SqliteTest() {
global $sys;
$sys['dbPath'] = 'app_data/cloud/index.db';
$tbls = db()->query('select * from sqlite_master');
return $tbls;
if($tbls) return db()->table($tbls[0]['name'])->limit(0, 3)->query();
// 如果是空数据库,测试操作数据库
db()->none("
create table test(
id integer primary key,
nick varchar(64),
regtime timestamp not null default( datetime('now', 'localtime') )
)
");
// 插入一条
db()->insert('test', [ 'nick' => 'Hello' ] );
// 插入两条
db()->insert('test', [
[ 'nick' => 'One' ],
[ 'nick' => 'Two' ]
]);
$rows = db()->table('test')->query();
db()->none('drop table test');
return $rows;
}