Examples with FreeUpdateSqlBuilder com.ctrip.platform.dal.dao.sqlbuilder.FreeUpdateSqlBuilder used on opensource projects

Example 11 with FreeUpdateSqlBuilder

use of com.ctrip.platform.dal.dao.sqlbuilder.FreeUpdateSqlBuilder in project dal by ctripcorp.

the class FreeUpdateSqlBuilderTest method testValues.

@Test
public void testValues() throws SQLException {
    FreeUpdateSqlBuilder test = createTest();
    test.values(noShardTableName);
    assertEquals("([noShard]) VALUES (?)", test.build());
    test = createTest();
    test.values(noShardTableName, tableName);
    assertEquals("([noShard], [dal_client_test]) VALUES (?, ?)", test.build());
    test = createTest();
    test.insertInto(noShardTableName);
    test.values(noShardTableName, tableName);
    assertEquals("INSERT INTO [noShard] ([noShard], [dal_client_test]) VALUES (?, ?)", test.build());
}

Example 12 with FreeUpdateSqlBuilder

use of com.ctrip.platform.dal.dao.sqlbuilder.FreeUpdateSqlBuilder in project dal by ctripcorp.

the class FreeUpdateSqlBuilderTest method testInsertInto.

@Test
public void testInsertInto() throws SQLException {
    FreeUpdateSqlBuilder test = createTest();
    test.insertInto(noShardTableName);
    assertEquals("INSERT INTO " + wrappedNoShardTableName, test.build());
    test = createTest();
    test.insertInto(table(noShardTableName));
    assertEquals("INSERT INTO " + wrappedNoShardTableName, test.build());
}

Example 13 with FreeUpdateSqlBuilder

use of com.ctrip.platform.dal.dao.sqlbuilder.FreeUpdateSqlBuilder in project dal by ctripcorp.

the class DalGroupDBDao method updateGroupDB.

public int updateGroupDB(int id, Integer groupId) throws SQLException {
    FreeUpdateSqlBuilder builder = new FreeUpdateSqlBuilder(dbCategory);
    builder.setTemplate("UPDATE alldbs SET dal_group_id=? WHERE id=?");
    StatementParameters parameters = new StatementParameters();
    int i = 1;
    parameters.set(i++, "dal_group_id", Types.INTEGER, groupId);
    parameters.set(i++, "id", Types.INTEGER, id);
    DalHints hints = DalHints.createIfAbsent(null);
    return queryDao.update(builder, parameters, hints);
}

Example 14 with FreeUpdateSqlBuilder

use of com.ctrip.platform.dal.dao.sqlbuilder.FreeUpdateSqlBuilder in project dal by ctripcorp.

the class DalGroupDBDao method updateGroupDB.

public int updateGroupDB(int id, String comment) throws SQLException {
    FreeUpdateSqlBuilder builder = new FreeUpdateSqlBuilder(dbCategory);
    builder.setTemplate("UPDATE alldbs SET comment=? WHERE id=?");
    StatementParameters parameters = new StatementParameters();
    int i = 1;
    parameters.set(i++, "comment", Types.VARCHAR, comment);
    parameters.set(i++, "id", Types.INTEGER, id);
    DalHints hints = DalHints.createIfAbsent(null);
    return queryDao.update(builder, parameters, hints);
}

Example 15 with FreeUpdateSqlBuilder

use of com.ctrip.platform.dal.dao.sqlbuilder.FreeUpdateSqlBuilder in project dal by ctripcorp.

the class DaoByFreeSql method updateTask.

public int updateTask(GenTaskByFreeSql task) throws SQLException {
    {
        FreeSelectSqlBuilder<GenTaskByFreeSql> builder = new FreeSelectSqlBuilder<>(dbCategory);
        builder.setTemplate("SELECT * FROM task_sql WHERE id != ? AND project_id=? AND db_name=? AND class_name=? AND method_name=? LIMIT 1");
        StatementParameters parameters = new StatementParameters();
        int i = 1;
        parameters.set(i++, "id", Types.INTEGER, task.getId());
        parameters.set(i++, "project_id", Types.INTEGER, task.getProject_id());
        parameters.set(i++, "db_name", Types.VARCHAR, task.getDatabaseSetName());
        parameters.set(i++, "class_name", Types.VARCHAR, task.getClass_name());
        parameters.set(i++, "method_name", Types.VARCHAR, task.getMethod_name());
        builder.mapWith(genTaskByFreeSqlRowMapper).requireFirst().nullable();
        DalHints hints = DalHints.createIfAbsent(null).allowPartial();
        GenTaskByFreeSql entity = queryDao.query(builder, parameters, hints);
        if (entity != null)
            return 0;
    }
    FreeUpdateSqlBuilder builder = new FreeUpdateSqlBuilder(dbCategory);
    StringBuilder sb = new StringBuilder();
    sb.append("UPDATE task_sql SET project_id=?, db_name=?,class_name=?,pojo_name=?,");
    sb.append("method_name=?,crud_type=?,sql_content=?,parameters=?,`generated`=?,");
    sb.append("version=version+1,update_user_no=?,update_time=?,comment=?,");
    sb.append("scalarType=?,pojoType=?,pagination=?,sql_style=?,approved=?,approveMsg=?,hints=? ");
    sb.append(" WHERE id=? AND version=?");
    builder.setTemplate(sb.toString());
    StatementParameters parameters = new StatementParameters();
    int i = 1;
    parameters.set(i++, "project_id", Types.INTEGER, task.getProject_id());
    parameters.set(i++, "db_name", Types.VARCHAR, task.getDatabaseSetName());
    parameters.set(i++, "class_name", Types.VARCHAR, task.getClass_name());
    parameters.set(i++, "pojo_name", Types.VARCHAR, task.getPojo_name());
    parameters.set(i++, "method_name", Types.VARCHAR, task.getMethod_name());
    parameters.set(i++, "crud_type", Types.VARCHAR, task.getCrud_type());
    parameters.set(i++, "sql_content", Types.LONGVARCHAR, task.getSql_content());
    parameters.set(i++, "parameters", Types.LONGVARCHAR, task.getParameters());
    parameters.set(i++, "generated", Types.BIT, task.getGenerated());
    parameters.set(i++, "update_user_no", Types.VARCHAR, task.getUpdate_user_no());
    parameters.set(i++, "update_time", Types.TIMESTAMP, task.getUpdate_time());
    parameters.set(i++, "comment", Types.LONGVARCHAR, task.getComment());
    parameters.set(i++, "scalarType", Types.VARCHAR, task.getScalarType());
    parameters.set(i++, "pojoType", Types.VARCHAR, task.getPojoType());
    parameters.set(i++, "pagination", Types.BIT, task.getPagination());
    parameters.set(i++, "sql_style", Types.VARCHAR, task.getSql_style());
    parameters.set(i++, "approved", Types.INTEGER, task.getApproved());
    parameters.set(i++, "approveMsg", Types.LONGVARCHAR, task.getApproveMsg());
    parameters.set(i++, "hints", Types.VARCHAR, task.getHints());
    // parameters.set(i++, "length", Types.TINYINT, task.getLength());
    parameters.set(i++, "id", Types.INTEGER, task.getId());
    parameters.set(i++, "version", Types.INTEGER, task.getVersion());
    DalHints hints = DalHints.createIfAbsent(null);
    return queryDao.update(builder, parameters, hints);
}