thorsager/docker-quick-mysql

Quick and Dirty MySql for development and testing

docker-quick-mysql's Issues

Helper script

Perhaps adding https://gist.github.com/micsor-norlys/aa05ec220b2c3cc1949aeec6a80c951f or something like it, would make some sense.

To help starting/stopping.. a mysql-server, in some default config.

Drop tables

The ability to drop tables in some databases, as part of the truncate-all process

Truncate tables

Adding some simple, easy and quick way of truncating all tables in all databases, perhaps with the possibility to exclude specific table-names, would be nice.

This could be used ex. when resetting a lab or test environment.

The SQL to support such a function could look something like this

SET @DATABASES='devel';
SET @IGNORES='flyway_schema_history';
SET FOREIGN_KEY_CHECKS=0;
SELECT CONCAT('TRUNCATE TABLE `',`table_schema`,'.',`table_name`,'`;') from information_schema.TABLES WHERE TABLE_SCHEMA IN (@DATABASES) AND `TABLE_NAME` NOT IN (@IGNORES);
SELECT @TQ:=CONCAT('TRUNCATE TABLE `',`table_schema`,'.',`table_name`,'`;') from information_schema.TABLES WHERE TABLE_SCHEMA IN (@DATABASES) AND `TABLE_NAME` NOT IN (@IGNORES);
PREPARE TS FROM @TQ;
EXECUTE TS;
DEALLOCATE PREPARE TS;
SET FOREIGN_KEY_CHECKS=1