andybega/icews

Test errors due to dplyr 1.0.0

andybega opened this issue · 1 comments

andybega commented 
Testing icews
✓ |  OK F W S | Context
✓ |   1   1   | create-db [0.1 s]
───────────────────────────────────────────────────────────────────────────────────────────
test-create-db.R:8: warning: create_db works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.
───────────────────────────────────────────────────────────────────────────────────────────
✓ |  16   6   | database [1.1 s]
───────────────────────────────────────────────────────────────────────────────────────────
database.R:56: warning: check_db works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.

test-database.R:29: warning: ingest_from_file works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.

test-database.R:42: warning: delete_events works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.

test-database.R:51: warning: purge_db works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.

test-database.R:65: warning: remove_db works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.

test-database.R:71: warning: optimize_db works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.
───────────────────────────────────────────────────────────────────────────────────────────
✓ |   3       | Download/file functions [0.3 s]
✓ |  11       | dr_icews
✓ |   4   2   | get_db_state [0.2 s]
───────────────────────────────────────────────────────────────────────────────────────────
test-get-db-state.R:4: warning: list_source_files works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.

test-get-db-state.R:10: warning: get_db_state works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.
───────────────────────────────────────────────────────────────────────────────────────────
✓ |  10       | is data file, is weeky file
✓ |   1       | normalize-label
✓ |   7   2   | Planners [0.4 s]
───────────────────────────────────────────────────────────────────────────────────────────
test-plan.R:21: warning: local syn works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.

test-plan.R:54: warning: plan_database_changes works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.
───────────────────────────────────────────────────────────────────────────────────────────
✓ |   5       | read_events_tsv
x |  12 1 5   | read-icews [0.4 s]
───────────────────────────────────────────────────────────────────────────────────────────
test-read-icews.R:17: warning: n_max in read_icews and variants works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.

test-read-icews.R:31: warning: read_icews respects paths
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.

test-read-icews.R:32: warning: read_icews respects paths
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.

test-read-icews.R:33: warning: read_icews respects paths
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.

test-read-icews.R:67: warning: read from local or db returns same column info and types
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.

test-read-icews.R:78: failure: read from local or db returns same column info and types
`o_db` not equal to `o_raw`.
Attributes: < Component "class": Lengths (3, 4) differ (string compare on first 3) >
Attributes: < Component "class": 3 string mismatches >
───────────────────────────────────────────────────────────────────────────────────────────
✓ |   5       | State getter functions
✓ |   3   1   | Update ICEWS [0.5 s]
───────────────────────────────────────────────────────────────────────────────────────────
update.R:86: warning: update_icews works
`src_sqlite()` is deprecated as of dplyr 1.0.0.
Please use `tbl()` directly with a database connection
This warning is displayed once every 8 hours.
Call `lifecycle::last_warnings()` to see where this warning was generated.
───────────────────────────────────────────────────────────────────────────────────────────
✓ |  13       | Misc tests
✓ |   2       | data helpers

══ Results ════════════════════════════════════════════════════════════════════════════════
Duration: 3.4 s

OK:       93
Failed:   1
Warnings: 17
Skipped:  0
andybega commented

Two problems:

  • src_sqlite() has been deprecated. This was only used in create_db() to setup the database file.
  • read_icews() returns class spec_tbl_df, tbl_df, ..., which caused an error in a test comparing this to what's returned by read_icews(db, ...) (just a tbl_df).