iot-platform-rust-lite/data_init.py

import sqlite3

curs = (conn:=sqlite3.connect('db.sqlite')).cursor()

curs.execute('''
create table if not exists user (
id integer PRIMARY KEY,
uname text not null,
passwd text not null,
nickname text not null,
token text not null default '',
createtime timestamp not null default current_timestamp,
lastlogin timestamp,
isdelete integer not null default 0
)
''').fetchall()

curs.execute('''
insert into user (uname,passwd,nickname) values ('root', 'e10adc3949ba59abbe56e057f20f883e', 'admin')
''').fetchall()
curs.execute('''
insert into user (uname,passwd,nickname) values ('admin', 'e10adc3949ba59abbe56e057f20f883e', 'test')
''').fetchall()
curs.execute('''
select * from user
''').fetchall()