Fixture generator for fixture module
Project description
# Fixture Generator for [Fixture](https://github.com/fixture-py/fixture)
Supports only SQLAlchemy
## Install
Using pip
```sh
pip install fixturegen
```
Or using easy_install
```sh
easy_install fixturegen
```
## Usage
Basic
```sh
$ fixturegen --table=user --dsn=mysql://user:password@localhost/your_db
from fixture import DataSet
class UserData(DataSet):
class user_0:
id = 1
name = u'first'
class user_1:
id = 2
name = u'second'
class user_2:
id = 3
name = u'third'
```
Limiting
```sh
$ fixturegen --table=user --dsn=mysql://user:password@localhost/your_db --limit=2
from fixture import DataSet
class UserData(DataSet):
class user_0:
id = 1
name = u'first'
class user_1:
id = 2
name = u'second'
```
Ordering
```sh
$ fixturegen --table=user --dsn=mysql://user:password@localhost/your_db --order-by='id DESC'
from fixture import DataSet
class UserData(DataSet):
class user_0:
id = 3
name = u'third'
class user_1:
id = 2
name = u'second'
class user_2:
id = 1
name = u'first'
```
Filtering
```sh
$ fixturegen --table=user --dsn=mysql://user:password@localhost/your_db --where='id > 1'
from fixture import DataSet
class UserData(DataSet):
class user_0:
id = 2
name = u'second'
```
Supports only SQLAlchemy
## Install
Using pip
```sh
pip install fixturegen
```
Or using easy_install
```sh
easy_install fixturegen
```
## Usage
Basic
```sh
$ fixturegen --table=user --dsn=mysql://user:password@localhost/your_db
from fixture import DataSet
class UserData(DataSet):
class user_0:
id = 1
name = u'first'
class user_1:
id = 2
name = u'second'
class user_2:
id = 3
name = u'third'
```
Limiting
```sh
$ fixturegen --table=user --dsn=mysql://user:password@localhost/your_db --limit=2
from fixture import DataSet
class UserData(DataSet):
class user_0:
id = 1
name = u'first'
class user_1:
id = 2
name = u'second'
```
Ordering
```sh
$ fixturegen --table=user --dsn=mysql://user:password@localhost/your_db --order-by='id DESC'
from fixture import DataSet
class UserData(DataSet):
class user_0:
id = 3
name = u'third'
class user_1:
id = 2
name = u'second'
class user_2:
id = 1
name = u'first'
```
Filtering
```sh
$ fixturegen --table=user --dsn=mysql://user:password@localhost/your_db --where='id > 1'
from fixture import DataSet
class UserData(DataSet):
class user_0:
id = 2
name = u'second'
```
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
fixturegen-0.2.tar.gz
(2.5 kB
view hashes)