Пример #1
0
  public static void addUndefined(SQLBase base) {
    Set<String> tableNames = base.getTableNames();
    for (String tableName : tableNames) {
      SQLTable table = base.getTable(tableName);
      SQLField fieldPrimaryKey = table.getKey();

      if (fieldPrimaryKey != null
          && fieldPrimaryKey.getType().getJavaType().getSuperclass() != null
          && fieldPrimaryKey.getType().getJavaType().getSuperclass() == Number.class) {

        String patch =
            "INSERT INTO \"" + tableName + "\"(\"" + fieldPrimaryKey.getName() + "\") VALUES (1)";
        base.execute(patch);
      }
    }
  }
Пример #2
0
  /**
   * Check si la table posséde au moins une ligne avec un ordre different null le cas cas échéant le
   * crée
   *
   * @param base
   */
  public static void correct(SQLBase base) {
    Set<String> tableNames = base.getTableNames();
    for (String tableName : tableNames) {

      if (base.getTable(tableName).contains("ORDRE")) {
        SQLSelect select = new SQLSelect(base);
        select.addSelect("ORDRE");
        List l = base.getDataSource().execute(select.asString());
        if (l == null || l.size() == 0) {
          SQLRowValues rowVals = new SQLRowValues(base.getTable(tableName));
          rowVals.put("ORDRE", 0);
          try {
            rowVals.commit();
          } catch (SQLException e) {

            e.printStackTrace();
          }
        }
      }
    }
    // TODO Checker que toutes les tables sont dans FWK_UNDEFINED_ID
  }
Пример #3
0
  public static void setOrder(SQLBase base) {
    Set<String> tableNames = base.getTableNames();
    for (String tableName : tableNames) {
      SQLTable table = base.getTable(tableName);
      // SQLField fieldPrimaryKey = table.getKey();
      SQLField field = table.getOrderField();

      if (field != null) {
        base.execute(
            "ALTER TABLE \""
                + tableName
                + "\" ALTER COLUMN \""
                + field.getName()
                + "\" SET DEFAULT 0;");
        base.execute(
            "ALTER TABLE \""
                + tableName
                + "\" ALTER COLUMN \""
                + field.getName()
                + "\" SET NOT NULL;");
      }
    }
  }