Ok Lukas . :(
thank you.
On Monday, February 17, 2014 2:34:01 PM UTC+5:30, Lukas Eder wrote:
>
> Hi Shyam,
>
> Thanks for your nice words. Currently, SQL 2 jOOQ only converts single
> SELECT statements and well-known built-in functions. Its current intent is
> to be used for manual conversion of SQL statements, e.g. when you enter and
> test your statement in MySQL workbench, and then want to transform it to
> its jOOQ equivalent.
>
> Your use-case from what I understand would mean to transform a sequence of
> arbitrary statements ("stored procedure") into a sequence of jOOQ
> statements. This is currently not possible.
>
> Cheers
> Lukas
>
>
> 2014-02-17 7:45 GMT+01:00 Sha <[email protected] <javascript:>>:
>
>> Let me first congratulate you on our jOOQ-3.3. release Lukas.
>> Hearty Congratulation.
>>
>> Does this new utility sql2jooq converts Stroed procedures too ?
>>
>> ~Shyam
>>
>>
>> On Monday, February 10, 2014 7:28:32 PM UTC+5:30, Sha wrote:
>>>
>>> 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]>:
>>>>
>>>>> 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].
>>>>> 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.
