- Notifications
You must be signed in to change notification settings - Fork2
Database Introspection Tool - Open-Source | AppSeed
License
NotificationsYou must be signed in to change notification settings
app-generator/devtool-db-introspection
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
Open-Sourcedevelopers tool that provides simple helpers for legacy databases introspection. Crafted on top ofPython andPeewee.
- 👉 Freesupport via Email andDiscord
- 👉 MoreDeveloper Tools - provided by AppSeed
Features
PeeweeDB Reflection- Supported DB:
- SQLite, MySql, PostgreSQL
- DbWrapper Class:
print_all_models()- returns all tablesprint_db_model- print table definitiondump_tables()- Dump SQL definitions (all tables)dump_tables_data()- Dump database content (all tables)
Clone Sources (this repo)
$ git clone https://github.com/app-generator/devtool-db.git$cd devtool-dbInstall Modules using a Virtual Environment
$ virtualenv env$source env/bin/activate$ pip install -r requirements.txtOr forWindows-based Systems
$ virtualenv env$ .\env\Scripts\activate$$# Install modules - SQLite Database$ pip3 install -r requirements.txt
Launch the Python console
$ python>>> >>> from util import*# import helpers>>> >>> db_sqlite =DbWrapper()# invoke the Base Class>>> db_sqlite.driver = COMMON.DB_SQLITE# set driver>>> db_sqlite.db_name ='samples/api-django.sqlite3'# set db name>>>db_sqlite.connect()# connectTrue >>>db_sqlite.load_models()# load DB SChemaTrue>>>db_sqlite.dump_tables()# Dump tables definitionsTrue>>>db_sqlite.dump_tables_data()# Dump data> Dump datafor [api_user_user]> Dump datafor [api_authentication_activesession]> Dump datafor [auth_group]> Dump datafor [api_user_user_groups]> Dump datafor [django_content_type]> Dump datafor [auth_permission]> Dump datafor [api_user_user_user_permissions]> Dump datafor [auth_group_permissions]> Dump datafor [django_admin_log]> Dump datafor [django_migrations]> Dump datafor [django_session]True>>>db_sqlite.reset()# reset the Class data>>>
At this point, the tables and data are saved in theoutput directory.
$cd output; ls $ SQLITE.sql$ SQLITE_api_user_user.sql$ SQLITE_auth_permission.sql$ SQLITE_django_content_type.sql$ SQLITE_django_migrations.sql
Database Introspection Tool - Provided byAppSeedApp Generator.
About
Database Introspection Tool - Open-Source | AppSeed
Topics
Resources
License
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Packages0
No packages published