{"level":"info","message":"logger initialized at level debug","label":"wizard","timestamp":"2018-09-04T07:25:45.290Z"}
{"level":"debug","message":"open resource C:\\Users\\Louis Paris\\AppData\\Local\\tropy\\app-1.2.0\\resources\\app.asar\\res\\strings\\renderer.en.yml","label":"wizard","timestamp":"2018-09-04T07:25:46.057Z"}
{"level":"verbose","message":"wizard ready after 949.97ms (78.1ms)","label":"wizard","timestamp":"2018-09-04T07:25:46.141Z"}
{"level":"verbose","message":"plugins scanned: 0","label":"wizard","timestamp":"2018-09-04T07:25:46.144Z"}
{"level":"verbose","message":"plugins loaded: 0","label":"wizard","timestamp":"2018-09-04T07:25:46.144Z"}
{"level":"info","message":"creating new project  in D:\\Histoire de la pédagogie de la création artistique\\Consultations archives\\Tropy HPCA\\test.tpy","label":"wizard","timestamp":"2018-09-04T07:26:09.365Z"}
{"level":"debug","message":"init db D:\\Histoire de la pédagogie de la création artistique\\Consultations archives\\Tropy HPCA\\test.tpy","label":"wizard","timestamp":"2018-09-04T07:26:09.368Z"}
{"level":"verbose","message":"opening db D:\\Histoire de la pédagogie de la création artistique\\Consultations archives\\Tropy HPCA\\test.tpy","label":"wizard","timestamp":"2018-09-04T07:26:09.371Z"}
{"query":"\n      SELECT count(*) AS count FROM sqlite_master","time":1059,"level":"debug","message":"db query took 1s","label":"wizard","timestamp":"2018-09-04T07:26:10.437Z"}
{"query":"--\r\n-- This file is auto-generated by executing all current\r\n-- migrations. Instead of editing this file, please create\r\n-- migrations to incrementally modify the database, and\r\n-- then regenerate this schema file.\r\n--\r\n-- To create a new empty migration, run:\r\n--   node scripts/db migration -- project [name] [sql|js]\r\n--\r\n-- To re-generate this file, run:\r\n--   node scripts/db migrate\r\n--\r\n\r\n-- Save the current migration number\r\nPRAGMA user_version=1803301510;","time":135,"level":"debug","message":"db query took 135ms","label":"wizard","timestamp":"2018-09-04T07:26:10.573Z"}
{"query":"-- Load sqlite3 .dump\r\nPRAGMA foreign_keys=OFF;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.573Z"}
{"query":"BEGIN TRANSACTION;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.573Z"}
{"query":"CREATE TABLE project (\r\n  project_id  TEXT     NOT NULL PRIMARY KEY,\r\n  name        TEXT     NOT NULL,\r\n  created     NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n\r\n  CHECK (project_id != ''),\r\n  CHECK (name != '')\r\n\r\n) WITHOUT ROWID;","time":1,"level":"debug","message":"db query took 1ms","label":"wizard","timestamp":"2018-09-04T07:26:10.575Z"}
{"query":"CREATE TABLE access (\r\n  uuid        TEXT     NOT NULL,\r\n  version     TEXT     NOT NULL,\r\n  path        TEXT     NOT NULL,\r\n  opened      NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  closed      NUMERIC,\r\n  CHECK (uuid != '' AND version != '' AND path != '')\r\n);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.575Z"}
{"query":"CREATE TABLE subjects (\r\n  id           INTEGER  PRIMARY KEY,\r\n  template     TEXT     NOT NULL DEFAULT 'https://tropy.org/v1/templates/generic',\r\n  type         TEXT,\r\n  created      NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  modified     NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP\r\n);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.575Z"}
{"query":"CREATE TABLE images (\r\n  id      INTEGER  PRIMARY KEY REFERENCES subjects ON DELETE CASCADE,\r\n  width   INTEGER  NOT NULL DEFAULT 0,\r\n  height  INTEGER  NOT NULL DEFAULT 0,\r\n  angle   NUMERIC  NOT NULL DEFAULT 0,\r\n  mirror  BOOLEAN  NOT NULL DEFAULT 0, brightness INTEGER NOT NULL DEFAULT 0, contrast INTEGER NOT NULL DEFAULT 0, hue INTEGER NOT NULL DEFAULT 0, saturation INTEGER NOT NULL DEFAULT 0, negative  BOOLEAN  NOT NULL DEFAULT 0,\r\n\r\n  CHECK (angle >= 0 AND angle <= 360),\r\n  CHECK (width >= 0 AND height >= 0)\r\n\r\n) WITHOUT ROWID;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.575Z"}
{"query":"CREATE TABLE photos (\r\n  id           INTEGER  PRIMARY KEY REFERENCES images ON DELETE CASCADE,\r\n  item_id      INTEGER  NOT NULL REFERENCES items ON DELETE CASCADE,\r\n  position     INTEGER,\r\n  path         TEXT     NOT NULL,\r\n  protocol     TEXT     NOT NULL DEFAULT 'file',\r\n  mimetype     TEXT     NOT NULL,\r\n  checksum     TEXT     NOT NULL,\r\n  orientation  INTEGER  NOT NULL DEFAULT 1,\r\n  metadata     TEXT     NOT NULL DEFAULT '{}', size INTEGER NOT NULL DEFAULT 0,\r\n\r\n  CHECK (orientation > 0 AND orientation < 9)\r\n) WITHOUT ROWID;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.575Z"}
{"query":"CREATE TABLE items (\r\n  id              INTEGER  PRIMARY KEY REFERENCES subjects ON DELETE CASCADE,\r\n  cover_image_id  INTEGER  REFERENCES images ON DELETE SET NULL\r\n) WITHOUT ROWID;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.576Z"}
{"query":"CREATE TABLE metadata (\r\n  id          INTEGER  NOT NULL REFERENCES subjects ON DELETE CASCADE,\r\n  property    TEXT     NOT NULL,\r\n  value_id    INTEGER  NOT NULL REFERENCES metadata_values,\r\n  language    TEXT,\r\n  created     NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n\r\n  CHECK (\r\n    language IS NULL OR language != '' AND language = trim(lower(language))\r\n  ),\r\n\r\n  PRIMARY KEY (id, property)\r\n) WITHOUT ROWID;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.576Z"}
{"query":"CREATE TABLE metadata_values (\r\n  value_id   INTEGER  PRIMARY KEY,\r\n  datatype   TEXT     NOT NULL,\r\n  text                NOT NULL,\r\n  data       TEXT,\r\n\r\n  CHECK (datatype != ''),\r\n  UNIQUE (datatype, text)\r\n);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.576Z"}
{"query":"CREATE TABLE notes (\r\n  note_id      INTEGER  PRIMARY KEY,\r\n  id           INTEGER  NOT NULL REFERENCES subjects ON DELETE CASCADE,\r\n  text         TEXT     NOT NULL,\r\n  state        TEXT     NOT NULL,\r\n  language     TEXT     NOT NULL DEFAULT 'en',\r\n  created      NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  modified     NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  deleted      NUMERIC,\r\n\r\n  CHECK (\r\n    language != '' AND language = trim(lower(language))\r\n  ),\r\n  CHECK (text != '')\r\n);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.576Z"}
{"query":"CREATE TABLE lists (\r\n  list_id         INTEGER  PRIMARY KEY,\r\n  name            TEXT     NOT NULL COLLATE NOCASE,\r\n  parent_list_id  INTEGER  DEFAULT 0 REFERENCES lists ON DELETE CASCADE,\r\n  position        INTEGER,\r\n  created         NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  modified        NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n\r\n  CHECK (list_id != parent_list_id),\r\n  CHECK (name != ''),\r\n\r\n  UNIQUE (parent_list_id, name)\r\n);","time":1,"level":"debug","message":"db query took 1ms","label":"wizard","timestamp":"2018-09-04T07:26:10.576Z"}
{"query":"INSERT INTO lists VALUES(0,'ROOT',NULL,NULL,'2017-01-31 12:00:00','2017-01-31 12:00:00');","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.576Z"}
{"query":"CREATE TABLE list_items (\r\n  list_id  INTEGER  REFERENCES lists ON DELETE CASCADE,\r\n  id       INTEGER  REFERENCES items ON DELETE CASCADE,\r\n  position INTEGER,\r\n  added    NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  deleted  NUMERIC,\r\n\r\n  PRIMARY KEY (list_id, id)\r\n) WITHOUT ROWID;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.576Z"}
{"query":"CREATE TABLE tags (\r\n  tag_id      INTEGER  PRIMARY KEY,\r\n  name        TEXT     NOT NULL COLLATE NOCASE,\r\n  color,\r\n  created     NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  modified    NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n\r\n  CHECK (name != ''),\r\n  UNIQUE (name)\r\n);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.576Z"}
{"query":"CREATE TABLE taggings (\r\n  tag_id     INTEGER  NOT NULL REFERENCES tags ON DELETE CASCADE,\r\n  id         INTEGER  NOT NULL REFERENCES subjects ON DELETE CASCADE,\r\n  PRIMARY KEY (id, tag_id)\r\n) WITHOUT ROWID;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.577Z"}
{"query":"CREATE TABLE trash (\r\n  id          INTEGER  PRIMARY KEY REFERENCES subjects ON DELETE CASCADE,\r\n  deleted     NUMERIC  NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n  reason      TEXT     NOT NULL DEFAULT 'user',\r\n\r\n  CHECK (reason IN ('user', 'auto', 'merge'))\r\n) WITHOUT ROWID;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.577Z"}
{"query":"PRAGMA writable_schema=ON;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.577Z"}
{"query":"INSERT INTO sqlite_master(type,name,tbl_name,rootpage,sql)VALUES('table','fts_notes','fts_notes',0,'CREATE VIRTUAL TABLE fts_notes USING fts5(\r\n  id UNINDEXED,\r\n  text,\r\n  language UNINDEXED,\r\n  content = ''notes'',\r\n  content_rowid = ''note_id'',\r\n  tokenize = ''porter unicode61''\r\n)');","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.577Z"}
{"query":"CREATE TABLE IF NOT EXISTS 'fts_notes_data'(id INTEGER PRIMARY KEY, block BLOB);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.577Z"}
{"query":"INSERT INTO fts_notes_data VALUES(1,X'');","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.577Z"}
{"query":"INSERT INTO fts_notes_data VALUES(10,X'00000000000000');","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.577Z"}
{"query":"CREATE TABLE IF NOT EXISTS 'fts_notes_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.577Z"}
{"query":"CREATE TABLE IF NOT EXISTS 'fts_notes_docsize'(id INTEGER PRIMARY KEY, sz BLOB);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.578Z"}
{"query":"CREATE TABLE IF NOT EXISTS 'fts_notes_config'(k PRIMARY KEY, v) WITHOUT ROWID;","time":1,"level":"debug","message":"db query took 1ms","label":"wizard","timestamp":"2018-09-04T07:26:10.578Z"}
{"query":"INSERT INTO fts_notes_config VALUES('version',4);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.578Z"}
{"query":"INSERT INTO sqlite_master(type,name,tbl_name,rootpage,sql)VALUES('table','fts_metadata','fts_metadata',0,'CREATE VIRTUAL TABLE fts_metadata USING fts5(\r\n  datatype UNINDEXED,\r\n  text,\r\n  content = ''metadata_values'',\r\n  content_rowid = ''value_id'',\r\n  tokenize = ''porter unicode61''\r\n)');","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.578Z"}
{"query":"CREATE TABLE IF NOT EXISTS 'fts_metadata_data'(id INTEGER PRIMARY KEY, block BLOB);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.578Z"}
{"query":"INSERT INTO fts_metadata_data VALUES(1,X'');","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.578Z"}
{"query":"INSERT INTO fts_metadata_data VALUES(10,X'00000000000000');","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.578Z"}
{"query":"CREATE TABLE IF NOT EXISTS 'fts_metadata_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.578Z"}
{"query":"CREATE TABLE IF NOT EXISTS 'fts_metadata_docsize'(id INTEGER PRIMARY KEY, sz BLOB);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.578Z"}
{"query":"CREATE TABLE IF NOT EXISTS 'fts_metadata_config'(k PRIMARY KEY, v) WITHOUT ROWID;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"INSERT INTO fts_metadata_config VALUES('version',4);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE TABLE selections (\r\n  id        INTEGER  PRIMARY KEY REFERENCES images ON DELETE CASCADE,\r\n  photo_id  INTEGER  NOT NULL REFERENCES photos ON DELETE CASCADE,\r\n  x         NUMERIC  NOT NULL DEFAULT 0,\r\n  y         NUMERIC  NOT NULL DEFAULT 0,\r\n  position  INTEGER\r\n\r\n) WITHOUT ROWID;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE TRIGGER insert_tags_trim_name\r\n  AFTER INSERT ON tags\r\n  BEGIN\r\n    UPDATE tags SET name = trim(name)\r\n      WHERE tag_id = NEW.tag_id;\r\n  END;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE TRIGGER update_tags_trim_name\r\n  AFTER UPDATE OF name ON tags\r\n  BEGIN\r\n    UPDATE tags SET name = trim(name)\r\n      WHERE tag_id = NEW.tag_id;\r\n  END;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE TRIGGER insert_lists_trim_name\r\n  AFTER INSERT ON lists\r\n  BEGIN\r\n    UPDATE lists SET name = trim(name)\r\n      WHERE list_id = NEW.list_id;\r\n  END;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE TRIGGER update_lists_trim_name\r\n  AFTER UPDATE OF name ON lists\r\n  BEGIN\r\n    UPDATE lists SET name = trim(name)\r\n      WHERE list_id = NEW.list_id;\r\n  END;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE TRIGGER update_lists_cycle_check\r\n  BEFORE UPDATE OF parent_list_id ON lists\r\n  FOR EACH ROW WHEN NEW.parent_list_id NOT NULL\r\n  BEGIN\r\n    SELECT CASE (\r\n        WITH RECURSIVE\r\n          ancestors(id) AS (\r\n            SELECT parent_list_id\r\n              FROM lists\r\n              WHERE list_id = OLD.list_id\r\n            UNION\r\n            SELECT parent_list_id\r\n              FROM lists, ancestors\r\n              WHERE lists.list_id = ancestors.id\r\n          )\r\n          SELECT count(*) FROM ancestors WHERE id = OLD.list_id LIMIT 1\r\n      )\r\n      WHEN 1 THEN\r\n        RAISE(ABORT, 'Lists may not contain cycles')\r\n      END;\r\n  END;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE TRIGGER update_metadata_values_abort\r\n  BEFORE UPDATE ON metadata_values\r\n  BEGIN\r\n    SELECT RAISE(ABORT, 'Metadata values should never be updated');\r\n  END;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE TRIGGER notes_ai_fts\r\n  AFTER INSERT ON notes\r\n  BEGIN\r\n    INSERT INTO fts_notes (rowid, id, text, language)\r\n      VALUES (NEW.note_id, NEW.id, NEW.text, NEW.language);\r\n  END;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE TRIGGER notes_ad_fts\r\n  AFTER DELETE ON notes\r\n  BEGIN\r\n    INSERT INTO fts_notes (fts_notes, rowid, id, text, language)\r\n      VALUES ('delete', OLD.note_id, OLD.id, OLD.text, OLD.language);\r\n  END;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE TRIGGER notes_au_fts\r\n  AFTER UPDATE OF text ON notes\r\n  BEGIN\r\n    INSERT INTO fts_notes (fts_notes, rowid, id, text, language)\r\n      VALUES ('delete', OLD.note_id, OLD.id, OLD.text, OLD.language);\r\n    INSERT INTO fts_notes (rowid, id, text, language)\r\n      VALUES (NEW.note_id, NEW.id, NEW.text, NEW.language);\r\n  END;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE TRIGGER metadata_values_ai_fts\r\n  AFTER INSERT ON metadata_values\r\n  FOR EACH ROW WHEN NEW.datatype NOT IN (\r\n    'http://www.w3.org/2001/XMLSchema#boolean',\r\n    'http://www.w3.org/2001/XMLSchema#hexBinary',\r\n    'http://www.w3.org/2001/XMLSchema#base64Binary',\r\n    'http://www.w3.org/1999/02/22-rdf-syntax-ns#HTML',\r\n    'http://www.w3.org/1999/02/22-rdf-syntax-ns#langString',\r\n    'http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral')\r\n  BEGIN\r\n    INSERT INTO fts_metadata (rowid, datatype, text)\r\n      VALUES (NEW.value_id, NEW.datatype, NEW.text);\r\n  END;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE TRIGGER metadata_values_ad_fts\r\n  AFTER DELETE ON metadata_values\r\n  FOR EACH ROW WHEN OLD.datatype NOT IN (\r\n    'http://www.w3.org/2001/XMLSchema#boolean',\r\n    'http://www.w3.org/2001/XMLSchema#hexBinary',\r\n    'http://www.w3.org/2001/XMLSchema#base64Binary',\r\n    'http://www.w3.org/1999/02/22-rdf-syntax-ns#HTML',\r\n    'http://www.w3.org/1999/02/22-rdf-syntax-ns#langString',\r\n    'http://www.w3.org/1999/02/22-rdf-syntax-ns#XMLLiteral')\r\n  BEGIN\r\n    INSERT INTO fts_metadata (fts_metadata, rowid, datatype, text)\r\n      VALUES ('delete', OLD.value_id, OLD.datatype, OLD.text);\r\n  END;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.579Z"}
{"query":"CREATE INDEX idx_photos_checksum ON photos (checksum);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.580Z"}
{"query":"CREATE INDEX idx_metadata_value_id ON metadata (value_id);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.580Z"}
{"query":"CREATE INDEX idx_trash_reason_deleted ON trash (reason, deleted);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.580Z"}
{"query":"CREATE INDEX idx_metadata_property ON metadata (property);","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.580Z"}
{"query":"PRAGMA writable_schema=OFF;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.580Z"}
{"query":"COMMIT;","time":89,"level":"debug","message":"db query took 89ms","label":"wizard","timestamp":"2018-09-04T07:26:10.669Z"}
{"query":"PRAGMA foreign_keys=ON;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.670Z"}
{"level":"verbose","message":"closing db D:\\Histoire de la pédagogie de la création artistique\\Consultations archives\\Tropy HPCA\\test.tpy","label":"wizard","timestamp":"2018-09-04T07:26:10.676Z"}
{"query":"INSERT INTO project (project_id, name) VALUES (?,?)","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.677Z"}
{"query":"PRAGMA optimize;","time":0,"level":"debug","message":"db query took 0ms","label":"wizard","timestamp":"2018-09-04T07:26:10.677Z"}
{"level":"warn","message":"failed to create project: SQLITE_CONSTRAINT: CHECK constraint failed: project","label":"wizard","timestamp":"2018-09-04T07:26:10.685Z"}
{"level":"debug","message":"Error: SQLITE_CONSTRAINT: CHECK constraint failed: project","label":"wizard","timestamp":"2018-09-04T07:26:10.685Z"}