Package org.apache.empire.db

Examples of org.apache.empire.db.DBTableColumn

510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
        // Enable Column default for the database
        // This is needed for adding required fields to non-empty tables
        db.getDriver().setDDLColumnDefaults(true);

        // First, add a new column to the Table object
        DBTableColumn C_FOO = db.T_EMPLOYEES.addColumn("FOO", DataType.TEXT, 20, DataMode.Nullable);

        // Now create the corresponding DDL statement
        System.out.println("Creating new column named FOO as varchar(20) for the EMPLOYEES table:");
        DBSQLScript script = new DBSQLScript();
        db.getDriver().getDDLScript(DBCmdType.CREATE, C_FOO, script);
        script.run(db.getDriver(), conn, false);
       
        // Now load a record from that table and set the value for foo
        System.out.println("Changing the value for the FOO field of a particular employee:");
        DBRecord rec = new DBRecord();
        rec.read(db.T_EMPLOYEES, idTestPerson, conn);
        rec.setValue(C_FOO, "Hello World");
        rec.update(conn);
       
        // Now extend the size of the field from 20 to 40 characters
        System.out.println("Extending size of column FOO to 40 characters:");
        C_FOO.setSize(40);
        script.clear();
        db.getDriver().getDDLScript(DBCmdType.ALTER, C_FOO, script);
        script.run(db.getDriver(), conn, false);

        // Now set a longer value for the record
View Full Code Here
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
        // Enable Column default for the database
        // This is needed for adding required fields to non-empty tables
        db.getDriver().setDDLColumnDefaults(true);

        // First, add a new column to the Table object
        DBTableColumn C_FOO = db.T_EMPLOYEES.addColumn("FOO", DataType.TEXT, 20, DataMode.Nullable);

        // Now create the corresponding DDL statement
        System.out.println("Creating new column named FOO as varchar(20) for the EMPLOYEES table:");
        DBSQLScript script = new DBSQLScript();
        db.getDriver().getDDLScript(DBCmdType.CREATE, C_FOO, script);
        script.run(db.getDriver(), conn, false);
       
        // Now load a record from that table and set the value for foo
        System.out.println("Changing the value for the FOO field of a particular employee:");
        DBRecord rec = new DBRecord();
        rec.read(db.T_EMPLOYEES, idTestPerson, conn);
        rec.setValue(C_FOO, "Hello World");
        rec.update(conn);
       
        // Now extend the size of the field from 20 to 40 characters
        System.out.println("Extending size of column FOO to 40 characters:");
        C_FOO.setSize(40);
        script.clear();
        db.getDriver().getDDLScript(DBCmdType.ALTER, C_FOO, script);
        script.run(db.getDriver(), conn, false);

        // Now set a longer value for the record
View Full Code Here
250
251
252
253
254
255
256
257
258
259
260
261
262
263
    input.setValue(getRecord().getValue(col));
    return input;
  }

  private HtmlOutputLabel createOutputLabelForCol() {
    DBTableColumn col = getColumn();
    HtmlOutputLabel label = new HtmlOutputLabel();
    String colName = getLabelString()+":";
    if (col.isRequired()) {
      colName += "*";
    }
    label.setId(this.getId() + LABEL_SUFFIX);
    label.setValue(colName);
    return label;
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
103
104
  }

  @Override
  public void updateModel(FacesContext context) {
    DBRecord rec = getRecord();
    DBTableColumn col = getColumn();

    // don't set automatically created cols or readOnly cols
    if (!col.isAutoGenerated() && !isReadOnly()) {
      UIInput inputComponent = (UIInput)getChildren().get(1);
      rec.setValue(col, inputComponent.getValue());
    }
    super.updateModel(context);
  }
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
123
124
125
    {
      return;
    }
   
    DBRecord rec = getRecord();
    DBTableColumn col = (DBTableColumn) rec.getDBColumn(rec
        .getFieldIndex(getAttributes().get("column").toString()));
    try {
      col.checkValue(inputComponent.getValue());
    } catch (Exception e) {
      FacesContext.getCurrentInstance().addMessage(getClientId(), new FacesMessage(e.getLocalizedMessage()));
      this.setValid(false);
    }
    super.validate(context);
View Full Code Here
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
      }
    }
  }

  private UIInput createInputComponentForCol() {
    DBTableColumn col = getColumn();
    String controlType = col.getControlType();
    // registerControl("text", new TextInputControl());
    // registerControl("select", new SelectInputControl());
    // registerControl("checkbox", new CheckboxInputControl());
    // registerControl("phone", new PhoneInputControl());
    // registerControl("radio", new RadioInputControl());
    // registerControl("textarea", new TextAreaInputControl());
    // registerControl("email", new EMailInputControl());
    // registerControl("hlink", new HLinkInputControl());
    // registerControl("password", new PasswordInputControl());
    UIInput input = null;
    if (controlType.equals("text")) {
      // DATE_TIME
      if (col.getDataType().equals(DataType.DATETIME))
      {
        HtmlInputText inputText = new HtmlInputText();
        inputText.setReadonly(isReadOnly() || col.isAutoGenerated());
        inputText.setLabel(getLabelString());
        input = inputText;       
      }
      // AUTOINC
      else if (col.getDataType().equals(DataType.AUTOINC))
      {
        HtmlInputText inputText = new HtmlInputText();
        inputText.setReadonly(true);
        inputText.setLabel(getLabelString());
        input = inputText;       
      }
     
      // INTEGER
      else if (col.getDataType().equals(DataType.INTEGER))
      {
        HtmlInputText inputText = new HtmlInputText();
        inputText.setReadonly(isReadOnly() || col.isAutoGenerated());
        inputText.setLabel(getLabelString());
        input = inputText;       
      }     
      // DATE
      else if (col.getDataType().equals(DataType.TEXT) || col.getDataType().equals(DataType.DATE)) {
        HtmlInputText inputText = new HtmlInputText();
        inputText.setReadonly(isReadOnly() || col.isAutoGenerated());
        inputText.setLabel(getLabelString());
        input = inputText;
      }
      // TEXT
      else if (col.getDataType().equals(DataType.TEXT) || col.getDataType().equals(DataType.DATE)) {
        HtmlInputText inputText = new HtmlInputText();
        inputText.setReadonly(isReadOnly() || col.isAutoGenerated());
        inputText.setLabel(getLabelString());
        inputText.setMaxlength((int) Math.round(col.getSize()));
        input = inputText;
      }
    }
   
    else if (controlType.equals("textarea")) {
     
      HtmlSelectBooleanCheckbox inputSelectBooleanCheckbox = new HtmlSelectBooleanCheckbox();
      inputSelectBooleanCheckbox.setReadonly(isReadOnly() || col.isAutoGenerated());
      inputSelectBooleanCheckbox.setLabel(getLabelString());
      input = inputSelectBooleanCheckbox;
    } else if (controlType.equals("password")) {
      HtmlSelectBooleanCheckbox inputSelectBooleanCheckbox = new HtmlSelectBooleanCheckbox();
      inputSelectBooleanCheckbox.setReadonly(isReadOnly() || col.isAutoGenerated());
      inputSelectBooleanCheckbox.setLabel(getLabelString());
      input = inputSelectBooleanCheckbox;
    } else if (controlType.equals("select")) {
      HtmlSelectOneMenu inputSelectOneMenu = new HtmlSelectOneMenu();
      inputSelectOneMenu.setReadonly(isReadOnly() || col.isAutoGenerated());
      addSelectItems(inputSelectOneMenu);
      inputSelectOneMenu.setLabel(getLabelString());
      input = inputSelectOneMenu;

    } else if (controlType.equals("checkbox")) {
      HtmlSelectBooleanCheckbox inputSelectBooleanCheckbox = new HtmlSelectBooleanCheckbox();
      inputSelectBooleanCheckbox.setReadonly(isReadOnly() || col.isAutoGenerated());
      inputSelectBooleanCheckbox.setLabel(getLabelString());
      input = inputSelectBooleanCheckbox;
    }
   
    else if (controlType.equals("phone")) {
      HtmlInputText inputText = new HtmlInputText();
      inputText.setReadonly(isReadOnly() || col.isAutoGenerated());
      inputText.setLabel(getLabelString());
      inputText.setMaxlength((int) Math.round(col.getSize()));
      input = inputText;
    }

    // For testing purposes only
    if (input == null) {
      log.error("No matching control found for column "
          + col.getFullName());
      input = new HtmlInputText();
    }

    // JSF2 Validator
    switch (col.getDataType()) {
    case TEXT: {
      input.addValidator(new LengthValidator((int) Math.round(col
          .getSize())));
      break;
    }
    }

    input.setRequired(col.isRequired() && !col.isAutoGenerated());
    input.setId(this.getId() + INPUT_SUFFIX);
    input.setValue(getRecord().getValue(col));
    return input;
  }
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
96
        {
            DBTable table = seqtabs.next();
            Iterator<DBColumn> cols = table.getColumns().iterator();
            while (cols.hasNext())
            {
                DBTableColumn c = (DBTableColumn) cols.next();
                if (c.getDataType() == DataType.AUTOINC)
                {
                    createSequence(db, c, script);
                }
            }
        }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
108
        {
            DBTable table = seqtabs.next();
            Iterator<DBColumn> cols = table.getColumns().iterator();
            while (cols.hasNext())
            {
                DBTableColumn c = (DBTableColumn) cols.next();
                if (c.getDataType() == DataType.AUTOINC)
                {
                    createSequence(db, c, script);
                }
            }
        }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
97
        {
            DBTable table = seqtabs.next();
            Iterator<DBColumn> cols = table.getColumns().iterator();
            while (cols.hasNext())
            {
                DBTableColumn c = (DBTableColumn) cols.next();
                if (c.getDataType() == DataType.AUTOINC)
                {
                    createSequence(db, c, script);
                }
            }
        }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
108
        {
            DBTable table = seqtabs.next();
            Iterator<DBColumn> cols = table.getColumns().iterator();
            while (cols.hasNext())
            {
                DBTableColumn c = (DBTableColumn) cols.next();
                if (c.getDataType() == DataType.AUTOINC)
                {
                    createSequence(db, c, script);
                }
            }
        }
View Full Code Here
TOP

Related Classes of org.apache.empire.db.DBTableColumn

  • components.control
  • org.apache.empire.commons.Attributes
  • org.apache.empire.db.codegen.CodeGenParser
  • org.apache.empire.db.codegen.WriterService
  • org.apache.empire.db.codegen.WriterServiceTest
  • org.apache.empire.db.derby.DBDatabaseDriverDerby
  • org.apache.empire.db.h2.DBDatabaseDriverH2
  • org.apache.empire.db.hsql.DBDatabaseDriverHSql
  • org.apache.empire.db.hsql.HSqlDDLGenerator
  • org.apache.empire.db.mysql.DBDatabaseDriverMySQL
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.