Insert rows into a table.

Insert rows into a table. If the table has key, it will ignore the duplicate rows indexed by the key. It assumes that the table has been created beforehand.

dbAppendTableNew(conn, name, value, ...)

Arguments

conn	A SQLiteConnection object, as returned by dbConnect().
name	Name of the table.
value	A data frame of values. The column names must be consistent with those in the target table in the database.
...	Other arguments used by individual methods.

Value

Number of rows appended successfully.

Examples

con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
DBI::dbWriteTable(con, "iris", iris[0, ])
flightscanner:::dbAppendTableNew(con, "iris", iris)
#> [1] 150
df <- DBI::dbReadTable(con, "iris")
head(df)
#>   Sepal.Length Sepal.Width Petal.Length Petal.Width Species
#> 1          5.1         3.5          1.4         0.2  setosa
#> 2          4.9         3.0          1.4         0.2  setosa
#> 3          4.7         3.2          1.3         0.2  setosa
#> 4          4.6         3.1          1.5         0.2  setosa
#> 5          5.0         3.6          1.4         0.2  setosa
#> 6          5.4         3.9          1.7         0.4  setosa
dbDisconnect(con)