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()
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqlfocus-0.3.4.tar.gz
(3.3 kB
view details)
File details
Details for the file sqlfocus-0.3.4.tar.gz.
File metadata
- Download URL: sqlfocus-0.3.4.tar.gz
- Upload date:
- Size: 3.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/3.4.0 importlib_metadata/3.7.3 packaging/20.9 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.59.0 CPython/3.8.6
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
9c4aa6c46f02fefc540f250a8ffd7624fee858f21face2bfb621f1170fef9e49
|
|
| MD5 |
e2ef66a240a6c8e1863c18d4538958bc
|
|
| BLAKE2b-256 |
4636945694b93677d7d99091636c06940d451be82bc86223e7e1f0268186e85c
|
