pecan icon indicating copy to clipboard operation
pecan copied to clipboard

Re-enable tests for Settings package

Open mdietze opened this issue 11 years ago • 3 comments

I just disabled the tests for the settings package by commenting out testthat.R. This was done because new database constraints were causing the test to fail:

tests for read.settings and related functions : Loading required package: RPostgreSQL Error in postgresqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not Retrieve the result : ERROR: insert or update on table "workflows" violates foreign key constraint "fk_workflows_models_1" DETAIL: Key (model_id)=(-1) is not present in table "models". ) Error in logger.severe(paste("Error executing db query '", query, "' errorcode=", : Error executing db query 'INSERT INTO workflows (site_id, model_id, hostname, start_date, end_date, started_at, created_at) values ('288','-1', 'localhost', '2000-01-01 06:00:00', '2009-12-31 05:59:00', '2015-01-20 22:51:05', '2015-01-20 22:51:05')' errorcode=0 message='ERROR: insert or update on table "workflows" violates foreign key constraint "fk_workflows_models_1" DETAIL: Key (model_id)=(-1) is not present in table "models". ' Calls: test_check ... read.settings -> check.settings -> db.query -> logger.severe In addition: Warning message: In postgresqlQuickSQL(conn, statement, ...) : Could not create executeINSERT INTO workflows (site_id, model_id, hostname, start_date, end_date, started_at, created_at) values ('288','-1', 'localhost', '2000-01-01 06:00:00', '2009-12-31 05:59:00', '2015-01-20 22:51:05', '2015-01-20 22:51:05') Execution halted

mdietze avatar Jan 21 '15 10:01 mdietze

Blocked by https://github.com/PecanProject/bety/issues/180

robkooper avatar Jan 21 '15 16:01 robkooper

This issue is stale because it has been open 365 days with no activity.

github-actions[bot] avatar Apr 21 '21 00:04 github-actions[bot]

tests are still skipped in test.read.settings.R

Aariq avatar Jul 21 '22 15:07 Aariq