db

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 HistoriesCategoryRenameParams struct {
	OldCategory string `json:"old_category"`
	NewCategory string `json:"new_category"`
	Username    string `json:"username"`
}

type History struct {
	Username    string          `json:"username"`
	PostType    PostType        `json:"post_type"`
	PostOwner   string          `json:"post_owner"`
	Post        string          `json:"post"`
	PostDate    time.Time       `json:"post_date"`
	Files       []string        `json:"files"`
	Categories  []string        `json:"categories"`
	Incognito   bool            `json:"incognito"`
	Coordinates types.NullPoint `json:"coordinates"`
}

type HistoryAddFromArchiveParams struct {
	Username   string    `json:"username"`
	PostType   PostType  `json:"post_type"`
	PostOwner  string    `json:"post_owner"`
	Post       string    `json:"post"`
	PostDate   time.Time `json:"post_date"`
	Files      []string  `json:"files"`
	Categories []string  `json:"categories"`
}

type HistoryAddParams struct {
	Username   string   `json:"username"`
	PostType   PostType `json:"post_type"`
	PostOwner  string   `json:"post_owner"`
	Post       string   `json:"post"`
	Files      []string `json:"files"`
	Categories []string `json:"categories"`
	Latitude   float64  `json:"latitude"`
	Longitude  float64  `json:"longitude"`
}

type HistoryCountByFileParams struct {
	PostType  PostType `json:"post_type"`
	PostOwner string   `json:"post_owner"`
	File      string   `json:"file"`
	Username  string   `json:"username"`
}

type HistoryCountParams struct {
	PostTypes           []PostType `json:"post_types"`
	Exclusive           bool       `json:"exclusive"`
	Categories          []string   `json:"categories"`
	UserCategories      []string   `json:"user_categories"`
	PostOwners          []string   `json:"post_owners"`
	Username            string     `json:"username"`
	OnlyWithCoordinates bool       `json:"only_with_coordinates"`
}

type HistoryGetByOwnerParams struct {
	PostType  PostType `json:"post_type"`
	PostOwner string   `json:"post_owner"`
	Post      string   `json:"post"`
	Username  string   `json:"username"`
}

type HistoryGetPageParams struct {
	PostTypes           []PostType `json:"post_types"`
	Exclusive           bool       `json:"exclusive"`
	Categories          []string   `json:"categories"`
	UserCategories      []string   `json:"user_categories"`
	PostOwners          []string   `json:"post_owners"`
	Username            string     `json:"username"`
	OnlyWithCoordinates bool       `json:"only_with_coordinates"`
	Page                int32      `json:"page"`
	PageSize            int32      `json:"page_size"`
}

type HistoryGetParams struct {
	PostType PostType `json:"post_type"`
	Post     string   `json:"post"`
	Username string   `json:"username"`
}

type HistoryOwnersParams struct {
	PostTypes           []PostType `json:"post_types"`
	Exclusive           bool       `json:"exclusive"`
	Categories          []string   `json:"categories"`
	UserCategories      []string   `json:"user_categories"`
	PostOwner           string     `json:"post_owner"`
	Username            string     `json:"username"`
	OnlyWithCoordinates bool       `json:"only_with_coordinates"`
}

type HistoryOwnersRow struct {
	PostOwner string   `json:"post_owner"`
	PostType  PostType `json:"post_type"`
}

type HistoryRemoveParams struct {
	PostType  PostType `json:"post_type"`
	PostOwner string   `json:"post_owner"`
	Post      string   `json:"post"`
	Username  string   `json:"username"`
}

type HistoryUpdateCategoriesParams struct {
	Categories []string `json:"categories"`
	PostType   PostType `json:"post_type"`
	Post       string   `json:"post"`
	PostOwner  string   `json:"post_owner"`
	Username   string   `json:"username"`
}

type HistoryUpdateCoordinatesParams struct {
	Latitude  float64  `json:"latitude"`
	Longitude float64  `json:"longitude"`
	PostType  PostType `json:"post_type"`
	PostOwner string   `json:"post_owner"`
	Post      string   `json:"post"`
	Username  string   `json:"username"`
}

type HistoryUpdateOwnerParams struct {
	NewOwner string   `json:"new_owner"`
	PostType PostType `json:"post_type"`
	OldOwner string   `json:"old_owner"`
	Username string   `json:"username"`
}

type NetworkType string

type NullNetworkType struct {
	NetworkType NetworkType `json:"network_type"`
	Valid       bool        `json:"valid"` // Valid is true if NetworkType is not NULL
}

type NullPostType struct {
	PostType PostType `json:"post_type"`
	Valid    bool     `json:"valid"` // Valid is true if PostType is not NULL
}

type Owner struct {
	Owner string `json:"owner"`
	Type  string `json:"type"`
}

type Passkey struct {
	ID              []byte    `json:"id"`
	Name            string    `json:"name"`
	UserID          uuid.UUID `json:"user_id"`
	PublicKey       []byte    `json:"public_key"`
	AttestationType string    `json:"attestation_type"`
	Aaguid          []byte    `json:"aaguid"`
	SignCount       int64     `json:"sign_count"`
	Transports      []string  `json:"transports"`
	BackupEligible  bool      `json:"backup_eligible"`
	BackupState     bool      `json:"backup_state"`
}

type PasskeyDeleteParams struct {
	PasskeyID []byte    `json:"passkey_id"`
	UserID    uuid.UUID `json:"user_id"`
}

type PasskeyRenameParams struct {
	Name      string    `json:"name"`
	PasskeyID []byte    `json:"passkey_id"`
	UserID    uuid.UUID `json:"user_id"`
}

type PostType string

type Querier interface {
	HistoriesCategoryRename(ctx context.Context, arg HistoriesCategoryRenameParams) error
	HistoryAdd(ctx context.Context, arg HistoryAddParams) (History, error)
	HistoryAddFromArchive(ctx context.Context, arg HistoryAddFromArchiveParams) (History, error)
	HistoryCount(ctx context.Context, arg HistoryCountParams) (int64, error)
	HistoryCountByFile(ctx context.Context, arg HistoryCountByFileParams) (int64, error)
	HistoryGet(ctx context.Context, arg HistoryGetParams) (History, error)
	HistoryGetByOwner(ctx context.Context, arg HistoryGetByOwnerParams) (History, error)
	// https://docs.sqlc.dev/en/stable/howto/select.html#passing-a-slice-as-a-parameter-to-a-query
	// https://docs.sqlc.dev/en/stable/howto/named_parameters.html
	HistoryGetPage(ctx context.Context, arg HistoryGetPageParams) ([]History, error)
	HistoryOwners(ctx context.Context, arg HistoryOwnersParams) ([]HistoryOwnersRow, error)
	HistoryRemove(ctx context.Context, arg HistoryRemoveParams) error
	HistoryUpdateCategories(ctx context.Context, arg HistoryUpdateCategoriesParams) (History, error)
	HistoryUpdateCoordinates(ctx context.Context, arg HistoryUpdateCoordinatesParams) error
	HistoryUpdateOwner(ctx context.Context, arg HistoryUpdateOwnerParams) error
	PasskeyDelete(ctx context.Context, arg PasskeyDeleteParams) error
	PasskeyRename(ctx context.Context, arg PasskeyRenameParams) error
	PasskeyUpdateSignCount(ctx context.Context, passkeyID []byte) error
	UpdateHistoryDuplicateFile(ctx context.Context, arg UpdateHistoryDuplicateFileParams) (History, error)
	UpdateHistoryRemoveFile(ctx context.Context, arg UpdateHistoryRemoveFileParams) (History, error)
	UserAdd(ctx context.Context, arg UserAddParams) (User, error)
	UserCategoryAdd(ctx context.Context, arg UserCategoryAddParams) error
	UserCategoryRemove(ctx context.Context, arg UserCategoryRemoveParams) error
	UserCreatePasskey(ctx context.Context, arg UserCreatePasskeyParams) error
	UserGetByID(ctx context.Context, userID uuid.UUID) (User, error)
	UserGetByUsername(ctx context.Context, username string) (User, error)
	UserGetPasskeysByID(ctx context.Context, userID uuid.UUID) ([]Passkey, error)
	UserUpdateHash(ctx context.Context, arg UserUpdateHashParams) error
	UserUpdateInstagramSession(ctx context.Context, arg UserUpdateInstagramSessionParams) error
}

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

type UpdateHistoryDuplicateFileParams struct {
	File      string   `json:"file"`
	Duplicate string   `json:"duplicate"`
	PostType  PostType `json:"post_type"`
	Post      string   `json:"post"`
	PostOwner string   `json:"post_owner"`
	Username  string   `json:"username"`
}

type UpdateHistoryRemoveFileParams struct {
	File      string   `json:"file"`
	PostType  PostType `json:"post_type"`
	Post      string   `json:"post"`
	PostOwner string   `json:"post_owner"`
	Username  string   `json:"username"`
}

type User struct {
	Username             string      `json:"username"`
	PasswordHash         string      `json:"password_hash"`
	InstagramSessionID   string      `json:"instagram_session_id"`
	InstagramUserID      string      `json:"instagram_user_id"`
	Network              NetworkType `json:"network"`
	Categories           []string    `json:"categories"`
	TiktokSessionID      string      `json:"tiktok_session_id"`
	TiktokSessionIDGuard string      `json:"tiktok_session_id_guard"`
	ID                   uuid.UUID   `json:"id"`
}

type UserAddParams struct {
	ID                 uuid.UUID `json:"id"`
	Username           string    `json:"username"`
	PasswordHash       string    `json:"password_hash"`
	InstagramSessionID string    `json:"instagram_session_id"`
	InstagramUserID    string    `json:"instagram_user_id"`
	Categories         []string  `json:"categories"`
}

type UserCategoryAddParams struct {
	Category string `json:"category"`
	Username string `json:"username"`
}

type UserCategoryRemoveParams struct {
	Category string `json:"category"`
	Username string `json:"username"`
}

type UserCreatePasskeyParams struct {
	PasskeyID       []byte    `json:"passkey_id"`
	UserID          uuid.UUID `json:"user_id"`
	Name            string    `json:"name"`
	PublicKey       []byte    `json:"public_key"`
	AttestationType string    `json:"attestation_type"`
	Aaguid          []byte    `json:"aaguid"`
	SignCount       int64     `json:"sign_count"`
	Transports      []string  `json:"transports"`
	BackupEligible  bool      `json:"backup_eligible"`
	BackupState     bool      `json:"backup_state"`
}

type UserUpdateHashParams struct {
	PasswordHash string `json:"password_hash"`
	Username     string `json:"username"`
}

type UserUpdateInstagramSessionParams struct {
	InstagramSessionID string `json:"instagram_session_id"`
	InstagramUserID    string `json:"instagram_user_id"`
	PasswordHash       string `json:"password_hash"`
	Username           string `json:"username"`
}