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