ok thanks, as i say to you before if you want all request for firebird ddl (procedure,view, trigger, table) i can send to you (i have done an automatic versionning for firebird db) if i have time, i will try to implement the procedure generation code for firebird. (i have now a better understanding of JOOQ).
Le mardi 15 juillet 2014 16:25:43 UTC+2, Lukas Eder a écrit : > > Hi there, > > Yes, thanks for tracking down the right SQL to add to FirebirdDatabase. > I will check whether it is valid and then probably integrate it. I'll get > back to you with questions, should I have any. > > I've been busy with merging 3.3.3 and 3.2.6 and some other work, but this > should be fixed very soon. > > Cheers > Lukas > > > 2014-07-14 21:09 GMT+02:00 <[email protected] <javascript:>>: > >> Hi Lukas, >> >> do you think you can integrate this request for ddl generation on >> firebird database (problem with length) ? >> >> SELECT >> TRIM( >> "r" . "RDB$FIELD_NAME" >> ) , >> "r" . "RDB$DESCRIPTION" , >> "r" . "RDB$DEFAULT_VALUE" , >> CASE >> WHEN "r" . "RDB$NULL_FLAG" IS NOT NULL >> THEN "r" . "RDB$NULL_FLAG" >> ELSE 0 >> END , >> "r" . "RDB$DEFAULT_SOURCE" , >> "r" . "RDB$FIELD_POSITION" , >> CASE >> "f" . "RDB$FIELD_TYPE" WHEN 261 >> THEN 0 >> ELSE iif("RDB$BYTES_PER_CHARACTER" is not null,"f" . >> "RDB$FIELD_LENGTH" / "CH" . "RDB$BYTES_PER_CHARACTER", "f" . >> "RDB$FIELD_LENGTH") >> END "FIELD_LENGTH" , >> "f" . "RDB$FIELD_PRECISION" , >> -( >> "f" . "RDB$FIELD_SCALE" >> ) "FIELD_SCALE" , >> CASE >> "f" . "RDB$FIELD_TYPE" WHEN 7 >> THEN CASE >> WHEN "f" . "RDB$FIELD_SUB_TYPE" = 1 >> THEN 'NUMERIC' WHEN( >> "f" . "RDB$FIELD_SUB_TYPE" = 0 >> AND "f" . "RDB$FIELD_SCALE" < 0 >> ) >> THEN 'NUMERIC' WHEN "f" . "RDB$FIELD_SUB_TYPE" = 2 >> THEN 'DECIMAL' >> ELSE 'SMALLINT' >> END WHEN 8 >> THEN CASE >> WHEN "f" . "RDB$FIELD_SUB_TYPE" = 1 >> THEN 'NUMERIC' WHEN( >> "f" . "RDB$FIELD_SUB_TYPE" = 0 >> AND "f" . "RDB$FIELD_SCALE" < 0 >> ) >> THEN 'NUMERIC' WHEN "f" . "RDB$FIELD_SUB_TYPE" = 2 >> THEN 'DECIMAL' >> ELSE 'INTEGER' >> END WHEN 9 >> THEN 'QUAD' WHEN 10 >> THEN 'FLOAT' WHEN 11 >> THEN 'D_FLOAT' WHEN 12 >> THEN 'DATE' WHEN 13 >> THEN 'TIME' WHEN 14 >> THEN 'CHAR' WHEN 16 >> THEN CASE >> WHEN "f" . "RDB$FIELD_SUB_TYPE" = 1 >> THEN 'NUMERIC' WHEN( >> "f" . "RDB$FIELD_SUB_TYPE" = 0 >> AND "f" . "RDB$FIELD_SCALE" < 0 >> ) >> THEN 'NUMERIC' WHEN "f" . "RDB$FIELD_SUB_TYPE" = 2 >> THEN 'DECIMAL' >> ELSE 'BIGINT' >> END WHEN 27 >> THEN 'DOUBLE' WHEN 35 >> THEN 'TIMESTAMP' WHEN 37 >> THEN 'VARCHAR' WHEN 40 >> THEN 'CSTRING' WHEN 261 >> THEN CASE >> "f" . "RDB$FIELD_SUB_TYPE" WHEN 0 >> THEN 'BLOB' WHEN 1 >> THEN 'BLOB SUB_TYPE TEXT' >> ELSE 'BLOB' >> END >> ELSE 'UNKNOWN' >> END "FIELD_TYPE" , >> "f" . "RDB$FIELD_SUB_TYPE" >> FROM >> "RDB$RELATION_FIELDS" "r" LEFT OUTER JOIN "RDB$FIELDS" "f" >> ON "r" . "RDB$FIELD_SOURCE" = "f" . "RDB$FIELD_NAME" >> LEFT OUTER JOIN RDB$CHARACTER_SETS "CH" ON >> ("CH"."RDB$CHARACTER_SET_ID" = "f"."RDB$CHARACTER_SET_ID") >> WHERE >> "r" . "RDB$RELATION_NAME" = 'BUPDATERLINKS' >> ORDER BY >> "r" . "RDB$FIELD_POSITION" ASC >> >> >> -- >> 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/d/optout. >> > > -- 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/d/optout.
