database

func ScheduleOptimization ¶

func ScheduleOptimization(ctx context.Context, pool *dbconnpool.DbSQLConnPool, wg *sync.WaitGroup)

func Setup ¶

func Setup(ctx context.Context, rootDir string, cfg *config.Config) (string, *dbconnpool.DbSQLConnPool, *dbconnpool.DbSQLConnPool, error)

Setup initializes the database environment: 1. Sets up the directory struct 2. Runs schema migrations 3. Establishes connection pools (RW/RO) 4. Ensures root folder entry exists 5. Schedules periodic optimization