Нема описа

manage_srv_settings_db.py 615B

123456789101112131415161718192021222324252627
  1. from sqlalchemy import text
  2. from app import db
  3. from app.models.models import ServerSettings
  4. from app.schema.marshables import ServerSettingsSchema
  5. def get_srv_settings():
  6. return ServerSettings.query.first()
  7. def get_server_settings_as_dict():
  8. srv_settings = ServerSettings.query.first()
  9. if srv_settings:
  10. sc = ServerSettingsSchema()
  11. return sc.dump(srv_settings)
  12. else:
  13. return {}
  14. def get_alembic_revision():
  15. with db.engine.connect() as con:
  16. version_num = con.execute(text("SELECT version_num FROM alembic_version")).first()[0]
  17. return version_num or None