public static void Fill(SqliteDatabaseProvider provider, IEnumerable <string> jsonResponses) { //1. create (temp) table SqliteTableBuilder builder = CreateTable(provider); provider.BulkInsert(builder.GetInsertStatements(ExtractEventNodes("owner", "repo", jsonResponses))); }
public static SqliteTableBuilder CreateTable(SqliteDatabaseProvider provider) { Guard.ArgumentNotNull(provider, nameof(provider)); SqliteTableBuilder builder = RepositoryTableSnapshot.CreateTableBuilder(); provider.CreateTable(builder); return(builder); }
public static SqliteTableBuilder CreateTable(SqliteDatabaseProvider provider) { Guard.ArgumentNotNull(provider, nameof(provider)); SqliteTableBuilder builder = EventTableSnapshot.CreateTableBuilder(); provider.CreateTable(builder); //foreach (string statement in builder.Build()) //{ // provider.Connection.Execute(statement); //execute create table and other DML Statements! //} return(builder); }