Examples with SerialInfo com.cubrid.common.core.common.model.SerialInfo used on opensource projects

Example 31 with SerialInfo

use of com.cubrid.common.core.common.model.SerialInfo in project cubrid-manager by CUBRID.

the class GetSerialInfoListTask method execute.

/**
	 * Execute to get serial information list by JDBC
	 */
public void execute() {
    // FIXME extract to utility class
    try {
        if (errorMsg != null && errorMsg.trim().length() > 0) {
            return;
        }
        if (connection == null || connection.isClosed()) {
            errorMsg = Messages.error_getConnection;
            return;
        }
        //databaseInfo.getServerInfo().compareVersionKey("8.2.2") >= 0;
        boolean isSupportCache = CompatibleUtil.isSupportCache(databaseInfo);
        String sql = "SELECT owner.name, db_serial.* FROM db_serial WHERE class_name IS NULL";
        // [TOOLS-2425]Support shard broker
        if (databaseInfo.isShard()) {
            sql = databaseInfo.wrapShardQuery(sql);
        }
        stmt = connection.createStatement();
        rs = stmt.executeQuery(sql);
        while (rs.next()) {
            String name = rs.getString("name");
            String owner = rs.getString("owner.name");
            String currentVal = rs.getString("current_val");
            String incrementVal = rs.getString("increment_val");
            String maxVal = rs.getString("max_val");
            String minVal = rs.getString("min_val");
            String cyclic = rs.getString("cyclic");
            String startVal = rs.getString("started");
            String className = rs.getString("class_name");
            String attName = rs.getString("att_name");
            boolean isCycle = false;
            if (cyclic != null && cyclic.equals("1")) {
                isCycle = true;
            }
            String cacheCount = null;
            if (isSupportCache) {
                cacheCount = rs.getString("cached_num");
            }
            SerialInfo serialInfo = new SerialInfo(name, owner, currentVal, incrementVal, maxVal, minVal, isCycle, startVal, cacheCount, className, attName);
            serialInfoList.add(serialInfo);
        }
    } catch (SQLException e) {
        errorMsg = e.getMessage();
        LOGGER.error(e.getMessage(), e);
    } finally {
        finish();
    }
}

Example 32 with SerialInfo

use of com.cubrid.common.core.common.model.SerialInfo in project cubrid-manager by CUBRID.

the class GetSerialInfoTask method getSerialInfo.

/**
	 * Get serial information by serial name
	 *
	 * @param serialName String The given serial name
	 * @return SerialInfo The instance of SerialInfo
	 */
public SerialInfo getSerialInfo(String serialName) {
    // FIXME extract to utility class
    SerialInfo serialInfo = null;
    try {
        if (errorMsg != null && errorMsg.trim().length() > 0) {
            return null;
        }
        if (connection == null || connection.isClosed()) {
            errorMsg = Messages.error_getConnection;
            return null;
        }
        boolean isSupportCache = CompatibleUtil.isSupportCache(databaseInfo);
        String sql = "SELECT owner.name, db_serial.* FROM db_serial WHERE name=?";
        // [TOOLS-2425]Support shard broker
        if (databaseInfo.isShard()) {
            sql = databaseInfo.wrapShardQuery(sql);
        }
        stmt = connection.prepareStatement(sql);
        ((PreparedStatement) stmt).setString(1, serialName);
        rs = ((PreparedStatement) stmt).executeQuery();
        while (rs.next()) {
            String name = rs.getString("name");
            String owner = rs.getString("owner.name");
            String currentVal = rs.getString("current_val");
            String incrementVal = rs.getString("increment_val");
            String maxVal = rs.getString("max_val");
            String minVal = rs.getString("min_val");
            String cyclic = rs.getString("cyclic");
            String startVal = rs.getString("started");
            String className = rs.getString("class_name");
            String attName = rs.getString("att_name");
            String cacheCount = null;
            if (isSupportCache) {
                cacheCount = rs.getString("cached_num");
            }
            boolean isCycle = false;
            if (cyclic != null && cyclic.equals("1")) {
                isCycle = true;
            }
            serialInfo = new SerialInfo(name, owner, currentVal, incrementVal, maxVal, minVal, isCycle, startVal, cacheCount, className, attName);
        }
    } catch (SQLException e) {
        errorMsg = e.getMessage();
        LOGGER.error(e.getMessage(), e);
    } finally {
        finish();
    }
    return serialInfo;
}

Example 33 with SerialInfo

use of com.cubrid.common.core.common.model.SerialInfo in project cubrid-manager by CUBRID.

the class ConstraintComparator method getInstanceAttributeDDL.

/**
	 * DDL of a attribute in creating a schema
	 *
	 * @param instanceAttr DBAttribute the given reference of a DBAttribute
	 *        object
	 * @param pkAttributes List<String> the given list that includes the info of
	 *        primary key
	 * @param newSchemaInfo SchemaInfo the given reference of a SchemaInfo
	 *        object
	 * @param isVirtual boolean whether be a virtual table
	 * @return String a string that indicates the info of instance atttribute
	 *         DDL
	 */
private String getInstanceAttributeDDL(DBAttribute instanceAttr, List<String> pkAttributes, SchemaInfo newSchemaInfo, boolean isVirtual) {
    StringBuffer bf = new StringBuffer();
    bf.append(QuerySyntax.escapeKeyword(instanceAttr.getName().toLowerCase()));
    // it don't be modified because instanceAttr.getType() can be "ENUM('Y','N')"
    bf.append(" ").append(instanceAttr.getType());
    if (DataType.DATATYPE_ENUM.equalsIgnoreCase(instanceAttr.getType()) && instanceAttr.getEnumeration() != null) {
        bf.append(instanceAttr.getEnumeration());
    }
    boolean supportCharset = CompatibleUtil.isSupportCreateDBByCharset(databaseInfo);
    if ((isVirtual || supportCharset) && !StringUtil.isEmpty(instanceAttr.getCollation()) && DataType.canUseCollation(instanceAttr.getType())) {
        bf.append(" COLLATE ").append(instanceAttr.getCollation()).append(" ");
    }
    String defaultv = instanceAttr.getDefault();
    if (instanceAttr.isShared()) {
        bf.append(" SHARED ");
        String sharedValue = instanceAttr.getSharedValue();
        if (sharedValue != null) {
            sharedValue = DBAttrTypeFormatter.formatValueForInput(instanceAttr.getType(), sharedValue, false);
            bf.append(sharedValue);
        }
    } else {
        if (defaultv == null) {
            SerialInfo autoInc = instanceAttr.getAutoIncrement();
            if (autoInc != null) {
                bf.append(" AUTO_INCREMENT");
                String seed = autoInc.getMinValue();
                String incrementValue = autoInc.getIncrementValue();
                if (seed != null && incrementValue != null) /*&& !("1".equals(seed) && "1".equals(incrementValue))*/
                {
                    bf.append("(");
                    bf.append(seed).append(",").append(incrementValue);
                    bf.append(")");
                }
            }
        } else {
            defaultv = DBAttrTypeFormatter.formatValueForInput(instanceAttr.getType(), defaultv, false);
            if (defaultv != null && defaultv.trim().length() == 0) {
                defaultv = "'" + defaultv + "'";
            }
            bf.append(" DEFAULT ").append(defaultv);
        }
    }
    if (pkAttributes.contains(instanceAttr.getName())) {
        bf.append(" NOT NULL");
    } else {
        if (instanceAttr.isNotNull()) {
            bf.append(" NOT NULL");
        }
    }
    return bf.toString();
}

Example 34 with SerialInfo

use of com.cubrid.common.core.common.model.SerialInfo in project cubrid-manager by CUBRID.

the class GetAutoIncrementTaskTest method testGetAutoIncrementTaskTest.

public void testGetAutoIncrementTaskTest() {
    createTestTable();
    //test normal case
    GetAutoIncrementTask task = new GetAutoIncrementTask(databaseInfo);
    task.setTableName(testTableName);
    task.execute();
    ArrayList<SerialInfo> list = task.getSerialInfoList();
    assertEquals(1, list.size());
    SerialInfo serial = list.get(0);
    assertEquals("3", serial.getMinValue());
    assertEquals("5", serial.getIncrementValue());
    //test exception case: connection is closed
    task.execute();
    //test exception case: have error
    task.setErrorMsg("error");
    task.execute();
}