public Beatmap CreateBeatmapFromEntry(BeatmapProcessorContainerEntry entry)
{
BeatmapReader bmReader = new BeatmapReader(ProcessorSettings);
var bm = bmReader.ReadBeatmap(_graphicsDevice, GetBeatmapNameWithoutVersion(entry.BeatmapName),
entry.BeatmapVersion);
return(bm);
}
private void ProcessDatabase(GraphicsDevice graphicsDevice)
{
// TODO: Encapsulate work with the data base
var dbConnection = new SQLiteConnection($"Data Source={ProcessorSettings.DatabaseName};Version=3;");
dbConnection.Open();
var dbCommand = dbConnection.CreateCommand();
dbCommand.CommandText = "SELECT * FROM beatmaps";
var dbDataReader = dbCommand.ExecuteReader();
BeatmapReader bmReader = new BeatmapReader(ProcessorSettings);
// Read all entries while there is any
while (dbDataReader.Read())
{
// There are 22 values (from 0 to 21)
// 0-3 values are information about beatmap location
string beatmapFolder = dbDataReader.GetString(0);
string beatmapFilename = dbDataReader.GetString(1);
string beatmapName = dbDataReader.GetString(2);
string beatmapVersion = dbDataReader.GetString(3);
// 4-17 values are beatmap settings data
var bmSettingsGeneral = new BeatmapSettingsGeneral(
dbDataReader.GetString(4),
dbDataReader.GetInt32(5),
dbDataReader.GetString(6));
var bmSettingsEditor = new BeatmapSettingsEditor(dbDataReader.GetInt32(7));
var bmSettingsMetadata = new BeatmapSettingsMetadata(dbDataReader.GetString(8),
dbDataReader.GetString(9), dbDataReader.GetString(10), dbDataReader.GetString(11),
dbDataReader.GetString(12), dbDataReader.GetInt32(13), dbDataReader.GetInt32(14));
var bmSettingsDifficutly = new BeatmapSettingsDifficulty(dbDataReader.GetFloat(15),
dbDataReader.GetFloat(16), dbDataReader.GetInt32(17));
var bmSettings = new BeatmapSettings(bmSettingsGeneral, bmSettingsEditor, bmSettingsMetadata, bmSettingsDifficutly);
// 20th - hit object count, 21st - the first beats per minute value
var hitObjectCount = dbDataReader.GetInt32(20);
var bpm = dbDataReader.GetDouble(21);
var bg = bmReader.LoadBeatmapBackgroundTexture(graphicsDevice, bmSettings, GetBeatmapNameWithoutVersion(beatmapName));
var music = bmReader.LoadBeatmapMusicTrack(bmSettings, GetBeatmapNameWithoutVersion(beatmapName));
var entry = new BeatmapProcessorContainerEntry(bmSettings,
bg, music, beatmapFolder, beatmapFilename, beatmapName,
beatmapVersion, hitObjectCount, bpm);
_beatmapSettingsList.Add(entry);
}
dbConnection.Close();
}
/// <summary>
/// Initialize a database and fill it with all available beatmaps.
/// </summary>
private void InitializeDatabase(GraphicsDevice graphicsDevice)
{
// TODO: Encapsulate work with the data base
string folder = ProcessorSettings.BeatmapsFolder;
string fileExt = ProcessorSettings.BeatmapFileExtension;
BeatmapReader bmReader = new BeatmapReader(ProcessorSettings);
SQLiteConnection dbConnection =
new SQLiteConnection($"Data Source={ProcessorSettings.DatabaseName};Version=3;");
dbConnection.Open();
SQLiteCommand dbCreateTableCommand = dbConnection.CreateCommand();
// SQLite table contains all the each beatmap's settings and some other necessary values
dbCreateTableCommand.CommandText =
@"CREATE TABLE IF NOT EXISTS
[beatmaps] (
[beatmap_folder] VARCHAR(2048) DEFAULT NULL,
[beatmap_filename] VARCHAR(256) DEFAULT NULL,
[beatmap_name] VARCHAR(256) DEFAULT NULL,
[beatmap_version] VARCHAR(256) DEFAULT NULL,
[beatmap_settings_audio_filename] VARCHAR(128) DEFAULT NULL,
[beatmap_settings_preview_time] INTEGER NOT NULL,
[beatmap_settings_background_filename] VARCHAR(128) DEFAULT NULL,
[beatmap_settings_beat_divisor] INTEGER NOT NULL,
[beatmap_settings_title] VARCHAR(128) DEFAULT NULL,
[beatmap_settings_artist] VARCHAR(128) DEFAULT NULL,
[beatmap_settings_creator] VARCHAR(128) DEFAULT NULL,
[beatmap_settings_version] VARCHAR(128) DEFAULT NULL,
[beatmap_settings_tags] VARCHAR(2048) DEFAULT NULL,
[beatmap_settings_beatmap_id] INTEGER NOT NULL PRIMARY KEY,
[beatmap_settings_beatmap_set_id] INTEGER NOT NULL,
[beatmap_settings_hp_drain_rate] REAL NOT NULL,
[beatmap_settings_overall_difficulty] REAL NOT NULL,
[beatmap_settings_key_amount] INTEGER NOT NULL,
[beatmap_settings_timing_points_filename] VARCHAR(128) DEFAULT NULL,
[beatmap_settings_hit_objects_filename] VARCHAR(128) DEFAULT NULL,
[beatmap_hit_object_count] INTEGER NOT NULL,
[beatmap_bpm] REAL NOT NULL)";
// Do create table
dbCreateTableCommand.ExecuteNonQuery();
// Enumerate each directory in the beatmap dir and process them
foreach (var directory in Directory.EnumerateDirectories(folder))
{
// Get all files with beatmap extension
var files = Directory.GetFiles(directory, $"*{fileExt}");
// If there is any, process it
if (files.Length != 0)
{
foreach (var file in files)
{
var settings = bmReader.ReadBeatmapSettings(file);
var beatmapName = GetBeatmapNameWithoutVersion(Path.GetFileNameWithoutExtension(file));
var version = settings.Metadata.Version;
var timingPoints = bmReader.ReadTimingPoints(beatmapName, settings);
var hitObjects = bmReader.ReadHitObjects(beatmapName, settings);
var bg = bmReader.LoadBeatmapBackgroundTexture(graphicsDevice, settings, GetBeatmapNameWithoutVersion(beatmapName));
var music = bmReader.LoadBeatmapMusicTrack(settings, GetBeatmapNameWithoutVersion(beatmapName));
var entry = new BeatmapProcessorContainerEntry(settings, bg, music, directory, Path.GetFileName(file),
Path.GetFileNameWithoutExtension(file), version, hitObjects.Count,
timingPoints[0].BeatsPerMinute);
_beatmapSettingsList.Add(entry);
// Insert a new value into the table
SQLiteCommand dbCmd = dbConnection.CreateCommand();
dbCmd.CommandText =
$@"INSERT INTO beatmaps (beatmap_folder, beatmap_filename, beatmap_name, beatmap_version, beatmap_settings_audio_filename, beatmap_settings_preview_time, beatmap_settings_background_filename, beatmap_settings_beat_divisor, beatmap_settings_title, beatmap_settings_artist, beatmap_settings_creator, beatmap_settings_version, beatmap_settings_tags, beatmap_settings_beatmap_id, beatmap_settings_beatmap_set_id, beatmap_settings_hp_drain_rate, beatmap_settings_overall_difficulty, beatmap_settings_key_amount, beatmap_settings_timing_points_filename, beatmap_settings_hit_objects_filename, beatmap_hit_object_count, beatmap_bpm)
VALUES (
'{directory}',
'{Path.GetFileName(file)}',
'{Path.GetFileNameWithoutExtension(file)}',
'{version}',
'{settings.General.AudioFileName}',
{settings.General.PreviewTime},
'{settings.General.BackgroundFileName}',
{settings.Editor.BeatDivisor},
'{settings.Metadata.Title}',
'{settings.Metadata.Artist}',
'{settings.Metadata.Creator}',
'{settings.Metadata.Version}',
'{settings.Metadata.Tags}',
{settings.Metadata.BeatmapId},
{settings.Metadata.BeatmapSetId},
{settings.Difficulty.HpDrainRate:F1},
{settings.Difficulty.OverallDifficutly:F1},
{settings.Difficulty.KeyAmount},
'{settings.TimingPointsFilename}',
'{settings.HitObjectsFilename}',
{hitObjects.Count},
{timingPoints[0].BeatsPerMinute:F2});";
dbCmd.ExecuteNonQuery();
}
}
}
dbConnection.Close();
}
