本文整理汇总了Java中liquibase.executor.Executor.queryForList方法的典型用法代码示例。如果您正苦于以下问题:Java Executor.queryForList方法的具体用法?Java Executor.queryForList怎么用?Java Executor.queryForList使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类liquibase.executor.Executor
的用法示例。
在下文中一共展示了Executor.queryForList方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: getViewDefinition
import liquibase.executor.Executor; //导入方法依赖的package包/类
@Override
public String getViewDefinition(String schemaName, String viewName) throws DatabaseException {
GetViewDefinitionStatement statement = new GetViewDefinitionStatement(convertRequestedSchemaToSchema(schemaName), viewName);
Executor executor = ExecutorService.getInstance().getExecutor(this);
@SuppressWarnings("unchecked")
List<String> definitionRows = (List<String>) executor.queryForList(statement, String.class);
StringBuilder definition = new StringBuilder();
for (String d : definitionRows) {
definition.append(d);
}
return definition.toString();
}
示例2: test
import liquibase.executor.Executor; //导入方法依赖的package包/类
@Test
public void test() throws Exception {
final List<String> expected = Arrays.asList(
"iftableexists", "iftablenotexists", "ifviewexists", "ifviewnotexists",
"ifindexexists1", "ifindexexists2", "ifindexnotexists1", "ifpkexists",
"ifpknotexists", "iffkexists", "iffknotexists", "ifsequenceexists",
"ifsequencenotexists"
);
Executor executor = ExecutorService.getInstance().getExecutor( liquiBase.getDatabase() );
List<String> successes = executor.queryForList( new RawSqlStatement( "select * from testresults" ), String.class );
assertTrue( successes.containsAll( expected ) );
}
示例3: generateChildren
import liquibase.executor.Executor; //导入方法依赖的package包/类
private void generateChildren(Database database) {
// Make a new list
childDropChanges = new ArrayList<DropForeignKeyConstraintChange>();
Executor executor = ExecutorService.getInstance().getExecutor(database);
FindForeignKeyConstraintsStatement sql = new FindForeignKeyConstraintsStatement(
getBaseTableSchemaName(),
getBaseTableName()
);
try {
List<Map> results = executor.queryForList(sql);
Set<String> handledConstraints = new HashSet<String>();
if (results != null && results.size() > 0) {
for (Map result : results) {
String baseTableName =
(String) result.get(FindForeignKeyConstraintsStatement.RESULT_COLUMN_BASE_TABLE_NAME);
String constraintName =
(String) result.get(FindForeignKeyConstraintsStatement.RESULT_COLUMN_CONSTRAINT_NAME);
if (getBaseTableName().equalsIgnoreCase(baseTableName)) {
if( !handledConstraints.contains(constraintName)) {
DropForeignKeyConstraintChange dropForeignKeyConstraintChange =
new DropForeignKeyConstraintChange();
dropForeignKeyConstraintChange.setBaseTableSchemaName(getBaseTableSchemaName());
dropForeignKeyConstraintChange.setBaseTableName(baseTableName);
dropForeignKeyConstraintChange.setConstraintName(constraintName);
childDropChanges.add(dropForeignKeyConstraintChange);
handledConstraints.add(constraintName);
}
} else {
throw new IllegalStateException("Expected to return only foreign keys for base table name: " +
getBaseTableName() + " and got results for table: " + baseTableName);
}
}
}
} catch (DatabaseException e) {
throw new UnexpectedLiquibaseException("Failed to find foreign keys for table: " + getBaseTableName(), e);
}
}