db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fox (Resolved) (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (TORQUE-24) Generator doesn't generate data values correctly for BOOLEANCHAR
Date Mon, 30 Jan 2012 18:34:10 GMT

     [ https://issues.apache.org/jira/browse/TORQUE-24?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Thomas Fox resolved TORQUE-24.
------------------------------

    Resolution: Won't Fix
      Assignee: Thomas Fox

Datasql is not supported any more
                
> Generator doesn't generate data values correctly for BOOLEANCHAR
> ----------------------------------------------------------------
>
>                 Key: TORQUE-24
>                 URL: https://issues.apache.org/jira/browse/TORQUE-24
>             Project: Torque
>          Issue Type: Improvement
>          Components: Generator
>    Affects Versions: 3.2
>         Environment: MySQL Database, JDK 1.5.0
>            Reporter: Henning Schmiedehausen
>            Assignee: Thomas Fox
>            Priority: Minor
>
> Consider the following table description:
> <table name="people">
>   <column javaName="firstName" javaType="object" name="people_firstname" required="false"
size="32" type="VARCHAR"/>
>   <column javaName="name" javaType="object" name="people_name" required="true" size="32"
type="VARCHAR"/>
>   <column javaName="login" javaType="object" name="people_login" required="true" size="16"
type="VARCHAR"/>
>   <column javaName="member" javaType="primitive" name="people_member" required="true"
type="BOOLEANCHAR"/>
>   <column javaName="id" javaType="object" name="people_id" type="BIGINT" primaryKey="true"
required="true" autoIncrement="true" />
> </table>
> And the following people-data.xml file:
> <dataset name="all">
>   <People Name="Doe" FirstName="John" Member="true" Login="jdoe"/>
>   <People Name="User" FirstName="Joe" Member="false" Login="juser"/>
>   <People Name="Spot the Dog" Member="false" Login="spot"/>
> </dataset>
> Running ant -f build-torque.xml datasql creates:
> INSERT INTO people (people_name,people_firstname,people_member,people_login)
>     VALUES ('Doe','John',true,'jdoe');
> INSERT INTO people (people_name,people_firstname,people_member,people_login)
>     VALUES ('User','Joe',false,'juser');
> which end up as '1' and '0' in the people_member column. However the BOOLEANCHAR Definition
expects 'Y' and 'N', so using a boolean criteria does not work because both values in the
boolean column (1 and 0) are interpreted correctly. WIth the example above and a booleanchar
column, you will get
>         Criteria crit = new Criteria();
>         crit.add(PeoplePeer.PEOPLE_MEMBER, true);
>         PeoplePeer.doSelect(crit).size() == 0
>         Criteria crit = new Criteria();
>         crit.add(PeoplePeer.PEOPLE_MEMBER, false);
>         PeoplePeer.doSelect(crit).size() == 0
> which is fun, considering the fact that there are three rows and the column is not-null...
:-) 
> The generator should use 'Y' and 'N' for BOOLEANCHAR columns. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message