Mercurial > kraina_muminkow
comparison frontend/mfrontend/db.py @ 1:c3fb1e9fc1f7
(none)
| author | michalr |
|---|---|
| date | Tue, 22 Feb 2011 18:10:18 +0000 |
| parents | |
| children | cf786ee26a22 |
comparison
equal
deleted
inserted
replaced
| 0:ebb283da07f7 | 1:c3fb1e9fc1f7 |
|---|---|
| 1 #!/usr/bin/python | |
| 2 # -*- coding: utf-8 -*- | |
| 3 | |
| 4 import sqlite3 | |
| 5 from flask import g | |
| 6 import ConfigParser | |
| 7 | |
| 8 config = ConfigParser.SafeConfigParser() | |
| 9 config.read('config.ini') | |
| 10 | |
| 11 def connect_db(): | |
| 12 """Funkcja łącząca się z bazą danych.""" | |
| 13 g.db = sqlite3.connect(config.get('Basic','Database')) | |
| 14 | |
| 15 def disconnect_db(): | |
| 16 """Funkcja zamykająca połączenie z bazą danych""" | |
| 17 g.db.close() | |
| 18 | |
| 19 def query_db(query, args=(), one=False): | |
| 20 """Funkcja ułatwiająca odpytywanie bazy danych, źródło: | |
| 21 http://flask.pocoo.org/docs/patterns/sqlite3/ | |
| 22 """ | |
| 23 cur = g.db.execute(query, args) | |
| 24 rv = [dict((cur.description[idx][0], value) | |
| 25 for idx, value in enumerate(row)) for row in cur.fetchall()] | |
| 26 return (rv[0] if rv else None) if one else rv |