2019-10-01 -> 2021-03-15
A service providing some database related utilities.
This is a Light framework plugin.
This is part of the universe framework.
Using the planet installer via light-cli
lt install Ling.Light_DatabaseUtils
Using the uni command.
uni import Ling/Light_DatabaseUtils
Or just download it and place it where you want otherwise.
- Light_DatabaseUtils api (generated with DocTools)
- Services
- duplicate row conception
- Usage examples
This plugin provides the following services:
- database_utils (returns a LightDatabaseUtilsService instance)
Here is an example of the service configuration:
database_utils:
instance: Ling\Light_DatabaseUtils\Service\LightDatabaseUtilsService
methods:
setContainer:
container: @container()
/**
* @var $dumpUtil LightDatabaseUtilsService
*/
$dumpUtil = $container->get("database_utils");
//$dumpUtil->getDumpUtil()->dumpTable("lud_user", "/tmp");
$dumpUtil->getDumpUtil()->dumpTable("lud_user", "/tmp", [
"useNullForAutoIncrementedKey" => true,
]);
This will create a file which content looks like this:
INSERT INTO `lud_user` (`id`, `identifier`, `pseudo`, `password`, `avatar_url`, `extra`) VALUES
(NULL, 'root', 'root', '$2y$10$wHddULZplQE.529IF6Cg0erKZ3zee33cealjlVR.PfLFSVQGQC5yG', '/plugins/Light_Kit_Admin/img/avatars/root_avatar.png', 'a:0:{}'),
(NULL, 'lka_dude', 'Dude', '$2y$10$zvWUzKqHKr1zUxORRPm5NusyW5BaMq/T5w8dEq0xjcYpCxZLlzkbW', '/plugins/Light_Kit_Admin/img/avatars/user_avatar.png', 'a:0:{}'),
(NULL, 'lka_admin', 'Boss', '$2y$10$DTYX6/Yf26hc8n6sSYpMuu.Mml07HSiURTUROdPwfVVY850pIxR/i', '/plugins/Light_Kit_Admin/img/avatars/lka_admin.png', 'a:0:{}')
;
-
1.1.11 -- 2021-05-31
- Removing trailing plus in lpi-deps file (to work with Light_PlanetInstaller:2.0.0 api
-
1.1.10 -- 2021-03-15
- update planet to adapt Ling.Light:0.70.0
-
1.1.9 -- 2021-03-05
- update README.md, add install alternative
-
1.1.8 -- 2021-02-19
- upgrade dependencies
-
1.1.7 -- 2020-12-08
- Fix lpi-deps not using natsort.
-
1.1.6 -- 2020-12-04
- Add lpi-deps.byml file
-
1.1.5 -- 2020-11-24
- update Light_DatabaseDumpUtility->dumpTable, add ignore and disableFkCheck options
-
1.1.4 -- 2020-11-17
- update RowDuplicator->onInsertAfter method, add reference to the old row and main table
-
1.1.3 -- 2020-11-17
- fix doc link
-
1.1.2 -- 2020-11-17
- add RowDuplicator class
-
1.1.1 -- 2020-09-03
- fix Light_DatabaseDumpUtility->dumpTable not keeping NULL values in some cases
-
1.1.0 -- 2019-10-01
- add Light_DatabaseDumpUtility->dumpTable returnAsString option
-
1.0.0 -- 2019-10-01
- initial commit