· 5 years ago · Jun 25, 2020, 08:06 PM
1import sqlite3 as sql3
2from os import system
3from colorama import init, Fore
4
5init()
6system('cls')
7
8def printDonate():
9 print(Fore.YELLOW + '''\n[ TABLES ]\n
10Создатель - donate_creator;
11Основатель - donate_founder;
12Владелец - donate_owner;
13Цезарь - donate_caesar;
14Президент - donate_president;
15Бог - donate_god;
16Властелин - donate_sovereign;
17Правитель - donate_ruler;
18Барон - donate_baron;
19Владыка - donate_lord;
20Султан - donate_sultan;
21Мажор - donate_major;
22Хозяин - donate_master;
23 ''' + Fore.RESET)
24
25def add_account():
26 system('cls')
27 print(Fore.YELLOW + '\n# Account Add Mode' + Fore.RESET)
28 choose_table = input('$ table: ').lower()
29 print(printDonate)
30
31 try:
32 flag = True
33 while flag == True:
34 user_login = input('\n$ login: ')
35 user_password = input('$ password: ')
36
37 sql.execute(f'SELECT login FROM {choose_table} WHERE login = "{user_login}"')
38 if sql.fetchone() is None:
39 sql.execute(f'INSERT INTO {choose_table} VALUES (?, ?)', (user_login, user_password))
40 database.commit()
41 print(Fore.GREEN + '\n# Account added' + Fore.RESET)
42 flag = False
43
44 else:
45 print(Fore.RED + '\nERROR: Record already exists' + Fore.RESET)
46 except:
47 print(Fore.RED + '\nERROR: The table is not in the database' + Fore.RESET)
48
49def show_table():
50 print()
51
52
53database = sql3.connect('accounts.db')
54sql = database.cursor()
55
56# "creator" donate (создатель)
57sql.execute('''
58 CREATE TABLE IF NOT EXISTS donate_creator (
59 login TEXT,
60 password TEXT
61 )''')
62
63# "founder" donate (основатель)
64sql.execute('''
65 CREATE TABLE IF NOT EXISTS donate_founder (
66 login TEXT,
67 password TEXT
68 )''')
69
70# "owner" donate (владелец)
71sql.execute('''
72 CREATE TABLE IF NOT EXISTS donate_owner (
73 login TEXT,
74 password TEXT
75 )''')
76
77# "caesar" donate (цезарь)
78sql.execute('''
79 CREATE TABLE IF NOT EXISTS donate_caesar (
80 login TEXT,
81 password TEXT
82 )''')
83
84# "president" donate (президент)
85sql.execute('''
86 CREATE TABLE IF NOT EXISTS donate_president (
87 login TEXT,
88 password TEXT
89 )''')
90
91# "god" donate (Бог)
92sql.execute('''
93 CREATE TABLE IF NOT EXISTS donate_god (
94 login TEXT,
95 password TEXT
96 )''')
97
98# "sovereign" donate (властелин)
99sql.execute('''
100 CREATE TABLE IF NOT EXISTS donate_sovereign (
101 login TEXT,
102 password TEXT
103 )''')
104
105# "ruler" donate (правитель)
106sql.execute('''
107 CREATE TABLE IF NOT EXISTS donate_ruler (
108 login TEXT,
109 password TEXT
110 )''')
111
112# "baron" donate (барон)
113sql.execute('''
114 CREATE TABLE IF NOT EXISTS donate_baron (
115 login TEXT,
116 password TEXT
117 )''')
118
119# "lord" donate (владыка)
120sql.execute('''
121 CREATE TABLE IF NOT EXISTS donate_lord (
122 login TEXT,
123 password TEXT
124 )''')
125
126# "sultan" donate (султан)
127sql.execute('''
128 CREATE TABLE IF NOT EXISTS donate_sultan (
129 login TEXT,
130 password TEXT
131 )''')
132
133# "major" donate (мажор)
134sql.execute('''
135 CREATE TABLE IF NOT EXISTS donate_major (
136 login TEXT,
137 password TEXT
138 )''')
139
140# "master" donate (хозяин)
141sql.execute('''
142 CREATE TABLE IF NOT EXISTS donate_master (
143 login TEXT,
144 password TEXT
145 )''')
146
147database.commit()
148
149while True:
150 command = input('\n$ ')
151
152 if command == 'add account' or command == 'ac':
153 add_account()
154
155 elif command == 'show table' or command == 'st':
156 show_table()
157
158 elif command == 'clear' or command == 'cls':
159 system('cls')
160
161 else:
162 print(Fore.RED + '\n# Unknown command' + Fore.RESET)