A good SQLian like a good shepherd.
Project description
A good SQLian like a good shepherd. I handle SQL strings so you don’t have to.
Sneak Peek
Connect to a database:
import sqlian
db = sqlian.connect('postgresql:://user:pa55@localhost/contactbook')
Perform a query:
rows = db.select(
'name', 'occupation',
from_='person',
where={'main_language': 'Python'},
)
Access the data directly:
>>> rows[0]
<Record {"name": "Mosky", "occupation": "Pinkoi"}>
Or iterate over them:
for r in rows:
print('{} works at {}'.format(r.name, r.occupation))
Want more? Read the documentation.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqlian-0.1.0.dev0.tar.gz
(16.2 kB
view details)
Built Distribution
File details
Details for the file sqlian-0.1.0.dev0.tar.gz.
File metadata
- Download URL: sqlian-0.1.0.dev0.tar.gz
- Upload date:
- Size: 16.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | b5fa0931c779c0d2be3d477e22f3c7c0e2ef9bddd10b2a0eec5194c64976183e |
|
| MD5 | 21b626499c2d5e83abfddc8dc098ac5a |
|
| BLAKE2b-256 | a8f19c0e79c6ab73c7b6e7fcdd45113ae1c8b83d345e048ab18975a1e395ff34 |
File details
Details for the file sqlian-0.1.0.dev0-py2.py3-none-any.whl.
File metadata
- Download URL: sqlian-0.1.0.dev0-py2.py3-none-any.whl
- Upload date:
- Size: 24.7 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 903d0667eece2ab52a4a662856b504bfd6cd95160f87534d4eb332b2ff751817 |
|
| MD5 | e1dfb17f7dc4cd750eb65e13a56cab32 |
|
| BLAKE2b-256 | 5a001c4e58e24a5fea440220f0e018d1cbb6679a3c4f981004cdacbcd783f7b2 |
