Загрузка данных
Загрузка данных
mc@mcris-ad-293a:~/Загрузки/Distr/Ironlogic$ sqlite3 -header -column db/database.sqlite "SELECT accessTypeSource, isGuest, state, COUNT(*) n FROM Employees GROUP BY 1,2,3;" "SELECT accessTypeSource, active, isActiveInTheZone, COUNT(*) n, SUM(employeeId IS NULL) no_employee, MIN(validTo) min_to, MAX(validTo) max_to FROM Identifiers GROUP BY 1,2,3;" "SELECT id, name, parentId, state FROM Entities;" "SELECT p.id, p.name, p.state, c.serial, c.state c_state, c.fireMode, p.insideEntityId ins, p.outsideEntitysId outs FROM PassPoints p JOIN Controllers c ON c.id = p.controllerId;"
accessTypeSource isGuest state n
---------------- ------- ----- ---
allow 0 1 8
allow 0 2 2
allow 1 1 1
department 0 1 117
department 0 2 48
department 1 2 1
entity 0 1 3
accessTypeSource active isActiveInTheZone n no_employee min_to max_to
---------------- ------ ----------------- --- ----------- ------------- -------------
1 0 133 68 1798666500000 1822374000000
id name parentId state
-- ------- -------- -----
1 7 этаж 1
2 6 этаж 1
3 3 этаж 1
id name state serial c_state fireMode ins outs
-- -------- ----- ------ ------- -------- --- ----
1 Вход 0 25692 ACTIVE 1
2 Лестница 0 15888 ACTIVE 1
3 Лифт 2 0 26033 ACTIVE 1
4 Лифт 1 0 28383 ACTIVE 1
5 Лестница 0 28379 ACTIVE 1
6 Лифт 2 0 53681 ACTIVE 1
7 Лестница 0 53682 ACTIVE 1
8 Лифт 1 0 51795 ACTIVE 1
mc@mcris-ad-293a:~/Загрузки/Distr/Ironlogic$ sqlite3 db/database.sqlite ".schema ModePeriods" ".schema Periods" ".schema EmployeesLockModes" ".schema ReasonsLockModes"
CREATE TABLE `ModePeriods` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `number` INTEGER, `days` INTEGER, `from` INTEGER, `to` INTEGER, `active` TINYINT(1), `mode` INTEGER, `cntrlId` INTEGER NOT NULL REFERENCES `Controllers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE);
CREATE TABLE `Periods` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `number` INTEGER, `days` INTEGER, `from` INTEGER, `to` INTEGER, `active` TINYINT(1), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `entityId` INTEGER REFERENCES `Entities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE);
CREATE TABLE `EmployeesLockModes` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `dateFrom` BIGINT NOT NULL, `dateTo` BIGINT NOT NULL, `status` TINYINT(1) NOT NULL, `isIncludeReport` TINYINT(1) NOT NULL DEFAULT 0, `substatus` INTEGER NOT NULL, `deleteStatus` INTEGER NOT NULL DEFAULT 1, `deleteDescription` VARCHAR(255) NOT NULL DEFAULT '-', `state` INTEGER NOT NULL DEFAULT 2, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `employeeId` INTEGER REFERENCES `Employees` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, `reasonId` INTEGER NOT NULL REFERENCES `ReasonsLockModes` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE);
CREATE TABLE `ReasonsLockModes` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `fullTitel` VARCHAR(255) NOT NULL, `abbreviation` VARCHAR(255) NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
mc@mcris-ad-293a:~/Загрузки/Distr/Ironlogic$ for t in ModePeriods Periods EmployeesLockModes ReasonsLockModes ControllerMemories; do echo "$t: $(sqlite3 db/database.sqlite "SELECT COUNT(*) FROM $t")"; done
ModePeriods: 16
Periods: 21
EmployeesLockModes: 0
ReasonsLockModes: 0
ControllerMemories: 0
mc@mcris-ad-293a:~/Загрузки/Distr/Ironlogic$
