Sqlite数据库操作

use FireSqlite\Sqlite;

$sqlite = Sqlite::init(__DIR__.'/db/test.db',[
        'tablePrefix'=>'tbl_',
        'username'=>'user',
        'password'=>'pass',
        'debug'=>true,
]);

Sqlite::table('records')->find_one(2);
Sqlite::table('records')->where('function',333)->find_one();
Sqlite::table('records')->where('line','=',1)->or_where('line','>',2)->limit(5)->as_array()->find_all();
Sqlite::table('records')->where('args',5555)->where('file','like','%6%')->update(['source'=>mt_rand()]);
$sqlite->table('records')->timestamp('create_at')->insert(['function'=>3,'args'=>4]);
$sqlite->table('records')->timestamp(['create_at','update_at'])->mutil_insert([['function'=>777,'args'=>888],['function'=>999,'file'=>000]]);
$sqlite->table('records')->where('id','=',7)->delete(2);