db.py 1.17 KB
Newer Older
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
import configparser
import mysql.connector
import os


class Connection:
    _conn = None

    def __init__(self):
        config = configparser.RawConfigParser()
        config.read(os.path.dirname(os.path.realpath(__file__)) + "/../conf/config")

        aur_db_host = config.get('database', 'host')
        aur_db_name = config.get('database', 'name')
        aur_db_user = config.get('database', 'user')
        aur_db_pass = config.get('database', 'password')
        aur_db_socket = config.get('database', 'socket')

        self._conn = mysql.connector.connect(host=aur_db_host,
                                             user=aur_db_user,
                                             passwd=aur_db_pass,
                                             db=aur_db_name,
                                             unix_socket=aur_db_socket,
                                             buffered=True)

    def execute(self, query, params=()):
        query = query.replace('%', '%%').replace('?', '%s')

        cur = self._conn.cursor()
        cur.execute(query, params)

        return cur

    def commit(self):
        self._conn.commit()

    def close(self):
        self._conn.close()