skip to navigation
skip to content

Not Logged In

anosql 0.1.0

Easy SQL in Python

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.available_queries
# => ['get_all_greetings']
```

Caveats
-------

Postgresql and sqlite only at the moment

License
-------

BSD, short and sweet

[1]: https://github.com/krisajenkins/yesql/  
File Type Py Version Uploaded on Size
anosql-0.1.0.tar.gz (md5) Source 2014-08-31 2KB
  • Downloads (All Versions):
  • 1 downloads in the last day
  • 65 downloads in the last week
  • 243 downloads in the last month