sqlfocus 0.3.2

No project description provided

sqlfocus

Simple wrapper for sql

Example of usage (sqlite3)

import sqlite3

from sqlfocus import SQLTable

conn = sqlite3.connect("test.db")
table = SQLTable("test", conn)


"CREATE TABLE IF NOT EXISTS test (id INTEGER, name TEXT);"
table.create(exists=True, schema=(
    ("id", "INTEGER"),
    ("name", "TEXT")
))


'SELECT * FROM test WHERE id = 23455 AND name = "None"'
table.select()
table.select(where=[table.id == 23455,
                    table.name == "None"])


'INSERT INTO test VALUES (23455, "None")'
table.insert(23455, "None")

conn.commit()