dbWriteTable() needs overwrite=TRUE

[brianhigh]

Regarding, "Advanced_data_manipulation.Rpres" and the slide, "Creating your own SQLite database in R" ...

If the database table ("hai", "cohort") already exists (i.e. code has already been run once), the following code returns an error and the slide presentation will not continue.

db <- dbConnect(SQLite(), dbname="./Data/SDY61/SDY61.sqlite")
dbWriteTable(conn = db, name = "hai", value = "./Data/SDY61/hai_result.txt", row.names = FALSE, header = TRUE, sep="\t")

Error: Table hai exists in database, and both overwrite and append are FALSE

dbWriteTable(conn = db, name = "cohort", value = "./Data/SDY61/arm_or_cohort.txt", row.names = FALSE, header = TRUE, sep="\t")

Error: Table cohort exists in database, and both overwrite and append are FALSE

These errors can be fixed by using "overwrite=TRUE" in dbWriteTable().

db <- dbConnect(SQLite(), dbname="./Data/SDY61/SDY61.sqlite")
dbWriteTable(conn = db, name = "hai", value = "./Data/SDY61/hai_result.txt", row.names = FALSE, header = TRUE, sep="\t", overwrite=TRUE)
dbWriteTable(conn = db, name = "cohort", value = "./Data/SDY61/arm_or_cohort.txt", row.names = FALSE, header = TRUE, sep="\t", overwrite=TRUE)

[raphg]

I will fix this as I get to it.

[aengstrom28]

Please remove me from the mailing list. I no longer want to receive these e-mails (this is last years listserv).

On Dec 26, 2014, at 11:18 PM, Raphael Gottardo notifications@github.com wrote:

I will fix this as I get to it.

—
Reply to this email directly or view it on GitHub.

[brianhigh]

@aengstrom28 -- you probably get email messages from Raphael's GitHub "issues" if you had subscribed to get alerts from his repo. This is not actually a mailing list or listserv, but the "issues" feature of GitHub. You can "Unwatch" to no longer receive these. See: https://github.com/raphg/Biostat-578/subscription