Ben Baumer
Ben Baumer
@schoend you might also want to check `/home/schoend/dumps/airlines/raw/airports.dat` to make sure it has the right number of rows and columns. Here is what I get: ``` bbaumer@mini-meerkat:~$ wc ~/dumps/airlines/raw/airports.dat 8107...
@homerhanumat I haven't tried it in a long time, but I know that package is under active development. Can you try it out and report back?
Another underlying problem here is that `DBI::dbRemoveTable` doesn't remove VIEWs. I think the easiest fix is to just remove the VIEW from the creation script.
@joelgombin can you confirm that the latest version fixes your problem?
Right. I forgot to actually change the offending line. How about now?
Aha. So I am confirming the error. I see the same behavior. I have added this case to the `tests`. ``` > DBI::dbWriteTable(ontime_monet$con, "flights", "~/dumps/airlines/load/flights_1987_10.csv", append = TRUE) Treating character...
@ajdamico did you install the dev version of `etl`? See (https://github.com/beanumber/airlines/issues/50) If you can get that working, see line 33 of the (https://github.com/beanumber/airlines/blob/master/tests/testthat/test-airlines.R) file, or try: ``` library(airlines) db
I'm going to try changing this to use the `downloader` package.
Note that a call to `shakeWAR` with `n` resamples results in `getRAA` being called `2n+2` times. ``` owar
This is a known bug (#54). The problem is that we don't know which months of data are available on the server until we try to download them. I'm happy...