Cool Lukas, Looking forward to that in jOOQ-3.3. Lets know if there is anything we can do for it.
~Shyam On Monday, February 10, 2014 5:07:38 PM UTC+5:30, Lukas Eder wrote: > > Hi Shyam, > > Sounds crazy but any way you think of . or any clue !!! > > > It's not so crazy at all, it's a very valid use-case for people migrating > to jOOQ. > > But we're not quite there yet, although we're currently working on > precisely that kind of solution with the folks from > http://www.sqlparser.com. With the upcoming jOOQ 3.3, we'll ship their > prototype SQL-to-jOOQ transformer that will work with MySQL and PostgreSQL. > But this is far from production-ready: > https://github.com/sqlparser/sql2jooq > > Once jOOQ 3.3 is ready, there will be a couple of examples in the manual > as well. > > Cheers > Lukas > > 2014-02-10 8:02 GMT+01:00 Sha <[email protected] <javascript:>>: > >> Sorry for dealy Lukas, >> Assure stored procedures are written in a T-SQL support db , and >> copied them to a file .sql file. >> Can we read .sql files and convert into equivalent jOOQ script ? >> >> Sounds crazy but any way you think of . or any clue !!! >> >> ~Shyam >> >> On Friday, February 7, 2014 2:12:48 PM UTC+5:30, Lukas Eder wrote: >> >>> 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] <javascript:>. >> 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.
