49 lines
1.8 KiB
JavaScript
49 lines
1.8 KiB
JavaScript
|
export const getAllTables = `SELECT name FROM sqlite_schema WHERE type = 'table' AND name NOT LIKE 'sqlite_%';`
|
||
|
|
export const createTaskTable = `
|
||
|
|
CREATE TABLE if not exists "task" (
|
||
|
|
"id" INTEGER,
|
||
|
|
"title" TEXT,
|
||
|
|
"desc" TEXT,
|
||
|
|
"status" TEXT,
|
||
|
|
"timeTill" TEXT,
|
||
|
|
"timeFinished" TEXT,
|
||
|
|
"navi" TEXT,
|
||
|
|
PRIMARY KEY("id" AUTOINCREMENT)
|
||
|
|
);
|
||
|
|
`
|
||
|
|
|
||
|
|
export const createSubtaskTable = `
|
||
|
|
CREATE TABLE if not exists "subtask" (
|
||
|
|
"id" INTEGER,
|
||
|
|
"taskID" INTEGER,
|
||
|
|
"title" TEXT,
|
||
|
|
"desc" TEXT,
|
||
|
|
"status" TEXT,
|
||
|
|
"timeTill" TEXT,
|
||
|
|
"timeFinished" TEXT,
|
||
|
|
"navi" TEXT,
|
||
|
|
PRIMARY KEY("id" AUTOINCREMENT)
|
||
|
|
);
|
||
|
|
`
|
||
|
|
|
||
|
|
export const createNotificationTable = `
|
||
|
|
CREATE TABLE if not exists "notification" (
|
||
|
|
"id" INTEGER,
|
||
|
|
"title" TEXT,
|
||
|
|
"desc" TEXT,
|
||
|
|
"status" TEXT,
|
||
|
|
"dateCreated" TEXT,
|
||
|
|
"dateRead" TEXT,
|
||
|
|
PRIMARY KEY("id" AUTOINCREMENT)
|
||
|
|
);
|
||
|
|
|
||
|
|
`
|
||
|
|
|
||
|
|
export const fakeTaskInsert = `
|
||
|
|
insert into task (title, desc, status, timeTill, timeFinished) values
|
||
|
|
('Автомобиль назначен на маршрут Москва-Омск-Новосибирск', '', 'active', '2023-12-10T23:59:59.000Z', null),
|
||
|
|
('Автомобиль назначен на маршрут Москва-Омск-Новосибирск', '', 'active', '2024-12-31T23:59:59.000Z', null),
|
||
|
|
('Автомобиль назначен на маршрут Москва-Омск-Новосибирск', '', 'completed', '2023-12-31T23:59:59.000Z', '2023-12-31T23:58:59.000Z'),
|
||
|
|
('Автомобиль назначен на маршрут Москва-Омск-Новосибирск', '', 'completed', '2023-12-05T23:59:59.000Z', '2023-12-06T23:58:59.000Z');
|
||
|
|
`
|