Simple SQLite wrapper to make it easier to manage your database
Project description
# EasyDB
A really simple **SQLite wrapper** that saves you from having to worry about creating tables or managing connections.
It can be used on existing SQLite database by simply passing in the database filename:
```python
from easydb import EasyDB
db = EasyDB('filename.db')
cursor = db.query("SELECT * FROM mytable")
```
New databases can be creating by specifying your schema as a dictionary, eg:
```python
schema = {
'table_name': ['column_name column_type', …],
'table_name': ['column_name column_type', …],
'table_name': ['column_name column_type', …]
}
db = EasyDB('filename.db', schema)
```
If the database file already exists then the schema won't be updated, but if it doesn't exist then it'll be created with the given schema. Here's a full example:
```python
from easydb import EasyDB
db = EasyDB('my.db', {'users': ['username text', 'description text']})
db.query("INSERT INTO users (username, description) VALUES (?, ?)", ('ben', 'some sort of description'))
for result in db.query("SELECT * FROM users"):
print result
# => ('ben', 'some sort of description')
```
A really simple **SQLite wrapper** that saves you from having to worry about creating tables or managing connections.
It can be used on existing SQLite database by simply passing in the database filename:
```python
from easydb import EasyDB
db = EasyDB('filename.db')
cursor = db.query("SELECT * FROM mytable")
```
New databases can be creating by specifying your schema as a dictionary, eg:
```python
schema = {
'table_name': ['column_name column_type', …],
'table_name': ['column_name column_type', …],
'table_name': ['column_name column_type', …]
}
db = EasyDB('filename.db', schema)
```
If the database file already exists then the schema won't be updated, but if it doesn't exist then it'll be created with the given schema. Here's a full example:
```python
from easydb import EasyDB
db = EasyDB('my.db', {'users': ['username text', 'description text']})
db.query("INSERT INTO users (username, description) VALUES (?, ?)", ('ben', 'some sort of description'))
for result in db.query("SELECT * FROM users"):
print result
# => ('ben', 'some sort of description')
```
Project details
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
easydb-0.2.tar.gz
(2.0 kB
view details)
File details
Details for the file easydb-0.2.tar.gz
.
File metadata
- Download URL: easydb-0.2.tar.gz
- Upload date:
- Size: 2.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | f0ccebb3268f4867cf696cbd9fdc1a6e6c25a03f30fb41fa6e3035d53a7309d5 |
|
MD5 | 5e4bb20b3ebcd48ae2a0e838916ba7c1 |
|
BLAKE2b-256 | 2535bf86c56d4c0f53e2b57d74f6f2a19d30905fec9e6534b835700a496acd08 |