Hi Shyam, I'm not quite sure how you intend to make this work. Specifically:
I have a stored procedure in a (.sql) file. If this stored procedure is written in T-SQL, how can it access the data from the "flat file" ? Can you provide concrete examples? Lukas 2014-02-07 8:04 GMT+01:00 Sha <[email protected]>: > Hi Lukas, > My question might sound crazy but do we have any approach/suggestion on > this. > > Here is the crazy test scenario : > I have a stored procedure in a (.sql) file. > Have a data set in a file i.e. flat file. > Using the above data ,the stored procedures in the flat files to be > executed (in a unit testing way ) and results should be directed to another > flat file. > > Whole idea is to unit test the stored procedures from files ,in a java > way, against the a data set (i.e. mock DB) . > The objective is test those stroed procedures in a line by line fashion > against the mockDB. > > Do you have any way out or suggestion or idea ,how to go about it ? > > Sorry me asking very crazy question. > > Thank you. > ~Shyam > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
