DBdebug.py

import sqlite3


def DB_pwd():
    with sqlite3.connect("users.db") as usersDB:
        usersDB.execute('''create table if not exists users
        (name primary key not null,
        password varchar(16) not null)
        ''')
        
        '''
        usersDB.execute(
            "insert into users (name,password) values('CaptainChen','12345')")
        usersDB.execute(
            "insert into users (name,password) values('Zhongli','12345')")
        usersDB.execute(
            "insert into users (name,password) values('Xingqiu','12345')")
        usersDB.execute(
            "insert into users (name,password) values('Xiangling','12345')")
        usersDB.execute(
            "insert into users (name,password) values('Beidou','12345')")
        usersDB.execute(
            "insert into users (name,password) values('Hu Tao','12345')")
        '''

        usersDB.commit()


def DB_CaptainChen_friends():
    DB = sqlite3.connect(".\\userdatas\\CaptainChen.db")
    DB.execute('''create table if not exists friends
    (name primary key not null)
    ''')
    DB.execute("insert into friends (name) values('Zhongli')")
    DB.execute("insert into friends (name) values('Xingqiu')")

    DB.commit()


def DB_msglog():
    DB = sqlite3.connect(".\\msglogdb\\CaptainChen.db")
    DB.execute('''create table if not exists Zhongli
    (id int primary key not null,
    username,
    time varchar(14),
    content)
    ''')
    DB.execute("insert into Zhongli (id,username,time,content) values(1,'Zhongli','20220429214800','你好，世界！')")
    DB.execute("insert into Zhongli (id,username,time,content) values(2,'CaptainChen','20220429214800','Hello, World!')")
    DB.execute("insert into Zhongli (id,username,time,content) values(3,'Zhongli','20220429214800','我是钟离。')")
    DB.execute("insert into Zhongli (id,username,time,content) values(4,'CaptainChen','20220429214800','I am CaptainChen')")
    DB.execute("insert into Zhongli (id,username,time,content) values(5,'Zhongli','20220429214800','asdfasdfasdfasda')")
    DB.execute("insert into Zhongli (id,username,time,content) values(6,'Zhongli','20220429214800','你好，世界！')")
    DB.execute("insert into Zhongli (id,username,time,content) values(7,'CaptainChen','20220429214800','Hello, World!')")
    DB.execute("insert into Zhongli (id,username,time,content) values(8,'Zhongli','20220429214800','我是钟离。')")
    DB.execute("insert into Zhongli (id,username,time,content) values(9,'CaptainChen','20220429214800','I am CaptainChen')")
    DB.execute("insert into Zhongli (id,username,time,content) values(10,'Zhongli','20220429214800','asdfasdfa\nsdfasda')")
    DB.execute("insert into Zhongli (id,username,time,content) values(11,'Zhongli','20220429214800','asdfasdfa\nsdfasda')")
    DB.execute("insert into Zhongli (id,username,time,content) values(12,'Zhongli','20220429214800','asdfasdfa\nsdfasda')")
    DB.execute("insert into Zhongli (id,username,time,content) values(13,'Zhongli','20220429214800','asdfasdfa\nsdfasda')")

    DB.commit()


def DB_msglog2():
    with sqlite3.connect(".\\msglogdb\\CaptainChen.db") as DB:
        DB.execute('''create table if not exists 钟离
        (id int primary key not null,
        username,
        time varchar(14),
        content)
        ''')
        DB.execute("insert into 钟离 (id,username,time,content) values(1,'钟离','20220429214800','你好，世界！')")
        DB.execute("insert into 钟离 (id,username,time,content) values(2,'CaptainChen','20220429214800','Hello, World!')")
        DB.execute("insert into 钟离 (id,username,time,content) values(3,'钟离','20220429214800','我是钟离。')")
        DB.execute("insert into 钟离 (id,username,time,content) values(4,'CaptainChen','20220429214800','I am CaptainChen')")
        DB.execute("insert into 钟离 (id,username,time,content) values(5,'钟离','20220429214800','asdfasdfasdfasda')")
        DB.execute("insert into 钟离 (id,username,time,content) values(6,'钟离','20220429214800','你好，世界！')")
        DB.execute("insert into 钟离 (id,username,time,content) values(7,'CaptainChen','20220429214800','Hello, World!')")
        DB.execute("insert into 钟离 (id,username,time,content) values(8,'钟离','20220429214800','我是钟离。')")
        DB.execute("insert into 钟离 (id,username,time,content) values(9,'CaptainChen','20220429214800','I am CaptainChen')")
        DB.execute("insert into 钟离 (id,username,time,content) values(10,'钟离','20220429214800','asdfasdfa\nsdfasda')")
        DB.execute("insert into 钟离 (id,username,time,content) values(11,'钟离','20220429214800','asdfasdfa\nsdfasda')")
        DB.execute("insert into 钟离 (id,username,time,content) values(12,'钟离','20220429214800','asdfasdfa\nsdfasda')")
        DB.execute("insert into 钟离 (id,username,time,content) values(13,'钟离','20220429214800','asdfasdfa\nsdfasda')")

        DB.execute('''create table if not exists Alice
        (id int primary key not null,
        username,
        time varchar(14),
        content)
        ''')
        DB.execute("insert into Alice (id,username,time,content) values(1,'Alice','20220430143702','你好，世界！')")

        DB.commit()
    

def DB_group():
    with sqlite3.connect("groups.db") as DB:
        DB.execute("create table if not exists groups (id int primary key not null,name)")
        DB.commit()


if __name__ == "__main__":
    DB_group()
    DB_pwd()