Trying to find changes since the release in specific files (.sql and .properties files):

git diff --name-only release/x.x.x.x develop | grep -P "\.(sql|properties)"

Which lists all the files (just the name, not the content) which changed between the two versions provided, then filters it if it either contains .sql or .properties.

Trying to find new rows added to a specific database table:

git diff release/x.x.x.x develop | grep -A 1 -iP "insert into TABLE_NAME"

Which list all the changes between the two versions provided, then filters for the beginning of the SQL insert statement (case insensitively, even though we usually follow our defined code style).

Leave a Reply

Your email address will not be published. Required fields are marked *