Re: Single quotes need escaping in scarab-schema.xml

Nigel; I did test your patch (well, your previous email, really).
Though I agree it's needed, I wonder why did it work with PostgreSQL
8.0.x before.
I'd like someone to test on both versions, and I also fear it would
harm the rest of supported database platforms.

Is there any way to instruct postgress so it doesn't need the escaping?


On Mon, Oct 13, 2008 at 9:19 PM, Nigel Tamplin <[email protected]> wrote:
> I had to escape some ' (single quote) characters within scarab-schema.xml so
> that the ant task "create-db" would run against a PostgreSQL 8.1 DB.
>
> diff attached.
>
> Nigel
>
> Index: src/schema/scarab-schema.xml
> ===================================================================
> --- src/schema/scarab-schema.xml        (revision 10627)
> +++ src/schema/scarab-schema.xml        (working copy)
> @@ -18,7 +18,7 @@
>                <column name="DEPEND_ID" required="false" type="INTEGER"
> description="Value of the dependency change."/>
>                <column name="DESCRIPTION" required="false" type="VARCHAR"
> size="255" description="System-generated description of modification
> (deprecated since b21, kept for backward compatibility)."/>
>                <column name="END_DATE" required="false" type="DATE"
> description="Date this Activity is no longer the current value of the
> Attribute."/>
> -               <column name="ATTACHMENT_ID" required="false" type="BIGINT"
> description=" If an attachment is associated to the activity, store it here.
> Note: there is also attachments associated to the activitySet which
> 'contains' the activity. These are generally the result of multiple activity
> records being  created via the modification of several attributes at one
> time."/>
> +               <column name="ATTACHMENT_ID" required="false" type="BIGINT"
> description=" If an attachment is associated to the activity, store it here.
> Note: there is also attachments associated to the activitySet which
> \'contains\' the activity. These are generally the result of multiple
> activity records being  created via the modification of several attributes
> at one time."/>
>                <column name="ACTIVITY_TYPE" required="true" type="VARCHAR"
> size="30" description="Type of activity, useful when generating the activity
> description."/>
>                <foreign-key foreignTable="SCARAB_ISSUE">
>                        <reference local="ISSUE_ID" foreign="ISSUE_ID"/>
> @@ -134,7 +134,7 @@
>                <column name="PERMISSION" required="false" type="VARCHAR"
> size="255" description="A permission related to this attribute."/>
>                <column name="REQUIRED_OPTION_ID" required="false"
> type="INTEGER" description="A required option for this attribute to be
> active."/>
>                <column name="DESCRIPTION" javaName="Description"
> required="true" type="VARCHAR" size="255" description="Description."/>
> -               <column name="ACTION" required="false" type="VARCHAR"
> size="255" description="For user attributes, whether the user will be
> emailed, cc'd, or neither."/>
> +               <column name="ACTION" required="false" type="VARCHAR"
> size="255" description="For user attributes, whether the user will be
> emailed, cc\'d, or neither."/>
>                <column name="CREATED_BY" javaName="CreatedBy"
> required="false" type="INTEGER" description="Person that set value to the
> column of the table initially."/>
>                <column name="CREATED_DATE" javaName="CreatedDate"
> required="false" type="TIMESTAMP" description="Date of the initial set of
> the column of the table."/>
>                <column name="DELETED" required="false" type="BOOLEANINT"
> default="0" javaType="primitive" description="Flag, which marks that
> attribute has been deleted."/>
> @@ -584,7 +584,7 @@
>                        <reference local="RELATIONSHIP_ID"
> foreign="RELATIONSHIP_ID"/>
>                </foreign-key>
>        </table>
> -       <table name="SCARAB_R_MODULE_USER_ATTRIBUTE" idMethod="idbroker"
> javaName="RModuleUserAttribute" description="User's choice of attributes to
> appear on the Issue List screen.">
> +       <table name="SCARAB_R_MODULE_USER_ATTRIBUTE" idMethod="idbroker"
> javaName="RModuleUserAttribute" description="User\'s choice of attributes to
> appear on the Issue List screen.">
>                <column name="RMUA_ID" primaryKey="true" required="true"
> type="BIGINT" description="Unique ID."/>
>                <column name="LIST_ID" required="false" type="BIGINT"
> description="MITList ."/>
>                <column name="MODULE_ID" required="false" type="INTEGER"
> description="Module."/>
> @@ -645,15 +645,15 @@
>        </table>
>        <table name="SCARAB_USER_PREFERENCE" idMethod="none"
> javaName="UserPreference" description="This table is used to store user
> preferences and other information relating to a specific user.">
>                <column name="USER_ID" primaryKey="true" required="true"
> type="INTEGER" description="Unique ID."/>
> -               <column name="PASSWORD_EXPIRE" type="TIMESTAMP"
> description="This is a column that Scarab standalone needs. Torque doesn't
> do anything with it at this point because this is an aliased table. Leaving
> it in here just as an FYI and in the hope that one day, Torque will generate
> the right methods even for aliased tables."/>
> +               <column name="PASSWORD_EXPIRE" type="TIMESTAMP"
> description="This is a column that Scarab standalone needs. Torque doesn\'t
> do anything with it at this point because this is an aliased table. Leaving
> it in here just as an FYI and in the hope that one day, Torque will generate
> the right methods even for aliased tables."/>
>                <column name="ENTER_ISSUE_REDIRECT" type="INTEGER"
> javaType="primitive"/>
>                <column name="HOME_PAGE" type="VARCHAR" size="32"/>
> -               <column name="LOCALE" type="VARCHAR" size="255"
> description="Currently stores information in a format which conforms to the
> definition of the HTTP Accept-Language header. Real world examples:
> de-at,de;q=0.8,en-us;q=0.5,en;q=0.3 | en-us,en;q=0.5 | en-gb,en-us;q=0.5 |
> zh-cn | de-de,de-ch;q=0.8,en-us;q=0.5,en;q=0.3 [ en-us, en;q=0.50. If this
> value cannot be parsed or is null, the current Module's default locale will
> be used.  If the Module does not have a default locale, the
> LocalizationService's default language will be used."/>
> +               <column name="LOCALE" type="VARCHAR" size="255"
> description="Currently stores information in a format which conforms to the
> definition of the HTTP Accept-Language header. Real world examples:
> de-at,de;q=0.8,en-us;q=0.5,en;q=0.3 | en-us,en;q=0.5 | en-gb,en-us;q=0.5 |
> zh-cn | de-de,de-ch;q=0.8,en-us;q=0.5,en;q=0.3 [ en-us, en;q=0.50. If this
> value cannot be parsed or is null, the current Module\'s default locale will
> be used.  If the Module does not have a default locale, the
> LocalizationService\'s default language will be used."/>
>                <foreign-key foreignTable="TURBINE_USER">
>                        <reference local="USER_ID" foreign="USER_ID"/>
>                </foreign-key>
>        </table>
> -       <table name="SCARAB_USER_VOTE" idMethod="none" javaName="UserVote"
> description="A user's record of votes.  It is assumed that a module that
> supports voting will give a new user some votes to use when the user is
> added, otherwise the user has no votes.">
> +       <table name="SCARAB_USER_VOTE" idMethod="none" javaName="UserVote"
> description="A user\'s record of votes.  It is assumed that a module that
> supports voting will give a new user some votes to use when the user is
> added, otherwise the user has no votes.">
>                <column name="MODULE_ID" primaryKey="true" required="true"
> type="INTEGER" description="Module."/>
>                <column name="USER_ID" primaryKey="true" required="true"
> type="INTEGER" description="Person."/>
>                <column name="TOTAL_VOTES" required="false" type="INTEGER"
> default="0" javaType="primitive" description="The total votes a user is
> allowed to cast in a project."/>
> @@ -715,8 +715,8 @@
>                <column name="QUERY_ID" primaryKey="true" required="true"
> type="BIGINT" description="Query."/>
>                <column name="USER_ID" primaryKey="true" required="true"
> type="INTEGER" description="Person subscribed to a query (might not be the
> person who created it)."/>
>                <column name="IS_SUBSCRIBED" required="false"
> type="BOOLEANINT" default="0" javaType="primitive" description="Is user
> subscribed."/>
> -               <column name="SUBSCRIPTION_FREQUENCY_ID"
> javaName="SubscriptionFrequency" required="false" type="INTEGER"
> description="User's subscription frequency."/>
> -               <column name="ISDEFAULT" required="false" type="BOOLEANINT"
> default="0" javaType="primitive" description="Whether this is the user's
> default query."/>
> +               <column name="SUBSCRIPTION_FREQUENCY_ID"
> javaName="SubscriptionFrequency" required="false" type="INTEGER"
> description="User\'s subscription frequency."/>
> +               <column name="ISDEFAULT" required="false" type="BOOLEANINT"
> default="0" javaType="primitive" description="Whether this is the user\'s
> default query."/>
>                <foreign-key foreignTable="SCARAB_QUERY">
>                        <reference local="QUERY_ID" foreign="QUERY_ID"/>
>                </foreign-key>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>



-- 
Jorge Uriarte Aretxaga
http://www.gailen.es
http://www.linkedin.com/in/jorgeuriarte