*Thank you so much Lukas.*
On Tuesday, January 28, 2014 7:28:00 PM UTC+5:30, Lukas Eder wrote:
>
> Hi Shyam,
>
> 2014-01-28 Sha <[email protected] <javascript:>>
>
>> sorry for confusion Lukas,
>> Whole purpose of my POC is , convert all stored procedures ( which are
>> generated by a tool as flat files on the disk) to equalent java classes.
>> So that it would be easy to unit test and find out any discripencies
>> while compile time. i.e. respective objects are there or not , any syntax
>> errors there etc.
>>
>
> OK, I understand. That is indeed a very interesting use-case for jOOQ,
> which I believe not many people have thought of, so far. Unfortunately,
> sql2jooq is not production-ready yet to help you automatically convert SQL
> statements to jOOQ statements. We're currently working on that:
> https://github.com/sqlparser/sql2jooq
>
*Oh great to know , if you have any test version I will check and let you
know if there are any improvements are need.*
> Lukas,
>> Me trying to achieve the temporary table impact using ResultSet records
>> as you suggested earlier.
>> But I have a small problem in one area.
>>
>> Below are the details
>>
>> The original proc is some thing like this
>> --------------------------------------------------------
>> CREATE TABLE #LEAF_TEMP
>> (
>> LEAF1_ID numeric(15, 0) NULL,
>> LEAF2_ID numeric(15, 0) NULL,
>> LEAF3_ID numeric(15, 0) NULL,
>> BOOK_ID numeric(7, 0) NOT NULL,
>> already_exists numeric(1,0) default 0 not null
>> )
>>
>>
>> insert into #LEAF_TEMP
>> (
>> LEAF1_ID,
>> LEAF2_ID,
>> LEAF3_ID,
>> BOOK_ID)
>> select
>> ld.leaf1_id,
>> ld.leaf2_id,,
>> ld.leaf3_id,
>> ld.book_id
>> from leaf_detail ld
>> where ld.is_first = 1
>> --------------------------
>> Now trying to write the equalent JOOQ code
>> something like the below
>> LeafDetail ld = LEAF_DETAIL.as("ld");
>> Result<Record4<Integer, Integer, Integer, Short>> RS_LEAF_TEMP =
>> ctx.select(ld.LEAF1_ID,ld.LEAF2_ID,ld.LEAF3_ID,ld.BOOK_ID)
>>
>> .from(ld).where(ld.is_first.equal((byte) 1)).fetch();
>>
>> ---
>> But the problem is how to incorporate the missing field (already_exists
>> numeric(1,0) default 0 not null ) in the Result<R>
>> i,e. adding one more field to Record4 of Result.
>>
>
> I'm not sure if I understand this question. You should just add another
> column to the SELECT clause and change the Record4 type to a Record5 type.
> Or, alternatively, you do not use row type safety, and just assign the
> whole statement to Result<?> - which is the same as Result<? extends Record>
>
> Does this answer your question?
>
*Some extent , let me try and let you know the result.*
*thank you. *
--
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.
