Write row count to log?

Question

I would like to count the rows in a (Oracle) database table and then write that row count to the Translation log.

This is so that I can quickly compare the row counts of two tables against each other (as a quick way to determine if an update has occurred)

I can use SQLCreator to count the rows of the table

Select count(*) as COUNT from TABLE

This places the count as a value in a column that is output from the Result of the SQLCreator

My question is, how can I write this value to the Translation Log?

I assume I use the Shutdown Python script. But how does the script read that attribute value?

Page 1 / 1

Expose the attribute COUNT in the SQLCreator.

Next add a Logger, and edit the Log Message to show the value of COUNT.

geomancer · Answer

Expose the attribute COUNT in the SQLCreator.Next add a Logger, and edit the Log Message to show the value of COUNT.

Sign up