sabisan/internal/store/site.go

package store

import "context"

func (s *Store) SiteContent(ctx context.Context) (SiteContent, error) {
	var c SiteContent
	err := s.db.QueryRowContext(ctx, `select
		hero_title, hero_subtitle, positioning, hero_cta_label, hero_cta_url, secondary_cta_label, secondary_cta_url,
		intro_title, intro_text,
		service_one_title, service_one_text, service_two_title, service_two_text, service_three_title, service_three_text,
		process_one_title, process_one_text, process_two_title, process_two_text, process_three_title, process_three_text,
		about_name, about_role, about_bio, studio_philosophy, studio_approach, studio_credentials, service_area,
		email, phone, location, hero_image, about_image
		from site_content where id = 1`).
		Scan(
			&c.HeroTitle, &c.HeroSubtitle, &c.Positioning, &c.HeroCTALabel, &c.HeroCTAURL, &c.SecondaryCTALabel, &c.SecondaryCTAURL,
			&c.IntroTitle, &c.IntroText,
			&c.ServiceOneTitle, &c.ServiceOneText, &c.ServiceTwoTitle, &c.ServiceTwoText, &c.ServiceThreeTitle, &c.ServiceThreeText,
			&c.ProcessOneTitle, &c.ProcessOneText, &c.ProcessTwoTitle, &c.ProcessTwoText, &c.ProcessThreeTitle, &c.ProcessThreeText,
			&c.AboutName, &c.AboutRole, &c.AboutBio, &c.StudioPhilosophy, &c.StudioApproach, &c.StudioCredentials, &c.ServiceArea,
			&c.Email, &c.Phone, &c.Location, &c.HeroImage, &c.AboutImage,
		)
	return c, err
}

func (s *Store) UpdateSiteContent(ctx context.Context, c SiteContent) error {
	_, err := s.db.ExecContext(ctx, `update site_content set
		hero_title=?, hero_subtitle=?, positioning=?, hero_cta_label=?, hero_cta_url=?, secondary_cta_label=?, secondary_cta_url=?,
		intro_title=?, intro_text=?,
		service_one_title=?, service_one_text=?, service_two_title=?, service_two_text=?, service_three_title=?, service_three_text=?,
		process_one_title=?, process_one_text=?, process_two_title=?, process_two_text=?, process_three_title=?, process_three_text=?,
		about_name=?, about_role=?, about_bio=?, studio_philosophy=?, studio_approach=?, studio_credentials=?, service_area=?,
		email=?, phone=?, location=?, hero_image=?, about_image=?
		where id=1`,
		c.HeroTitle, c.HeroSubtitle, c.Positioning, c.HeroCTALabel, c.HeroCTAURL, c.SecondaryCTALabel, c.SecondaryCTAURL,
		c.IntroTitle, c.IntroText,
		c.ServiceOneTitle, c.ServiceOneText, c.ServiceTwoTitle, c.ServiceTwoText, c.ServiceThreeTitle, c.ServiceThreeText,
		c.ProcessOneTitle, c.ProcessOneText, c.ProcessTwoTitle, c.ProcessTwoText, c.ProcessThreeTitle, c.ProcessThreeText,
		c.AboutName, c.AboutRole, c.AboutBio, c.StudioPhilosophy, c.StudioApproach, c.StudioCredentials, c.ServiceArea,
		c.Email, c.Phone, c.Location, c.HeroImage, c.AboutImage)
	return err
}