Skip to main content

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')
```

Project details


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)

Uploaded Source

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

Hashes for easydb-0.2.tar.gz
Algorithm Hash digest
SHA256 f0ccebb3268f4867cf696cbd9fdc1a6e6c25a03f30fb41fa6e3035d53a7309d5
MD5 5e4bb20b3ebcd48ae2a0e838916ba7c1
BLAKE2b-256 2535bf86c56d4c0f53e2b57d74f6f2a19d30905fec9e6534b835700a496acd08

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page