Uploaded image for project: 'Torque'
  1. Torque
  2. TORQUE-44

Column names in generated classes are uppercase

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.1, 3.1.1, 3.2
    • 3.3
    • Generator
    • None

    Description

      The generator creates constants for the column names in tables. The content of this constants uses upper cases.

      For example if you have a table like:

      <table name="address">
      <column name="class" javaName="aClass" primaryKey="true" required="true" size="2" type="CHAR"/>
      <column name="id" primaryKey="true" required="true" size="30" type="VARCHAR"/>
      <column name="position" primaryKey="true" required="true" type="INTEGER"/>
      <column name="name1" size="50" type="VARCHAR"/>
      <column name="name2" size="50" type="VARCHAR"/>
      <column name="name3" size="50" type="VARCHAR"/>
      <column name="street" size="50" type="VARCHAR"/>
      <column name="zipcode" size="25" type="VARCHAR"/>
      <column name="city" size="60" type="VARCHAR"/>
      <column name="phone" size="40" type="VARCHAR"/>
      <column name="phone2" size="40" type="VARCHAR"/>
      <column name="country" size="200" type="VARCHAR"/>
      <column name="state" size="200" type="VARCHAR"/>
      <column name="fax" size="40" type="VARCHAR"/>
      <column name="email" size="150" type="VARCHAR"/>
      </table>

      The generator creates in the corresponding BaseAddressPeer the following constants.

      ...
      static
      {
      CLASS = "address.CLASS";
      ID = "address.ID";
      POSITION = "address.POSITION";
      NAME1 = "address.NAME1";
      NAME2 = "address.NAME2";
      NAME3 = "address.NAME3";
      STREET = "address.STREET";
      ZIPCODE = "address.ZIPCODE";
      CITY = "address.CITY";
      PHONE = "address.PHONE";
      PHONE2 = "address.PHONE2";
      COUNTRY = "address.COUNTRY";
      STATE = "address.STATE";
      FAX = "address.FAX";
      EMAIL = "address.EMAIL";
      ....

      but this variables should be for example "address.email".
      The AddressMapBuilder.doBuild() method creates the same uppercase mapping:

      public void doBuild() throws TorqueException {
      ...
      dbMap.addTable("address");
      TableMap tMap = dbMap.getTable("address");

      tMap.setPrimaryKeyMethod("none");
      tMap.addPrimaryKey("address.CLASS", "" );
      tMap.addPrimaryKey("address.ID", "" );
      tMap.addPrimaryKey("address.POSITION", new Integer(0) );
      tMap.addColumn("address.NAME1", "", 50 );
      tMap.addColumn("address.NAME2", "", 50 );
      tMap.addColumn("address.NAME3", "", 50 );
      tMap.addColumn("address.STREET", "", 50 );
      tMap.addColumn("address.ZIPCODE", "", 25 );
      tMap.addColumn("address.CITY", "", 60 );
      tMap.addColumn("address.PHONE", "", 40 );
      tMap.addColumn("address.PHONE2", "", 40 );
      tMap.addColumn("address.COUNTRY", "", 200 );
      tMap.addColumn("address.STATE", "", 200 );
      tMap.addColumn("address.FAX", "", 40 );
      tMap.addColumn("address.EMAIL", "", 150 );
      }

      Attachments

        1. patch.txt
          1 kB
          Thoralf Rickert
        2. Torque-44.zip
          50 kB
          CG Monroe

        Activity

          People

            tfischer Thomas Fox
            trickert Thoralf Rickert
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: