[odb-users] Joining underscore for column pragma on composite values

Dieter Govaerts dieter.govaerts at bricsys.com
Tue Dec 6 05:52:14 EST 2016


Hello Boris,

Yes, thank you. That does the trick:
  
    --column-regex '/(.+)\$_(.+)/$1\$$2/'

Unfortunately there seems to be a bug in 2.4.0 because it only works for non-TEXT columns (SQLite).

Change log before:
      <column name="Common$_reference" type="TEXT" null="false" default="''"/>
      <column name="Common$_acoustic_rating" type="TEXT" null="false" default="''"/>
      <column name="Common$_fire_rating" type="TEXT" null="false" default="''"/>
      <column name="Common$_combustible" type="INTEGER" null="false" default="0"/>
      <column name="Common$_surface_spread_of_flame" type="TEXT" null="false" default="''"/>
      <column name="Common$_thermal_transmittance" type="REAL" null="false" default="0"/>
      <column name="Common$_external" type="INTEGER" null="false" default="0"/>
      <column name="Common$_extend_to_structure" type="INTEGER" null="false" default="1"/>
      <column name="Common$_load_bearing" type="INTEGER" null="false" default="0"/>
      <column name="Common$_compartmentation" type="INTEGER" null="false" default="0"/>

Change log after:
      <column name="Common$_reference" type="TEXT" null="false" default="''"/>
      <column name="Common$_acoustic_rating" type="TEXT" null="false" default="''"/>
      <column name="Common$_fire_rating" type="TEXT" null="false" default="''"/>
      <column name="Common$combustible" type="INTEGER" null="false" default="0"/>
      <column name="Common$_surface_spread_of_flame" type="TEXT" null="false" default="''"/>
      <column name="Common$thermal_transmittance" type="REAL" null="false" default="0"/>
      <column name="Common$external" type="INTEGER" null="false" default="0"/>
      <column name="Common$extend_to_structure" type="INTEGER" null="false" default="1"/>
      <column name="Common$load_bearing" type="INTEGER" null="false" default="0"/>
      <column name="Common$compartmentation" type="INTEGER" null="false" default="0"/>

Best regards,
  Dieter Govaerts


On Friday, 2 December, 2016 16:49, "Boris Kolpackov" <boris at codesynthesis.com> said:

> Hi Dieter,
> 
> Dieter Govaerts <dieter.govaerts at bricsys.com> writes:
> 
>> Above example results in a column named "person$_first" instead of
>> my preferred "person$first".
> 
> I think you can "fix up" your names with the --column-regex ODB
> compiler option.
> 
> Boris
> 





More information about the odb-users mailing list