stmt

Documentation

Index

• Constants

Constants

const AllFilesInBucket = `` /* 351-byte string literal not displayed */

const AllPicsInBucket = `` /* 380-byte string literal not displayed */

const BucketCountFiles = `SELECT count(*) FROM file
	INNER JOIN bucket ON file.bucket_name = bucket.name
	WHERE bucket.id=?;`

const BucketTotalSize = `SELECT COALESCE(sum(size),0) as totalsize FROM file
	INNER JOIN bucket ON file.bucket_name = bucket.name
	WHERE bucket.id=?;`

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

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

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

const CountFilesInBucket = `SELECT count(*) FROM file WHERE bucket_name=?;`

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

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

const DeleteBucket = `DELETE FROM bucket WHERE id=?;`

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

const GetAllBuckets = `SELECT * FROM bucket ORDER BY encrypted;`

const GetAllFiles = `SELECT * FROM file;`

const GetAllFilesLimit = `` /* 332-byte string literal not displayed */

Bug: 有注入風險, 但这是單用戶系統, 因此風險可控.

const GetAllKeywords = `SELECT file.keywords FROM file
	GROUP BY file.keywords
	ORDER BY file.keywords;`

const GetAllPicsLimit = `` /* 364-byte string literal not displayed */

const GetBucket = `SELECT * FROM bucket WHERE id=?;`

const GetBucketByName = `SELECT * FROM bucket WHERE name=?;`

const GetDamagedFiles = `` /* 329-byte string literal not displayed */

const GetFileByChecksum = `SELECT * FROM file WHERE checksum=?;`

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

const GetFileByName = `SELECT * FROM file WHERE name=?;`

const GetFilePlus = `` /* 301-byte string literal not displayed */

const GetFilePlusByName = `` /* 303-byte string literal not displayed */

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

const GetPublicBuckets = `SELECT * FROM bucket WHERE encrypted=FALSE;`

const GetPublicFilesLimit = `` /* 359-byte string literal not displayed */

Bug: 有注入風險, 但这是單用戶系統, 因此風險可控.

const GetPublicKeywords = `` /* 162-byte string literal not displayed */

const GetPublicPicsLimit = `` /* 396-byte string literal not displayed */

const InsertBucket = `INSERT INTO bucket (
	name, title, subtitle, encrypted
) VALUES (?, ?, ?, ?);`

const InsertBucketWithID = `INSERT INTO bucket (
	id, name, title, subtitle, encrypted
) VALUES (?, ?, ?, ?, ?);`

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

const InsertFileWithID = `` /* 197-byte string literal not displayed */

const MoveFileToBucket = `UPDATE file SET bucket_name=? WHERE id=?;`

const PublicFilesInBucket = `` /* 383-byte string literal not displayed */

const PublicPicsInBucket = `` /* 412-byte string literal not displayed */

const SearchAllFiles = `` /* 387-byte string literal not displayed */

const SearchAllPics = `` /* 421-byte string literal not displayed */

const SearchPublicFiles = `` /* 419-byte string literal not displayed */

const SearchPublicPics = `` /* 448-byte string literal not displayed */

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

const UpdateBackupFileInfo = `` /* 149-byte string literal not displayed */

const UpdateBucketInfo = `UPDATE bucket SET name=?, title=?, subtitle=?
	WHERE id=?;`

const UpdateBucketName = `UPDATE bucket SET name=? WHERE id=?;`

const UpdateBucketTitle = `UPDATE bucket SET title=?, subtitle=? WHERE id=?;`

const UpdateChecksumAndBucket = `UPDATE file
	SET checksum=?, bucket_name=? WHERE id=?;`

const UpdateFileContent = `UPDATE file
	SET checksum=?, size=?, utime=?, damaged=FALSE WHERE id=?;`

const UpdateFileInfo = `UPDATE file SET name=?, notes=?,
	keywords=?, type=?, like=?, ctime=?, utime=? WHERE id=?;`