[jira] [Created] (TC-258) setup_kabletown.pl needs to be updated

["Dan Kirkwood (JIRA)" <ji...@apache.org>]

Dan Kirkwood created TC-258:
-------------------------------

             Summary: setup_kabletown.pl needs to be updated
                 Key: TC-258
                 URL: https://issues.apache.org/jira/browse/TC-258
             Project: Traffic Control
          Issue Type: Bug
          Components: Traffic Ops
    Affects Versions: 2.0.0
            Reporter: Dan Kirkwood


app/bin/db/setup_kabletown.pl loads data from app/lib/Fixtures (via lib/Test/IntegrationHelper.pm), but appears to be out of date.   Several issues:

- sub teardown {} tries to delete all rows from a table,  but doesn't succeed many times with postgresql -- possibly because of foreign key constraints. Suggest using a TRUNCATE table CASCADE sql command rather than $resultset->delete_all

- sub unload_core_data {} runs teardown on a bunch of tables, but doesn't list all of them.   May be leftover data.

- new unique constraints are violated by parameter and profile_parameter data in the Fixtures.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)