public class DatabaseWorker
extends java.lang.Object
| Modifier and Type | Field and Description |
|---|---|
static java.lang.String |
_Archived |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_Archived_TYPE |
static java.lang.String |
_DateInserted |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_DateInserted_TYPE |
static java.lang.String |
_DateTime |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_DateTime_TYPE |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_DateUpdate_TYPE |
static java.lang.String |
_DateUpdated |
static java.lang.String |
_DeletedInWebsite |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_DeletedInWebsite_TYPE |
static java.lang.String |
_Description |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_Description_TYPE |
static java.lang.String |
_Duration |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_Duration_TYPE |
static java.lang.String |
_EventDirectory |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_EventDirectory_TYPE |
static java.lang.String |
_EventName |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_EventName_TYPE |
static java.lang.String |
_Filter |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_Filter_TYPE |
static java.lang.String |
_ID |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_ID_TYPE |
static java.lang.String |
_InformID |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_InformID_TYPE |
static java.lang.String |
_InsertedBy |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_InsertedBy_TYPE |
static java.lang.String |
_Latitude |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_Latitude_TYPE |
static java.lang.String |
_Longitude |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_Longitude_TYPE |
static java.lang.String |
_MagnitudeI |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_MagnitudeI_TYPE |
static java.lang.String |
_MagnitudeR |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_MagnitudeR_TYPE |
static java.lang.String |
_Type |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_Type_TYPE |
static java.lang.String |
_UpdatedBy |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_UpdatedBy_TYPE |
static java.lang.String |
_Validated |
static esa.neliota.archiving.DatabaseWorker.FieldType |
_Validated_TYPE |
| Constructor and Description |
|---|
DatabaseWorker()
Class constructor.
|
| Modifier and Type | Method and Description |
|---|---|
int |
dbConnect()
Connects using default hardcoded username and password.
|
int |
dbConnect(java.lang.String connectStr,
java.lang.String username,
java.lang.String password)
Connects using the specified credentials.
|
void |
disconnect() |
java.lang.String |
getMessage() |
java.util.ArrayList<java.lang.String[]> |
getRecordByName(java.lang.String name)
Gets all records with the specified name.
|
java.util.ArrayList<java.lang.String[]> |
getRecords(java.util.ArrayList<java.lang.String> displayColumns,
java.util.ArrayList<java.lang.String[]> filters)
Executes a query for getting records from the database.
|
int |
insertRecord(java.lang.String name,
TimePoint dateTime,
boolean archived,
int informID,
java.util.ArrayList<java.lang.String[]> additional)
Inserts a new record to the database, with the least required fields and maybe additional ones.
|
boolean |
isConnected() |
boolean |
updateRecord(int id,
java.util.ArrayList<java.lang.String[]> fields)
Executes a query to update a record in the database.
|
public static final java.lang.String _EventName
public static final java.lang.String _ID
public static final java.lang.String _DateTime
public static final java.lang.String _Archived
public static final java.lang.String _Latitude
public static final java.lang.String _Longitude
public static final java.lang.String _EventDirectory
public static final java.lang.String _Validated
public static final java.lang.String _MagnitudeR
public static final java.lang.String _MagnitudeI
public static final java.lang.String _Duration
public static final java.lang.String _Description
public static final java.lang.String _Type
public static final java.lang.String _InformID
public static final java.lang.String _DeletedInWebsite
public static final java.lang.String _Filter
public static final java.lang.String _DateInserted
public static final java.lang.String _InsertedBy
public static final java.lang.String _DateUpdated
public static final java.lang.String _UpdatedBy
public static final esa.neliota.archiving.DatabaseWorker.FieldType _EventName_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _ID_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _DateTime_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _Archived_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _Latitude_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _Longitude_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _EventDirectory_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _Validated_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _MagnitudeR_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _MagnitudeI_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _Duration_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _Description_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _Type_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _InformID_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _DeletedInWebsite_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _Filter_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _DateInserted_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _InsertedBy_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _DateUpdate_TYPE
public static final esa.neliota.archiving.DatabaseWorker.FieldType _UpdatedBy_TYPE
public int dbConnect()
public int dbConnect(java.lang.String connectStr,
java.lang.String username,
java.lang.String password)
connectStr - username - password - public int insertRecord(java.lang.String name,
TimePoint dateTime,
boolean archived,
int informID,
java.util.ArrayList<java.lang.String[]> additional)
name - the name of the recorddateTime - the date and time of the eventarchived - if it has been archivedinformID - the id of the record on the website database, or -1 if it has not been iserted yetadditional - additional fields to be addedpublic java.util.ArrayList<java.lang.String[]> getRecordByName(java.lang.String name)
name - public java.util.ArrayList<java.lang.String[]> getRecords(java.util.ArrayList<java.lang.String> displayColumns,
java.util.ArrayList<java.lang.String[]> filters)
displayColumns - The array of columns to be displayed. If null or empty, all columns will be returned.filters - The array of name-value filters. Each element of the list must contain two String objects. All filters are connected via AND operator. If null or empty, no filters are applied.public boolean updateRecord(int id,
java.util.ArrayList<java.lang.String[]> fields)
id - the id of the record to be updatedfields - the array of name-value fields to be updated. Each element of the list must contain two String objects.public void disconnect()
public java.lang.String getMessage()
public boolean isConnected()