feat: add basic workings

internal/server/service/fileservice.go

@@ -2,10 +2,12 @@ package service
 
 import (
 	"io"
+	"log/slog"
 	"orbits-server/internal/server/api/assets"
 	"orbits-server/internal/server/bootstrap"
 	"orbits-server/internal/server/database"
 	"os"
+	"path/filepath"
 
 	"gorm.io/gorm"
 )
@@ -19,6 +21,35 @@ func NewFileService(db *gorm.DB, env bootstrap.Environment) *FileService {
 	return &FileService{db: db, env: env}
 }
 
+func (s *FileService) SyncFile(fp string) {
+	f, err := os.Open(fp)
+	if err != nil {
+		slog.Error("failed to open the file", "file", fp, "error", err)
+		return
+	}
+	defer f.Close()
+
+	fileData, err := database.BuildFileRecord(f, filepath.Base(fp), s.env.ContentDirectory)
+	if err != nil {
+		slog.Error("failed to build file record", "error", err)
+		return
+	}
+
+	if err := database.CreateFile(s.db, &fileData); err != nil {
+		slog.Error("failed to create file record", "error", err)
+		return
+	}
+
+	if err := os.Rename(fp, fileData.FilePath); err != nil {
+		// if this fails across mounts then try copy + delete
+		slog.Error("failed to move file", "error", err)
+
+		database.DeleteFileByID(s.db, fileData.ID)
+
+		return
+	}
+}
+
 func (s *FileService) ListFiles() ([]assets.FileResponse, error) {
 	fileRecords, err := database.ListFiles(s.db)
 	if err != nil {
@@ -32,7 +63,7 @@ func (s *FileService) ListFiles() ([]assets.FileResponse, error) {
 			ID:        f.ID,
 			MetaName:  f.MetaName,
 			MediaType: string(f.MediaType),
-			FileName:  f.FileName,
+			FileID:    f.FileID,
 			FilePath:  f.FilePath,
 			Checksum:  f.Checksum,
 			CreatedAt: f.CreatedAt,
@@ -57,7 +88,7 @@ func (s *FileService) Create(r io.Reader, filename string) (assets.FileResponse,
 		ID:        f.ID,
 		MetaName:  f.MetaName,
 		MediaType: string(f.MediaType),
-		FileName:  f.FileName,
+		FileID:    f.FileID,
 		FilePath:  f.FilePath,
 		Checksum:  f.Checksum,
 		CreatedAt: f.CreatedAt,
@@ -68,7 +99,7 @@ func (s *FileService) Create(r io.Reader, filename string) (assets.FileResponse,
 }
 
 func (s *FileService) DeleteByName(filename string) error {
-	fileRecord, err := database.FindFileByName(s.db, filename)
+	fileRecord, err := database.FindFileByFileID(s.db, filename)
 	if err != nil {
 		return err
 	}