summaryrefslogtreecommitdiff
path: root/jfr_playoff/db.py
blob: ad32ac82551de4c4a3b913a5edc3c2194e74de90 (plain)
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
import mysql.connector


class PlayoffDB(object):

    db_cursor = None

    def __init__(self, settings):
        self.database = mysql.connector.connect(
            user=settings['user'],
            password=settings['pass'],
            host=settings['host'],
            port=settings['port'])
        self.db_cursor = self.database.cursor(buffered=True)

    def get_cursor(self):
        return self.db_cursor

    def __execute_query(self, db_name, sql, params):
        self.db_cursor.execute(sql.replace('#db#', db_name), params)

    def fetch(self, db_name, sql, params):
        self.__execute_query(db_name, sql, params)
        row = self.db_cursor.fetchone()
        return row

    def fetch_all(self, db_name, sql, params):
        self.__execute_query(db_name, sql, params)
        results = self.db_cursor.fetchall()
        return results