mirror of
https://github.com/Sheldan/Sissi.git
synced 2026-01-19 06:24:07 +00:00
c6f20d617d
updating for Debra 2023 campaign adding internal rest api for debra information adding a debra button to receive information
21 lines
580 B
Python
21 lines
580 B
Python
import os
|
|
import sqlalchemy as db
|
|
|
|
from legacy_loader import load_all_warnings
|
|
from warning_importer import import_warnings
|
|
|
|
server_id = os.getenv('SERVER_ID')
|
|
|
|
all_warnings = load_all_warnings()
|
|
db_host = os.getenv('DB_HOST')
|
|
db_port = os.getenv('DB_PORT')
|
|
db_database = os.getenv('DB_NAME')
|
|
db_user = os.getenv('DB_USER')
|
|
db_password = os.getenv('DB_PASS')
|
|
|
|
engine = db.create_engine('postgresql://%s:%s@%s:%s/%s' % (db_user, db_password, db_host, db_port, db_database))
|
|
|
|
with engine.connect() as con:
|
|
with con.begin():
|
|
import_warnings(server_id, all_warnings, con)
|