<filename>labertasche/database/__init__.py
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
# /**********************************************************************************
#  * _author  : <NAME>
#  * _mail    : <EMAIL>
#  * _repo    : https://git.tuxstash.de/gothseidank/labertasche
#  * _license : This project is under MIT License
#  *********************************************************************************/
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy import MetaData
from sqlalchemy.pool import NullPool

# naming conventions
convention = {
    "ix": 'ix_%(column_0_label)s',
    "uq": "uq_%(table_name)s_%(column_0_name)s",
    "ck": "ck_%(table_name)s_%(column_0_name)s",
    "fk": "fk_%(table_name)s_%(column_0_name)s_%(referred_table_name)s",
    "pk": "pk_%(table_name)s"
}
metadata = MetaData(naming_convention=convention)

# Create SQLAlchemy
labertasche_db = SQLAlchemy(metadata=metadata, engine_options={
    'poolclass': NullPool
})

<filename>labertasche/database/__init__.py
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
# /**********************************************************************************
#  * _author  : <NAME>
#  * _mail    : <EMAIL>
#  * _repo    : https://git.tuxstash.de/gothseidank/labertasche
#  * _license : This project is under MIT License
#  *********************************************************************************/
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy import MetaData
from sqlalchemy.pool import NullPool

# naming conventions
convention = {
    "ix": 'ix_%(column_0_label)s',
    "uq": "uq_%(table_name)s_%(column_0_name)s",
    "ck": "ck_%(table_name)s_%(column_0_name)s",
    "fk": "fk_%(table_name)s_%(column_0_name)s_%(referred_table_name)s",
    "pk": "pk_%(table_name)s"
}
metadata = MetaData(naming_convention=convention)

# Create SQLAlchemy
labertasche_db = SQLAlchemy(metadata=metadata, engine_options={
    'poolclass': NullPool
})

#!/usr/bin/env python3 # -*- coding: utf-8 -*- # /********************************************************************************** #  * _author  : <NAME> #  * _mail    : <EMAIL> #  * _repo    : https://git.tuxstash.de/gothseidank/labertasche #  * _license : This project is under MIT License #  *********************************************************************************/ # naming conventions # Create SQLAlchemy