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)));
        }
Пример #2
0
        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);
        }