def get_list(group_id, user_id):
recent_path = os.getcwd()
operate = "query"
db_path = recent_path + "/data/config/authority.mdb"
if group_id == "":
value = "id='" + str(user_id) + "' and type='private'"
else:
value = "id='" + str(group_id) + "' and type='group'"
result = database_operate.access_operate(operate, value, db_path)
#print(result)
if result == []:
chat_list = {}
else:
chat_list = {
"group_id": group_id,
"user_id": user_id,
"type": result[0][1],
"admin": result[0][2],
"warframe": result[0][3],
"honkai3": result[0][4]
}
#print(chat_list)
return chat_list
def admin_add(message_from_user):
message_from_user = message_from_user.split(" ", 3)
if message_from_user[2] == "格式":
message_to_send = "\n添加数据格式：\nadmin add <database> '' ''"
return message_to_send
if len(message_from_user) != 4:
message_to_send = "\n输入格式错误！"
return message_to_send
operate = "add"
db_path = get_path(message_from_user[2])
if db_path == "":
message_to_send = "\n数据库名错误！"
return message_to_send
value = message_from_user[3]
value = value.split("' '")
#print(value)
value = "', '".join(value)
value = "(" + value + ")"
#print(value)
result = access_operate(operate, value, db_path)
if result == False:
message_to_send = "\n添加数据时发生错误！"
else:
message_to_send = "\n成功添加数据！"
return message_to_send
def admin_query(message_from_user):
message_from_user = message_from_user.split(" ", 3)
if message_from_user[2] == "格式":
message_to_send = "\n查询数据格式：\nadmin query <database> <字段>=''"
return message_to_send
if len(message_from_user) != 4:
message_to_send = "\n输入格式错误！"
return message_to_send
operate = "query"
db_path = get_path(message_from_user[2])
if db_path == "":
message_to_send = "\n数据库名错误！"
return message_to_send
value = message_from_user[3]
result = access_operate(operate, value, db_path)
if result == []:
message_to_send = "\n未找到数据！"
else:
result = result[0]
result = ",".join(result)
message_to_send = "\n找到数据：\n" + result
return message_to_send
def admin_update(message_from_user):
message_from_user = message_from_user.split(" ", 3)
if message_from_user[2] == "格式":
message_to_send = "\n更改数据格式：\nadmin update <database> <更改后> <字段>=''"
return message_to_send
if len(message_from_user) != 4:
message_to_send = "\n输入格式错误！"
return message_to_send
operate = "delete"
db_path = get_path(message_from_user[2])
if db_path == "":
message_to_send = "\n数据库名错误！"
return message_to_send
value = message_from_user[3]
result = access_operate(operate, value, db_path)
if result == False:
message_to_send = "\n更改数据时发生错误！"
else:
message_to_send = "\n成功更改数据！"
return message_to_send
def var_write(file_path):
data = []
data = database_operate.access_operate("all", None, file_path)
if data == []:
print("文件%s的数据读取出现错误！" % file_path)
return data
else:
return data
def var_write(file_path):
data = []
output_dict = {}
data = database_operate.access_operate("all", None, file_path)
if data == []:
print("文件%s的数据读取出现错误！" % file_path)
else:
length = len(data)
for i in range(length):
dict_add = {data[i][0]: data[i][1]}
output_dict.update(dict_add)
return output_dict