public void DBRead(int gameId, bool readRoms = false)
{
if (_commandRvGameRead == null)
{
_commandRvGameRead = new SQLiteCommand(@"
SELECT GameId, DatId, name, description, manufacturer, cloneof, romof, sourcefile, isbios, board, year, istrurip, publisher, developer, edition, version, type, media, language, players, ratings, genre, peripheral, barcode, mediacatalognumber
FROM GAME WHERE GameId=@GameId ORDER BY name", DBSqlite.db.Connection);
_commandRvGameRead.Parameters.Add(new SQLiteParameter("GameId"));
}
_commandRvGameRead.Parameters["GameId"].Value = gameId;
using (DbDataReader dr = _commandRvGameRead.ExecuteReader())
{
if (dr.Read())
{
RvGameReadFromReader(dr, this);
}
dr.Close();
}
if (readRoms)
{
Roms = RvRom.ReadRoms(GameId);
}
}
public static List <RvGame> ReadGames(uint datId, bool readRoms = false)
{
if (_commandRvGameReadDatGames == null)
{
_commandRvGameReadDatGames = new SQLiteCommand(@"
SELECT GameId, DatId, name, description, manufacturer, cloneof, romof, sourcefile, isbios, board, year, istrurip, publisher, developer, edition, version, type, media, language, players, ratings, genre, peripheral, barcode, mediacatalognumber
FROM GAME WHERE DatId=@DatId ORDER BY name", DBSqlite.db.Connection);
_commandRvGameReadDatGames.Parameters.Add(new SQLiteParameter("DatId"));
}
List <RvGame> games = new List <RvGame>();
_commandRvGameReadDatGames.Parameters["DatId"].Value = datId;
using (DbDataReader dr = _commandRvGameReadDatGames.ExecuteReader())
{
while (dr.Read())
{
RvGame rvGame = new RvGame();
RvGameReadFromReader(dr, rvGame);
games.Add(rvGame);
}
dr.Close();
}
if (readRoms)
{
foreach (RvGame game in games)
{
game.Roms = RvRom.ReadRoms(game.GameId);
}
}
return(games);
}
public static List <RvRom> ReadRoms(uint gameId)
{
if (_commandRvRomReader == null)
{
_commandRvRomReader = new SQLiteCommand(
@"SELECT RomId,name,
type,
rom.size,
rom.crc,
rom.sha1,
rom.md5,
merge,status,putinzip,
rom.FileId,
files.size as fileSize,
files.compressedsize as fileCompressedSize,
files.crc as filecrc,
files.sha1 as filesha1,
files.md5 as filemd5
FROM rom LEFT OUTER JOIN files ON files.FileId=rom.FileId WHERE GameId=@GameId ORDER BY RomId", DBSqlite.db.Connection);
_commandRvRomReader.Parameters.Add(new SQLiteParameter("GameId"));
}
List <RvRom> roms = new List <RvRom>();
_commandRvRomReader.Parameters["GameId"].Value = gameId;
using (DbDataReader dr = _commandRvRomReader.ExecuteReader())
{
while (dr.Read())
{
RvRom row = new RvRom
{
RomId = Convert.ToUInt32(dr["RomId"]),
GameId = gameId,
Name = dr["name"].ToString(),
AltType = VarFix.FixFileType(dr["type"]),
Size = VarFix.FixLong(dr["size"]),
CRC = VarFix.CleanMD5SHA1(dr["CRC"].ToString(), 8),
SHA1 = VarFix.CleanMD5SHA1(dr["SHA1"].ToString(), 40),
MD5 = VarFix.CleanMD5SHA1(dr["MD5"].ToString(), 32),
Merge = dr["merge"].ToString(),
Status = dr["status"].ToString(),
PutInZip = (bool)dr["putinzip"],
FileId = VarFix.FixLong(dr["FileId"]),
FileSize = VarFix.FixLong(dr["fileSize"]),
FileCompressedSize = VarFix.FixLong(dr["fileCompressedSize"]),
FileCRC = VarFix.CleanMD5SHA1(dr["fileCRC"].ToString(), 8),
FileSHA1 = VarFix.CleanMD5SHA1(dr["fileSHA1"].ToString(), 40),
FileMD5 = VarFix.CleanMD5SHA1(dr["fileMD5"].ToString(), 32)
};
roms.Add(row);
}
dr.Close();
}
return(roms);
}
public int AddRom(RvRom rvRom)
{
if (Roms == null)
{
Roms = new List <RvRom>();
}
int index;
ChildNameSearch(rvRom.Name, out index);
Roms.Insert(index, rvRom);
return(index);
}
private void MakeDB()
{
/******** Create Tables ***********/
ExecuteNonQuery(@"
CREATE TABLE IF NOT EXISTS [VERSION] (
[Version] INTEGER NOT NULL);
INSERT INTO VERSION (version) VALUES (@Version);",
"version", DBVersion);
RvDir.CreateTable();
RvDat.CreateTable();
RvGame.CreateTable();
RvFile.CreateTable();
RvRom.CreateTable();
}
private static void CopyDir(DatDir datD, HeaderFileType headerFileType, RvDat retDat = null, RvGame retGame = null)
{
DatBase[] datB = datD.ToArray();
if (datB == null)
{
return;
}
foreach (DatBase b in datB)
{
switch (b)
{
case DatDir nDir:
if (nDir.DGame == null)
{
break;
}
DatGame dGame = nDir.DGame;
RvGame cGame = new RvGame();
cGame.Name = b.Name;
cGame.Description = dGame.Description;
cGame.Manufacturer = dGame.Manufacturer;
cGame.CloneOf = dGame.CloneOf;
cGame.RomOf = dGame.RomOf;
cGame.SampleOf = dGame.SampleOf;
cGame.SourceFile = dGame.SourceFile;
cGame.IsBios = dGame.IsBios;
cGame.Board = dGame.Board;
cGame.Year = dGame.Year;
if (dGame.IsEmuArc)
{
cGame.IsTrurip = true;
cGame.Publisher = dGame.Publisher;
cGame.Developer = dGame.Developer;
//cGame.Edition
//cGame.Version
//cGame.Type
//cGame.Media
//cGame.Language
cGame.Players = dGame.Players;
cGame.Ratings = dGame.Ratings;
cGame.Genre = dGame.Genre;
//cGame.Peripheral
//cGame.BarCode
//cGame.MediaCatalogNumber
}
retDat?.AddGame(cGame);
CopyDir(nDir, headerFileType, null, cGame);
break;
case DatFile nFile:
if (nFile.isDisk)
{
break;
}
RvRom nf = new RvRom()
{
Name = nFile.Name,
Size = nFile.Size,
CRC = nFile.CRC,
SHA1 = nFile.SHA1,
MD5 = nFile.MD5,
Merge = nFile.Merge,
Status = nFile.Status,
AltType = headerFileType
};
retGame?.AddRom(nf);
break;
}
}
}
