26 lines
1.5 KiB
Python
26 lines
1.5 KiB
Python
import sqlite3
|
|
import os
|
|
|
|
DB_PATH = os.path.join(os.path.dirname(__file__), 'logs.db')
|
|
|
|
def init_db():
|
|
conn = sqlite3.connect(DB_PATH)
|
|
c = conn.cursor()
|
|
c.execute('''CREATE TABLE IF NOT EXISTS logs
|
|
(timestamp TEXT, hostname TEXT, ip_address TEXT, message TEXT)''')
|
|
c.execute('''CREATE TABLE IF NOT EXISTS boards
|
|
(hostname TEXT PRIMARY KEY, ip_address TEXT, input1 TEXT, input2 TEXT, input3 TEXT, input4 TEXT, relay1 TEXT, relay2 TEXT, relay3 TEXT, relay4 TEXT)''')
|
|
c.execute('''CREATE TABLE IF NOT EXISTS mir_server_missions
|
|
(ip TEXT, authorization TEXT, username TEXT, password TEXT, mission_id TEXT PRIMARY KEY)''')
|
|
c.execute('''CREATE TABLE IF NOT EXISTS requested_missions
|
|
(state TEXT, start_time TEXT, mission TEXT, mission_name TEXT, robot_id INTEGER, id INTEGER PRIMARY KEY)''')
|
|
c.execute('''CREATE TABLE IF NOT EXISTS robots
|
|
(ip TEXT PRIMARY KEY, url TEXT)''')
|
|
conn.commit()
|
|
|
|
# Insert a first row into the mir_server_missions table
|
|
c.execute('''INSERT OR IGNORE INTO mir_server_missions (ip, authorization, username, password, mission_id)
|
|
VALUES (?, ?, ?, ?, ?)''',
|
|
("10.76.153.4", "Basic ZGlzdHJpYnV0b3I6Y2RjYjhiNjAzYzFhZDNjNjVkZTM4ZGY2OWU5YjFkM2ZhMDA2OWEwMDcyMzZkMDNkOGVhNjMyNDVhMDg3YjJkZA==", "distributor", "cdc8b603c1ad3c65de38df69e9b1d3fa0069a007236d03d8ea63245a087b2dd", "a1343edc-975c-11ef-87e6-0242ac120002"))
|
|
conn.commit()
|
|
conn.close() |