DB schema and sqlalchemy db models for fibrenest
Project description
fibrenest_db_models
This is the DB schema and sqlalchemy db models for fibrenest
Usage
You would want to install this module in your project and then import the
needed db model.
There is separate model if the backend DB is postgres.
DB Models for OLD Mysql DB are in old.py
Installation
pip install fibrenest-db-models
Example import for postgres
from fibrenest_db_models.postgres import *
Example import for all other DBs
from fibrenest_db_models.all import *
Creating the DB and tables
If the DB is not created, then you would need to first create the DB. Use sqlalchemy-utils for this.
After the DB is created, you can connect to this DB and create tables. Detailed instructions here
engine = create_engine('sqlite:///test.db')
Base.metadata.create_all(engine)
Models
- ONT: Table for ONTs info
- SUBSCRIPTION: Table for Service subscriptions
- RADCHECK: Table for radius radcheck
- RADUSERGROUP: Table for radius user group
- RADACCT: Radius accounting table. Available only for postgres
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file fibrenest_db_models-21.11.tar.gz
.
File metadata
- Download URL: fibrenest_db_models-21.11.tar.gz
- Upload date:
- Size: 5.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.6.0 importlib_metadata/4.8.2 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.7.12
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8da448166d32246fc9519632fe7dfc91afb74cb5753923ed9337669db4eeb929 |
|
MD5 | 9e3b2d9fb0891554389ae0e89250551d |
|
BLAKE2b-256 | f3c30024a68f906c24d1946b276522d59d9086a37ac642623377e75c15d8c68f |
File details
Details for the file fibrenest_db_models-21.11-py3-none-any.whl
.
File metadata
- Download URL: fibrenest_db_models-21.11-py3-none-any.whl
- Upload date:
- Size: 8.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.6.0 importlib_metadata/4.8.2 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.7.12
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 974dac8dd4ef4cf93777d63df24f26ad4e421fe894b807496dacc4d3ca77e5bb |
|
MD5 | 46d3dfd364d72f7a1e8d4f27f1e90a97 |
|
BLAKE2b-256 | 4eb44cc5cb23113560499fc4286be6d911a9934a240b12b3f81ccad090dac1b0 |