export --format sql

[simonharrer]

export --format sql

[jochenchrist]

I see, however the concept of datacontract test is to really execute tests against the data store as defined in the server.

[jankatins]

I would also love to see that the checks get exported as plain SQL queries, e.g. by returning either "nothing" if passing or true/false or even raise errors on not passing (in the worst case: select case when (<subquery which returns false on test failure>) then 1 else 'error message' || random() : int end).

[jochenchrist]

@jankatins
Great idea! I would propose a separate export format:

datacontract export --format sql-tests

[jankatins]

Logically, I would have expected it under datacontract test --export=sql or something similar, as it is part of the testing workflow.

[simonharrer]

I've implemented export to sql-ddl and sql-query. Closing this for now. Feel free to reopen if you want to continue the discussion on the sql-tests export idea.