project_photo.go 740 B

1234567891011121314151617181920212223242526272829303132
  1. package db
  2. import (
  3. "context"
  4. "youngee_b_api/model/gorm_model"
  5. )
  6. func CreateProjectPhoto(ctx context.Context, projectPhotos []gorm_model.ProjectPhoto) error {
  7. db := GetReadDB(ctx)
  8. err := db.Create(&projectPhotos).Error
  9. if err != nil {
  10. return err
  11. }
  12. return nil
  13. }
  14. func DeleteProjectPhotoByProjecttID(ctx context.Context, productID string) error {
  15. db := GetReadDB(ctx)
  16. err := db.Where("project_id = ?", productID).Delete(&gorm_model.ProjectPhoto{}).Error
  17. if err != nil {
  18. return err
  19. }
  20. return nil
  21. }
  22. func DeletePhotoUrl(ctx context.Context, photoUrl string) error {
  23. db := GetReadDB(ctx)
  24. err := db.Where("photo_url = ?", photoUrl).Delete(&gorm_model.YounggeeProductPhoto{}).Error
  25. if err != nil {
  26. return err
  27. }
  28. return nil
  29. }