public class org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter extends java.lang.Object implements org.apache.nifi.processors.standard.db.DatabaseAdapter
{
public void <init>()
{
org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter;
specialinvoke v.<java.lang.Object: void <init>()>();
return;
}
public java.lang.String getName()
{
org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter;
return "MS SQL 2012+";
}
public java.lang.String getDescription()
{
org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter;
return "Generates MS SQL Compatible SQL, for version 2012 or greater";
}
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.MSSQLDatabaseAdapter v;
java.lang.Long v, v;
java.lang.String v, v, v, v, v;
v := @this: org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter;
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.MSSQLDatabaseAdapter: 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)
{
org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter v;
long v, v, v, v;
byte v;
java.lang.Long v, v;
java.lang.String v, v, v, v, v, v, v;
boolean v, v, v, v, v, v, v, v, v, v;
java.lang.IllegalArgumentException v, v;
java.lang.Comparable v;
java.lang.StringBuilder v;
v := @this: org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter;
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 ");
if v == null goto label;
if v != null goto label;
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)>("TOP ");
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)>(" ");
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:
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);
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)>(" 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;
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)>(" ORDER BY ");
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
label:
v = staticinvoke <org.apache.commons.lang.StringUtils: boolean isEmpty(java.lang.CharSequence)>(v);
if v == 0 goto label;
if v == null goto label;
if v == null goto label;
v = virtualinvoke v.<java.lang.Long: long longValue()>();
v = v cmp 0L;
if v <= 0 goto label;
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)>("Order by clause cannot be null or empty when using row paging");
throw v;
label:
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" OFFSET ");
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)>(" ROWS");
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" FETCH NEXT ");
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)>(" ROWS ONLY");
label:
v = virtualinvoke v.<java.lang.StringBuilder: java.lang.String toString()>();
return v;
}
public java.lang.String unwrapIdentifier(java.lang.String)
{
org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter v;
java.lang.String v, v;
v := @this: org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter;
v := @parameter: java.lang.String;
if v != null goto label;
v = null;
goto label;
label:
v = virtualinvoke v.<java.lang.String: java.lang.String replaceAll(java.lang.String,java.lang.String)>("[\"\\[\\]]", "");
label:
return v;
}
public java.util.List getAlterTableStatements(java.lang.String, java.util.List, boolean, boolean)
{
org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter v;
java.util.ArrayList v;
int v, v;
java.lang.String v, v, v, v, v, v, v, v, v, v;
boolean v, v, v;
java.util.Iterator v;
java.util.List v, v;
java.lang.Object v;
java.lang.StringBuilder v, v, v, v, v, v, v, v;
v := @this: org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter;
v := @parameter: java.lang.String;
v := @parameter: java.util.List;
v := @parameter: boolean;
v := @parameter: boolean;
v = new java.util.ArrayList;
v = interfaceinvoke v.<java.util.List: int size()>();
specialinvoke v.<java.util.ArrayList: void <init>(int)>(v);
v = interfaceinvoke v.<java.util.List: java.util.Iterator iterator()>();
label:
v = interfaceinvoke v.<java.util.Iterator: boolean hasNext()>();
if v == 0 goto label;
v = interfaceinvoke v.<java.util.Iterator: java.lang.Object next()>();
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.ColumnDescription: int getDataType()>();
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter: java.lang.String getSQLForDataType(int)>(v);
specialinvoke v.<java.lang.StringBuilder: void <init>(java.lang.String)>("ADD ");
if v == 0 goto label;
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter: java.lang.String getColumnQuoteString()>();
goto label;
label:
v = "";
label:
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.ColumnDescription: java.lang.String getColumnName()>();
if v == 0 goto label;
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter: java.lang.String getColumnQuoteString()>();
goto label;
label:
v = "";
label:
v = dynamicinvoke "makeConcatWithConstants" <java.lang.String (java.lang.String,java.lang.String,java.lang.String,java.lang.String)>(v, v, v, v) <java.lang.invoke.StringConcatFactory: java.lang.invoke.CallSite makeConcatWithConstants(java.lang.invoke.MethodHandles$Lookup,java.lang.String,java.lang.invoke.MethodType,java.lang.String,java.lang.Object[])>("\u0001\u0001\u \u0001");
interfaceinvoke v.<java.util.List: boolean add(java.lang.Object)>(v);
goto label;
label:
v = new java.lang.StringBuilder;
specialinvoke v.<java.lang.StringBuilder: void <init>()>();
v = virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>("ALTER TABLE ");
if v == 0 goto label;
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter: java.lang.String getTableQuoteString()>();
goto label;
label:
v = "";
label:
v = virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
v = virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
if v == 0 goto label;
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.impl.MSSQLDatabaseAdapter: java.lang.String getTableQuoteString()>();
goto label;
label:
v = "";
label:
v = virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
v = virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" ");
v = staticinvoke <java.lang.String: java.lang.String join(java.lang.CharSequence,java.lang.Iterable)>(", ", v);
v = virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
v = virtualinvoke v.<java.lang.StringBuilder: java.lang.String toString()>();
v = staticinvoke <java.util.Collections: java.util.List singletonList(java.lang.Object)>(v);
return v;
}
}