Book a Demo!
CoCalc Logo Icon
StoreFeaturesDocsShareSupportNewsAboutPoliciesSign UpSign In
wiseplat
GitHub Repository: wiseplat/python-code
 Path: blob/master/ invest-robot-contest_trading_bot-master/db/create_tables.py
5932 views
1
import sqlite3 as sl

2


3


4
def create_tables():

5
    connection = sl.connect("db/BotDB.db")

6


7
    # Таблица содержит данные обо всех проведённых операциях

8
    connection.execute('CREATE TABLE IF NOT EXISTS operations ('

9
                       'id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,'

10
                       'user_id TEXT,'

11
                       'account_id TEXT,'

12
                       'account_type TEXT,'

13
                       'account_access TEXT,'

14
                       'order_id TEXT,'

15
                       'date_op TEXT,'

16
                       'time_op TEXT,'

17
                       'direction TEXT,'

18
                       'figi TEXT,'

19
                       'ticker TEXT,'

20
                       'name TEXT,'

21
                       'quantity_lots INTEGER,'

22
                       'in_lot INTEGER,'

23
                       'quantity_total INTEGER,'

24
                       'price_position REAL,'

25
                       'price_total REAL,'

26
                       'commission REAL,'

27
                       'currency TEXT,'

28
                       'message TEXT,'

29
                       'via TEXT)')

30


31
    # Таблица содержит данные о конфигурации стратегии EMA + ADX + MACD

32
    connection.execute('CREATE TABLE IF NOT EXISTS str1_config ('

33
                       'id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,'

34
                       'user_id TEXT,'

35
                       'account_id TEXT,'

36
                       'account_type TEXT,'

37
                       'account_access TEXT,'

38
                       'figi TEXT,'

39
                       'name TEXT,'

40
                       'trade_status TEXT,'

41
                       'notif_status TEXT,'

42
                       'buy_price REAL,'

43
                       'currency TEXT,'

44
                       'quantity_lots INTEGER,'

45
                       'period INTEGER,'

46
                       'macd_border REAL,'

47
                       'adx_border REAL,'

48
                       'take_profit REAL,'

49
                       'stop_loss REAL)')

50


51
    # Таблица содержит данные пользователя, которые используются в данный момент

52
    connection.execute('CREATE TABLE IF NOT EXISTS users ('

53
                       'id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,'

54
                       'user_id INTEGER NOT NULL,'

55
                       'first_name TEXT,'

56
                       'last_name TEXT,'

57
                       'username TEXT,'

58
                       'token TEXT,'

59
                       'account_id TEXT,'

60
                       'account_type TEXT,'

61
                       'account_access TEXT,'

62
                       'bot_access_level TEXT)')

63


64
    connection_message = sl.connect("db/message.db")

65


66
    connection_message.execute('CREATE TABLE IF NOT EXISTS message_type ('

67
                               'id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,'

68
                               'message_type INTEGER NOT NULL,'

69
                               'message TEXT)')

70


71
    connection_message.execute('CREATE TABLE IF NOT EXISTS messages ('

72
                               'id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,'

73
                               'message_type INTEGER NOT NULL,'

74
                               'user_id INTEGER,'

75
                               'account_type TEXT,'

76
                               'date_message TEXT,'

77
                               'time_message TEXT,'

78
                               'function TEXT,'

79
                               'user_text TEXT)')

80
    return 0

81


82