private static void WriteTranslationToSqliteDb(
string sourceText,
TranslationPair translation,
string model,
SegmentationMethod segmentationMethod,
string targetLanguage)
{
var translationDb = new FileInfo(HelperFunctions.GetOpusCatDataPath(OpusCatMTEngineSettings.Default.TranslationDBName));
if (translationDb.Length == 0)
{
translationDb.Delete();
}
if (!translationDb.Exists)
{
TranslationDbHelper.CreateTranslationDb();
}
using (var m_dbConnection = new SQLiteConnection($"Data Source={translationDb};Version=3;"))
{
m_dbConnection.Open();
using (SQLiteCommand insert =
new SQLiteCommand(
"INSERT or REPLACE INTO translations (sourcetext, translation, segmentedsource, segmentedtranslation, alignment, model, additiondate, segmentationmethod, targetlanguage) VALUES (@sourcetext,@translation,@segmentedsource,@segmentedtranslation,@alignment,@model,CURRENT_TIMESTAMP,@segmentationmethod,@targetlanguage)", m_dbConnection))
{
insert.Parameters.Add(new SQLiteParameter("@sourcetext", sourceText));
insert.Parameters.Add(new SQLiteParameter("@translation", translation.Translation));
insert.Parameters.Add(new SQLiteParameter("@segmentedsource", String.Join(" ", translation.SegmentedSourceSentence)));
insert.Parameters.Add(new SQLiteParameter("@segmentedtranslation", String.Join(" ", translation.SegmentedTranslation)));
insert.Parameters.Add(new SQLiteParameter("@alignment", translation.AlignmentString));
insert.Parameters.Add(new SQLiteParameter("@model", model));
insert.Parameters.Add(new SQLiteParameter("@segmentationmethod", segmentationMethod.ToString()));
insert.Parameters.Add(new SQLiteParameter("@targetlanguage", targetLanguage));
insert.ExecuteNonQuery();
}
}
}
