Testing Custom SQL Seeds

The structure of a custom SQL database seed URL is the following:

  database-system://host:port/database?[per=num]&[sql=SQL]

Testing a seed URL will show all of the enqueued URLs. For example, testing the following URL for a database containing 200 records:

  sqlserver://testbed5-5.test.vivisimo.com:1433/WWII_Navy/?per=100&sql=select_*_from_vessel&

shows the following enqueued URLs:

  sqlserver://testbed5-5.test.vivisimo.com:1433/WWII_Navy/?key-val=0&
  sqlserver://testbed5-5.test.vivisimo.com:1433/WWII_Navy/?key-val=100&
  sqlserver://testbed5-5.test.vivisimo.com:1433/WWII_Navy/?key-val=200&

Testing the following URL will show the data retrieved from row 43:

  sqlserver://testbed5-5.test.vivisimo.com:1433/WWII_Navy/?per=1&key-val=43