stmt

const AllTagGroups = `SELECT * FROM taggroup ORDER BY updated_at;`

const AllTagsByDate = `` /* 145-byte string literal not displayed */

const AllTagsByName = `` /* 139-byte string literal not displayed */

const ChangeNoteType = `UPDATE note SET type=? WHERE id=?;`

const CountPatches = `SELECT count(*) FROM note_patch WHERE note_id=?;`

const CreateTables = `` /* 2358-byte string literal not displayed */

const DeleteNote = `DELETE FROM note WHERE id=?;`

const DeleteTag = `DELETE FROM tag WHERE id=?;`

const DeleteTagGroup = `DELETE FROM taggroup WHERE id=?;`

const DeleteTags = `DELETE FROM note_tag WHERE note_id=? and tag_id=?;`

const DeleteTagsByNote = `DELETE FROM note_tag WHERE note_id=?;`

const GetAllNoteIDs = `SELECT id FROM note`

const GetDeletedNotes = `SELECT * FROM note WHERE deleted>0 ORDER BY updated_at DESC;`

const GetIntValue = `SELECT int_value FROM metadata WHERE name=?;`

const GetLastNoteID = `SELECT id FROM note ORDER BY created_at DESC LIMIT 1;`

const GetNote = `SELECT * FROM note WHERE id=?;`

const GetNoteSize = `SELECT size FROM note WHERE id=?;`

const GetNotes = `SELECT * FROM note WHERE deleted=0 ORDER BY updated_at DESC;`

const GetNotesByTagID = `SELECT note_id FROM note_tag WHERE tag_id=?;`

const GetNotesByTagName = `` /* 166-byte string literal not displayed */

const GetPatchesByNote = `` /* 161-byte string literal not displayed */

const GetReminders = `SELECT * FROM note WHERE deleted=0 and remind_at<>"" ORDER BY remind_at;`

const GetTag = `SELECT * FROM tag WHERE id=?;`

const GetTagByName = `SELECT * FROM tag WHERE name=?;`

const GetTagGroup = `SELECT * FROM taggroup WHERE id=?;`

const GetTagGroupID = `SELECT id FROM taggroup WHERE tags=?;`

const GetTagID = `SELECT id FROM tag WHERE name=?;`

const GetTagsByNote = `` /* 155-byte string literal not displayed */

const GetTextValue = `SELECT text_value FROM metadata WHERE name=?;`

const InsertFile = `INSERT INTO file (
    id, name, size, type, checksum, deleted, created_at, updated_at)
    VALUES (?, ?, ?, ?, ?, ?, ?, ?);`

const InsertIntValue = `INSERT INTO metadata (name, int_value) VALUES (?, ?);`

const InsertNote = `` /* 126-byte string literal not displayed */

const InsertNoteFile = `INSERT INTO note_file (note_id, file_id) VALUES (?, ?);`

const InsertNotePatch = `INSERT INTO note_patch (note_id, patch_id) VALUES (?, ?);`

const InsertNoteTag = `INSERT INTO note_tag (note_id, tag_id) VALUES (?, ?);`

const InsertPatch = `INSERT INTO patch (id, diff) VALUES (?, ?);`

const InsertTag = `INSERT INTO tag (id, name, created_at) VALUES (?, ?, ?);`

const InsertTagGroup = `INSERT INTO taggroup (
    id, tags, protected, created_at, updated_at)
    VALUES (?, ?, ?, ?, ?);`

const InsertTextValue = `INSERT INTO metadata (name, text_value) VALUES (?, ?);`

const LastTagGroup = `SELECT id FROM taggroup WHERE protected=0
    ORDER BY updated_at LIMIT 1;`

const RenameTag = `UPDATE tag SET name=? WHERE id=?; `

const SearchNoteTitle = `SELECT * FROM note WHERE deleted=0 and title LIKE ?`

const SetNoteDeleted = `UPDATE note SET deleted=? WHERE id=?;`

const SetReminder = `UPDATE note SET remind_at=? WHERE id=?;`

const SetTagGroupProtected = `UPDATE taggroup SET protected=? WHERE id=?;`

const SetTypeTitle = `UPDATE note SET type=?, title=? WHERE id=?;`

const TagGroupCount = `SELECT count(*) FROM taggroup`

const UpdateIntValue = `UPDATE metadata SET int_value=? WHERE name=?;`

const UpdateTagGroupNow = `UPDATE taggroup SET updated_at=? WHERE id=?;`

const UpdateTextValue = `UPDATE metadata SET text_value=? WHERE name=?;`

const UpdateTitleSizeNow = `UPDATE note SET title=?, size=?, updated_at=?
    WHERE id=?;`