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"); }