public void RetrieveListTest_withValidData(string value)
{
// Arrange
DBReader reader = new SQLiteReader();
// Act
List <FilmLengthItem> list = Data.FilmLengthItem.RetrieveList(reader, value, "_xxx", "FilmLength");
// Assert
Assert.AreEqual(3, list.Count);
Assert.AreEqual("_xx1", list[0].ID);
Assert.AreEqual($"{value} FilmLength Length X1", list[0].Length);
Assert.AreEqual($"{value} FilmLength Details X1", list[0].Details);
Assert.AreEqual("_xxx", list[0].Status.ID);
Assert.AreEqual($"{value} FilmLength LastUpdated X1", list[0].LastUpdated);
Assert.AreEqual("_xx2", list[1].ID);
Assert.AreEqual($"{value} FilmLength Length X2", list[1].Length);
Assert.AreEqual($"{value} FilmLength Details X2", list[1].Details);
Assert.AreEqual("_xxx", list[1].Status.ID);
Assert.AreEqual($"{value} FilmLength LastUpdated X2", list[1].LastUpdated);
Assert.AreEqual("_xx3", list[2].ID);
Assert.AreEqual($"{value} FilmLength Length X3", list[2].Length);
Assert.AreEqual($"{value} FilmLength Details X3", list[2].Details);
Assert.AreEqual("_xxx", list[2].Status.ID);
Assert.AreEqual($"{value} FilmLength LastUpdated X3", list[2].LastUpdated);
}
private bool GetPeptideProteinMap(SQLiteReader reader, string tableName, out List <RowEntry> pepToProtMapping)
{
reader.SQLText = "SELECT * FROM [" + tableName + "]";
// Make a Mage sink Module (row buffer
var sink = new SimpleSink();
// Construct and run mage pipeline to get the peptide and protein info
ProcessingPipeline.Assemble("Test_Pipeline", reader, sink).RunRoot(null);
var proteinIdx = sink.ColumnIndex["Protein"];
var peptideIdx = sink.ColumnIndex["Peptide"];
pepToProtMapping = new List <RowEntry>();
foreach (object[] row in sink.Rows)
{
var entry = new RowEntry
{
ProteinEntry = (string)row[proteinIdx],
PeptideEntry = (string)row[peptideIdx]
};
pepToProtMapping.Add(entry);
}
if (pepToProtMapping.Count == 0)
{
throw new Exception("Error reading data from " + tableName + "; no results found using " + reader.SQLText);
}
return(true);
}
public void RetrieveListTest_withValidData(string value1, string value2)
{
// Arrange
DBReader reader = new SQLiteReader();
// Act
List <TimespanItem> list = Data.TimespanItem.RetrieveList(reader, value1, "_xxx", value2.Replace(" ", ""));
// Assert
Assert.AreEqual(3, list.Count);
Assert.AreEqual("_xx1", list[0].ID);
Assert.AreEqual($"{value1} {value2} StartDate X1", list[0].StartDate);
Assert.AreEqual($"{value1} {value2} EndDate X1", list[0].EndDate);
Assert.AreEqual($"{value1} {value2} Details X1", list[0].Details);
Assert.AreEqual("_xxx", list[0].Status.ID);
Assert.AreEqual($"{value1} {value2} LastUpdated X1", list[0].LastUpdated);
Assert.AreEqual("_xx2", list[1].ID);
Assert.AreEqual($"{value1} {value2} StartDate X2", list[1].StartDate);
Assert.AreEqual($"{value1} {value2} EndDate X2", list[1].EndDate);
Assert.AreEqual($"{value1} {value2} Details X2", list[1].Details);
Assert.AreEqual("_xxx", list[1].Status.ID);
Assert.AreEqual($"{value1} {value2} LastUpdated X2", list[1].LastUpdated);
Assert.AreEqual("_xx3", list[2].ID);
Assert.AreEqual($"{value1} {value2} StartDate X3", list[2].StartDate);
Assert.AreEqual($"{value1} {value2} EndDate X3", list[2].EndDate);
Assert.AreEqual($"{value1} {value2} Details X3", list[2].Details);
Assert.AreEqual("_xxx", list[2].Status.ID);
Assert.AreEqual($"{value1} {value2} LastUpdated X3", list[2].LastUpdated);
}
public void RetrieveListTest_withValidData(string value, string value2)
{
// Arrange
DBReader reader = new SQLiteReader();
// Act
List <CastPersonItem> list = Data.CastPersonItem.RetrieveList(reader, value, "_xxx", value2);
// Assert
Assert.AreEqual(3, list.Count);
Assert.AreEqual("_xx1", list[0].ID);
Assert.AreEqual("_xxx", list[0].Actor.ID);
Assert.AreEqual("_xxx", list[0].GermanDubber.ID);
Assert.AreEqual($"{value} {value2} Character X1", list[0].Character);
Assert.AreEqual($"{value} {value2} Details X1", list[0].Details);
Assert.AreEqual("_xxx", list[0].Status.ID);
Assert.AreEqual($"{value} {value2} LastUpdated X1", list[0].LastUpdated);
Assert.AreEqual("_xx2", list[1].ID);
Assert.AreEqual("_yyy", list[1].Actor.ID);
Assert.AreEqual("_xxx", list[1].GermanDubber.ID);
Assert.AreEqual($"{value} {value2} Character X2", list[1].Character);
Assert.AreEqual($"{value} {value2} Details X2", list[1].Details);
Assert.AreEqual("_xxx", list[1].Status.ID);
Assert.AreEqual($"{value} {value2} LastUpdated X2", list[1].LastUpdated);
Assert.AreEqual("_xx3", list[2].ID);
Assert.AreEqual("_zzz", list[2].Actor.ID);
Assert.AreEqual("_xxx", list[2].GermanDubber.ID);
Assert.AreEqual($"{value} {value2} Character X3", list[2].Character);
Assert.AreEqual($"{value} {value2} Details X3", list[2].Details);
Assert.AreEqual("_xxx", list[2].Status.ID);
Assert.AreEqual($"{value} {value2} LastUpdated X3", list[2].LastUpdated);
}
public void RetrieveListTest_withValidData(string value)
{
// Arrange
DBReader reader = new SQLiteReader();
// Act
List <LanguageItem> list = Data.LanguageItem.RetrieveList(reader, value, "_xxx", "Language");
// Assert
Assert.AreEqual(3, list.Count);
Assert.AreEqual("_xx1", list[0].ID);
Assert.AreEqual("_xxx", list[0].Language.ID);
Assert.AreEqual($"{value} Language Details X1", list[0].Details);
Assert.AreEqual("_xxx", list[0].Status.ID);
Assert.AreEqual($"{value} Language LastUpdated X1", list[0].LastUpdated);
Assert.AreEqual("_xx2", list[1].ID);
Assert.AreEqual("_yyy", list[1].Language.ID);
Assert.AreEqual($"{value} Language Details X2", list[1].Details);
Assert.AreEqual("_xxx", list[1].Status.ID);
Assert.AreEqual($"{value} Language LastUpdated X2", list[1].LastUpdated);
Assert.AreEqual("_xx3", list[2].ID);
Assert.AreEqual("_zzz", list[2].Language.ID);
Assert.AreEqual($"{value} Language Details X3", list[2].Details);
Assert.AreEqual("_xxx", list[2].Status.ID);
Assert.AreEqual($"{value} Language LastUpdated X3", list[2].LastUpdated);
}
public UInt32?GetInt32(int i)
{
if (SQLiteReader.IsDBNull(i))
{
return(null);
}
return((UInt32?)SQLiteReader.GetInt32(i));
}
public float?GetFloat(int i)
{
if (SQLiteReader.IsDBNull(i))
{
return(null);
}
return((float?)SQLiteReader.GetFloat(i));
}
public bool?GetBoolean(int i)
{
if (SQLiteReader.IsDBNull(i))
{
return(null);
}
return((bool?)SQLiteReader.GetBoolean(i));
}
public void SQLiteReaderTest()
{
// Arrange
SQLiteReader reader = new SQLiteReader();
// Act
// Assert
Assert.IsNotNull(reader);
Assert.AreEqual("", reader.Query);
Assert.IsNotNull(reader.Table);
}
public void RetrieveListTest_withValidData(string value)
{
// Arrange
DBReader reader = new SQLiteReader();
// Act
List <AwardItem> list = Data.AwardItem.RetrieveList(reader, value, "_xxx", "Award");
// Assert
Assert.AreEqual(3, list.Count);
Assert.AreEqual("_xx1", list[0].ID);
Assert.AreEqual("_xxx", list[0].Award.ID);
Assert.AreEqual($"{value} Award Category X1", list[0].Category);
Assert.AreEqual($"{value} Award Date X1", list[0].Date);
Assert.AreEqual($"1", list[0].Winner);
Assert.AreEqual($"{value} Award Details X1", list[0].Details);
Assert.AreEqual("_xxx", list[0].Status.ID);
Assert.AreEqual($"{value} Award LastUpdated X1", list[0].LastUpdated);
Assert.AreEqual(3, list[0].Persons.Count);
Assert.AreEqual("_x11", list[0].Persons[0].ID);
Assert.AreEqual("_x12", list[0].Persons[1].ID);
Assert.AreEqual("_x13", list[0].Persons[2].ID);
Assert.AreEqual("_xx2", list[1].ID);
Assert.AreEqual("_yyy", list[1].Award.ID);
Assert.AreEqual($"{value} Award Category X2", list[1].Category);
Assert.AreEqual($"{value} Award Date X2", list[1].Date);
Assert.AreEqual($"0", list[1].Winner);
Assert.AreEqual($"{value} Award Details X2", list[1].Details);
Assert.AreEqual("_xxx", list[1].Status.ID);
Assert.AreEqual($"{value} Award LastUpdated X2", list[1].LastUpdated);
Assert.AreEqual(3, list[1].Persons.Count);
Assert.AreEqual("_x21", list[1].Persons[0].ID);
Assert.AreEqual("_x22", list[1].Persons[1].ID);
Assert.AreEqual("_x23", list[1].Persons[2].ID);
Assert.AreEqual("_xx3", list[2].ID);
Assert.AreEqual("_zzz", list[2].Award.ID);
Assert.AreEqual($"{value} Award Category X3", list[2].Category);
Assert.AreEqual($"{value} Award Date X3", list[2].Date);
Assert.AreEqual($"0", list[2].Winner);
Assert.AreEqual($"{value} Award Details X3", list[2].Details);
Assert.AreEqual("_xxx", list[2].Status.ID);
Assert.AreEqual($"{value} Award LastUpdated X3", list[2].LastUpdated);
Assert.AreEqual(3, list[2].Persons.Count);
Assert.AreEqual("_x31", list[2].Persons[0].ID);
Assert.AreEqual("_x32", list[2].Persons[1].ID);
Assert.AreEqual("_x33", list[2].Persons[2].ID);
}
public void RetrieveTest_validID_AdditionalInfo(string value)
{
// Arrange
SQLiteReader reader = new SQLiteReader();
reader.Query = $"SELECT ID FROM {value} WHERE ID LIKE \"_xxx\"";
// Act
reader.Retrieve(false);
// Assert
Assert.AreEqual(1, reader.Table.Columns.Count);
Assert.AreEqual(1, reader.Table.Rows.Count);
}
static void Main(string[] args)
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion
<SupermarketContext, Configuration>());
ClientMySQL.MySQLReader.MoveData();
ExcelReader.ExtractReportNames();
MongoDbWriter.Write();
SQLiteReader.MoveData();
PDFFileCreator.CreateTable("sampleForTest.pdf");
XMLFIleCreator.CreateXMLFile("salesForTest.xml");
ExcelWriter.CreateExcelTable();
XMLFileReader.ParseXML("../../Vendor-Expenses.xml");
}
public void LoadLastOpenedFile()
{
string fileName = windowService.LastSavedFileName;
if (fileName != string.Empty)
{
FileReader fileHandler = new SQLiteReader();
if (fileHandler.LoadFile(fileName))
{
if (!core.InitializeNewFileReader(fileHandler))
{
windowService.ShowMessage("File is corrupted.");
CloseFile.Execute(null);
}
OpenedFile = fileName;
}
}
}
public void RetrieveListTest_withValidData(string value1, string value2)
{
// Arrange
DBReader reader = new SQLiteReader();
// Act
List <DistributorCompanyItem> list = Data.DistributorCompanyItem.RetrieveList(reader, value1, "_xxx", value2.Replace(" ", ""));
// Assert
Assert.AreEqual(3, list.Count);
Assert.AreEqual("_xx1", list[0].ID);
Assert.AreEqual("_xxx", list[0].Company.ID);
Assert.AreEqual("_xxx", list[0].Country.ID);
Assert.AreEqual($"{value1} {value2} ReleaseDate X1", list[0].ReleaseDate);
Assert.AreEqual($"{value1} {value2} Role X1", list[0].Role);
Assert.AreEqual($"{value1} {value2} Details X1", list[0].Details);
Assert.AreEqual("_xxx", list[0].Status.ID);
Assert.AreEqual($"{value1} {value2} LastUpdated X1", list[0].LastUpdated);
Assert.AreEqual("_xx2", list[1].ID);
Assert.AreEqual("_yyy", list[1].Company.ID);
Assert.AreEqual("_xxx", list[1].Country.ID);
Assert.AreEqual($"{value1} {value2} ReleaseDate X2", list[1].ReleaseDate);
Assert.AreEqual($"{value1} {value2} Role X2", list[1].Role);
Assert.AreEqual($"{value1} {value2} Details X2", list[1].Details);
Assert.AreEqual("_xxx", list[1].Status.ID);
Assert.AreEqual($"{value1} {value2} LastUpdated X2", list[1].LastUpdated);
Assert.AreEqual("_xx3", list[2].ID);
Assert.AreEqual("_zzz", list[2].Company.ID);
Assert.AreEqual("_xxx", list[2].Country.ID);
Assert.AreEqual($"{value1} {value2} ReleaseDate X3", list[2].ReleaseDate);
Assert.AreEqual($"{value1} {value2} Role X3", list[2].Role);
Assert.AreEqual($"{value1} {value2} Details X3", list[2].Details);
Assert.AreEqual("_xxx", list[2].Status.ID);
Assert.AreEqual($"{value1} {value2} LastUpdated X3", list[2].LastUpdated);
}
public bool IsDBNull(int i)
{
return(SQLiteReader.IsDBNull(i));
}
public string GetString(int i)
{
return(SQLiteReader.IsDBNull(i) ? null : SQLiteReader.GetString(i));
}
public bool Read()
{
return(SQLiteReader.Read());
}
/// <summary>
/// Run the parsimony algorithm against the peptides and proteins in table sourceTableName in the specified SQLite database
/// </summary>
/// <param name="databaseFolderPath"></param>
/// <param name="dataBaseFileName"></param>
/// <param name="sourceTableName">Table name to process</param>
/// <returns>True if success; false if an error</returns>
public bool ProcessSQLite(string databaseFolderPath, string dataBaseFileName, string sourceTableName = DEFAULT_SQLITE_TABLE)
{
List <RowEntry> pepToProtMapping;
List <Node> result;
var diDataFolder = new DirectoryInfo(databaseFolderPath);
if (!diDataFolder.Exists)
{
throw new DirectoryNotFoundException("Database folder not found: " + databaseFolderPath);
}
var fiDatabaseFile = new FileInfo(Path.Combine(diDataFolder.FullName, dataBaseFileName));
if (!fiDatabaseFile.Exists)
{
throw new FileNotFoundException("Database not found: " + fiDatabaseFile);
}
if (ShowProgressAtConsole)
{
OnStatusEvent("Opening SQLite database " + fiDatabaseFile.FullName);
}
if (!VerifySourceTableExists(fiDatabaseFile, sourceTableName))
{
return(false);
}
var dbReader = new SQLiteReader
{
Database = fiDatabaseFile.FullName
};
try
{
var success = GetPeptideProteinMap(dbReader, sourceTableName, out pepToProtMapping);
if (!success)
{
if (ShowProgressAtConsole)
{
OnErrorEvent("Error loading data from table {0}; GetPeptideProteinMap returned false", sourceTableName);
}
return(false);
}
if (ShowProgressAtConsole)
{
OnStatusEvent("Loaded {0} rows from table {1}", pepToProtMapping.Count, sourceTableName);
}
}
catch (Exception ex)
{
throw new Exception("Error calling GetPeptideProteinMap: " + ex.Message, ex);
}
if (fiDatabaseFile.DirectoryName == null)
{
throw new Exception("Error determining the parent directory for " + fiDatabaseFile.FullName);
}
var parsimonyResultsFilePath = Path.Combine(fiDatabaseFile.DirectoryName, "pars_info_temp.txt");
var proteinGroupMembersFilePath = Path.Combine(fiDatabaseFile.DirectoryName, "pars_info_temp_groups.txt");
if (pepToProtMapping == null || pepToProtMapping.Count == 0)
{
DeleteFile(parsimonyResultsFilePath);
DeleteFile(proteinGroupMembersFilePath);
throw new Exception("Error in RunAlgorithm: No rows to operate on");
}
GlobalIDContainer globalIDTracker;
try
{
PerformParsimonyThreaded(pepToProtMapping, out result, out globalIDTracker);
}
catch (Exception ex)
{
throw new Exception("Error calling PerformParsimonyThreaded: " + ex.Message, ex);
}
if (ShowProgressAtConsole)
{
Console.WriteLine();
OnStatusEvent("Exporting protein groups to temp text files");
}
Utilities.SaveResults(result, parsimonyResultsFilePath, proteinGroupMembersFilePath, globalIDTracker);
ClearExistingSQLiteResults(fiDatabaseFile);
if (ShowProgressAtConsole)
{
Console.WriteLine();
}
try
{
var resultsReader = new DelimitedFileReader
{
FilePath = parsimonyResultsFilePath
};
var writer = new SQLiteWriter
{
DbPath = fiDatabaseFile.FullName,
TableName = PARSIMONY_GROUPING_TABLE
};
writer.ColDefOverride = new List <MageColumnDef>
{
new("GroupID", "integer", "4") // Note that "size" doesn't matter since we're writing to a SqLite database
};
if (ShowProgressAtConsole)
{
OnStatusEvent("Importing data into table " + PARSIMONY_GROUPING_TABLE);
}
ProcessingPipeline.Assemble("ImportToSQLite", resultsReader, writer).RunRoot(null);
}
catch (Exception ex)
{
throw new Exception("Error adding data to table " + PARSIMONY_GROUPING_TABLE + " to the SqLite database: " + ex.Message, ex);
}
try
{
var proteinGroupsReader = new DelimitedFileReader
{
FilePath = proteinGroupMembersFilePath
};
var writer = new SQLiteWriter
{
DbPath = fiDatabaseFile.FullName,
TableName = PARSIMONY_GROUP_MEMBERS_TABLE
};
writer.ColDefOverride = new List <MageColumnDef>
{
new("GroupID", "integer", "4") // Note that "size" doesn't matter since we're writing to a SqLite database
};
if (ShowProgressAtConsole)
{
OnStatusEvent("Importing data into table " + PARSIMONY_GROUP_MEMBERS_TABLE);
}
ProcessingPipeline.Assemble("ImportToSQLite", proteinGroupsReader, writer).RunRoot(null);
}
catch (Exception ex)
{
throw new Exception("Error adding data to table " + PARSIMONY_GROUP_MEMBERS_TABLE + " to the SqLite database: " + ex.Message, ex);
}
DeleteFile(parsimonyResultsFilePath);
DeleteFile(proteinGroupMembersFilePath);
return(true);
}
public void Dispose()
{
SQLiteReader.Dispose();
}
protected SQLiteHelper()
{
sqlitereader = new SQLiteReader();
sqlitewriter = new SQLiteWriter();
}
// --- Methods ---
static void Main(string[] args)
{
Logger.Trace($"'WikiPageCreator' aufgerufen");
Console.WriteLine($"Willkommen beim WikiPage Creator!");
// Output-Folder
string outputFolderDefault = ".\\output";
string outputFolder;
Console.WriteLine($"");
Console.WriteLine($"Bitte geben Sie den Ordner für die Dateiausgabe an (oder Enter für voreingestellten Pfad):");
Console.WriteLine($"(voreingestellter Pfad ist '{outputFolderDefault}'");
outputFolder = Console.ReadLine();
if (String.IsNullOrEmpty(outputFolder))
{
outputFolder = outputFolderDefault;
}
Console.WriteLine($"");
Console.WriteLine($"Ihr ausgewählter Ausgabe-Ordner ist '{outputFolder}'");
Logger.Trace($"Ausgabeordner: {outputFolder}");
// Target language
string targetLanguageCodeUser = "******";
Logger.Trace($"Zielsprache: {targetLanguageCodeUser}");
// ID
string idUser;
do
{
do
{
Console.WriteLine($"");
Console.WriteLine($"Bitte geben Sie die ID des Films ein, für den eine Wiki-Seite erstellt werden soll (oder 'q' für Beenden):");
idUser = Console.ReadLine();
}while (String.IsNullOrEmpty(idUser));
if (idUser.Equals("q") || idUser.Equals("Q"))
{
break;
}
Logger.Trace($"Film ID: {idUser}");
// do work
// TODO: which DB reader is to be used should be defined in configuration
SQLiteReader reader = new SQLiteReader();
if (idUser.Equals("*"))
{
List <Movie> list = Movie.RetrieveList(reader, "ok");
foreach (Movie item in list)
{
CreateMoviePage(item.ID, targetLanguageCodeUser, outputFolder);
Console.WriteLine($"Seitenerstellung für ID: {item.ID} erfolgreich beendet.");
}
}
else
{
CreateMoviePage(idUser, targetLanguageCodeUser, outputFolder);
Console.WriteLine($"Seitenerstellung für ID: {idUser} erfolgreich beendet.");
}
// End
Console.WriteLine($"");
Console.WriteLine($"Alle Seiten erfolgreich erstellt.");
Console.ReadLine();
}while (true);
Logger.Trace($"'WikiPageCreator' beendet");
}
