30 lines
1014 B
Python
30 lines
1014 B
Python
import sqlite3
|
|
import os
|
|
|
|
DB_PATH = os.path.join(os.path.dirname(__file__), "onever_drive.db")
|
|
|
|
def seed():
|
|
conn = sqlite3.connect(DB_PATH)
|
|
cursor = conn.cursor()
|
|
|
|
jobs = [
|
|
("Respaldo de FortiGate API", "python", "app/scripts/backup_fortigate.py", "0 6,18 * * *"),
|
|
("Respaldo de UniFi Controller", "python", "app/scripts/backup_unifi.py", "0 3 * * *"),
|
|
("Respaldo de Grandstream UCM/GWN", "python", "app/scripts/backup_grandstream.py", "0 1 * * *")
|
|
]
|
|
|
|
for name, stype, path, cron in jobs:
|
|
cursor.execute("SELECT id FROM script_jobs WHERE script_path = ?", (path,))
|
|
if not cursor.fetchone():
|
|
cursor.execute(
|
|
"INSERT INTO script_jobs (name, script_type, script_path, schedule_cron, is_active, created_at) VALUES (?, ?, ?, ?, 1, CURRENT_TIMESTAMP)",
|
|
(name, stype, path, cron)
|
|
)
|
|
print(f"Seeded script job: {name}")
|
|
|
|
conn.commit()
|
|
conn.close()
|
|
|
|
if __name__ == "__main__":
|
|
seed()
|