蚯鲇蜍的工具箱

部署

1. 将仓库clone到本地

$ git clone https://github.com/zvmsbackend/tools.git

2. 安装python依赖项

$ pip3 -r requirements.txt

3. 初始化数据库(假设使用litecli)

$ mkdir instance
$ litecli instance/qncblog.db

source sql.sql

或者使用python的sqlite3模块:

import sqlite3
connection = sqlite3.connect('instance/qncblog.db')
cursor = connection.cursor()
with open('sql.sql', encoding='utf-8') as file:
    script = file.read()
cursor.execute_script(script)
connection.commit()
connection.close()

4. 创建管理员账号(必须为20220905)

INSERT INTO user(id, name) VALUES(20220905, "你的名字")

5. 运行服务

$ python web.py

或者指定端口:

$ python web.py <port>