mirror of
https://github.com/MikroWizard/mikroman.git
synced 2025-06-21 03:55:39 +02:00
41 lines
1 KiB
Python
41 lines
1 KiB
Python
|
|
||
|
|
# 002_devices.py
|
||
|
|
|
||
|
|
def migrate(migrator, database, fake=False, **kwargs):
|
||
|
|
|
||
|
|
# an example class for demonstrating CRUD...
|
||
|
|
|
||
|
|
migrator.sql("""CREATE TABLE devices(
|
||
|
|
id serial PRIMARY KEY NOT NULL,
|
||
|
|
name text,
|
||
|
|
ip text,
|
||
|
|
mac text UNIQUE,
|
||
|
|
details text,
|
||
|
|
uptime text,
|
||
|
|
license text,
|
||
|
|
interface text,
|
||
|
|
user_name text,
|
||
|
|
password text,
|
||
|
|
port text,
|
||
|
|
update_availble boolean,
|
||
|
|
current_firmware text,
|
||
|
|
arch text,
|
||
|
|
upgrade_availble boolean,
|
||
|
|
sensors text,
|
||
|
|
router_type text,
|
||
|
|
wifi_config text,
|
||
|
|
peer_ip text,
|
||
|
|
failed_attempt int DEFAULT 0,
|
||
|
|
syslog_configured boolean,
|
||
|
|
status text NOT NULL DEFAULT 'done',
|
||
|
|
firmware_to_install text,
|
||
|
|
owner uuid REFERENCES users(id),
|
||
|
|
created timestamp not null default CURRENT_TIMESTAMP,
|
||
|
|
modified timestamp not null default CURRENT_TIMESTAMP
|
||
|
|
)""")
|
||
|
|
|
||
|
|
def rollback(migrator, database, fake=False, **kwargs):
|
||
|
|
|
||
|
|
migrator.sql("""DROP TABLE devices""")
|
||
|
|
|