package org.paneris.jal.model;
   
   import java.sql.Connection;
   import java.sql.ResultSet;
   import java.sql.Statement;
   
   /**
    * A FieldMetaData encapsulates meta data for a single field in the datadictionary. 
    */
  public class FieldMetaData {
  
      private String fieldName;
      private SQLMetaData SQLMetaData;
      private Integer fieldNumber;
      private Integer tableNumber;
      private String tableName;
      private String displayName;
      private String defaultValue;
      private String type;
      private int displayOrder;
      private boolean mandatory;
      private String relationshipTable;
      private String relationshipField;
      private boolean listDisplay;
      private int size;
      private int maxLength;
      private int height;
      private boolean enforceUnique;
      private boolean selectDisplay;
      private String database;
      private DBConnectionManager connMgr = DBConnectionManager.getInstance();
  
  /**
   * construct meta data for a field in the datadictionary
   */
      public FieldMetaData(String db, Integer fn) throws Exception {
          database = db;
          fieldNumber = fn;
          String sqlString = "";
          try {
              Connection conn = connMgr.getConnection("FieldMetaData",database);
              Statement s = conn.createStatement();
              Statement s2 = conn.createStatement();
              sqlString = "SELECT * FROM datadictionary WHERE id = ";
              sqlString = sqlString.concat(fieldNumber.toString());
              ResultSet rs = s.executeQuery(sqlString);
              if (rs.next()) {
                  fieldName = rs.getString("fieldname").trim();
                  displayName = rs.getString("displayname").trim();
                  int typeInt = rs.getInt("type");
                  if (typeInt != 0) {
                      sqlString = new String("SELECT type FROM datadictionarytypes WHERE id = " + typeInt);
                      ResultSet rs2 = s2.executeQuery(sqlString);
                      rs2.next();
                      type = rs2.getString("type").trim();
                  } else {
                      type = "";
                  }
              // set up the sql metadata for this field
                  SQLMetaData = new SQLMetaData(db,fn);
                  displayOrder = rs.getInt("displayorder");
                  mandatory = rs.getBoolean("mandatory");
  
                  // get the name of the table for this field
                  tableNumber = new Integer(rs.getInt("tablename"));
                  sqlString = new String("SELECT tablename FROM datadictionarytables WHERE id = " + tableNumber);
                  ResultSet rs3 = s2.executeQuery(sqlString);
                  if (rs3.next()) {
                      tableName = rs3.getString("tablename").trim();
                  }
  
                  int relationshipTableInt = rs.getInt("relationshiptable");
                  if (relationshipTableInt != 0) {
                      sqlString = new String("SELECT tablename FROM datadictionarytables WHERE id = " + relationshipTableInt);
                      rs3 = s2.executeQuery(sqlString);
                      if (rs3.next()) {
                          relationshipTable = rs3.getString("tablename").trim();
                      } else {
                          relationshipTable = "";
                      }
                  } else {
                      relationshipTable = "";
                  }
                  String rf = rs.getString("relationshipfield");
                  if (rf != null) {
                      relationshipField = rf.trim();
                  } else {
                      relationshipField = "";
                  }
                  try {
                      String dv = rs.getString("defaultvalue");
                      if (dv != null) {
                          defaultValue = dv.trim();
                      } else {
                          defaultValue = "";
                      }
                  } catch (Exception e) {
                      defaultValue = "";
                  }
                 listDisplay = rs.getBoolean("listdisplay");
                 size = rs.getInt("size");
                 try {
                     height = rs.getInt("height");
                 } catch (Exception e) {
                     height = 0;
                 }
                 try {
                     maxLength = rs.getInt("maxlength");
                 } catch (Exception e) {
                     maxLength = 0;
                 }
                 enforceUnique = rs.getBoolean("enforceunique");
                 selectDisplay = rs.getBoolean("selectdisplay");
                 s.close();
                 s2.close();
             } else {
                 throw new Exception("Field number: " + fieldNumber + " is not present in the datadictionary table");
             }
             connMgr.freeConnection(database, conn);
         } catch (Exception e) {
             throw new Exception("Failed to build FieldMetaData: " + e.toString() + " FieldMetaData SQL: " + sqlString);
         }
     }
 
 
 /**
 returns the field's number
 **/
     public Integer getFieldNumber() {
         return fieldNumber;
     }
 
 /**
 returns the field's name
 **/
     public String getFieldName() {
         return fieldName;
     }
 
 /**
 returns the field's default value
 **/
     public String getDefaultValue() {
         return defaultValue;
     }
 
 /**
 returns the field's display name
 **/
     public String getDisplayName() {
         return displayName;
     }
 
 /**
 returns the field's type
 **/
     public String getType() {
         return type;
     }
 
 /**
 returns the field's tablenumber
 **/
     public Integer getTableNumber() {
         return tableNumber;
     }
 /**
 returns the field's tablename
 **/
     public String getTableName() {
         return tableName;
     }
 
 /**
 returns the field's display order
 **/
     public int getDisplayOrder() {
         return displayOrder;
     }
 
 /**
 returns true if the field is mandatory
 **/
     public boolean getMandatory() {
         return mandatory;
     }
 
 /**
 returns null if the field is not mandatory.  this will not be required in webmacro 0.90
 where we can properly evaluate boolean expressions in the template
 **/
     public Object getMandatoryNull() {
         if (mandatory) {
             return Boolean.TRUE;
         } else {
             return null;
         }
     }
 
 /**
 returns the tablename if this field is a look-up field
 **/
     public String getRelationshipTable() {
         return relationshipTable;
     }
 
 /**
 returns the fieldname if this field is a look-up field
 **/
     public String getRelationshipField() {
         return relationshipField;
     }
 
 /**
 returns true if this field should appear on the list page
 **/
     public boolean getListDisplay() {
         return listDisplay;
     }
 
 
 /**
 returns the size of the input box
 **/
     public int getSize() {
         return size;
     }
 
 /**
 returns the maximum length of text in an input box
 **/
     public int getMaxLength() {
         return maxLength;
     }
 
 /**
 returns the height of a textarea input box
 **/
     public int getHeight() {
         return height;
     }
 
 
 /**
 returns true if this field should contain a unique value.
 **/
     public boolean getEnforceUnique() {
         return enforceUnique;
     }
 
 
 /**
 returns true if this field should as a selection option on the list page
 **/
     public boolean getSelectDisplay() {
         return selectDisplay;
     }
 
 
 /**
 gets the type of this field as an java.sql.Type.  this is useful when setting null
 values in a prepared statement, where the type of the object is important
 **/
     public SQLMetaData getSQLMetaData() {
         return SQLMetaData;
     }
 
 }