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
|
import logging, sys
class TeamyDB(object):
db_cursor = None
def __init__(self, settings):
reload(sys)
sys.setdefaultencoding("latin1")
import mysql.connector
self.database = mysql.connector.connect(
user=settings['user'],
password=settings['password'],
host=settings['host'],
port=settings.get('port', 3306),
database=settings['database'])
self.db_cursor = self.database.cursor(buffered=True)
self.db_name = settings['database']
logging.info('Connected to database %s', self.db_name)
def get_cursor(self):
return self.db_cursor
def __execute_query(self, sql, params):
logging.debug('query (%s): %s | %s' % (self.db_name, sql.replace('\n', ' '), params))
self.db_cursor.execute(sql, params)
def fetch(self, sql, params=None):
import mysql.connector
try:
self.__execute_query(sql, params)
row = self.db_cursor.fetchone()
return row
except mysql.connector.Error as e:
logging.error(str(e))
raise IOError(e.errno, str(e), sql)
def fetch_all(self, sql, params=None):
import mysql.connector
try:
self.__execute_query(sql, params)
results = self.db_cursor.fetchall()
return results
except mysql.connector.Error as e:
logging.error(str(e))
raise IOError(
e.errno, str(e), sql)
|
