class org.hsqldb.util.PostgresTransferHelper extends org.hsqldb.util.TransferHelper
minor version: 0
major version: 59
flags: flags: (0x0020) ACC_SUPER
this_class: org.hsqldb.util.PostgresTransferHelper
super_class: org.hsqldb.util.TransferHelper
{
private final int PostgreSQL;
descriptor: I
flags: (0x0012) ACC_PRIVATE, ACC_FINAL
ConstantValue: 0
private final int HSQLDB;
descriptor: I
flags: (0x0012) ACC_PRIVATE, ACC_FINAL
ConstantValue: 1
java.lang.String[][] Funcs;
descriptor: [[Ljava/lang/String;
flags: (0x0000)
void <init>();
descriptor: ()V
flags: (0x0000)
Code:
stack=8, locals=1, args_size=1
start local 0 0: aload 0
invokespecial org.hsqldb.util.TransferHelper.<init>:()V
1: aload 0
iconst_0
putfield org.hsqldb.util.PostgresTransferHelper.PostgreSQL:I
2: aload 0
iconst_1
putfield org.hsqldb.util.PostgresTransferHelper.HSQLDB:I
3: aload 0
iconst_1
anewarray java.lang.String[]
dup
iconst_0
4: iconst_2
anewarray java.lang.String
dup
iconst_0
5: ldc "now()"
aastore
dup
iconst_1
ldc "'now'"
aastore
aastore
putfield org.hsqldb.util.PostgresTransferHelper.Funcs:[[Ljava/lang/String;
6: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 7 0 this Lorg/hsqldb/util/PostgresTransferHelper;
void <init>(org.hsqldb.util.TransferDb, org.hsqldb.util.Traceable, java.lang.String);
descriptor: (Lorg/hsqldb/util/TransferDb;Lorg/hsqldb/util/Traceable;Ljava/lang/String;)V
flags: (0x0000)
Code:
stack=8, locals=4, args_size=4
start local 0 start local 1 start local 2 start local 3 0: aload 0
aload 1
aload 2
aload 3
invokespecial org.hsqldb.util.TransferHelper.<init>:(Lorg/hsqldb/util/TransferDb;Lorg/hsqldb/util/Traceable;Ljava/lang/String;)V
1: aload 0
iconst_0
putfield org.hsqldb.util.PostgresTransferHelper.PostgreSQL:I
2: aload 0
iconst_1
putfield org.hsqldb.util.PostgresTransferHelper.HSQLDB:I
3: aload 0
iconst_1
anewarray java.lang.String[]
dup
iconst_0
4: iconst_2
anewarray java.lang.String
dup
iconst_0
5: ldc "now()"
aastore
dup
iconst_1
ldc "'now'"
aastore
aastore
putfield org.hsqldb.util.PostgresTransferHelper.Funcs:[[Ljava/lang/String;
6: return
end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 7 0 this Lorg/hsqldb/util/PostgresTransferHelper;
0 7 1 database Lorg/hsqldb/util/TransferDb;
0 7 2 t Lorg/hsqldb/util/Traceable;
0 7 3 q Ljava/lang/String;
MethodParameters:
Name Flags
database
t
q
int convertToType(int);
descriptor: (I)I
flags: (0x0000)
Code:
stack=2, locals=2, args_size=2
start local 0 start local 1 0: iload 1
iconst_3
if_icmpne 3
1: iconst_2
istore 1
2: aload 0
getfield org.hsqldb.util.PostgresTransferHelper.tracer:Lorg/hsqldb/util/Traceable;
ldc "Converted DECIMAL to NUMERIC"
invokeinterface org.hsqldb.util.Traceable.trace:(Ljava/lang/String;)V
3: StackMap locals:
StackMap stack:
iload 1
ireturn
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 4 0 this Lorg/hsqldb/util/PostgresTransferHelper;
0 4 1 type I
MethodParameters:
Name Flags
type
java.lang.String fixupColumnDefRead(org.hsqldb.util.TransferTable, java.sql.ResultSetMetaData, java.lang.String, java.sql.ResultSet, int);
descriptor: (Lorg/hsqldb/util/TransferTable;Ljava/sql/ResultSetMetaData;Ljava/lang/String;Ljava/sql/ResultSet;I)Ljava/lang/String;
flags: (0x0000)
Code:
stack=5, locals=13, args_size=6
start local 0 start local 1 start local 2 start local 3 start local 4 start local 5 0: new java.lang.String
dup
new java.lang.StringBuilder
dup
ldc "_"
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 4
iconst_4
invokeinterface java.sql.ResultSet.getString:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc "_seq"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokespecial java.lang.String.<init>:(Ljava/lang/String;)V
astore 6
start local 6 1: bipush 31
aload 6
invokevirtual java.lang.String.length:()I
isub
istore 7
start local 7 2: aload 1
getfield org.hsqldb.util.TransferTable.Stmts:Lorg/hsqldb/util/SQLStatements;
getfield org.hsqldb.util.SQLStatements.sDestTable:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
iload 7
if_icmple 5
3: new java.lang.StringBuilder
dup
aload 1
getfield org.hsqldb.util.TransferTable.Stmts:Lorg/hsqldb/util/SQLStatements;
getfield org.hsqldb.util.SQLStatements.sDestTable:Ljava/lang/String;
iconst_0
iload 7
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 6
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 6
4: goto 6
5: StackMap locals: java.lang.String int
StackMap stack:
new java.lang.StringBuilder
dup
aload 1
getfield org.hsqldb.util.TransferTable.Stmts:Lorg/hsqldb/util/SQLStatements;
getfield org.hsqldb.util.SQLStatements.sDestTable:Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 6
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 6
6: StackMap locals:
StackMap stack:
new java.lang.StringBuilder
dup
ldc "nextval('\""
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 6
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc "\"'"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 8
start local 8 7: aload 3
aload 8
invokevirtual java.lang.String.indexOf:(Ljava/lang/String;)I
iflt 9
8: ldc "SERIAL"
astore 3
9: StackMap locals: java.lang.String
StackMap stack:
iconst_0
istore 9
start local 9 10: goto 23
11: StackMap locals: int
StackMap stack:
aload 0
getfield org.hsqldb.util.PostgresTransferHelper.Funcs:[[Ljava/lang/String;
iload 9
aaload
iconst_0
aaload
astore 10
start local 10 12: aload 3
aload 10
invokevirtual java.lang.String.indexOf:(Ljava/lang/String;)I
istore 11
start local 11 13: iload 11
iflt 22
14: aload 3
iconst_0
iload 11
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
astore 12
start local 12 15: new java.lang.StringBuilder
dup
aload 12
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.hsqldb.util.PostgresTransferHelper.Funcs:[[Ljava/lang/String;
iload 9
aaload
iconst_1
aaload
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 12
16: new java.lang.StringBuilder
dup
aload 12
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
17: aload 3
iload 11
18: aload 10
invokevirtual java.lang.String.length:()I
iadd
19: invokevirtual java.lang.String.substring:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
20: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 12
21: aload 12
astore 3
end local 12 end local 11 end local 10 22: StackMap locals:
StackMap stack:
iinc 9 1
StackMap locals:
StackMap stack:
23: iload 9
aload 0
getfield org.hsqldb.util.PostgresTransferHelper.Funcs:[[Ljava/lang/String;
arraylength
if_icmplt 11
end local 9 24: aload 3
areturn
end local 8 end local 7 end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 25 0 this Lorg/hsqldb/util/PostgresTransferHelper;
0 25 1 t Lorg/hsqldb/util/TransferTable;
0 25 2 meta Ljava/sql/ResultSetMetaData;
0 25 3 columnType Ljava/lang/String;
0 25 4 columnDesc Ljava/sql/ResultSet;
0 25 5 columnIndex I
1 25 6 SeqName Ljava/lang/String;
2 25 7 spaceleft I
7 25 8 CompareString Ljava/lang/String;
10 24 9 Idx I
12 22 10 PostgreSQL_func Ljava/lang/String;
13 22 11 iStartPos I
15 22 12 NewColumnType Ljava/lang/String;
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
t
meta
columnType
columnDesc
columnIndex
java.lang.String fixupColumnDefWrite(org.hsqldb.util.TransferTable, java.sql.ResultSetMetaData, java.lang.String, java.sql.ResultSet, int);
descriptor: (Lorg/hsqldb/util/TransferTable;Ljava/sql/ResultSetMetaData;Ljava/lang/String;Ljava/sql/ResultSet;I)Ljava/lang/String;
flags: (0x0000)
Code:
stack=5, locals=10, args_size=6
start local 0 start local 1 start local 2 start local 3 start local 4 start local 5 0: aload 3
ldc "SERIAL"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 13
1: new java.lang.String
dup
new java.lang.StringBuilder
dup
ldc "_"
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 4
iconst_4
invokeinterface java.sql.ResultSet.getString:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
2: ldc "_seq"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
3: invokespecial java.lang.String.<init>:(Ljava/lang/String;)V
astore 6
start local 6 4: bipush 31
aload 6
invokevirtual java.lang.String.length:()I
isub
istore 7
start local 7 5: aload 1
getfield org.hsqldb.util.TransferTable.Stmts:Lorg/hsqldb/util/SQLStatements;
getfield org.hsqldb.util.SQLStatements.sDestTable:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
iload 7
if_icmple 10
6: new java.lang.StringBuilder
dup
aload 1
getfield org.hsqldb.util.TransferTable.Stmts:Lorg/hsqldb/util/SQLStatements;
getfield org.hsqldb.util.SQLStatements.sDestTable:Ljava/lang/String;
iconst_0
iload 7
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
7: aload 6
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
8: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 6
9: goto 11
10: StackMap locals: java.lang.String int
StackMap stack:
new java.lang.StringBuilder
dup
aload 1
getfield org.hsqldb.util.TransferTable.Stmts:Lorg/hsqldb/util/SQLStatements;
getfield org.hsqldb.util.SQLStatements.sDestTable:Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 6
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 6
11: StackMap locals:
StackMap stack:
new java.lang.StringBuilder
dup
ldc "DROP SEQUENCE "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 6
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc ";"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 8
start local 8 12: aload 1
getfield org.hsqldb.util.TransferTable.Stmts:Lorg/hsqldb/util/SQLStatements;
dup
getfield org.hsqldb.util.SQLStatements.sDestDrop:Ljava/lang/String;
new java.lang.StringBuilder
dup_x1
swap
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 8
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
putfield org.hsqldb.util.SQLStatements.sDestDrop:Ljava/lang/String;
end local 8 end local 7 end local 6 13: StackMap locals:
StackMap stack:
iconst_0
istore 6
start local 6 14: goto 25
15: StackMap locals: int
StackMap stack:
aload 0
getfield org.hsqldb.util.PostgresTransferHelper.Funcs:[[Ljava/lang/String;
iload 6
aaload
iconst_1
aaload
astore 7
start local 7 16: aload 3
aload 7
invokevirtual java.lang.String.indexOf:(Ljava/lang/String;)I
istore 8
start local 8 17: iload 8
iflt 24
18: aload 3
iconst_0
iload 8
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
astore 9
start local 9 19: new java.lang.StringBuilder
dup
aload 9
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.hsqldb.util.PostgresTransferHelper.Funcs:[[Ljava/lang/String;
iload 6
aaload
iconst_0
aaload
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 9
20: new java.lang.StringBuilder
dup
aload 9
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 3
iload 8
21: aload 7
invokevirtual java.lang.String.length:()I
iadd
22: invokevirtual java.lang.String.substring:(I)Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 9
23: aload 9
astore 3
end local 9 end local 8 end local 7 24: StackMap locals:
StackMap stack:
iinc 6 1
StackMap locals:
StackMap stack:
25: iload 6
aload 0
getfield org.hsqldb.util.PostgresTransferHelper.Funcs:[[Ljava/lang/String;
arraylength
if_icmplt 15
end local 6 26: aload 3
areturn
end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 27 0 this Lorg/hsqldb/util/PostgresTransferHelper;
0 27 1 t Lorg/hsqldb/util/TransferTable;
0 27 2 meta Ljava/sql/ResultSetMetaData;
0 27 3 columnType Ljava/lang/String;
0 27 4 columnDesc Ljava/sql/ResultSet;
0 27 5 columnIndex I
4 13 6 SeqName Ljava/lang/String;
5 13 7 spaceleft I
12 13 8 DropSequence Ljava/lang/String;
14 26 6 Idx I
16 24 7 HSQLDB_func Ljava/lang/String;
17 24 8 iStartPos I
19 24 9 NewColumnType Ljava/lang/String;
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
t
meta
columnType
columnDesc
columnIndex
void beginDataTransfer();
descriptor: ()V
flags: (0x0000)
Code:
stack=2, locals=1, args_size=1
start local 0 0: aload 0
getfield org.hsqldb.util.PostgresTransferHelper.db:Lorg/hsqldb/util/TransferDb;
iconst_0
invokevirtual org.hsqldb.util.TransferDb.setAutoCommit:(Z)V
1: goto 3
StackMap locals:
StackMap stack: java.lang.Exception
2: pop
3: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 4 0 this Lorg/hsqldb/util/PostgresTransferHelper;
Exception table:
from to target type
0 1 2 Class java.lang.Exception
void endDataTransfer();
descriptor: ()V
flags: (0x0000)
Code:
stack=2, locals=1, args_size=1
start local 0 0: aload 0
getfield org.hsqldb.util.PostgresTransferHelper.db:Lorg/hsqldb/util/TransferDb;
invokevirtual org.hsqldb.util.TransferDb.commit:()V
1: aload 0
getfield org.hsqldb.util.PostgresTransferHelper.db:Lorg/hsqldb/util/TransferDb;
ldc "VACUUM ANALYZE"
invokevirtual org.hsqldb.util.TransferDb.execute:(Ljava/lang/String;)Z
pop
2: goto 4
StackMap locals:
StackMap stack: java.lang.Exception
3: pop
4: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 5 0 this Lorg/hsqldb/util/PostgresTransferHelper;
Exception table:
from to target type
0 2 3 Class java.lang.Exception
}
SourceFile: "PostgresTransferHelper.java"