2020-06-19 -> 2021-06-28

A semi-automated tool to synchronize your database with a "create" file.

This is a Light plugin.

This is part of the universe framework.

Using the planet installer via light-cli

lt install Ling.Light_DbSynchronizer

Using the uni command.

uni import Ling/Light_DbSynchronizer

Or just download it and place it where you want otherwise.

• Light_DbSynchronizer api (generated with DocTools)
• Services
• Pages
  • Conception notes

Here is an example of the service configuration:

db_synchronizer:
    instance: Ling\Light_DbSynchronizer\Service\LightDbSynchronizerService
    methods:
        setContainer:
            container: @container()
        setOptions:
            options:
                useDebug: true          # default is true
                stopAtFirstError: false # default is false

• 1.2.22 -- 2021-06-28

  • fix service not able to create new columns with non-nullable date/datetime

• 1.2.21 -- 2021-06-28

  • fix api wrong reference to Ling.Light_Logger

• 1.2.20 -- 2021-06-25

  • update api, now use Ling.Light_Logger open registration system

• 1.2.19 -- 2021-05-31

  • Removing trailing plus in lpi-deps file (to work with Light_PlanetInstaller:2.0.0 api

• 1.2.18 -- 2021-05-03

  • Update dependencies to Ling.Light_Logger (pushed by SubscribersUtil)

• 1.2.17 -- 2021-05-03

  • Update dependencies to Ling.Light_Logger (pushed by SubscribersUtil)

• 1.2.16 -- 2021-04-06

  • update LightDbSynchronizerService->executeStatement, now returns more useful debug messages

• 1.2.15 -- 2021-03-15

  • update planet to adapt Ling.Light:0.70.0

• 1.2.14 -- 2021-03-05

  • update README.md, add install alternative

• 1.2.13 -- 2021-02-25

  • fix assets/map dir removed

• 1.2.12 -- 2021-02-23

  • Update dependencies (pushed by SubscribersUtil)

• 1.2.11 -- 2021-02-23

  • Update dependencies (pushed by SubscribersUtil)

• 1.2.10 -- 2021-02-23

  • Update dependencies

• 1.2.9 -- 2021-02-19

  • upgrade dependencies

• 1.2.8 -- 2021-02-11

  • fix non synchronized dependencies between uni style and lpi style

• 1.2.7 -- 2021-02-11

  • fix service not declaring dependency to Light_DatabaseInfo planet

• 1.2.6 -- 2021-01-25

  • update LightDbSynchronizerHelper::synchronizePlanetCreateFile, add scope option

• 1.2.5 -- 2021-01-25

  • update LightDbSynchronizerService, fix primary key remove/create problems, add column order detection feature

• 1.2.4 -- 2021-01-25

  • update conception notes, add clarifications

• 1.2.3 -- 2021-01-22

  • add LightDbSynchronizerHelper class
  • fix LightDbSynchronizerService not handling rename column statements correctly, fix tinyint display width triggering a stale sync

• 1.2.2 -- 2020-12-08

  • Fix lpi-deps not using natsort.

• 1.2.1 -- 2020-12-04

  • Add lpi-deps.byml file

• 1.2.0 -- 2020-08-11

  • update LightDbSynchronizerService->logDebug, now can return logDebug messages on demand even with logDebug turned off

• 1.1.1 -- 2020-06-22

  • add create file section in conception notes

• 1.1.0 -- 2020-06-22

  • add LightDbSynchronizerService->getLogErrorMessages and getLogDebugMessages methods

• 1.0.0 -- 2020-06-19

  • initial commit