Skip to main content

Admin Panel for DB with Gino ORM and Sanic (inspired by Flask-Admin)

Project description

gino_admin

Admin Panel for DB with Gino ORM and Sanic (inspired by Flask-Admin)

Work in progress

If you have time and want to fix: Please open issues with that you want to add or write to me in Telegram: @xnuinside or mail: xnuinside@gmail.com

Version 0.0.5 Updates:

1. Upload from CSV: fixed upload from _hash fields - now in step of upload called hash function ( same as in edit, or add per item) 2. Fixed errors relative to datetime fields edit, added datetime_str_formats field to Config object, that allows to add custom datetime str formats. They used in step of convert str from DB to datetime object. 3. Now ‘_hash’ fields values in table showed as ‘*******’ 4. Fixed errors relative to int id’s. Now they works correct in edit and delete. 5. Update Menu template. Now if there is more when 4 models - they will be available under Dropdown menu.

Version 0.0.4 Updates:

  1. Upload from CSV - works, added example to examples/ files. You can upload data from ‘.csv’ tables.

  2. Edit per row - now exist button ‘edit’.

  3. Fixed delete for ALL rows of the model

  4. Fixed delete per element.

  5. Now works full ‘CRUD’.

  6. Fixed auth, now it sets ‘cookie’ and compare user-agent (for multiple users per login)

Limitations

For correct work of Admin Panel all models MUST contain unique ‘id’ field. ‘id’ used to identify row (one element) for Edit & Delete operations.

so if you define model, for example, User:

class User(db.Model):

    __tablename__ = "users"

    id = db.Column(db.String(), unique=True, primary_key=True)

Supported operations

  • One user auth

  • Create item by one for the Model

  • Delete all rows

  • Delete one item

  • Edit existed data

  • Upload data from csv

TODO:

  • Select multiple for delete

  • Edit multiple

  • Multiple users

  • Set up data presets (drop table for some data state, defined from csv)

  • Filters in columns

  • Actions history

Screens:

Simple auth Add item Table view Add rows from CSV upload

Contributions

Contributions and feature requests are very welcome!

Developer guide

Project use pre-commit hooks, so you need setup them

Just run:

pre-commit install

to install git hooks in your .git/ directory.

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

gino_admin-0.0.5.tar.gz (13.0 kB view hashes)

Uploaded Source

Built Distribution

gino_admin-0.0.5-py3-none-any.whl (14.8 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page