---

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;"


sqlite3 db/database.sqlite ".schema ModePeriods" ".schema Periods" ".schema EmployeesLockModes" ".schema ReasonsLockModes"


for t in ModePeriods Periods EmployeesLockModes ReasonsLockModes ControllerMemories; do echo "$t: $(sqlite3 db/database.sqlite "SELECT COUNT(*) FROM $t")"; done