package data

import (
	"database/sql"
	_ "embed"
	"log"
)

//go:embed db_struct_v1.sql
var dbStructV1SQL string

type (
	migratorVersion1 struct {
		conn *sql.DB
	}
)

func (m *migratorVersion1) create() error {
	log.Printf("[INFO] no database, creating system database structure...")
	_, err := m.conn.Exec(dbStructV1SQL)
	if err != nil {
		return err
	}
	log.Printf("[INFO] root user and role inserted by default")
	log.Println("[INFO] database created with success!")
	return nil
}