Skip to main content

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

  1. ONT: Table for ONTs info
  2. SUBSCRIPTION: Table for Service subscriptions
  3. RADCHECK: Table for radius radcheck
  4. RADUSERGROUP: Table for radius user group
  5. RADACCT: Radius accounting table. Available only for postgres

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

fibrenest_db_models-21.11.tar.gz (5.7 kB view details)

Uploaded Source

Built Distribution

fibrenest_db_models-21.11-py3-none-any.whl (8.0 kB view details)

Uploaded Python 3

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

Hashes for fibrenest_db_models-21.11.tar.gz
Algorithm Hash digest
SHA256 8da448166d32246fc9519632fe7dfc91afb74cb5753923ed9337669db4eeb929
MD5 9e3b2d9fb0891554389ae0e89250551d
BLAKE2b-256 f3c30024a68f906c24d1946b276522d59d9086a37ac642623377e75c15d8c68f

See more details on using hashes here.

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

Hashes for fibrenest_db_models-21.11-py3-none-any.whl
Algorithm Hash digest
SHA256 974dac8dd4ef4cf93777d63df24f26ad4e421fe894b807496dacc4d3ca77e5bb
MD5 46d3dfd364d72f7a1e8d4f27f1e90a97
BLAKE2b-256 4eb44cc5cb23113560499fc4286be6d911a9934a240b12b3f81ccad090dac1b0

See more details on using hashes here.

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