gallerydb

type BatchLoadTarget struct {
	Path     string
	Htmx     string
	HxTarget string
	Encoding string
}

type Config struct {
	Key             string
	Value           string
	CreatedAt       interface{}
	UpdatedAt       interface{}
	Type            sql.NullString
	Category        sql.NullString
	RequiresRestart int64
	Description     sql.NullString
	DefaultValue    sql.NullString
	HelpText        sql.NullString
	ExampleValue    sql.NullString
}

type CustomQuerier interface {
	Querier
	GetBatchLoadTargets(ctx context.Context) ([]BatchLoadTarget, error)
	GetFileViewRowsByFolderID(ctx context.Context, folderID int64) (*sql.Rows, error)
	GetFileViewRowsByFolderPath(ctx context.Context, folderPath string) (*sql.Rows, error)
	GetFolderViewThumbnailBlobDataByPath(ctx context.Context, path string) ([]byte, error)
	GetPreloadRoutesByFolderID(ctx context.Context, parent_id sql.NullInt64) (*sql.Rows, error)
	GetThumbnailBlobDataByID(ctx context.Context, thumbnailID int64) ([]byte, error)
	UpsertThumbnailBlob(ctx context.Context, arg UpsertThumbnailBlobParams) error
}

type CustomQueries struct {
	*Queries
	// contains filtered or unexported fields
}

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type ExifMetadatum struct {
	FileID       int64
	CameraMake   sql.NullString
	CameraModel  sql.NullString
	LensModel    sql.NullString
	FocalLength  sql.NullString
	Aperture     sql.NullString
	ShutterSpeed sql.NullString
	Iso          sql.NullInt64
	Orientation  sql.NullInt64
	Latitude     sql.NullFloat64
	Longitude    sql.NullFloat64
	Altitude     sql.NullFloat64
	CaptureDate  sql.NullInt64
	Software     sql.NullString
}

type File struct {
	ID        int64
	FolderID  sql.NullInt64
	PathID    int64
	Filename  string
	SizeBytes sql.NullInt64
	Mtime     sql.NullInt64
	Md5       sql.NullString
	Phash     sql.NullInt64
	MimeType  sql.NullString
	Width     sql.NullInt64
	Height    sql.NullInt64
	CreatedAt interface{}
	UpdatedAt interface{}
}

type FilePath struct {
	ID   int64
	Path string
}

type FileView struct {
	ID         int64
	FolderID   sql.NullInt64
	FolderPath sql.NullString
	Path       string
	Filename   string
	SizeBytes  sql.NullInt64
	Mtime      sql.NullInt64
	Md5        sql.NullString
	Phash      sql.NullInt64
	MimeType   sql.NullString
	Width      sql.NullInt64
	Height     sql.NullInt64
	CreatedAt  interface{}
	UpdatedAt  interface{}
}

type Folder struct {
	ID        int64
	ParentID  sql.NullInt64
	PathID    int64
	Name      string
	Mtime     sql.NullInt64
	TileID    sql.NullInt64
	CreatedAt interface{}
	UpdatedAt interface{}
}

type FolderPath struct {
	ID   int64
	Path string
}

type FolderTileExistsView struct {
	Path  string
	ID    int64
	Found bool
}

type FolderView struct {
	ID        int64
	ParentID  sql.NullInt64
	Path      string
	Name      string
	Mtime     sql.NullInt64
	CreatedAt interface{}
	UpdatedAt interface{}
}

type GetGalleryStatisticsRow struct {
	CtFolders    int64
	CtFiles      int64
	SzFiles      sql.NullFloat64
	MinCreatedAt interface{}
	MaxUpdatedAt interface{}
}

type GetHttpCacheOldestCreatedRow struct {
	ID            int64
	CreatedAt     int64
	ContentLength sql.NullInt64
}

type HttpCache struct {
	ID              int64
	Key             string
	Method          string
	Path            string
	QueryString     sql.NullString
	Encoding        string
	Status          int64
	ContentType     sql.NullString
	CacheControl    sql.NullString
	Etag            sql.NullString
	LastModified    sql.NullString
	Vary            sql.NullString
	Body            []byte
	ContentLength   sql.NullInt64
	CreatedAt       int64
	ExpiresAt       sql.NullInt64
	ContentEncoding sql.NullString
}

type InsertIPTCKeywordParams struct {
	ID      int64
	FileID  int64
	Keyword string
}

type InvalidFile struct {
	Path      string
	Mtime     int64
	Size      int64
	Reason    sql.NullString
	CreatedAt int64
	UpdatedAt int64
}

type IptcKeyword struct {
	ID      int64
	FileID  int64
	Keyword string
}

type IptcMetadatum struct {
	FileID      int64
	Title       sql.NullString
	Description sql.NullString
	Keywords    sql.NullString
	Creator     sql.NullString
	Copyright   sql.NullString
	Credit      sql.NullString
	Source      sql.NullString
	CreatedDate sql.NullInt64
}

type LoginAttempt struct {
	Username       string
	FailedAttempts int64
	LockedUntil    sql.NullInt64
	LastAttemptAt  int64
}

type ModuleState struct {
	Name           string
	IsActive       int64
	LastStartedAt  sql.NullInt64
	LastFinishedAt sql.NullInt64
}

type QcFilePathSubsetFileName struct {
	Filename string
	Path     string
}

type QcFolderPathSubsetFilePath struct {
	FolderPath string
	FilePath   string
}

type Querier interface {
	ClearHttpCache(ctx context.Context) error
	ClearLoginAttempts(ctx context.Context, username string) error
	CountHttpCacheEntries(ctx context.Context) (int64, error)
	DeleteHttpCacheByID(ctx context.Context, id int64) error
	DeleteHttpCacheByKey(ctx context.Context, key string) error
	DeleteHttpCacheExpired(ctx context.Context) error
	DeleteIPTC(ctx context.Context, fileID int64) error
	DeleteIPTCKeyword(ctx context.Context, id int64) error
	DeleteInvalidFileByPath(ctx context.Context, path string) error
	DeleteXMPProperty(ctx context.Context, id int64) error
	DeleteXMPRaw(ctx context.Context, fileID int64) error
	GetConfigValueByKey(ctx context.Context, key string) (string, error)
	GetConfigs(ctx context.Context) ([]Config, error)
	GetExifByFile(ctx context.Context, fileID int64) (ExifMetadatum, error)
	GetFileByPath(ctx context.Context, path string) (File, error)
	GetFileViewByID(ctx context.Context, id int64) (FileView, error)
	GetFileViewsByFolderIDOrderByFileName(ctx context.Context, folderID sql.NullInt64) ([]FileView, error)
	// -- name: PopulateMissingTileID :exec
	// UPDATE folders
	//    SET tile_id = (
	//      SELECT tile_id
	//        FROM (
	//          SELECT f.id, p.id AS tile_id
	//               , DENSE_RANK() OVER (PARTITION BY f.id ORDER BY p.path) AS rnk
	//            FROM files f
	//                 INNER JOIN file_paths p
	//                   ON f.path_id = p.id
	//           WHERE f.tile_id IS NULL
	//        ) ranked
	//       WHERE ranked.id = folders.id
	//         AND ranked.rnk = 1
	//    )
	//  WHERE EXISTS (
	//      SELECT 1 FROM files f
	//      WHERE f.tile_id IS NULL AND folders.id = f.id
	//    );
	GetFolderByID(ctx context.Context, id int64) (Folder, error)
	GetFolderByPath(ctx context.Context, path string) (Folder, error)
	GetFolderIDByPath(ctx context.Context, path string) (int64, error)
	GetFolderTileExistsViewByPath(ctx context.Context, path string) (bool, error)
	GetFolderViewByID(ctx context.Context, id int64) (FolderView, error)
	GetFoldersViewsByParentIDOrderByName(ctx context.Context, parentID sql.NullInt64) ([]FolderView, error)
	GetGalleryStatistics(ctx context.Context) (GetGalleryStatisticsRow, error)
	// queries for HTTP cache table operations
	GetHttpCacheByKey(ctx context.Context, key string) (HttpCache, error)
	GetHttpCacheOldestCreated(ctx context.Context, limit int64) ([]GetHttpCacheOldestCreatedRow, error)
	GetHttpCacheSizeBytes(ctx context.Context) (interface{}, error)
	GetIPTCByFile(ctx context.Context, fileID int64) (IptcMetadatum, error)
	GetIPTCKeywords(ctx context.Context, fileID int64) ([]IptcKeyword, error)
	GetInvalidFileByPath(ctx context.Context, path string) (InvalidFile, error)
	GetLoginAttempt(ctx context.Context, username string) (LoginAttempt, error)
	GetModuleState(ctx context.Context, name string) (ModuleState, error)
	GetThumbnailExistsViewByID(ctx context.Context, id int64) (bool, error)
	GetThumbnailsByFileID(ctx context.Context, fileID int64) (Thumbnail, error)
	GetXMPPropertiesByFile(ctx context.Context, fileID int64) ([]XmpProperty, error)
	GetXMPRaw(ctx context.Context, fileID int64) (XmpRaw, error)
	HttpCacheExistsByKey(ctx context.Context, key string) (int64, error)
	InsertIPTCKeyword(ctx context.Context, arg InsertIPTCKeywordParams) error
	SetModuleState(ctx context.Context, arg SetModuleStateParams) error
	UnlockAccount(ctx context.Context, username string) error
	UpdateFolderTileId(ctx context.Context, arg UpdateFolderTileIdParams) error
	UpsertConfigValueOnly(ctx context.Context, arg UpsertConfigValueOnlyParams) error
	UpsertExif(ctx context.Context, arg UpsertExifParams) error
	UpsertFilePathReturningID(ctx context.Context, path string) (int64, error)
	UpsertFileReturningFile(ctx context.Context, arg UpsertFileReturningFileParams) (File, error)
	UpsertFolderPathReturningID(ctx context.Context, path string) (int64, error)
	UpsertFolderReturningFolder(ctx context.Context, arg UpsertFolderReturningFolderParams) (Folder, error)
	UpsertHttpCache(ctx context.Context, arg UpsertHttpCacheParams) error
	UpsertIPTC(ctx context.Context, arg UpsertIPTCParams) error
	UpsertInvalidFile(ctx context.Context, arg UpsertInvalidFileParams) error
	UpsertLoginAttempt(ctx context.Context, arg UpsertLoginAttemptParams) error
	UpsertThumbnailReturningID(ctx context.Context, arg UpsertThumbnailReturningIDParams) (int64, error)
	UpsertXMPProperty(ctx context.Context, arg UpsertXMPPropertyParams) error
	UpsertXMPRaw(ctx context.Context, arg UpsertXMPRawParams) error
}

type Queries struct {
	// contains filtered or unexported fields
}

type SetModuleStateParams struct {
	Name           string
	IsActive       int64
	LastStartedAt  sql.NullInt64
	LastFinishedAt sql.NullInt64
}

type Thumbnail struct {
	ID        int64
	FileID    int64
	SizeLabel string
	Width     int64
	Height    int64
	Format    string
	CreatedAt interface{}
	UpdatedAt interface{}
}

type ThumbnailExistsView struct {
	Path  string
	ID    int64
	Found bool
}

type UpdateFolderTileIdParams struct {
	TileID sql.NullInt64
	ID     int64
}

type UpsertConfigValueOnlyParams struct {
	Key       string
	Value     string
	CreatedAt interface{}
	UpdatedAt interface{}
}

type UpsertExifParams struct {
	FileID       int64
	CameraMake   sql.NullString
	CameraModel  sql.NullString
	LensModel    sql.NullString
	FocalLength  sql.NullString
	Aperture     sql.NullString
	ShutterSpeed sql.NullString
	Iso          sql.NullInt64
	Orientation  sql.NullInt64
	Latitude     sql.NullFloat64
	Longitude    sql.NullFloat64
	Altitude     sql.NullFloat64
	CaptureDate  sql.NullInt64
}

type UpsertFileReturningFileParams struct {
	FolderID  sql.NullInt64
	PathID    int64
	Filename  string
	SizeBytes sql.NullInt64
	Mtime     sql.NullInt64
	Md5       sql.NullString
	Phash     sql.NullInt64
	MimeType  sql.NullString
	Width     sql.NullInt64
	Height    sql.NullInt64
	CreatedAt interface{}
	UpdatedAt interface{}
}

type UpsertFolderReturningFolderParams struct {
	ParentID  sql.NullInt64
	PathID    int64
	Name      string
	Mtime     sql.NullInt64
	TileID    sql.NullInt64
	CreatedAt interface{}
	UpdatedAt interface{}
}

type UpsertHttpCacheParams struct {
	Key             string
	Method          string
	Path            string
	QueryString     sql.NullString
	Encoding        string
	Status          int64
	ContentType     sql.NullString
	ContentEncoding sql.NullString
	CacheControl    sql.NullString
	Etag            sql.NullString
	LastModified    sql.NullString
	Vary            sql.NullString
	Body            []byte
	ContentLength   sql.NullInt64
	CreatedAt       int64
	ExpiresAt       sql.NullInt64
}

type UpsertIPTCParams struct {
	FileID      int64
	Title       sql.NullString
	Description sql.NullString
	Keywords    sql.NullString
	Creator     sql.NullString
	Copyright   sql.NullString
	Credit      sql.NullString
	Source      sql.NullString
	CreatedDate sql.NullInt64
}

type UpsertInvalidFileParams struct {
	Path   string
	Mtime  int64
	Size   int64
	Reason sql.NullString
}

type UpsertLoginAttemptParams struct {
	Username       string
	FailedAttempts int64
	LastAttemptAt  int64
	LockedUntil    sql.NullInt64
}

type UpsertThumbnailBlobParams struct {
	ThumbnailID int64
	Data        []byte
}

type UpsertThumbnailReturningIDParams struct {
	FileID    int64
	SizeLabel string
	Width     int64
	Height    int64
	Format    string
	CreatedAt interface{}
	UpdatedAt interface{}
}

type UpsertXMPPropertyParams struct {
	ID        int64
	FileID    int64
	Namespace string
	Property  string
	Value     sql.NullString
}

type UpsertXMPRawParams struct {
	FileID int64
	RawXml sql.NullString
}

type XmpProperty struct {
	ID        int64
	FileID    int64
	Namespace string
	Property  string
	Value     sql.NullString
}

type XmpRaw struct {
	FileID int64
	RawXml sql.NullString
}