Skip to content

Latest commit

 

History

History
78 lines (62 loc) · 2.29 KB

README.md

File metadata and controls

78 lines (62 loc) · 2.29 KB

How to use App to fix Column Issues

Requirements:

  • Java 21
  • Docker and Docker Compose

How to get a dump from your Liferay's version

  1. Download your bundle version from https://customer.liferay.com/en_US/downloads

    The bundle version must be the same as your project

  2. Create a MySQL|PostgreSQL Docker image spin up the docker service:

    MySQL:

    docker compose up mysql -d

    PostgreSQL:

    docker compose up postgres -d

  3. Go to the bundle you just downloaded, and in the root folder, create a file portal-ext.propeties and put the following properties:

    MySQL:

    jdbc.default.driverClassName=com.mysql.cj.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost:3307/liferay?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=liferay
jdbc.default.password=liferay

    PostgreSQL:

    jdbc.default.driverClassName=com.mysql.cj.jdbc.Driver
jdbc.default.url=jdbc:postgresql://localhost:5432/liferay
jdbc.default.username=liferay
jdbc.default.password=liferay

  4. Now, go to the tomcat/bin folder in your downloaded bundle, and run: ./catalina.sh run

  5. After starting the portal, go to the docker container and extract a dump file:

    • Go to docker container:
    docker compose exec mysql|posgres bash
    • Run the following command to generate a dump

    MySQL:

    mysqldump -u liferay liferay > [name-file-dump.sql]

    PostgreSQL:

    pg_dump -U liferay liferay > [name-file-dump.sql]
    • Copy the dump out from the container:
    docker compose cp mysql|postgres:/[name-file-dump.slq] [destination folder]

  6. Now, put both dumps (the customer dump, and the extract dump from your bundle version) in the /src/main/resources/

  7. Rename the environment variables in Main.java to your files, following the rules below:

  • _DATABASE_TYPE: Database type supported (MySQL/Postgresql)
  • _SOURCE_FILE_NAME: Name file dump with the Liferay Scheme.
  • _TARGET_FILE_NAME: Name file dump with the Customer Scheme.
  • _NEW_FILE_NAME: New file name output.
  1. Run the project

Note

This application will fix column issues when using the Pentaho tool.