generated

package
v0.0.0-...-78f4eb6 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Feb 14, 2026 License: GPL-3.0 Imports: 5 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AddFeaturedProjectParams

type AddFeaturedProjectParams struct {
	PageID       pgtype.UUID
	ProjectID    pgtype.UUID
	DisplayOrder int32
}

type AddGalleryMediaParams

type AddGalleryMediaParams struct {
	MediaID    pgtype.UUID
	EntityType string
	EntityID   pgtype.UUID
	SortOrder  pgtype.Int4
}

type AddProjectTagParams

type AddProjectTagParams struct {
	ProjectID pgtype.UUID
	TagID     pgtype.UUID
}

type BatchCreateMediaRelationsParams

type BatchCreateMediaRelationsParams struct {
	ID           pgtype.UUID
	MediaID      pgtype.UUID
	EntityType   string
	EntityID     pgtype.UUID
	RelationType string
	SortOrder    pgtype.Int4
}

type Blog

type Blog struct {
	ID              pgtype.UUID
	Title           string
	Slug            string
	Excerpt         pgtype.Text
	Status          pgtype.Text
	ReadingTime     pgtype.Int4
	IsFeatured      pgtype.Bool
	CategoryID      pgtype.UUID
	FeaturedImageID pgtype.UUID
	AuthorID        pgtype.UUID
	CreatedAt       time.Time
	UpdatedAt       time.Time
	PublishedAt     *time.Time
	DeletedAt       *time.Time
}

type BlogTag

type BlogTag struct {
	BlogID    pgtype.UUID
	TagID     pgtype.UUID
	CreatedAt time.Time
}

type CheckProjectSlugExistsParams

type CheckProjectSlugExistsParams struct {
	Slug      string
	ProjectID pgtype.UUID
}

type CheckTagSlugExistsParams

type CheckTagSlugExistsParams struct {
	Slug  string
	TagID pgtype.UUID
}

type CommitSessionParams

type CommitSessionParams struct {
	Token  string
	Data   []byte
	Expiry time.Time
}

type CreateMediaParams

type CreateMediaParams struct {
	ID               pgtype.UUID
	Filename         string
	OriginalFilename string
	MimeType         string
	FileSize         int64
	Width            pgtype.Int4
	Height           pgtype.Int4
	Duration         pgtype.Int4
	StorageType      string
	S3Bucket         pgtype.Text
	S3Region         pgtype.Text
	OriginalKey      pgtype.Text
	LargeKey         pgtype.Text
	MediumKey        pgtype.Text
	ThumbnailKey     pgtype.Text
	AltText          pgtype.Text
	UploadedBy       pgtype.UUID
}

type CreateMediaRelationParams

type CreateMediaRelationParams struct {
	ID           pgtype.UUID
	MediaID      pgtype.UUID
	EntityType   string
	EntityID     pgtype.UUID
	RelationType string
	SortOrder    pgtype.Int4
}

type CreateProjectParams

type CreateProjectParams struct {
	ID              pgtype.UUID
	Title           string
	Slug            string
	Description     pgtype.Text
	ProjectDate     pgtype.Date
	Status          pgtype.Text
	ClientName      pgtype.Text
	ProjectYear     pgtype.Int4
	ProjectUrl      pgtype.Text
	ProjectStatus   pgtype.Text
	FeaturedImageID pgtype.UUID
	AuthorID        pgtype.UUID
}

type CreateSessionParams

type CreateSessionParams struct {
	Token  string
	Data   []byte
	Expiry time.Time
}

type CreateTagParams

type CreateTagParams struct {
	ID   pgtype.UUID
	Name string
	Slug string
}

type CreateUserParams

type CreateUserParams struct {
	FirstName    string
	LastName     string
	Email        string
	PasswordHash string
}

type DBTX

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
	CopyFrom(ctx context.Context, tableName pgx.Identifier, columnNames []string, rowSrc pgx.CopyFromSource) (int64, error)
}

type DeleteAllMediaRelationsForEntityParams

type DeleteAllMediaRelationsForEntityParams struct {
	EntityType string
	EntityID   pgtype.UUID
}

type DeleteGalleryMediaForEntityParams

type DeleteGalleryMediaForEntityParams struct {
	EntityType string
	EntityID   pgtype.UUID
}

type DeleteMediaRelationParams

type DeleteMediaRelationParams struct {
	MediaID    pgtype.UUID
	EntityType string
	EntityID   pgtype.UUID
}

type FindOrCreateTagParams

type FindOrCreateTagParams struct {
	ID   pgtype.UUID
	Name string
	Slug string
}

type GetDeletedMediaParams

type GetDeletedMediaParams struct {
	OffsetVal int32
	LimitVal  int32
}

type GetFeaturedMediaForEntityParams

type GetFeaturedMediaForEntityParams struct {
	EntityType string
	EntityID   pgtype.UUID
}

type GetFeaturedProjectsRow

type GetFeaturedProjectsRow struct {
	ID              pgtype.UUID
	Title           string
	Slug            string
	Description     pgtype.Text
	FeaturedImageID pgtype.UUID
	DisplayOrder    int32
}

type GetGalleryMediaForEntityParams

type GetGalleryMediaForEntityParams struct {
	EntityType string
	EntityID   pgtype.UUID
}

type GetMediaForEntityParams

type GetMediaForEntityParams struct {
	EntityType string
	EntityID   pgtype.UUID
}

type GetMediaStatsRow

type GetMediaStatsRow struct {
	TotalCount int64
	TotalSize  interface{}
	ImageCount int64
	VideoCount int64
	AudioCount int64
}

type GetMediaUsageByEntityRow

type GetMediaUsageByEntityRow struct {
	EntityType string
	EntityID   pgtype.UUID
	MediaCount int64
}

type GetMostUsedTagsRow

type GetMostUsedTagsRow struct {
	ID         pgtype.UUID
	Name       string
	Slug       string
	CreatedAt  time.Time
	UpdatedAt  time.Time
	UsageCount int64
}

type GetProjectsByStatusParams

type GetProjectsByStatusParams struct {
	Status    pgtype.Text
	OffsetVal int32
	LimitVal  int32
}

type GetProjectsByTagParams

type GetProjectsByTagParams struct {
	TagID     pgtype.UUID
	OffsetVal int32
	LimitVal  int32
}

type ListMediaByTypeParams

type ListMediaByTypeParams struct {
	MimeTypePattern string
	OffsetVal       int32
	LimitVal        int32
}

type ListMediaByUploaderParams

type ListMediaByUploaderParams struct {
	UploadedBy pgtype.UUID
	OffsetVal  int32
	LimitVal   int32
}

type ListMediaParams

type ListMediaParams struct {
	OffsetVal int32
	LimitVal  int32
}

type ListProjectsParams

type ListProjectsParams struct {
	OffsetVal int32
	LimitVal  int32
}

type ListPublishedProjectsParams

type ListPublishedProjectsParams struct {
	OffsetVal int32
	LimitVal  int32
}

type ListTagsParams

type ListTagsParams struct {
	OffsetVal int32
	LimitVal  int32
}

type ListUsersParams

type ListUsersParams struct {
	Limit  int32
	Offset int32
}

type Media

type Media struct {
	ID pgtype.UUID
	// Generated filename format: YYYYMMDD-<uuid>.ext
	Filename         string
	OriginalFilename string
	MimeType         string
	FileSize         int64
	Width            pgtype.Int4
	Height           pgtype.Int4
	// Video duration in seconds (NULL for images)
	Duration    pgtype.Int4
	StorageType string
	S3Bucket    pgtype.Text
	S3Region    pgtype.Text
	// S3 key pattern: media/original/<year>/<filename>
	OriginalKey pgtype.Text
	// S3 key for large version (1920px width)
	LargeKey pgtype.Text
	// S3 key for medium version (1024px width)
	MediumKey pgtype.Text
	// S3 key for thumbnail (300px width) or video thumbnail from FFmpeg
	ThumbnailKey pgtype.Text
	AltText      pgtype.Text
	UploadedBy   pgtype.UUID
	CreatedAt    time.Time
	UpdatedAt    time.Time
	DeletedAt    *time.Time
}

Stores all media files (images, videos) with S3 keys for different sizes

type MediaRelation

type MediaRelation struct {
	ID         pgtype.UUID
	MediaID    pgtype.UUID
	EntityType string
	EntityID   pgtype.UUID
	// Type: gallery (gallery images), featured (hero/featured image), content (inline content)
	RelationType string
	// Display order for gallery images (0-based index)
	SortOrder pgtype.Int4
	CreatedAt time.Time
}

Polymorphic relationship between media and entities (projects, blogs, pages)

type Page

type Page struct {
	ID             pgtype.UUID
	Title          string
	Slug           string
	PageType       string
	HeroMediaID    pgtype.UUID
	Header         pgtype.Text
	SubHeader      pgtype.Text
	Content        pgtype.Text
	ContentImageID pgtype.UUID
	CtaText        pgtype.Text
	CtaLink        pgtype.Text
	Email          pgtype.Text
	SocialLinks    []byte
	CreatedAt      time.Time
	UpdatedAt      time.Time
	DeletedAt      *time.Time
}

type PageFeaturedProject

type PageFeaturedProject struct {
	PageID       pgtype.UUID
	ProjectID    pgtype.UUID
	DisplayOrder int32
	CreatedAt    time.Time
}

type Project

type Project struct {
	ID              pgtype.UUID
	Title           string
	Slug            string
	Description     pgtype.Text
	ProjectDate     pgtype.Date
	Status          pgtype.Text
	ClientName      pgtype.Text
	ProjectYear     pgtype.Int4
	ProjectUrl      pgtype.Text
	ProjectStatus   pgtype.Text
	FeaturedImageID pgtype.UUID
	AuthorID        pgtype.UUID
	CreatedAt       time.Time
	UpdatedAt       time.Time
	PublishedAt     *time.Time
	DeletedAt       *time.Time
}

type ProjectTag

type ProjectTag struct {
	ProjectID pgtype.UUID
	TagID     pgtype.UUID
	CreatedAt time.Time
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) AddFeaturedProject

func (q *Queries) AddFeaturedProject(ctx context.Context, arg AddFeaturedProjectParams) (PageFeaturedProject, error)

Featured Projects for About Page

func (*Queries) AddGalleryMedia

func (q *Queries) AddGalleryMedia(ctx context.Context, arg AddGalleryMediaParams) error

func (*Queries) AddProjectTag

func (q *Queries) AddProjectTag(ctx context.Context, arg AddProjectTagParams) (ProjectTag, error)

Project Tags Operations

func (*Queries) BatchCreateMediaRelations

func (q *Queries) BatchCreateMediaRelations(ctx context.Context, arg []BatchCreateMediaRelationsParams) (int64, error)

Batch operations

func (*Queries) CheckEmailExists

func (q *Queries) CheckEmailExists(ctx context.Context, email string) (bool, error)

func (*Queries) CheckProjectSlugExists

func (q *Queries) CheckProjectSlugExists(ctx context.Context, arg CheckProjectSlugExistsParams) (bool, error)

func (*Queries) CheckTagSlugExists

func (q *Queries) CheckTagSlugExists(ctx context.Context, arg CheckTagSlugExistsParams) (bool, error)

func (*Queries) ClearFeaturedProjects

func (q *Queries) ClearFeaturedProjects(ctx context.Context, pageID pgtype.UUID) error

func (*Queries) ClearProjectTags

func (q *Queries) ClearProjectTags(ctx context.Context, projectID pgtype.UUID) error

func (*Queries) CommitSession

func (q *Queries) CommitSession(ctx context.Context, arg CommitSessionParams) error

func (*Queries) CountFeaturedProjects

func (q *Queries) CountFeaturedProjects(ctx context.Context, pageID pgtype.UUID) (int64, error)

func (*Queries) CountMedia

func (q *Queries) CountMedia(ctx context.Context) (int64, error)

func (*Queries) CountMediaByType

func (q *Queries) CountMediaByType(ctx context.Context, mimeTypePattern string) (int64, error)

func (*Queries) CountProjectGalleryImages

func (q *Queries) CountProjectGalleryImages(ctx context.Context, projectID pgtype.UUID) (int64, error)

func (*Queries) CountProjectTags

func (q *Queries) CountProjectTags(ctx context.Context, projectID pgtype.UUID) (int64, error)

func (*Queries) CountProjects

func (q *Queries) CountProjects(ctx context.Context) (int64, error)

func (*Queries) CountPublishedProjects

func (q *Queries) CountPublishedProjects(ctx context.Context) (int64, error)

func (*Queries) CountTags

func (q *Queries) CountTags(ctx context.Context) (int64, error)

func (*Queries) CountUsers

func (q *Queries) CountUsers(ctx context.Context) (int64, error)

func (*Queries) CreateMedia

func (q *Queries) CreateMedia(ctx context.Context, arg CreateMediaParams) (Media, error)

sql/queries/media.sql

func (*Queries) CreateMediaRelation

func (q *Queries) CreateMediaRelation(ctx context.Context, arg CreateMediaRelationParams) (MediaRelation, error)

Media Relations Queries

func (*Queries) CreateProject

func (q *Queries) CreateProject(ctx context.Context, arg CreateProjectParams) (Project, error)

Projects CRUD Operations

func (*Queries) CreateSession

func (q *Queries) CreateSession(ctx context.Context, arg CreateSessionParams) error

sql/queries/sessions.sql

func (*Queries) CreateTag

func (q *Queries) CreateTag(ctx context.Context, arg CreateTagParams) (Tag, error)

Tags CRUD Operations

func (*Queries) CreateUser

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)

func (*Queries) DeleteAllMediaRelationsForEntity

func (q *Queries) DeleteAllMediaRelationsForEntity(ctx context.Context, arg DeleteAllMediaRelationsForEntityParams) error

func (*Queries) DeleteExpiredSessions

func (q *Queries) DeleteExpiredSessions(ctx context.Context) error

func (*Queries) DeleteGalleryMediaForEntity

func (q *Queries) DeleteGalleryMediaForEntity(ctx context.Context, arg DeleteGalleryMediaForEntityParams) error

func (*Queries) DeleteMediaRelation

func (q *Queries) DeleteMediaRelation(ctx context.Context, arg DeleteMediaRelationParams) error

func (*Queries) DeleteSession

func (q *Queries) DeleteSession(ctx context.Context, token string) error

func (*Queries) DeleteTag

func (q *Queries) DeleteTag(ctx context.Context, id pgtype.UUID) error

func (*Queries) FindOrCreateTag

func (q *Queries) FindOrCreateTag(ctx context.Context, arg FindOrCreateTagParams) (Tag, error)

func (*Queries) GetDeletedMedia

func (q *Queries) GetDeletedMedia(ctx context.Context, arg GetDeletedMediaParams) ([]Media, error)

func (*Queries) GetFeaturedMediaForEntity

func (q *Queries) GetFeaturedMediaForEntity(ctx context.Context, arg GetFeaturedMediaForEntityParams) (Media, error)

func (*Queries) GetFeaturedProjects

func (q *Queries) GetFeaturedProjects(ctx context.Context, pageID pgtype.UUID) ([]GetFeaturedProjectsRow, error)

func (*Queries) GetGalleryMediaForEntity

func (q *Queries) GetGalleryMediaForEntity(ctx context.Context, arg GetGalleryMediaForEntityParams) ([]Media, error)

func (*Queries) GetMediaByFilename

func (q *Queries) GetMediaByFilename(ctx context.Context, filename string) (Media, error)

func (*Queries) GetMediaByID

func (q *Queries) GetMediaByID(ctx context.Context, id pgtype.UUID) (Media, error)

func (*Queries) GetMediaForEntity

func (q *Queries) GetMediaForEntity(ctx context.Context, arg GetMediaForEntityParams) ([]Media, error)

func (*Queries) GetMediaStats

func (q *Queries) GetMediaStats(ctx context.Context) (GetMediaStatsRow, error)

Media Statistics

func (*Queries) GetMediaUsageByEntity

func (q *Queries) GetMediaUsageByEntity(ctx context.Context, limitVal int32) ([]GetMediaUsageByEntityRow, error)

func (*Queries) GetMostUsedTags

func (q *Queries) GetMostUsedTags(ctx context.Context, limitVal int32) ([]GetMostUsedTagsRow, error)

func (*Queries) GetOrphanedMedia

func (q *Queries) GetOrphanedMedia(ctx context.Context) ([]Media, error)

func (*Queries) GetPageBySlug

func (q *Queries) GetPageBySlug(ctx context.Context, slug string) (Page, error)

Basic page queries

func (*Queries) GetPageByType

func (q *Queries) GetPageByType(ctx context.Context, pageType string) (Page, error)

func (*Queries) GetProjectByID

func (q *Queries) GetProjectByID(ctx context.Context, id pgtype.UUID) (Project, error)

func (*Queries) GetProjectBySlug

func (q *Queries) GetProjectBySlug(ctx context.Context, slug string) (Project, error)

func (*Queries) GetProjectFeaturedImage

func (q *Queries) GetProjectFeaturedImage(ctx context.Context, featuredImageID pgtype.UUID) (Media, error)

func (*Queries) GetProjectGallery

func (q *Queries) GetProjectGallery(ctx context.Context, projectID pgtype.UUID) ([]Media, error)

Project Gallery Operations (via media_relations)

func (*Queries) GetProjectIDBySlug

func (q *Queries) GetProjectIDBySlug(ctx context.Context, slug string) (pgtype.UUID, error)

func (*Queries) GetProjectTags

func (q *Queries) GetProjectTags(ctx context.Context, projectID pgtype.UUID) ([]Tag, error)

func (*Queries) GetProjectsByStatus

func (q *Queries) GetProjectsByStatus(ctx context.Context, arg GetProjectsByStatusParams) ([]Project, error)

func (*Queries) GetProjectsByTag

func (q *Queries) GetProjectsByTag(ctx context.Context, arg GetProjectsByTagParams) ([]Project, error)

func (*Queries) GetProjectsByYear

func (q *Queries) GetProjectsByYear(ctx context.Context, projectYear pgtype.Int4) ([]Project, error)

func (*Queries) GetRecentProjects

func (q *Queries) GetRecentProjects(ctx context.Context, limitVal int32) ([]Project, error)

func (*Queries) GetSession

func (q *Queries) GetSession(ctx context.Context, token string) ([]byte, error)

func (*Queries) GetTagByID

func (q *Queries) GetTagByID(ctx context.Context, id pgtype.UUID) (Tag, error)

func (*Queries) GetTagBySlug

func (q *Queries) GetTagBySlug(ctx context.Context, slug string) (Tag, error)

func (*Queries) GetTagIDBySlug

func (q *Queries) GetTagIDBySlug(ctx context.Context, slug string) (pgtype.UUID, error)

func (*Queries) GetTagUsageCount

func (q *Queries) GetTagUsageCount(ctx context.Context, tagID pgtype.UUID) (int64, error)

Tag Usage Statistics

func (*Queries) GetTagsByIDs

func (q *Queries) GetTagsByIDs(ctx context.Context, tagIds []pgtype.UUID) ([]Tag, error)

Batch Operations

func (*Queries) GetUnusedTags

func (q *Queries) GetUnusedTags(ctx context.Context) ([]Tag, error)

func (*Queries) GetUserByEmail

func (q *Queries) GetUserByEmail(ctx context.Context, email string) (User, error)

func (*Queries) GetUserByID

func (q *Queries) GetUserByID(ctx context.Context, id pgtype.UUID) (User, error)

func (*Queries) HardDeleteMedia

func (q *Queries) HardDeleteMedia(ctx context.Context, id pgtype.UUID) error

func (*Queries) HardDeleteProject

func (q *Queries) HardDeleteProject(ctx context.Context, id pgtype.UUID) error

func (*Queries) HardDeleteUser

func (q *Queries) HardDeleteUser(ctx context.Context, id pgtype.UUID) error

func (*Queries) ListAllTags

func (q *Queries) ListAllTags(ctx context.Context) ([]Tag, error)

func (*Queries) ListMedia

func (q *Queries) ListMedia(ctx context.Context, arg ListMediaParams) ([]Media, error)

func (*Queries) ListMediaByType

func (q *Queries) ListMediaByType(ctx context.Context, arg ListMediaByTypeParams) ([]Media, error)

func (*Queries) ListMediaByUploader

func (q *Queries) ListMediaByUploader(ctx context.Context, arg ListMediaByUploaderParams) ([]Media, error)

func (*Queries) ListPages

func (q *Queries) ListPages(ctx context.Context) ([]Page, error)

func (*Queries) ListProjects

func (q *Queries) ListProjects(ctx context.Context, arg ListProjectsParams) ([]Project, error)

func (*Queries) ListPublishedProjects

func (q *Queries) ListPublishedProjects(ctx context.Context, arg ListPublishedProjectsParams) ([]Project, error)

func (*Queries) ListTags

func (q *Queries) ListTags(ctx context.Context, arg ListTagsParams) ([]Tag, error)

func (*Queries) ListUsers

func (q *Queries) ListUsers(ctx context.Context, arg ListUsersParams) ([]User, error)

func (*Queries) PublishProject

func (q *Queries) PublishProject(ctx context.Context, id pgtype.UUID) (Project, error)

func (*Queries) PurgeOldDeletedMedia

func (q *Queries) PurgeOldDeletedMedia(ctx context.Context) error

func (*Queries) RemoveFeaturedProject

func (q *Queries) RemoveFeaturedProject(ctx context.Context, arg RemoveFeaturedProjectParams) error

func (*Queries) RemoveProjectTag

func (q *Queries) RemoveProjectTag(ctx context.Context, arg RemoveProjectTagParams) error

func (*Queries) ReorderGalleryMedia

func (q *Queries) ReorderGalleryMedia(ctx context.Context, arg ReorderGalleryMediaParams) error

func (*Queries) RestoreMedia

func (q *Queries) RestoreMedia(ctx context.Context, id pgtype.UUID) error

func (*Queries) RestoreProject

func (q *Queries) RestoreProject(ctx context.Context, id pgtype.UUID) error

func (*Queries) SearchProjects

func (q *Queries) SearchProjects(ctx context.Context, arg SearchProjectsParams) ([]Project, error)

Search and Filter Operations

func (*Queries) SearchTags

func (q *Queries) SearchTags(ctx context.Context, arg SearchTagsParams) ([]Tag, error)

func (*Queries) SoftDeleteMedia

func (q *Queries) SoftDeleteMedia(ctx context.Context, id pgtype.UUID) error

func (*Queries) SoftDeleteProject

func (q *Queries) SoftDeleteProject(ctx context.Context, id pgtype.UUID) error

func (*Queries) UnpublishProject

func (q *Queries) UnpublishProject(ctx context.Context, id pgtype.UUID) (Project, error)

func (*Queries) UpdateMedia

func (q *Queries) UpdateMedia(ctx context.Context, arg UpdateMediaParams) (Media, error)

func (*Queries) UpdateMediaAltText

func (q *Queries) UpdateMediaAltText(ctx context.Context, arg UpdateMediaAltTextParams) (Media, error)

func (*Queries) UpdatePage

func (q *Queries) UpdatePage(ctx context.Context, arg UpdatePageParams) (Page, error)

func (*Queries) UpdateProject

func (q *Queries) UpdateProject(ctx context.Context, arg UpdateProjectParams) (Project, error)

func (*Queries) UpdateSession

func (q *Queries) UpdateSession(ctx context.Context, arg UpdateSessionParams) error

func (*Queries) UpdateTag

func (q *Queries) UpdateTag(ctx context.Context, arg UpdateTagParams) (Tag, error)

func (*Queries) UpdateUser

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (User, error)

func (*Queries) WithTx

func (q *Queries) WithTx(tx pgx.Tx) *Queries

type RemoveFeaturedProjectParams

type RemoveFeaturedProjectParams struct {
	PageID    pgtype.UUID
	ProjectID pgtype.UUID
}

type RemoveProjectTagParams

type RemoveProjectTagParams struct {
	ProjectID pgtype.UUID
	TagID     pgtype.UUID
}

type ReorderGalleryMediaParams

type ReorderGalleryMediaParams struct {
	SortOrder  pgtype.Int4
	MediaID    pgtype.UUID
	EntityType string
	EntityID   pgtype.UUID
}

type SearchProjectsParams

type SearchProjectsParams struct {
	SearchTerm string
	OffsetVal  int32
	LimitVal   int32
}

type SearchTagsParams

type SearchTagsParams struct {
	SearchTerm string
	OffsetVal  int32
	LimitVal   int32
}

type Session

type Session struct {
	Token  string
	Data   []byte
	Expiry time.Time
}

type Tag

type Tag struct {
	ID        pgtype.UUID
	Name      string
	Slug      string
	CreatedAt time.Time
	UpdatedAt time.Time
}

type UpdateMediaAltTextParams

type UpdateMediaAltTextParams struct {
	AltText pgtype.Text
	ID      pgtype.UUID
}

type UpdateMediaParams

type UpdateMediaParams struct {
	AltText pgtype.Text
	ID      pgtype.UUID
}

type UpdatePageParams

type UpdatePageParams struct {
	Title          pgtype.Text
	Slug           pgtype.Text
	HeroMediaID    pgtype.UUID
	Header         pgtype.Text
	SubHeader      pgtype.Text
	Content        pgtype.Text
	ContentImageID pgtype.UUID
	CtaText        pgtype.Text
	CtaLink        pgtype.Text
	Email          pgtype.Text
	SocialLinks    []byte
	ID             pgtype.UUID
}

type UpdateProjectParams

type UpdateProjectParams struct {
	Title           pgtype.Text
	Slug            pgtype.Text
	Description     pgtype.Text
	ProjectDate     pgtype.Date
	Status          pgtype.Text
	ClientName      pgtype.Text
	ProjectYear     pgtype.Int4
	ProjectUrl      pgtype.Text
	ProjectStatus   pgtype.Text
	FeaturedImageID pgtype.UUID
	ID              pgtype.UUID
}

type UpdateSessionParams

type UpdateSessionParams struct {
	Token  string
	Data   []byte
	Expiry time.Time
}

type UpdateTagParams

type UpdateTagParams struct {
	Name pgtype.Text
	Slug pgtype.Text
	ID   pgtype.UUID
}

type UpdateUserParams

type UpdateUserParams struct {
	FirstName    pgtype.Text
	LastName     pgtype.Text
	Email        pgtype.Text
	PasswordHash pgtype.Text
	ID           pgtype.UUID
}

type User

type User struct {
	ID           pgtype.UUID
	FirstName    string
	LastName     string
	Email        string
	PasswordHash string
	CreatedAt    time.Time
	UpdatedAt    time.Time
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL