Ben Baumer

Results 90 comments of 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...