How to get compiled scripts output

General Discussion
1

I need to get compiled scripts output like below

Table Created
1 row Updated
Commit Completed

Can you please suggest how to get.

2

I’m not sure I understand your question, but I’m assuming it related to seeing the results of your SQL executions. Try setting the following when you run Liquibase:

log-level=INFO
sql-log-level=INFO
3

Not working, below log FYR,

[2023-08-31 14:51:01] INFO [liquibase.ui] Running Changeset: Database/TABLES/MASTER_TABLES/sample_table.sql::4::SAMPLE
[2023-08-31 14:51:01] INFO [liquibase.changelog] Custom SQL executed
[2023-08-31 14:51:01] INFO [liquibase.changelog] ChangeSet Database/TABLES/MASTER_TABLES/sample_table.sql::4::SAMPLE ran successfully in 219ms
[2023-08-31 14:51:01] INFO [liquibase.util] UPDATE SUMMARY
[2023-08-31 14:51:01] INFO [liquibase.util] Run: 1
[2023-08-31 14:51:01] INFO [liquibase.util] Previously run: 3
[2023-08-31 14:51:01] INFO [liquibase.util] Filtered out: 0
[2023-08-31 14:51:01] INFO [liquibase.util] -------------------------------
[2023-08-31 14:51:01] INFO [liquibase.util] Total change sets: 4

UPDATE SUMMARY
Run: 1
Previously run: 3
Filtered out: 0

Total change sets: 4

[2023-08-31 14:51:01] INFO [liquibase.util] Update summary generated
[2023-08-31 14:51:01] INFO [liquibase.command] Update command completed successfully.
Liquibase: Update has been successful.
[2023-08-31 14:51:01] INFO [liquibase.ui] Liquibase: Update has been successful.
[2023-08-31 14:51:01] INFO [liquibase.lockservice] Successfully released change log lock
[2023-08-31 14:51:01] INFO [liquibase.lockservice] Successfully released change log lock
[2023-08-31 14:51:01] INFO [liquibase.command] Command execution complete
Liquibase command ‘update’ was executed successfully.
[2023-08-31 14:51:01] INFO [liquibase.ui] Liquibase command ‘update’ was executed successfully.

4

Can you provide the full CLI command that you executed? I see all of the sql statements when sql-log-level=INFO.

5

liquibase update --changelog-file=changelog.xml --url=jdbc:oracle:thin:@10.1.1.134:1525:QADB --username=$SQA_DB_CRED_USR --password=$SQA_DB_CRED_PSW --log-level=INFO --sql-log-level=INFO

–changeset SAMPLE:3
–comment: Forward Alter Script
ALTER TABLE EMP_LIST ADD (REMARKS varchar2(20));
COMMIT;
–rollback ALTER TABLE EMP_LIST DROP COLUMN REMARKS;

–changeset SAMPLE:4
–comment: Forward Insert Script
Insert into EMP_LIST
(NUM_EMP_ID, VCH_NAME, VCH_ADDRESS, VCH_DESC, NUM_DOB,
NUM_DOJ,REMARKS)
Values
(1, ‘ASAITHAMBI’, ‘KGISL’, ‘RM’, NULL,
NULL,NULL);
COMMIT;
–rollback DELETE FROM EMP_LIST WHERE NUM_EMP_ID = 1;

–changeset SAMPLE:5
–comment: Forward Update Script
UPDATE EMP_LIST SET VCH_DESC = ‘LEAD’ WHERE NUM_EMP_ID = ‘1’;
COMMIT;
–rollback UPDATE EMP_LIST SET VCH_DESC = ‘RM’ WHERE VCH_NAME = ‘ASAITHAMBI’;