Test backends as part of Travis-CI tests #52
Comments
|
@hannesmuehleisen: How do I test stable/bleeding-edge versions of MonetDB.R and MonetDBLite in Travis? @marcelboldt: I see in https://github.com/EXASOL/r-exasol that you are already testing on Travis. Are you aware of the recent RODBCDBI package by @teramonagi? |
|
@krlmlr Travis? |
|
@hannesmuehleisen: Basically, I'm looking for an unanttended install of the database engine on an Ubuntu 12.04 (14.04) box with root access, and for a script to download sources for the bleeding-edge version of MonetDB.R and MonetDBLite. |
|
Ok, bleeding install for MonetDB.R/MonetDBLite: For MonetDB on Ubuntu, we have packages, see https://www.monetdb.org/downloads/deb/ |
|
It feels like testing should be job of the individual backends. I think the way we encourage the use of the tests is through a DBI-backend scorecard website or similar. |
|
Ok - this is for testing DBItest, not for testing the backends. |
- Test `RPostgres`, `RMySQL`, `RSQLite` and `RKazam` as part of the Travis-CI tests (#52). - Stress test now installs package in temporary library before loading DBI (r-dbi/RSQLite#128). - `make_context()` now works again if `tweaks` arg is omitted (regression introduced in 1.0-3). - Expect a warning instead of an error for double disconnect (#50). - Move connection test that requires `dbFetch()` to `test_result()`.
- New feature: tweaks
- New argument `tweaks` to `make_context()` (#49).
- New `tweaks()`, essentially constructs a named list of tweaks but with predefined and documented argument names.
- `constructor_name`, respected by the `constructor.*` tests.
- `strict_identifier`, if `TRUE` all identifier must be syntactic names even if quoted. The quoting test is now split, and a part is ignored conditional to this tweak. The `roundtrip_quotes` tests also respects this tweak.
- `omit_blob_tests` for DBMS that don't have a BLOB data type.
- `current_needs_parens` -- some SQL dialects (e.g., BigQuery) require parentheses for the functions `current_date`, `current_time` and `current_timestamp`.
- `union`, for specifying a nonstandard way of combining queries. All union queries now name each column in each subquery (required for `bigrquery`).
- New tests
- `dbGetInfo(Result)` (r-dbi/DBI#55).
- `dbListFields()` (#26).
- New "package_name" test in `test_getting_started()`.
- Improved tests
- Stress test now installs package in temporary library (before loading `DBI`) using `R CMD INSTALL` before loading DBI (r-dbi/RSQLite#128, #48).
- Row count is now tested for equality but not identity, so that backends can return a numeric value > 2^31 at their discretion.
- Call `dbRemoveTable()` instead of issuing `DROP` requests, the latter might be unsupported.
- Use subqueries in queries that use `WHERE`.
- Test that `dbClearResult()` on a closed result set raises a warning.
- Expect a warning instead of an error for double disconnect (#50).
- Move connection test that requires `dbFetch()` to `test_result()`.
- Split "can_connect_and_disconnect" test.
- Expect `DBI` to be in `Imports`, not in `Depends`.
- Removed tests
- Remove test for `dbGetException()` (r-dbi/DBI#51).
- Bug fixes
- Fix broken tests for quoting.
- Self-testing
- Test `RPostgres`, `RMySQL`, `RSQLite` and `RKazam` as part of the Travis-CI tests (#52).
- Travis CI now installs rstats-db/DBI, updated namespace imports (`dbiCheckCompliance()`, `dbListResults()`).
- Use fork of `testthat`.
- Utilities
- Return test results as named array of logical. Requires r-lib/testthat#360, gracefully degrades with the CRAN version.
- Internal
- Refactored the `get_info_()` tests to use a vector of names.
- Use versioned dependency for DBI
- Use unqualified calls to `dbBind()` again
- Same as 1.0-8.
in parallel, triggered by environment variable
The text was updated successfully, but these errors were encountered: