public class org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter extends java.lang.Object
{
private final org.apache.nifi.processors.standard.db.DatabaseAdapter db;
public void <init>()
{
org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter v;
org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter;
specialinvoke v.<java.lang.Object: void <init>()>();
v = new org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter;
specialinvoke v.<org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter: void <init>()>();
v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db> = v;
return;
}
public void testGeneration()
{
org.apache.nifi.processors.standard.db.DatabaseAdapter v, v, v, v;
java.lang.String v, v, v, v;
org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter;
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long)>("database.tablename", "some(set),of(columns),that,might,contain,methods,a.*", "", "", null, null);
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT some(set),of(columns),that,might,contain,methods,a.* FROM database.tablename", v);
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long)>("database.tablename", "some(set),of(columns),that,might,contain,methods,a.*", "that=\'some\"\' value\'", "", null, null);
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT some(set),of(columns),that,might,contain,methods,a.* FROM database.tablename WHERE that=\'some\"\' value\'", v);
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long)>("database.tablename", "some(set),of(columns),that,might,contain,methods,a.*", "that=\'some\"\' value\'", "might DESC", null, null);
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT some(set),of(columns),that,might,contain,methods,a.* FROM database.tablename WHERE that=\'some\"\' value\' ORDER BY might DESC", v);
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long)>("database.tablename", "", "that=\'some\"\' value\'", "might DESC", null, null);
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT * FROM database.tablename WHERE that=\'some\"\' value\' ORDER BY might DESC", v);
return;
}
public void testNoTableName()
{
org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter v;
org.junit.jupiter.api.function.Executable v;
v := @this: org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter;
v = staticinvoke <org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter$lambda_testNoTableName_0__276: org.junit.jupiter.api.function.Executable bootstrap$(org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter)>(v);
staticinvoke <org.junit.jupiter.api.Assertions: java.lang.Throwable assertThrows(java.lang.Class,org.junit.jupiter.api.function.Executable)>(class "Ljava/lang/IllegalArgumentException;", v);
return;
}
public void testTOPQuery()
{
org.apache.nifi.processors.standard.db.DatabaseAdapter v, v, v;
java.lang.Long v, v, v;
java.lang.String v, v, v;
org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter;
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(100L);
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long)>("database.tablename", "some(set),of(columns),that,might,contain,methods,a.*", "", "", v, null);
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT TOP 100 some(set),of(columns),that,might,contain,methods,a.* FROM database.tablename", v);
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(100L);
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long)>("database.tablename", "some(set),of(columns),that,might,contain,methods,a.*", "", "contain", v, null);
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT TOP 100 some(set),of(columns),that,might,contain,methods,a.* FROM database.tablename ORDER BY contain", v);
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(123456L);
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long)>("database.tablename", "", "that=\'some\"\' value\'", "might DESC", v, null);
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT TOP 123456 * FROM database.tablename WHERE that=\'some\"\' value\' ORDER BY might DESC", v);
return;
}
public void testPagingQuery()
{
org.apache.nifi.processors.standard.db.DatabaseAdapter v, v, v;
java.lang.Long v, v, v, v, v, v;
java.lang.String v, v, v;
org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter;
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(100L);
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(0L);
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long)>("database.tablename", "some(set),of(columns),that,might,contain,methods,a.*", "", "contain", v, v);
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT * FROM (SELECT TOP 100 some(set),of(columns),that,might,contain,methods,a.*, ROW_NUMBER() OVER(ORDER BY contain asc) rnum FROM database.tablename ORDER BY contain) A WHERE rnum > 0 AND rnum <= 100", v);
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(10000L);
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(123456L);
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long)>("database.tablename", "some(set),of(columns),that,might,contain,methods,a.*", "", "contain", v, v);
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT * FROM (SELECT TOP 133456 some(set),of(columns),that,might,contain,methods,a.*, ROW_NUMBER() OVER(ORDER BY contain asc) rnum FROM database.tablename ORDER BY contain) A WHERE rnum > 123456 AND rnum <= 133456", v);
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(10000L);
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(123456L);
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long)>("database.tablename", "some(set),of(columns),that,might,contain,methods,a.*", "methods=\'strange\'", "contain", v, v);
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT * FROM (SELECT TOP 133456 some(set),of(columns),that,might,contain,methods,a.*, ROW_NUMBER() OVER(ORDER BY contain asc) rnum FROM database.tablename WHERE methods=\'strange\' ORDER BY contain) A WHERE rnum > 123456 AND rnum <= 133456", v);
return;
}
public void testPagingQueryUsingColumnValuesForPartitioning()
{
java.lang.Long v, v, v, v, v, v, v;
java.lang.String v, v, v, v;
org.apache.nifi.processors.standard.db.DatabaseAdapter v, v, v, v;
org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter;
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(100L);
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(0L);
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long,java.lang.String)>("database.tablename", "some(set),of(columns),that,might,contain,methods,a.*", "1=1", "contain", v, v, "contain");
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT some(set),of(columns),that,might,contain,methods,a.* FROM database.tablename WHERE 1=1 AND contain >= 0 AND contain < 100", v);
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(10000L);
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(123456L);
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long,java.lang.String)>("database.tablename", "some(set),of(columns),that,might,contain,methods,a.*", "1=1", "contain", v, v, "contain");
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT some(set),of(columns),that,might,contain,methods,a.* FROM database.tablename WHERE 1=1 AND contain >= 123456 AND contain < 133456", v);
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(10000L);
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(123456L);
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long,java.lang.String)>("database.tablename", "some(set),of(columns),that,might,contain,methods,a.*", "methods=\'strange\'", "contain", v, v, "contain");
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT some(set),of(columns),that,might,contain,methods,a.* FROM database.tablename WHERE methods=\'strange\' AND contain >= 123456 AND contain < 133456", v);
v = v.<org.apache.nifi.processors.standard.db.impl.TestMSSQL2008DatabaseAdapter: org.apache.nifi.processors.standard.db.DatabaseAdapter db>;
v = staticinvoke <java.lang.Long: java.lang.Long valueOf(long)>(100L);
v = interfaceinvoke v.<org.apache.nifi.processors.standard.db.DatabaseAdapter: java.lang.String getSelectStatement(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Long,java.lang.Long,java.lang.String)>("database.tablename", "some(set),of(columns),that,might,contain,methods,a.*", "", "", v, null, "contain");
staticinvoke <org.junit.jupiter.api.Assertions: void assertEquals(java.lang.Object,java.lang.Object)>("SELECT some(set),of(columns),that,might,contain,methods,a.* FROM database.tablename", v);
return;
}
}