Easy SQL in Python
Project description
anosql
======
A Python library for using SQL
*Warning: very alpha*
Inspired by the excellent [Yesql][1] library by Kris Jenkins. In my mother
tongue, *ano* means *yes*.
Installation
------------
```
$ pip install anosql
```
Usage
-----
Given a `queries.sql` file:
```sql
-- name: get-all-greetings
-- Get all the greetings in the database
SELECT * FROM greetings;
```
We can issue SQL queries, like so:
```python
import anosql
import psycopg2
import sqlite3
# PostgreSQL
conn = psycopg2.connect('...')
queries = anosql.load_queries('postgres', 'queries.sql')
# Or, Sqlite3...
conn = sqlite3.connect('cool.db')
queries = anosql.load_queries('sqlite', 'queries.sql')
queries = queries.get_all_greetings(conn)
# => [(1, 'Hi')]
queries.get_all_greetings.__doc__
# => Get all the greetings in the database
queries.get_all_greetings.__query__
# => SELECT * FROM greetings;
queries.available_queries
# => ['get_all_greetings']
```
Caveats
-------
Postgresql and sqlite only at the moment
License
-------
BSD, short and sweet
[1]: https://github.com/krisajenkins/yesql/
======
A Python library for using SQL
*Warning: very alpha*
Inspired by the excellent [Yesql][1] library by Kris Jenkins. In my mother
tongue, *ano* means *yes*.
Installation
------------
```
$ pip install anosql
```
Usage
-----
Given a `queries.sql` file:
```sql
-- name: get-all-greetings
-- Get all the greetings in the database
SELECT * FROM greetings;
```
We can issue SQL queries, like so:
```python
import anosql
import psycopg2
import sqlite3
# PostgreSQL
conn = psycopg2.connect('...')
queries = anosql.load_queries('postgres', 'queries.sql')
# Or, Sqlite3...
conn = sqlite3.connect('cool.db')
queries = anosql.load_queries('sqlite', 'queries.sql')
queries = queries.get_all_greetings(conn)
# => [(1, 'Hi')]
queries.get_all_greetings.__doc__
# => Get all the greetings in the database
queries.get_all_greetings.__query__
# => SELECT * FROM greetings;
queries.available_queries
# => ['get_all_greetings']
```
Caveats
-------
Postgresql and sqlite only at the moment
License
-------
BSD, short and sweet
[1]: https://github.com/krisajenkins/yesql/
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
anosql-0.1.2.tar.gz
(2.5 kB
view hashes)