d5f403d557
Finished switch to JSONRPC commit 9cf6dd9a0e03c71135c01d4ad4f7d3be0f1e3066 Author: Giovanni Harting <giovanni.harting@touchdata.net> Date: Sat Oct 10 21:09:20 2015 +0200 fixed some bugs added some missing things from transition commit 8ed44b8fcde739b541b1834049025b055a50e6fe Author: Marius Schiffer <marius@mschiffer.de> Date: Sat Oct 10 05:53:41 2015 +0200 Creating fresh database works now. Fixed pwm_freq property. commit dc88ef0df427f90746a499912eff70dfce967c55 Author: Marius Schiffer <marius@mschiffer.de> Date: Sat Oct 10 04:40:41 2015 +0200 Completed SQLAlchemy integration. Completed JSON-RPC integration. All daemon class functionality is now on module-level (required for JSON-RPC decorators). Migrations will have to be reimplemented with alembic. commit a4cabdcd00a3e2a3cbbd92a3c9d59a4235e4d277 Author: Marius Schiffer <marius@mschiffer.de> Date: Sat Oct 10 03:00:19 2015 +0200 First steps towards SQLAlchemy integration.
24 lines
658 B
SQL
24 lines
658 B
SQL
CREATE TABLE `stripes` (
|
|
`id` INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE,
|
|
`name` TEXT,
|
|
`rgb` INTEGER,
|
|
`controller_id` INTEGER,
|
|
`channel_r` INTEGER,
|
|
`channel_g` INTEGER,
|
|
`channel_b` INTEGER,
|
|
`channel_r_gamma` REAL DEFAULT 2.8,
|
|
`channel_g_gamma` REAL DEFAULT 2.8,
|
|
`channel_b_gamma` REAL DEFAULT 2.8
|
|
);
|
|
CREATE TABLE "meta" (
|
|
`option` TEXT,
|
|
`value` TEXT
|
|
);
|
|
INSERT INTO `meta` VALUES ('db_version', '2');
|
|
CREATE TABLE "controller" (
|
|
`id` INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE,
|
|
`address` TEXT,
|
|
`i2c_device` INTEGER,
|
|
`channels` INTEGER,
|
|
`pwm_freq` INTEGER
|
|
); |