Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Database Introspection Tool - Open-Source | AppSeed

License

NotificationsYou must be signed in to change notification settings

app-generator/devtool-db-introspection

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Open-Sourcedevelopers tool that provides simple helpers for legacy databases introspection. Crafted on top ofPython andPeewee.


Features

  • Peewee DB Reflection
  • Supported DB:
    • SQLite, MySql, PostgreSQL
  • DbWrapper Class:
    • print_all_models() - returns all tables
    • print_db_model - print table definition
    • dump_tables() - Dump SQL definitions (all tables)
    • dump_tables_data() - Dump database content (all tables)

Support viaGithub (issues tracker) andDiscord.


DB Migration Tool - Open-Source Developer Tool provided by AppSeed.


✨ Quick Start

Clone Sources (this repo)

$ git clone https://github.com/app-generator/devtool-db.git$cd devtool-db

Install Modules using a Virtual Environment

$ virtualenv env$source env/bin/activate$ pip install -r requirements.txt

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

[8]ページ先頭
©2009-2025 Movatter.jp