<?php

namespace RoosterLMS\CourseInfo;

use RoosterLMS\Core\Schema;
use RoosterLMS\Data\Db;

defined( 'ABSPATH' ) || exit;

final class Seeds {

	public const LEVELS = array( 'beginner', 'intermediate', 'advanced' );

	public const BADGES = array(
		'hot'     => '#dc2626',
		'new'     => '#16a34a',
		'special' => '#7c3aed',
	);

	public static function seed(): int {
		$inserted = 0;
		foreach ( self::LEVELS as $i => $slug ) {
			$inserted += (int) Db::query( "INSERT IGNORE INTO %i (slug, label, position, state, builtin) VALUES (%s, '', %d, 1, 1)", Schema::table( 'course_levels' ), $slug, $i + 1 );
		}
		$i = 0;
		foreach ( self::BADGES as $slug => $color ) {
			$inserted += (int) Db::query( "INSERT IGNORE INTO %i (slug, label, color, position, state, builtin) VALUES (%s, '', %s, %d, 1, 1)", Schema::table( 'course_badges' ), $slug, $color, ++$i );
		}
		return $inserted;
	}
}