James Pluck b04a1ab41c Fix Truncate Error Issue when using views in a Unittest. ...

When using a view in a SilverStripe project, whenever the tear down scripts for the Unittests are run the following error occurs:

Couldn't run query:
TRUNCATE "ActivityPoints_view"
Table 'ss_tmpdb2391727.ActivityPoints_view' doesn't exist

This was due to the MySQLSchemaManager::tableList() function assuming that all records in the TABLES were actual tables containing data.

This small tweak fixes the issue by modifying the SQL to filter out views from the list before truncating.

2017-08-14 15:22:19 +12:00

..

Database.php

showqueries debugging tool now inserts parameters in place (#5885)

2016-09-15 09:15:19 +12:00

DatabaseException.php

Remove all redundant whitespace

2014-08-19 09:17:15 +12:00

DBConnector.php

MINORE: Remove training whitespace.

2016-01-07 10:15:54 +13:00

DBQueryBuilder.php

API Allow parameterised joins / subselects

2014-09-16 17:54:30 +12:00

DBSchemaManager.php

BUG Fix FulltextsearchEnable

2016-03-07 14:47:20 +13:00

MySQLDatabase.php

API Include File.ParentID in fulltext search results

2016-03-07 13:15:40 +13:00

MySQLiConnector.php

Checking for resource before closing MySQL connection

2016-07-07 10:01:33 +12:00

MySQLQuery.php

API Use mysql buffered statements

2015-05-08 13:23:53 +12:00

MySQLQueryBuilder.php

NEW: Allow 'null' limit for database queries (closes #3487)

2015-05-04 22:50:33 +01:00

MySQLSchemaManager.php

Fix Truncate Error Issue when using views in a Unittest.

2017-08-14 15:22:19 +12:00

MySQLStatement.php

Add missing packages

2015-08-24 16:15:38 +12:00

PDOConnector.php

Error should be checked on the db connection, not on the result

2017-03-01 10:41:06 +11:00

PDOQuery.php

BUG Fix PDOConnector issues

2014-08-01 18:17:51 +12:00

Query.php

BUG Fix major segfault on PDOConnector after any DDL

2015-06-17 13:34:21 +12:00