Commits

tbrugz  committed 75d93bd

doc: readme changes

  • Participants
  • Parent commits 9cccf89

Comments (0)

Files changed (3)

 	See [sqlrun.template.properties](https://bitbucket.org/tbrugz/sqldump/src/tip/sqlrun.template.properties) for more info 
 - **SQLDiff**: generates a diff from 2 schema models.
 	See [sqldiff.template.properties](https://bitbucket.org/tbrugz/sqldump/src/tip/sqldiff.template.properties) for more info 
+- **Diff2Queries**: generates data diff from 2 SQL queries.
+	See [diff2q.template.properties](https://bitbucket.org/tbrugz/sqldump/src/tip/diff2q.template.properties) for more info 
 
 Author: Telmo Brugnara <[tbrugz@gmail.com](mailto:tbrugz@gmail.com)>
 
 
 Not building? Setup env (without sources)
 -----------------------------------------
-- Download `sqldump.jar` jar from [sqldump/downloads](https://bitbucket.org/tbrugz/sqldump/downloads) (may be outdated).
-  Better than that, download from [sqldump maven repo](https://bitbucket.org/tbrugz/mvn-repo/src/tip/org/bitbucket/tbrugz/sqldump)
-  (e.g.: [sqldump 0.9.2](https://bitbucket.org/tbrugz/mvn-repo/src/tip/org/bitbucket/tbrugz/sqldump/0.9.2/sqldump-0.9.2.jar))
+- Download `sqldump.jar` jar from [sqldump maven repo](https://bitbucket.org/tbrugz/mvn-repo/src/tip/org/bitbucket/tbrugz/sqldump)
+  (e.g.: [sqldump 0.9.9](https://bitbucket.org/tbrugz/mvn-repo/src/tip/org/bitbucket/tbrugz/sqldump/0.9.9/sqldump-0.9.9.jar))
 - Download jar dependencies, especially *apache-commons-logging*, to `lib` (may be downloaded from [sqldump/downloads](https://bitbucket.org/tbrugz/sqldump/downloads))
 - (windows) Download [sqldump.bat.template](https://bitbucket.org/tbrugz/sqldump/raw/tip/sqldump.bat.template) as `sqldump.bat`
   or (unix-like) download [sqldump.sh.template](https://bitbucket.org/tbrugz/sqldump/raw/tip/sqldump.sh.template) as `sqldump.sh`

File diff2q.template.properties

+
+###############################################################################
+# diff2queries config file                                                    #
+# https://bitbucket.org/tbrugz/sqldump                                        #
+###############################################################################
+
+# global conn prop prefix (with default value - 'diff2q')
+#diff2q.connpropprefix=diff2q
+
+# to define different connections for target/source queries
+diff2q.target.connpropprefix=diff2q.dev
+diff2q.source.connpropprefix=diff2q.prod
+
+#-----------------
+
+diff2q.targetsql=select * from table_x where id < 300
+diff2q.sourcesql=select * from table_x
+diff2q.keycols=ID
+
+# table name used in diff dump (default is '_table_') 
+diff2q.tablename=table_x
+
+# output pattern: [tablename] & [changetype] patterns may be used ; default is <stdout> 
+#diff2q.outpattern=data_[tablename]_[changetype].sql
+
+# loop limit
+diff2q.looplimit=5000
+
+#-----------------
+
+# common
+diff2q.driverclass=org.h2.Driver
+diff2q.dburl=jdbc:h2:~/common
+
+# dev
+diff2q.dev.driverclass=org.h2.Driver
+diff2q.dev.dburl=jdbc:h2:~/dev
+
+# prod
+diff2q.prod.driverclass=org.h2.Driver
+diff2q.prod.dburl=jdbc:h2:~/prod

File diff2queries.template.properties

-
-###############################################################################
-# diff2queries config file                                                    #
-# https://bitbucket.org/tbrugz/sqldump                                        #
-###############################################################################
-
-# global conn prop prefix (with default value - 'diff2q')
-#diff2q.connpropprefix=diff2q
-
-# to define different connections for target/source queries
-diff2q.target.connpropprefix=diff2q.dev
-diff2q.source.connpropprefix=diff2q.prod
-
-#-----------------
-
-diff2q.targetsql=select * from table_x where id < 300
-diff2q.sourcesql=select * from table_x
-diff2q.keycols=ID
-
-# table name used in diff dump (default is '_table_') 
-diff2q.tablename=table_x
-
-# output pattern: [tablename] & [changetype] patterns may be used ; default is <stdout> 
-#diff2q.outpattern=data_[tablename]_[changetype].sql
-
-# loop limit
-diff2q.looplimit=5000
-
-#-----------------
-
-# common
-diff2q.driverclass=org.h2.Driver
-diff2q.dburl=jdbc:h2:~/common
-
-# dev
-diff2q.dev.driverclass=org.h2.Driver
-diff2q.dev.dburl=jdbc:h2:~/dev
-
-# prod
-diff2q.prod.driverclass=org.h2.Driver
-diff2q.prod.dburl=jdbc:h2:~/prod