public class org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter extends org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter
{
public void <init>()
{
org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter;
specialinvoke v.<org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter: void <init>()>();
return;
}
public java.lang.String getName()
{
org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter;
return "MS SQL 2008";
}
public java.lang.String getDescription()
{
org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter;
return "Generates MS SQL Compatible SQL for version 2008";
}
public java.lang.String getSelectStatement(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.Long, java.lang.Long)
{
org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter v;
java.lang.Long v, v;
java.lang.String v, v, v, v, v;
v := @this: org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter;
v := @parameter: java.lang.String;
v := @parameter: java.lang.String;
v := @parameter: java.lang.String;
v := @parameter: java.lang.String;
v := @parameter: java.lang.Long;
v := @parameter: java.lang.Long;
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter: 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)>(v, v, v, v, v, v, null);
return v;
}
public 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)
{
byte v;
java.lang.Long v, v;
boolean v, v, v, v, v, v, v, v;
org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter v;
java.lang.StringBuilder v;
long v, v, v, v, v, v, v, v, v, v, v;
java.lang.String v, v, v, v, v, v, v;
java.lang.IllegalArgumentException v;
java.lang.Comparable v;
v := @this: org.apache.nifi.processors.standard.db.impl.MSSQL2008DatabaseAdapter;
v := @parameter: java.lang.String;
v := @parameter: java.lang.String;
v := @parameter: java.lang.String;
v := @parameter: java.lang.String;
v := @parameter: java.lang.Long;
v := @parameter: java.lang.Long;
v := @parameter: java.lang.String;
v = staticinvoke <org.apache.commons.lang.StringUtils: boolean isEmpty(java.lang.CharSequence)>(v);
if v == 0 goto label;
v = new java.lang.IllegalArgumentException;
specialinvoke v.<java.lang.IllegalArgumentException: void <init>(java.lang.String)>("Table name cannot be null or empty");
throw v;
label:
v = new java.lang.StringBuilder;
specialinvoke v.<java.lang.StringBuilder: void <init>(java.lang.String)>("SELECT ");
v = staticinvoke <org.apache.commons.lang.StringUtils: boolean isEmpty(java.lang.CharSequence)>(v);
if v != 0 goto label;
v = 1;
goto label;
label:
v = 0;
label:
v = v;
if v == null goto label;
if v != 0 goto label;
if v == null goto label;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>("* FROM (SELECT ");
label:
if v != null goto label;
v = 0L;
goto label;
label:
v = virtualinvoke v.<java.lang.Long: long longValue()>();
label:
v = virtualinvoke v.<java.lang.Long: long longValue()>();
v = v + v;
v = v cmp 0L;
if v <= 0 goto label;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>("TOP ");
v = virtualinvoke v.<java.lang.Long: long longValue()>();
v = v + v;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(long)>(v);
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" ");
label:
v = staticinvoke <org.apache.commons.lang.StringUtils: boolean isEmpty(java.lang.CharSequence)>(v);
if v != 0 goto label;
v = virtualinvoke v.<java.lang.String: java.lang.String trim()>();
v = virtualinvoke v.<java.lang.String: boolean equals(java.lang.Object)>("*");
if v == 0 goto label;
label:
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>("*");
goto label;
label:
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
label:
if v == null goto label;
if v == null goto label;
if v == null goto label;
if v != 0 goto label;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(", ROW_NUMBER() OVER(ORDER BY ");
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" asc) rnum");
label:
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" FROM ");
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
v = staticinvoke <org.apache.commons.lang.StringUtils: boolean isEmpty(java.lang.CharSequence)>(v);
if v != 0 goto label;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" WHERE ");
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
if v == 0 goto label;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" AND ");
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" >= ");
if v == null goto label;
v = v;
goto label;
label:
v = "0";
label:
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.Object)>(v);
if v == null goto label;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" AND ");
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" < ");
if v != null goto label;
v = 0L;
goto label;
label:
v = virtualinvoke v.<java.lang.Long: long longValue()>();
label:
v = virtualinvoke v.<java.lang.Long: long longValue()>();
v = v + v;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(long)>(v);
label:
v = staticinvoke <org.apache.commons.lang.StringUtils: boolean isEmpty(java.lang.CharSequence)>(v);
if v != 0 goto label;
if v != 0 goto label;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" ORDER BY ");
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
label:
if v == null goto label;
if v == null goto label;
if v != 0 goto label;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(") A WHERE rnum > ");
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.Object)>(v);
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" AND rnum <= ");
v = virtualinvoke v.<java.lang.Long: long longValue()>();
v = virtualinvoke v.<java.lang.Long: long longValue()>();
v = v + v;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(long)>(v);
label:
v = virtualinvoke v.<java.lang.StringBuilder: java.lang.String toString()>();
return v;
}
}