public final class ActivityAudienceLoader extends java.lang.Object implements ImportLoader
Modifier and Type | Field and Description |
---|---|
static int |
bo_allows_ads |
static int |
bo_confirmed |
static int |
bo_paid |
static int |
bo_went |
static int |
de_data1 |
static int |
de_data2 |
static int |
de_data3 |
static int |
de_data4 |
static int |
de_data5 |
static int |
de_data6 |
static int |
de_data7 |
static int |
de_data8 |
static int |
de_data9 |
static int |
dt_confirmed |
static int |
dt_created |
static int |
dt_paid |
static int |
gu_activity |
static int |
gu_address |
static int |
gu_contact |
static int |
gu_list |
static int |
gu_writer |
static int |
id_data1 |
static int |
id_data2 |
static int |
id_data3 |
static int |
id_data4 |
static int |
id_data5 |
static int |
id_data6 |
static int |
id_data7 |
static int |
id_data8 |
static int |
id_data9 |
static int |
id_ref |
static int |
id_transact |
static int |
im_paid |
static int |
MODE_APPEND |
static int |
MODE_APPENDUPDATE |
static int |
NO_DUPLICATED_MAILS |
static int |
tp_billing |
static int |
tp_origin |
static int |
tx_data1 |
static int |
tx_data2 |
static int |
tx_data3 |
static int |
tx_data4 |
static int |
tx_data5 |
static int |
tx_data6 |
static int |
tx_data7 |
static int |
tx_data8 |
static int |
tx_data9 |
static int |
WRITE_ADDRESSES |
static int |
WRITE_COMPANIES |
static int |
WRITE_CONTACTS |
static int |
WRITE_LOOKUPS |
LOOUKP_TR_COLUMNS, LOOUKP_TR_COUNT, MODE_UPDATE
Constructor and Description |
---|
ActivityAudienceLoader() |
Modifier and Type | Method and Description |
---|---|
void |
close()
Close ImportLoader
Must be always called before ImportLoader is destroyed
|
int |
columnCount()
Get columns count
|
java.lang.String[] |
columnNames()
Get array of column names
|
java.lang.Object |
get(int iColumnIndex)
Get current value for a column given its index
|
java.lang.Object |
get(java.lang.String sColumnName)
Get current value for a column given its name
|
int |
getColumnIndex(java.lang.String sColumnName)
Get column index from its name
|
void |
prepare(java.sql.Connection oConn,
ColumnList oCols)
Prepare ImportLoader for repeated execution
|
void |
put(int iColumnIndex,
java.lang.Object oValue)
Put current value for a column
|
void |
put(java.lang.String sColumnName,
java.lang.Object oValue)
Put current value for a column
|
void |
setAllColumnsToNull()
Set all current values to null
|
void |
store(java.sql.Connection oConn,
java.lang.String sWorkArea,
int iFlags)
Store properties curently held in RAM into the database
|
void |
storeLine(java.sql.Connection oConn,
java.lang.String sWorkArea,
int iFlags,
java.lang.String sColNames,
char cColSep,
java.lang.String sColValues) |
public static int bo_allows_ads
public static int bo_confirmed
public static int bo_paid
public static int bo_went
public static int de_data1
public static int de_data2
public static int de_data3
public static int de_data4
public static int de_data5
public static int de_data6
public static int de_data7
public static int de_data8
public static int de_data9
public static int dt_confirmed
public static int dt_created
public static int dt_paid
public static int gu_activity
public static int gu_address
public static int gu_contact
public static int gu_list
public static int gu_writer
public static int id_data1
public static int id_data2
public static int id_data3
public static int id_data4
public static int id_data5
public static int id_data6
public static int id_data7
public static int id_data8
public static int id_data9
public static int id_ref
public static int id_transact
public static int im_paid
public static int tp_billing
public static int tp_origin
public static int tx_data1
public static int tx_data2
public static int tx_data3
public static int tx_data4
public static int tx_data5
public static int tx_data6
public static int tx_data7
public static int tx_data8
public static int tx_data9
public static final int MODE_APPEND
public static final int MODE_APPENDUPDATE
public static final int WRITE_LOOKUPS
public static final int WRITE_COMPANIES
public static final int WRITE_CONTACTS
public static final int WRITE_ADDRESSES
public static final int NO_DUPLICATED_MAILS
public int columnCount()
ImportLoader
columnCount
in interface ImportLoader
public java.lang.String[] columnNames() throws java.lang.IllegalStateException
ImportLoader
columnNames
in interface ImportLoader
java.lang.IllegalStateException
public java.lang.Object get(int iColumnIndex) throws java.lang.ArrayIndexOutOfBoundsException
ImportLoader
get
in interface ImportLoader
iColumnIndex
- int [0..columnCount()-1]java.lang.ArrayIndexOutOfBoundsException
public java.lang.Object get(java.lang.String sColumnName) throws java.lang.ArrayIndexOutOfBoundsException
ImportLoader
get
in interface ImportLoader
sColumnName
- Case insensitive Stringjava.lang.ArrayIndexOutOfBoundsException
- if no column with such name was foundpublic int getColumnIndex(java.lang.String sColumnName)
ImportLoader
getColumnIndex
in interface ImportLoader
sColumnName
- Stringpublic void put(int iColumnIndex, java.lang.Object oValue) throws java.lang.ArrayIndexOutOfBoundsException
ImportLoader
put
in interface ImportLoader
iColumnIndex
- int [0..columnCount()-1]oValue
- Objectjava.lang.ArrayIndexOutOfBoundsException
public void put(java.lang.String sColumnName, java.lang.Object oValue) throws java.lang.ArrayIndexOutOfBoundsException
ImportLoader
put
in interface ImportLoader
sColumnName
- String Column nameoValue
- Objectjava.lang.ArrayIndexOutOfBoundsException
public void setAllColumnsToNull()
ImportLoader
setAllColumnsToNull
in interface ImportLoader
public void prepare(java.sql.Connection oConn, ColumnList oCols) throws java.sql.SQLException
ImportLoader
prepare
in interface ImportLoader
oConn
- ConnectionoCols
- ColumnList List of columns that will be inserted or updated at the databasejava.sql.SQLException
public void close() throws java.sql.SQLException
ImportLoader
Close ImportLoader
Must be always called before ImportLoader is destroyedclose
in interface ImportLoader
java.sql.SQLException
public void store(java.sql.Connection oConn, java.lang.String sWorkArea, int iFlags) throws java.sql.SQLException, java.lang.IllegalArgumentException, java.lang.NullPointerException
store
in interface ImportLoader
oConn
- Opened JDBC connectionsWorkArea
- String GUID of WorkArea to which inserted data will belongiFlags
- int A boolean combination of {MODE_APPEND|MODE_APPENDUPDATE|WRITE_COMPANIES|WRITE_CONTACTS+WRITE_ADDRESSES|WRITE_LOOKUPS|NO_DUPLICATED_MAILS}java.sql.SQLException
java.lang.IllegalArgumentException
java.lang.NullPointerException
java.lang.ClassCastException
public void storeLine(java.sql.Connection oConn, java.lang.String sWorkArea, int iFlags, java.lang.String sColNames, char cColSep, java.lang.String sColValues) throws java.sql.SQLException, java.lang.IllegalArgumentException, java.lang.NullPointerException, java.text.ParseException, java.lang.NumberFormatException
java.sql.SQLException
java.lang.IllegalArgumentException
java.lang.NullPointerException
java.text.ParseException
java.lang.NumberFormatException