Book a Demo!
CoCalc Logo Icon
StoreFeaturesDocsShareSupportNewsAboutPoliciesSign UpSign In
wiseplat
GitHub Repository: wiseplat/python-code
 Path: blob/master/ invest-robot-contest_tinkoff-trading-bot-develop/app/sqlite/client.py
5935 views
1
import sqlite3

2


3


4
class SQLiteClient:

5
    def __init__(self, db_name):

6
        self.db_name = db_name

7
        self.conn = None

8


9
    def connect(self):

10
        self.conn = sqlite3.connect(self.db_name)

11


12
    def close(self):

13
        self.conn.close()

14


15
    def execute(self, sql, params=None):

16
        if params is None:

17
            params = []

18
        cursor = self.conn.cursor()

19
        cursor.execute(sql, params)

20
        self.conn.commit()

21
        return cursor.fetchall()

22


23
    def execute_insert(self, sql, params=None):

24
        if params is None:

25
            params = []

26
        cursor = self.conn.cursor()

27
        cursor.execute(sql, params)

28
        self.conn.commit()

29
        return cursor.lastrowid

30


31
    def execute_update(self, sql, params=None):

32
        if params is None:

33
            params = []

34
        cursor = self.conn.cursor()

35
        cursor.execute(sql, params)

36
        self.conn.commit()

37
        return cursor.rowcount

38


39
    def execute_delete(self, sql, params=None):

40
        if params is None:

41
            params = []

42
        cursor = self.conn.cursor()

43
        cursor.execute(sql, params)

44
        self.conn.commit()

45
        return cursor.rowcount

46


47
    def execute_select(self, sql, params=None):

48
        if params is None:

49
            params = []

50
        cursor = self.conn.cursor()

51
        cursor.execute(sql, params)

52
        return cursor.fetchall()

53


54
    def execute_select_one(self, sql, params=None):

55
        if params is None:

56
            params = []

57
        cursor = self.conn.cursor()

58
        cursor.execute(sql, params)

59
        return cursor.fetchone()

60


61