This project was inspired by Sandman by Jeff Knupp. Damvitool improves on the original in a few important areas:
- Support for compound queries (on server side (REST API) and client side (UI))
- Extremely flexible and powerful UI (query builder wizard) thanks to SmartClient library by Isomorphic
- Support for column summaries
- Unlimited resulting grid (sorted&filtered) export to CSV file
- SQLAlchemy v0.9.8+
- Morepath v0.9+
- AngularJS v1.2.1+
- Isomorphic SmartClient v9.1+
- ng_isc v0.2+
- Ability to save queries
- Extended authorisation support with fine grained control of access to queries/tables
- Editing of records
- Charting engine for data visualization
Use pip to install damvitool:
$ pip install damvitool
Run damvitool from command line:
$ damvitool
When you run damvitool from command line without parameters it connects by default to the demo Chinook Database for SQLite.
To connect to your legacy database run damvitool with your database URL as parameter, like so:
$ damvitool --database sqlite:///damvitool/data/Chinook_Sqlite.sqlite
where sqlite:///damvitool/data/Chinook_Sqlite.sqlite is database URL in SQLAlchemy format (http://docs.sqlalchemy.org/en/rel_0_9/core/engines.html#database-urls).
Default admin panel URL is http://localhost:8080
- Click
Wizard
button.
- Login with the following credentials: user1/password1.
- Choose root entity for your data query. If tables needed for your query don't have relations between them you can add another root entity to your query.
- Choose relevant entities fields.
- Set filter criteria.
- View results.
- Move RESTful API from /proxy/* to /api/*
- Improved documentation
- Fix backend and frontend e2e tests