summaryrefslogtreecommitdiff
path: root/jfr_playoff/db.py
blob: b85c5a42f2ae1500cd20e2aae2382cf93b7f7f6e (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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
import sys

from jfr_playoff.logger import PlayoffLogger


class PlayoffDB(object):

    db_cursor = None
    DATABASE_NOT_CONFIGURED_WARNING = 'database not configured'

    def __init__(self, settings):
        reload(sys)
        sys.setdefaultencoding("latin1")
        import mysql.connector
        self.database = mysql.connector.connect(
            user=settings['user'],
            password=settings['pass'],
            host=settings['host'],
            port=settings['port'])
        PlayoffLogger.get('db').info('db settings: %s', settings)
        self.db_cursor = self.database.cursor(buffered=True)

    def get_cursor(self):
        return self.db_cursor

    def __execute_query(self, db_name, sql, params):
        PlayoffLogger.get('db').info(
            'query (%s): %s %s', db_name, sql.replace('\n', ' '), params)
        self.db_cursor.execute(sql.replace('#db#', db_name), params)

    def fetch(self, db_name, sql, params):
        import mysql.connector
        try:
            self.__execute_query(db_name, sql, params)
            row = self.db_cursor.fetchone()
            return row
        except mysql.connector.Error as e:
            PlayoffLogger.get('db').error(str(e))
            raise IOError(e.errno, str(e), db_name)

    def fetch_all(self, db_name, sql, params):
        import mysql.connector
        try:
            self.__execute_query(db_name, sql, params)
            results = self.db_cursor.fetchall()
            return results
        except mysql.connector.Error as e:
            PlayoffLogger.get('db').error(str(e))
            raise IOError(
                message=str(e), filename=db_name,
                errno=e.errno, strerror=str(e))