-
Notifications
You must be signed in to change notification settings - Fork 0
/
trigger_request.py
33 lines (28 loc) · 1009 Bytes
/
trigger_request.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
import telebot
import sqlite3
conn = sqlite3.connect('trigs.db') # Initiating object of DB to connect DB
cur = conn.cursor() # Initiating cursor for manipulating of DB connection
# Here program create DB with tables
# It should be used once
def create_db():
global conn
global cur
cur.execute("""CREATE TABLE IF NOT EXISTS chats(
chat_id int PRIMARY KEY,
`name` varchar,
count_of_asking int
);""")
cur.execute("""CREATE TABLE IF NOT EXISTS triggers(
trigger_id int PRIMARY KEY,
trigger_text varchar,
answer varchar,
reply smallint,
count_of_asking int
);""")
cur.execute("""CREATE TABLE IF NOT EXISTS trigger_to_chat(
trigger_id int PRIMARY KEY,
chat_id int,
status int
);""")
conn.commit()
TRIGGER_LIST = []