138 lines
2.5 KiB
Go
138 lines
2.5 KiB
Go
package store
|
|
|
|
import (
|
|
"context"
|
|
"database/sql"
|
|
"os"
|
|
"path/filepath"
|
|
"time"
|
|
|
|
_ "github.com/mattn/go-sqlite3"
|
|
)
|
|
|
|
type Store struct {
|
|
db *sql.DB
|
|
}
|
|
|
|
type SiteContent struct {
|
|
HeroTitle string
|
|
HeroSubtitle string
|
|
Positioning string
|
|
HeroCTALabel string
|
|
HeroCTAURL string
|
|
SecondaryCTALabel string
|
|
SecondaryCTAURL string
|
|
IntroTitle string
|
|
IntroText string
|
|
ServiceOneTitle string
|
|
ServiceOneText string
|
|
ServiceTwoTitle string
|
|
ServiceTwoText string
|
|
ServiceThreeTitle string
|
|
ServiceThreeText string
|
|
ProcessOneTitle string
|
|
ProcessOneText string
|
|
ProcessTwoTitle string
|
|
ProcessTwoText string
|
|
ProcessThreeTitle string
|
|
ProcessThreeText string
|
|
AboutName string
|
|
AboutRole string
|
|
AboutBio string
|
|
StudioPhilosophy string
|
|
StudioApproach string
|
|
StudioCredentials string
|
|
ServiceArea string
|
|
Email string
|
|
Phone string
|
|
Location string
|
|
HeroImage string
|
|
AboutImage string
|
|
}
|
|
|
|
type Project struct {
|
|
ID int64
|
|
Slug string
|
|
Title string
|
|
Location string
|
|
Year string
|
|
Category string
|
|
Summary string
|
|
Scope string
|
|
Status string
|
|
Position int
|
|
Description string
|
|
CoverImage string
|
|
Featured bool
|
|
CreatedAt time.Time
|
|
Images []ProjectImage
|
|
}
|
|
|
|
type ProjectImage struct {
|
|
ID int64
|
|
ProjectID int64
|
|
Path string
|
|
Caption string
|
|
Position int
|
|
}
|
|
|
|
type Service struct {
|
|
ID int64
|
|
Title string
|
|
Summary string
|
|
Details string
|
|
Position int
|
|
Active bool
|
|
CreatedAt time.Time
|
|
}
|
|
|
|
type FAQ struct {
|
|
ID int64
|
|
Question string
|
|
Answer string
|
|
Position int
|
|
Active bool
|
|
CreatedAt time.Time
|
|
}
|
|
|
|
type ContactRequest struct {
|
|
ID int64
|
|
Name string
|
|
Email string
|
|
Phone string
|
|
ProjectType string
|
|
ProjectLocation string
|
|
BudgetRange string
|
|
Timeline string
|
|
Message string
|
|
Status string
|
|
Notes string
|
|
CreatedAt time.Time
|
|
}
|
|
|
|
type AdminUser struct {
|
|
ID int64
|
|
Username string
|
|
PasswordHash []byte
|
|
}
|
|
|
|
func Open(path string) (*Store, error) {
|
|
if err := os.MkdirAll(filepath.Dir(path), 0o755); err != nil {
|
|
return nil, err
|
|
}
|
|
db, err := sql.Open("sqlite3", path+"?_foreign_keys=on")
|
|
if err != nil {
|
|
return nil, err
|
|
}
|
|
db.SetMaxOpenConns(1)
|
|
return &Store{db: db}, db.Ping()
|
|
}
|
|
|
|
func (s *Store) Close() error {
|
|
return s.db.Close()
|
|
}
|
|
|
|
func (s *Store) Ping(ctx context.Context) error {
|
|
return s.db.PingContext(ctx)
|
|
}
|