SQL Abstraction layer written in Python 3.2 for use in lower level applications, such as tkinter.
All SQL modules written in python follows a standard DB-API 2.0.
Thus all connections attributes and methods can be used for different SQL engines.
An abstract class, “Database” was created in order for sub classes that inherit this class to re-implement the __init__ method in order to set a connection.
Since connections is loaded differently for each SQL engine.
Attribute Connection was made private in order not to change it from a different layer and to keep the connection consistent.
Python 3.2 required
from Databases.SQLite import SQLiteDatabase
db = SQLiteDatabase(None, ‘test.db’)
results = db.select(‘table_name’, [‘name’, ‘id’])