private void InsertRawTrainingRecord(Move move, float finalScore)
{
var sql = RLTSettings.GetInsertRecordSQL(move, finalScore); // $"INSERT INTO training_raw (Id, Decision, Score) values ({id}, '{decision}', {score})";
var command = new SQLiteCommand(sql, Conn);
command.ExecuteNonQuery();
}
private void UpdateTrainingDB(T iteration)
{
var tr = Conn.BeginTransaction();
foreach (var m in iteration.Board.MoveHistory)
{
var command = Conn.CreateCommand();
command.CommandText = RLTSettings.GetInsertRecordSQL(m, iteration.Board.Score); // $"INSERT INTO training_raw (Id, Decision, Score) values ({m.StartState.CanonicalFieldID()}, '{m.Direction}', {board.Score})";
command.ExecuteNonQuery();
}
//commit
try { tr.Commit(); }
catch (Exception)
{
Console.WriteLine("Error writing training data, rolled back");
tr.Rollback();
}
finally { tr.Dispose(); }
}