public class org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter extends java.lang.Object implements org.apache.nifi.processors.standard.db.DatabaseAdapter
{
public void <init>()
{
org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter;
specialinvoke v.<java.lang.Object: void <init>()>();
return;
}
public java.lang.String getName()
{
org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter;
return "Oracle";
}
public java.lang.String getDescription()
{
org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter;
return "Generates Oracle compliant SQL";
}
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.OracleDatabaseAdapter v;
java.lang.Long v, v;
java.lang.String v, v, v, v, v;
v := @this: org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter;
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.OracleDatabaseAdapter: 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)
{
java.lang.Long v, v;
boolean v, v, v, v, v, v, v, v, v, v, v, v;
org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter v;
java.lang.StringBuilder v;
long v, v, v, v, v, v;
java.lang.String v, v, v, v, v, v, v, v;
java.lang.IllegalArgumentException v;
java.lang.Comparable v;
v := @this: org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter;
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>()>();
if v != null goto label;
if v == null goto label;
label:
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 == 0 goto label;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>("SELECT ");
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 (SELECT a.*, ROWNUM rnum FROM (");
label:
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>("SELECT ");
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:
if v == 0 goto label;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(") a");
v = 0L;
if v == null goto label;
v = virtualinvoke v.<java.lang.Long: long longValue()>();
label:
if v == null goto label;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(" WHERE ROWNUM <= ");
v = virtualinvoke v.<java.lang.Long: long longValue()>();
v = v + v;
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(long)>(v);
label:
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(") WHERE rnum > ");
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(long)>(v);
label:
v = virtualinvoke v.<java.lang.StringBuilder: java.lang.String toString()>();
return v;
}
public java.lang.String getTableAliasClause(java.lang.String)
{
java.lang.String v;
org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter;
v := @parameter: java.lang.String;
return v;
}
public java.util.List getAlterTableStatements(java.lang.String, java.util.List, boolean, boolean)
{
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;
org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter v;
java.util.List v, v;
java.lang.Object v;
java.lang.StringBuilder v, v, v, v, v, v, v;
v := @this: org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter;
v := @parameter: java.lang.String;
v := @parameter: java.util.List;
v := @parameter: boolean;
v := @parameter: boolean;
v = new java.lang.StringBuilder;
specialinvoke v.<java.lang.StringBuilder: void <init>()>();
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.OracleDatabaseAdapter: java.lang.String getSQLForDataType(int)>(v);
if v == 0 goto label;
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter: 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.OracleDatabaseAdapter: 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 = 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.OracleDatabaseAdapter: 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.OracleDatabaseAdapter: 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)>(" ADD (");
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);
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(") ");
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;
}
public java.lang.String getSQLForDataType(int)
{
java.sql.JDBCType v;
int v;
java.lang.String v;
org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter;
v := @parameter: int;
lookupswitch(v)
{
case -16: goto label;
case -15: goto label;
case -9: goto label;
case -1: goto label;
case 1: goto label;
case 8: goto label;
case 12: goto label;
case 1111: goto label;
case 2005: goto label;
case 2009: goto label;
case 2011: goto label;
default: goto label;
};
label:
return "DOUBLE PRECISION";
label:
return "VARCHAR2(2000)";
label:
v = staticinvoke <java.sql.JDBCType: java.sql.JDBCType valueOf(int)>(v);
v = virtualinvoke v.<java.sql.JDBCType: java.lang.String getName()>();
return v;
}
public boolean supportsCreateTableIfNotExists()
{
org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter v;
v := @this: org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter;
return 1;
}
public java.lang.String getCreateTableStatement(org.apache.nifi.processors.standard.db.TableSchema, boolean, boolean)
{
int v, v, v;
java.lang.String v, v, v, v, v, v, v, v, v, v, v, v, v;
boolean v, v, v, v;
java.util.Set v;
org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter v;
java.util.List v;
org.apache.nifi.processors.standard.db.TableSchema v;
java.lang.Object v;
java.lang.StringBuilder v, v;
v := @this: org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter;
v := @parameter: org.apache.nifi.processors.standard.db.TableSchema;
v := @parameter: boolean;
v := @parameter: boolean;
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.TableSchema: java.lang.String getCatalogName()>();
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.TableSchema: java.lang.String getSchemaName()>();
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.TableSchema: java.lang.String getTableName()>();
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter: java.lang.String generateTableName(boolean,java.lang.String,java.lang.String,java.lang.String,org.apache.nifi.processors.standard.db.TableSchema)>(v, v, v, v, v);
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.TableSchema: java.util.List getColumnsAsList()>();
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.TableSchema: java.util.Set getPrimaryKeyColumnNames()>();
v = 0;
label:
v = interfaceinvoke v.<java.util.List: int size()>();
if v >= v goto label;
v = interfaceinvoke v.<java.util.List: java.lang.Object get(int)>(v);
if v == 0 goto label;
v = ", ";
goto label;
label:
v = "";
label:
if v == 0 goto label;
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter: 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.OracleDatabaseAdapter: java.lang.String getColumnQuoteString()>();
goto label;
label:
v = "";
label:
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.ColumnDescription: int getDataType()>();
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.impl.OracleDatabaseAdapter: java.lang.String getSQLForDataType(int)>(v);
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.ColumnDescription: boolean isNullable()>();
if v == 0 goto label;
v = "";
goto label;
label:
v = " NOT NULL";
label:
if v == null goto label;
v = virtualinvoke v.<org.apache.nifi.processors.standard.db.ColumnDescription: java.lang.String getColumnName()>();
v = interfaceinvoke v.<java.util.Set: boolean contains(java.lang.Object)>(v);
if v == 0 goto label;
v = " PRIMARY KEY";
goto label;
label:
v = "";
label:
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>(v);
v = v + 1;
goto label;
label:
virtualinvoke v.<java.lang.StringBuilder: java.lang.StringBuilder append(java.lang.String)>("NULL;\n\t\tELSE\n\t\t\tRAISE;\n\t\tEND IF;\nEND;");
v = dynamicinvoke "makeConcatWithConstants" <java.lang.String (java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String)>(v, v, v, 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[])>("DECLARE\n\tsql_stmt long;\nBEGIN\n\tsql_stmt:=\'CREATE TABLE \u (\u0001\u0001\u0001\u \u0001\u)\';\nEXECUTE IMMEDIATE sql_stmt;\nEXCEPTION\n\tWHEN OTHERS THEN\n\t\tIF SQLCODE = -955 THEN\n\t\t\t");
return v;
}
}