Question Re: pd16.6 reverse engineer default value '~' in Technology Q&A

pd16.6 reverse engineer default value '~'

Former Member — Thu, 31 May 2018 04:38:33 GMT

i user pd16.6 reverse engineer extact mysql5.6 physical model.

if column had default value ,colum is enclolsed by character '~' , not character '(quote).

just like

i changed setting,just like

.problem still exist!

who can help me !

Re: pd16.6 reverse engineer default value '~'

GeorgeMcGeachie — Thu, 31 May 2018 08:39:16 GMT

Are you reverse-engineering from a DB connection, or SQL? What does the line of SQL look like?

Re: pd16.6 reverse engineer default value '~'

Former Member — Mon, 04 Jun 2018 10:04:57 GMT

jdbc1.png

i used jdbc connection.

i try to user odbc connection,this problem is not occur,but other problem occur.

i don't know where to find 'line of SQL'.

thanks!

Re: pd16.6 reverse engineer default value '~'

arnaud_laurent — Mon, 04 Jun 2018 14:35:28 GMT

Hello,
As a workaround, you may run a VBScript after the reverse like the one below which can be included in the XDB file in an AfterDatabaseReverseEngineer Eventhandler for the Metaclass Model.
See in our documentation -> DBMS Resource File Reference > Managing Generation and Reverse Engineering -> Adding Scripts Before or After Generation and Reverse Engineering

' Sample script:

for each t in ActiveModel.Tables
if t.ClassName = "Table" then
for each c in t.Columns
if c.ClassName = "Column" then
if len(c.DefaultValueDisplayed) > 2 and InStr(c.DefaultValueDisplayed,"~") = 1 then
newDefault = c.DefaultValueDisplayed
newDefault = left(newDefault, len(newDefault) - 1)
newDefault = right(newDefault, len(newDefault) - 1)
c.DefaultValue = newDefault
end if
end if
next
end if
next

HTH,

Arnaud

Re: pd16.6 reverse engineer default value '~'

Former Member — Tue, 05 Jun 2018 05:19:13 GMT

that is OK!

"our documentation" just means "help document":)

thank you very much!

Re: pd16.6 reverse engineer default value '~'

Former Member — Tue, 05 Jun 2018 05:20:04 GMT

thank you very much!