Skip to main content
Help improve PyPI by participating in a 5-minute user interface survey!

Sandman inspired database and schema agnostic automatic REST API creator and data viewer/analyser

Project Description

Join the chat at https://gitter.im/praxigento/damvitool http://img.shields.io/:license-lgplv3.0-green.svg?style=flat-square Latest version

Introduction

As stated above this project was inspired by Sandman by Jeff Knupp. At the same time damvitool improves on the original in a few important areas:

  • Support for compound queries (both for REST API and 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

Frameworks and libraries used

Todo

  • Ability to save queries
  • Extended authorisation support with fine grained control of access to queries/tables
  • Editing of records
  • Charting engine for data visualization

Quick start

Installation

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).

Admin panel access

Default admin panel URL is http://localhost:8080

Build new database request

  1. Click Wizard button.
https://raw.githubusercontent.com/praxigento/damvitool/master/docs/pic1.png
  1. Login with the following credentials: user1/password1.
https://raw.githubusercontent.com/praxigento/damvitool/master/docs/pic2.png
  1. 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.
https://raw.githubusercontent.com/praxigento/damvitool/master/docs/pic3.png
  1. Choose relevant entities fields.
  2. Set filter criteria.
  3. View results.
https://raw.githubusercontent.com/praxigento/damvitool/master/docs/pic4.png

Changelog

Version 0.2.0

  • Move RESTful API from /proxy/* to /api/*
  • Improved documentation
  • Fix backend and frontend e2e tests

Release history Release notifications

This version
History Node

0.2.0

History Node

0.1.2

History Node

0.1.1

History Node

0.1.0

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
damvitool-0.2.0.tar.gz (15.2 MB) Copy SHA256 hash SHA256 Source None Feb 17, 2015

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page