database.py 文件源码

def user_insert(self, nm, pw):
        cmd = "SELECT USERNAME, PASSWORD FROM USERS"
        map_value = self._db.execute(cmd)
        dic = dict(map_value)
        if nm in dic.keys():
            return None, 1
        cmd = "INSERT INTO USERS (USERNAME, PASSWORD, NICKNAME, AVATARNAME) VALUES ('{0}', '{1}', '{2}', '{3}')".format(nm, pw, nm, "")
        self._db.execute(cmd)
        self._db.commit()
        cmd = "SELECT * FROM USERS"
        list_value = self._db.execute(cmd)
        for ind, name, nickname, avatar_name, password in list_value:
            if name == nm:
                dic = {"userID": ind, "name": name, "password": password, "nickname": nickname, "avatarName": avatar_name}
                current_time = time.localtime()
                str_time =  time.strftime("%Y-%m-%d %H:%M:%S", current_time)
                self.insert_message(SYSTEM_BROADCAST, 0, ind, str_time, "????Paper Melody!!")
                return dic, 0
        return None, 1