stmt

Documentation

Index

• Constants

Constants

const AllFilesByTag = `SELECT file_id FROM file_tag WHERE tag_id=?;`

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

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

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

const CountAllFiles = `SELECT count(*) FROM file;`

const CountDamagedFiles = `SELECT count(*) FROM file WHERE damaged>0;`

const CountFilesByName = `SELECT count(*) FROM file WHERE name=?;`

const CountFilesNeedCheck = `SELECT count(*) FROM file WHERE checked<?;`

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

const DamagedFileIDs = `SELECT id FROM file WHERE damaged>0;`

const DamagedFiles = `SELECT * FROM file WHERE damaged>0;`

const DeleteFile = `DELETE FROM file WHERE id=?;`

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

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

const DeleteTags = `DELETE FROM file_tag WHERE file_id=? and tag_id=?;`

const GetAllFiles = `SELECT * FROM file;`

const GetDeletedFiles = `SELECT * FROM file WHERE deleted>0 ORDER BY utime;`

const GetFile = `SELECT * FROM file WHERE id=?;`

const GetFileDamaged = `SELECT damaged FROM file WHERE id=?;`

const GetFileHash = `SELECT hash FROM file WHERE id=?;`

const GetFileID = `SELECT id FROM file WHERE hash=?;`

const GetFileIDsByName = `SELECT id FROM file WHERE name=? ORDER BY ctime DESC;`

const GetFileName = `SELECT name FROM file WHERE id=?`

const GetFiles = `SELECT * FROM file WHERE deleted=0 ORDER BY ctime DESC LIMIT ?;`

const GetFilesByTag = `` /* 164-byte string literal not displayed */

const GetFilesHasThumbByTag = `` /* 210-byte string literal not displayed */

const GetFilesNeedCheck = `SELECT * FROM file WHERE checked<?;`

const GetFilesNoThumbByTag = `` /* 210-byte string literal not displayed */

const GetImages = `
  SELECT * FROM file WHERE deleted=0 and type like "image/%"
  ORDER BY ctime DESC LIMIT ?;`

const GetImagesByTag = `` /* 193-byte string literal not displayed */

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

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

const GetTagCTime = `SELECT ctime FROM tag WHERE id=?;`

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

const GetTagsByFile = `SELECT tag_id FROM file_tag WHERE file_id=?;`

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

const InsertFile = `` /* 159-byte string literal not displayed */

const InsertFileTag = `INSERT INTO file_tag (file_id, tag_id) VALUES (?, ?);`

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

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

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

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

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

const RenameFilesNow = `UPDATE file SET name=?, type=?, utime=? WHERE name=?;`

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

const RenameTag_InFileTag = `UPDATE file_tag SET tag_id=? WHERE tag_id=?;`

const ReplaceFile = `UPDATE file SET size=?, hash=?, utime=?, checked=0, damaged=0 WHERE id=?;`

const SearchFileName = `
  SELECT * FROM file WHERE deleted=0 and name LIKE ? ORDER BY ctime DESC;`

const SearchImageName = `
  SELECT * FROM file WHERE deleted=0 and type like "image/%" and name LIKE ?
  ORDER BY ctime DESC;`

const SetFileChecked = `UPDATE file SET checked=?, damaged=? WHERE id=?;`

const SetFileDeletedNow = `UPDATE file SET deleted=?, utime=? WHERE id=?;`

const SetFilesCount = `UPDATE file SET count=? WHERE name=?;`

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

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

const TotalSize = `SELECT COALESCE(sum(size),0) as totalsize FROM file;`

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

const UpdateNow = `UPDATE file SET utime=? WHERE id=?;`

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

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