Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

postgres

package

Go to main page

Versions in this module

v0

v0.1.6

Nov 24, 2025

Changes in this version

+ func GetMigrationVersion(db *sql.DB) (uint, bool, error)

+ func RunMigrations(db *sql.DB) error

v0.1.5

Nov 22, 2025

Changes in this version

+ func NewAbsenceRepo(db *DB) repository.AbsenceRepository

+ func NewAnnouncementRepo(db *DB) repository.AnnouncementRepository

+ func NewClassMemberRepo(db *DB) repository.ClassMemberRepository

+ func NewClassRepo(db *DB) repository.ClassRepository

+ func NewMessageRepo(db *DB) repository.MessageRepository

+ func NewPhotoRepo(db *DB) repository.PhotoRepository

+ func NewProfileRepo(db *DB) repository.ProfileRepository

+ func NewRefreshTokenRepo(db *DB) repository.RefreshTokenRepository

+ func NewUserRepo(db *DB) repository.UserRepository

+ type AbsenceRepo struct

+ func (r *AbsenceRepo) Create(ctx context.Context, absence *domain.Absence) error

+ func (r *AbsenceRepo) Delete(ctx context.Context, id uuid.UUID) error

+ func (r *AbsenceRepo) GetByID(ctx context.Context, id uuid.UUID) (*domain.Absence, error)

+ func (r *AbsenceRepo) ListByClass(ctx context.Context, classID uuid.UUID, limit, offset int) ([]*domain.Absence, error)

+ func (r *AbsenceRepo) UpdateStatus(ctx context.Context, id uuid.UUID, status domain.AbsenceStatus) error

+ type AnnouncementRepo struct

+ func (r *AnnouncementRepo) Create(ctx context.Context, announcement *domain.Announcement) error

+ func (r *AnnouncementRepo) Delete(ctx context.Context, id uuid.UUID) error

+ func (r *AnnouncementRepo) GetByID(ctx context.Context, id uuid.UUID) (*domain.Announcement, error)

+ func (r *AnnouncementRepo) ListByClass(ctx context.Context, classID *uuid.UUID, limit, offset int) ([]*domain.Announcement, error)

+ func (r *AnnouncementRepo) ListGlobal(ctx context.Context, limit, offset int) ([]*domain.Announcement, error)

+ func (r *AnnouncementRepo) Update(ctx context.Context, announcement *domain.Announcement) error

+ type ClassMemberRepo struct

+ func (r *ClassMemberRepo) Create(ctx context.Context, member *domain.ClassMember) error

+ func (r *ClassMemberRepo) Delete(ctx context.Context, id uuid.UUID) error

+ func (r *ClassMemberRepo) GetByID(ctx context.Context, id uuid.UUID) (*domain.ClassMember, error)

+ func (r *ClassMemberRepo) GetByUserAndClass(ctx context.Context, userID, classID uuid.UUID) (*domain.ClassMember, error)

+ func (r *ClassMemberRepo) IsMember(ctx context.Context, userID, classID uuid.UUID) (bool, error)

+ func (r *ClassMemberRepo) IsTeacher(ctx context.Context, userID, classID uuid.UUID) (bool, error)

+ func (r *ClassMemberRepo) ListByClass(ctx context.Context, classID uuid.UUID) ([]*domain.ClassMember, error)

+ func (r *ClassMemberRepo) ListByUser(ctx context.Context, userID uuid.UUID) ([]*domain.ClassMember, error)

+ type ClassRepo struct

+ func (r *ClassRepo) Create(ctx context.Context, class *domain.Class) error

+ func (r *ClassRepo) Delete(ctx context.Context, id uuid.UUID) error

+ func (r *ClassRepo) GetByID(ctx context.Context, id uuid.UUID) (*domain.Class, error)

+ func (r *ClassRepo) GetUserClasses(ctx context.Context, userID uuid.UUID) ([]*domain.Class, error)

+ func (r *ClassRepo) List(ctx context.Context, limit, offset int) ([]*domain.Class, error)

+ func (r *ClassRepo) Update(ctx context.Context, class *domain.Class) error

+ type DB struct

+ func NewDB(databaseURL string) (*DB, error)

+ type MessageRepo struct

+ func (r *MessageRepo) Create(ctx context.Context, message *domain.Message) error

+ func (r *MessageRepo) Delete(ctx context.Context, id uuid.UUID) error

+ func (r *MessageRepo) GetByID(ctx context.Context, id uuid.UUID) (*domain.Message, error)

+ func (r *MessageRepo) ListByUser(ctx context.Context, userID uuid.UUID, limit, offset int) ([]*domain.Message, error)

+ func (r *MessageRepo) MarkAsRead(ctx context.Context, id uuid.UUID, readAt time.Time) error

+ type PhotoRepo struct

+ func (r *PhotoRepo) Create(ctx context.Context, photo *domain.Photo) error

+ func (r *PhotoRepo) Delete(ctx context.Context, id uuid.UUID) error

+ func (r *PhotoRepo) GetByID(ctx context.Context, id uuid.UUID) (*domain.Photo, error)

+ func (r *PhotoRepo) ListByClass(ctx context.Context, classID uuid.UUID, limit, offset int) ([]*domain.Photo, error)

+ type ProfileRepo struct

+ func (r *ProfileRepo) Create(ctx context.Context, profile *domain.Profile) error

+ func (r *ProfileRepo) Delete(ctx context.Context, userID uuid.UUID) error

+ func (r *ProfileRepo) GetByUserID(ctx context.Context, userID uuid.UUID) (*domain.Profile, error)

+ func (r *ProfileRepo) Update(ctx context.Context, profile *domain.Profile) error

+ type RefreshTokenRepo struct

+ func (r *RefreshTokenRepo) Create(ctx context.Context, token *domain.RefreshToken) error

+ func (r *RefreshTokenRepo) DeleteExpired(ctx context.Context) error

+ func (r *RefreshTokenRepo) GetByTokenHash(ctx context.Context, tokenHash string) (*domain.RefreshToken, error)

+ func (r *RefreshTokenRepo) Revoke(ctx context.Context, tokenHash string, revokedAt time.Time) error

+ func (r *RefreshTokenRepo) RevokeAllForUser(ctx context.Context, userID uuid.UUID, revokedAt time.Time) error

+ type UserRepo struct

+ func (r *UserRepo) Create(ctx context.Context, user *domain.User) error

+ func (r *UserRepo) Delete(ctx context.Context, id uuid.UUID) error

+ func (r *UserRepo) GetByEmail(ctx context.Context, email string) (*domain.User, error)

+ func (r *UserRepo) GetByID(ctx context.Context, id uuid.UUID) (*domain.User, error)

+ func (r *UserRepo) Update(ctx context.Context, user *domain.User) error

v0.1.4

Nov 22, 2025

v0.1.3

Nov 21, 2025