A B C E F G H I N P R S T U V

A

addNewiRowIdListener(NewRowIDListener) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Adds a NewRowIDListener to the list of listeners.
addNewRowIdChangeListener(NewRowIDListener) - Method in class fi.paatti.containers.ChoiceContainer
Adds a NewRowIDListener to the list of listeners.
addNewRowIdChangeListener(NewRowIDListener) - Method in class fi.paatti.containers.TaskContainer
Adds a NewRowIDListener to the list of listeners.
addScheduleToGroup(Object, Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Adds the schedule to the group.
addScheduleToGroup(Object, Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Adds the schedule to the group.
addUserGroup(UserGroup) - Method in class fi.paatti.paattidatabaseutils.dbobjects.User
Adds a new user group to the user.
addUserToGroup(Object, Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Adds the user to the group.
addUserToGroup(Object, Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Adds the user to the group.
ADMINISTERS - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
ADMINISTERS_description - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
ADMINISTERS_editTime - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
ADMINISTERS_EVENT_eventID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
ADMINISTERS_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
ADMINISTERS_USER_userID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 

B

BELONGS - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
BELONGS_editTime - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
BELONGS_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
BELONGS_USER_userID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
BELONGS_USERGROUP_usergroupID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
BelongsQueryDelegate - Class in fi.paatti.paattidatabaseutils.dbservice.querydelegates
A delegate for BELONGS-table.
BelongsQueryDelegate(Object, Object) - Constructor for class fi.paatti.paattidatabaseutils.dbservice.querydelegates.BelongsQueryDelegate
BelongsQueryDelegate constructor.
BINARYDATA - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
BINARYDATA_binarydataID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
BINARYDATA_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
BINARYDATA_sequence - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
BINARYDATA_TASKDATA_taskDataID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 

C

CHOICE - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
CHOICE_choiceID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
CHOICE_description - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
CHOICE_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
CHOICE_sequence - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
CHOICE_TASK_contains_taskID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
CHOICE_TASK_leadsto_taskID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
CHOICE_value - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
ChoiceContainer - Class in fi.paatti.containers
An extended SQLContainer has a possibility to add a listener for getting the new row ID after succesful insert to the database.
ChoiceContainer(FreeformQuery) - Constructor for class fi.paatti.containers.ChoiceContainer
Constructor.
ChoiceQueryDelegate - Class in fi.paatti.paattidatabaseutils.dbservice.querydelegates
A delegate for CHOICE-table.
ChoiceQueryDelegate(Object) - Constructor for class fi.paatti.paattidatabaseutils.dbservice.querydelegates.ChoiceQueryDelegate
Constructor.
createGroup(String, String, Object, Object, int, Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Saves the group's information to the database.
createGroup(String, String, Object, Object, int, Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Saves the group's information to the database.
createResearch(String, String, Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Saves the research's information to the database.
createResearch(String, String, Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Saves the research's information to the database.
createSchedule(String, Date, Object, IndexedContainer) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Creates a new schedule.
createSchedule(String, Date, Object, IndexedContainer) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Creates a new schedule.
createUser(Object, String, String, String, String, String) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Saves user's information to the database.
createUser(Object, String, String, String, String, String) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Saves user's information to the database.

E

EVENT - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
EVENT_description - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENT_estimatedTime - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENT_eventID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENT_EVENTTIME_eventTimeID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENT_EVENTTYPE_eventTypeID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENT_origEventID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENT_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENT_SCHEDULE_scheduleID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENT_status - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENT_title - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EventsInScheduleDelegate - Class in fi.paatti.paattidatabaseutils.dbservice.querydelegates
A delegate for combining the EVENTS and SCHEDULE table related queries.
EventsInScheduleDelegate(Object) - Constructor for class fi.paatti.paattidatabaseutils.dbservice.querydelegates.EventsInScheduleDelegate
Constructor.
EVENTSTATUS_eventStatusID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTSTATUS_status - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTIME - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
EVENTTIME_absolute - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTIME_day - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTIME_eventTimeID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTIME_fromHour - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTIME_hoursLeft - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTIME_minute - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTIME_month - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTIME_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTIME_week - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTIME_weekday - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTIME_year - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTYPE - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
EVENTTYPE_description - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTYPE_eventTypeID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
EVENTTYPE_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 

F

fi.paatti.containers - package fi.paatti.containers
 
fi.paatti.paattidatabaseutils.dbobjects - package fi.paatti.paattidatabaseutils.dbobjects
 
fi.paatti.paattidatabaseutils.dbservice - package fi.paatti.paattidatabaseutils.dbservice
 
fi.paatti.paattidatabaseutils.dbservice.querydelegates - package fi.paatti.paattidatabaseutils.dbservice.querydelegates
 
fi.paatti.paattidatabaseutils.names - package fi.paatti.paattidatabaseutils.names
 
fireNewRowIdEvent(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Fires an event after acquiring the new row ID from a succesful insert to the database.

G

getArrayAsStringWithAddedString(String[], String, String, boolean) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Creates a string from array adding the given string between arrays fields.
getArrayAsStringWithCommas(String[]) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Creates a String with all the column names from the given array.
getArrayAsStringWithCommasAndWithoutIdColumn(String[], String) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Creates a String with all the column names (except the id column) from the given array.
getCellValueFromTable(String, String, String, Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns the value of the given column.
getCellValueFromTable(String, String, String, Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiMobileDBService
Returns the value of the given column.
getCellValueFromTable(String, String, String, Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns the value of the given column.
getChoiceContainer(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns all the choices that belong to the event with the given id.
getChoiceContainer(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiMobileDBService
Returns all the choices that belong to the event with the given id.
getChoiceContainer(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns all the choices that belong to the event with the given id.
getChoiceContainerWithListener(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns the ChoiceContainer containing all the choices from the given event.
getChoiceContainerWithListener(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns the ChoiceContainer containing all the choices from the given event.
getChoiceID() - Method in class fi.paatti.paattidatabaseutils.dbobjects.TaskData
Returns the value of choiceID.
getChoiceSequence() - Method in class fi.paatti.paattidatabaseutils.dbobjects.TaskData
Returns the value of choiceSequence.
getColumnNames() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Returns the column names that are used in this delegate.
getColumnNames(String) - Static method in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
Returns the table column names as a list of strings.
getColumnNamesInArray(String) - Static method in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
Returns the table column names as a string array.
getContainsRowQueryStatement(Object...) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Inherited from FreeformStatementDelegate.
getContainsRowQueryString(Object...) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Inherited from FreeformStatementDelegate.
getCountQuery() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Inherited from FreeformStatementDelegate.
getCountStatement() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.ChoiceQueryDelegate
Returns the row count from the delegate's table.
getCountStatement() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.EventsInScheduleDelegate
Returns the row count from the delegate's table.
getCountStatement() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Returns the row count from the delegate's table.
getCountStatement() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.TaskQueryDelegate
Returns the row count from the delegate's table.
getEventsInSchedule(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns all the events that belong to the schedule with the given id.
getEventsInSchedule(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns all the events that belong to the schedule with the given id.
getFilters() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Returns the container filter list.
getFilterStringWithoutWhere(StatementHelper, boolean) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Creates a string from the list of filters, without the word 'WHERE'.
getGroupResearch(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns all the researches that belong to the group with the given id.
getGroupResearch(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns all the researches that belong to the group with the given id.
getGroupRole(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns the role of the given group.
getGroupRole(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns the role of the given group.
getGroupSchedules(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns all the schedules that belong to the group with the given id.
getGroupSchedules(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns all the schedules that belong to the group with the given id.
getGroupUsers(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns all the users that belong to the group with the given id.
getGroupUsers(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiMobileDBService
Returns all the users that belong to the group with the given id.
getGroupUsers(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns all the users that belong to the group with the given id.
getIdColumn() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Returns the column name that is used as the main table's id column.
getInsertQueryString(String, String, String[]) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Creates an insert query from the given parameters.
getInsertQueryString() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Uses the set tablename, id column and column names to create an insert string.
getNewRowId() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.NewRowIdEvent
Returns the new ID of the row.
getOrderBys() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Returns the sorting rules (order by) list.
getQueryStatement(int, int) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.BelongsQueryDelegate
Returns a new StatementHelper containing the SELECT query statement.
getQueryStatement(int, int) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.ChoiceQueryDelegate
Returns a new StatementHelper containing the SELECT query statement.
getQueryStatement(int, int) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.EventsInScheduleDelegate
Returns a new StatementHelper containing the SELECT query statement.
getQueryStatement(int, int) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.TaskQueryDelegate
Get the StatementHelper for the SELECT-query.
getQueryStatement(int, int) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.UserGroupRolesAndResearchDelegate
Returns a new StatementHelper containing the SELECT query statement.
getQueryStatement(int, int) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.UserUnfinishedEventsDelegate
Returns the SELECT-query.
getQueryStatement(int, int) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.VoluntaryEventsDelegate
Returns a new StatementHelper containing the SELECT query statement.
getQueryString(int, int) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Inherited from FreeformStatementDelegate.
getResearchGroups(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns all the groups that belong to the research with the given id.
getResearchGroups(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns all the groups that belong to the research with the given id.
getSQLContainerFromDBTable(String, String, boolean) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Queries the database for the given table and returns an SQLContainer containing the query results.
getSQLContainerFromDBTable(String, String, boolean) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiMobileDBService
Queries the database for the given table and returns an SQLContainer containing the query results.
getSQLContainerFromDBTable(String, String, boolean) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns the SQLContainer for the given database table.
getSQLContainerFromDBTableFiltered(String, String, boolean, Container.Filter) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Queries the database for the given table and returns an SQLContainer containing the query results.
getSQLContainerFromDBTableFiltered(String, String, boolean, Container.Filter) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiMobileDBService
Queries the database for the given table and returns an SQLContainer containing the query results.
getSQLContainerFromDBTableFiltered(String, String, boolean, Container.Filter) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns the SQLContainer for the given database table.
getTableName() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Returns the table name that is used as the delegate's "main" table.
getTaskContainer(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns all the tasks that belong to the event with the given id.
getTaskContainer(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiMobileDBService
Returns all the tasks that belong to the event with the given id.
getTaskContainer(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns all the tasks that belong to the event with the given id.
getTaskContainerWithListener(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns the TaskContainer containing all the tasks from the given event.
getTaskContainerWithListener(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns the TaskContainer containing all the tasks from the given event.
getUpdateQueryString(String, String, String[]) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Create an update String.
getUpdateQueryString() - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Uses the set tablename, id column and column names to create an update string.
getUserEventData(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns all the event data that belongs to the user with the given id.
getUserEventData(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiMobileDBService
Returns the event data from the user's finished events.
getUserEventData(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns all the event data that belongs to the user with the given id.
getUsergroupID() - Method in class fi.paatti.paattidatabaseutils.dbobjects.UserGroup
Returns the value of usergroupID.
getUsergroupResearchID() - Method in class fi.paatti.paattidatabaseutils.dbobjects.UserGroup
Returns the ID of the research that the group belongs to.
getUsergroupRoleID() - Method in class fi.paatti.paattidatabaseutils.dbobjects.UserGroup
Returns the value of userRoleID.
getUserGroups() - Method in class fi.paatti.paattidatabaseutils.dbobjects.User
Returns the user's groups.
getUserGroups(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns all the groups that belong to the user with the given id.
getUserGroups(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns all the groups that belong to the user with the given id.
getUserGroupsdRolesAndResearches(Integer) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns the roles and researches of the user's groups.
getUserGroupsdRolesAndResearches(Integer) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Returns the roles and researches of the user's groups.
getUserID() - Method in class fi.paatti.paattidatabaseutils.dbobjects.User
Returns the value of userID.
getUsername() - Method in class fi.paatti.paattidatabaseutils.dbobjects.User
Returns the value of username.
getUserUnfinishedEvents(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns all the available events for the user.
getUserUnfinishedEvents(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiMobileDBService
Returns all the available events for the user.
getUserVoluntaryEvents(Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Returns all the voluntary events that are assigned to the user.
getUserVoluntaryEvents(Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiMobileDBService
Returns all the voluntary events that are assigned to the user.
getValuesString(int) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Creates a string for inserting values.

H

hasRoleInAnyGroup(int) - Method in class fi.paatti.paattidatabaseutils.dbobjects.User
Checks if the user has the given role in any of his/her groups.
hasRoleInUserGRoup(int, int) - Method in class fi.paatti.paattidatabaseutils.dbobjects.User
Checks if the user has the given role in the given group.

I

isInUserGroup(int) - Method in class fi.paatti.paattidatabaseutils.dbobjects.User
Checks if the user belongs to a certain user group.

N

NewRowIDChangeEvent - Class in fi.paatti.paattidatabaseutils.dbservice.querydelegates
The event is used for acquiring a new row ID after a succesful insert to the database.
NewRowIDChangeEvent(Component, Object) - Constructor for class fi.paatti.paattidatabaseutils.dbservice.querydelegates.NewRowIDChangeEvent
Constructor.
NewRowIdEvent - Class in fi.paatti.paattidatabaseutils.dbservice.querydelegates
The event is used for acquiring a new row ID after a succesful insert to the database.
NewRowIdEvent(Object) - Constructor for class fi.paatti.paattidatabaseutils.dbservice.querydelegates.NewRowIdEvent
Constructor.
NewRowIDListener - Interface in fi.paatti.paattidatabaseutils.dbservice.querydelegates
The listener for NewRowID events.

P

PaattiColumnNames - Class in fi.paatti.paattidatabaseutils.names
The column names used by the application's database.
PaattiDBService - Class in fi.paatti.paattidatabaseutils.dbservice
The implementation of the interfaces PaattiResearchDBService and PaattiMobileDBService.
PaattiDBService(String, String, String, String) - Constructor for class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Constructor.
PaattiMobileDBService - Interface in fi.paatti.paattidatabaseutils.dbservice
The interface for the mobile client.
PaattiQueryDelegate - Class in fi.paatti.paattidatabaseutils.dbservice.querydelegates
A base class for all other delegates.
PaattiQueryDelegate(String, String, String[]) - Constructor for class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Constructor.
PaattiResearchDBService - Interface in fi.paatti.paattidatabaseutils.dbservice
The research interface for the database.
PaattiTableNames - Class in fi.paatti.paattidatabaseutils.names
The table names used by the application's database.

R

removeNewRowIdChangeListener(NewRowIDListener) - Method in class fi.paatti.containers.ChoiceContainer
Removes a NewRowIDListener from the list of listeners.
removeNewRowIdChangeListener(NewRowIDListener) - Method in class fi.paatti.containers.TaskContainer
Removes a NewRowIDListener from the list of listeners.
removeNewRowIdListener(NewRowIDListener) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Removes a NewRowIDListener from the list of listeners.
removeRow(Connection, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.BelongsQueryDelegate
Removes a row by setting its rowStatus to 'DELETED'.
removeRow(Connection, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Removes a row by setting its rowStatus to 'DELETED'.
removeRowFromTable(Object, String, String) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Removes the row from the table.
removeRowFromTable(Object, String, String) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Removes the row from the table.
removeUserFromGroup(Object, Object) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Removes the user from the group.
removeUserFromGroup(Object, Object) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiResearchDBService
Removes the user from the group.
RESEARCH - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
RESEARCH_description - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
RESEARCH_name - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
RESEARCH_researchID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
RESEARCH_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
ROLE - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
ROLE_description - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
ROLE_name - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
ROLE_roleID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
ROLE_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
rowIdChanged(NewRowIdEvent) - Method in interface fi.paatti.paattidatabaseutils.dbservice.querydelegates.NewRowIDListener
The new ID has been acquired from the succesful insert to the database.
ROWSTATUS_ACTIVE - Static variable in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
The status for active row.
ROWSTATUS_DELETED - Static variable in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
The status for deleted row.

S

saveEventTaskData(Object, Stack<TaskData>) - Method in class fi.paatti.paattidatabaseutils.dbservice.PaattiDBService
Saves all the data from a single event.
saveEventTaskData(Object, Stack<TaskData>) - Method in interface fi.paatti.paattidatabaseutils.dbservice.PaattiMobileDBService
Saves all the data from a single event.
SCHEDULE - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
SCHEDULE_description - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
SCHEDULE_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
SCHEDULE_scheduleID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
SCHEDULE_USERGROUP_usergroupID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
SCHEDULE_zeroTime - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
setChoiceID(Object) - Method in class fi.paatti.paattidatabaseutils.dbobjects.TaskData
Sets the value of choiceID.
setChoiceSequence(Object) - Method in class fi.paatti.paattidatabaseutils.dbobjects.TaskData
Sets the value of choiceSequence.
setFilters(List<Container.Filter>) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Sets the delegate's container filters.
setOrderBy(List<OrderBy>) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Sets the delegate's OrderBys.
setRowValues(PreparedStatement, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.BelongsQueryDelegate
Sets the values for the row.
setRowValues(PreparedStatement, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.ChoiceQueryDelegate
Sets the values for the row.
setRowValues(PreparedStatement, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.EventsInScheduleDelegate
Sets the values for the row.
setRowValues(PreparedStatement, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Sets the values for the row.
setRowValues(PreparedStatement, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.TaskQueryDelegate
Sets the values for the row.
setRowValues(PreparedStatement, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.UserGroupRolesAndResearchDelegate
Sets the values for the row.
setRowValues(PreparedStatement, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.UserUnfinishedEventsDelegate
Sets the values for the row.
setRowValues(PreparedStatement, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.VoluntaryEventsDelegate
Sets the values for the row.
setUsergroupResearchID(int) - Method in class fi.paatti.paattidatabaseutils.dbobjects.UserGroup
Returns the ID of the research that the group belongs to.
setUsergroupRoleID(int) - Method in class fi.paatti.paattidatabaseutils.dbobjects.UserGroup
Returns the value of userRoleID.
setUsername(String) - Method in class fi.paatti.paattidatabaseutils.dbobjects.User
Sets the value of username.
storeRow(Connection, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.BelongsQueryDelegate
Stores a row in the database.
storeRow(Connection, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.ChoiceQueryDelegate
Stores a row in the database.
storeRow(Connection, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.EventsInScheduleDelegate
Stores a row in the database.
storeRow(Connection, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
Stores a row in the database.
storeRow(Connection, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.TaskQueryDelegate
Stores a row in the database.
storeRow(Connection, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.UserGroupRolesAndResearchDelegate
Stores a row in the database.
storeRow(Connection, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.UserUnfinishedEventsDelegate
Stores a row in the database.
storeRow(Connection, RowItem) - Method in class fi.paatti.paattidatabaseutils.dbservice.querydelegates.VoluntaryEventsDelegate
Stores a row in the database.

T

TASK - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
TASK_content - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASK_description - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASK_EVENT_eventID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASK_posX - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASK_posY - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASK_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASK_sequence - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASK_taskID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASK_TASKTYPE_taskTypeID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASK_url - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TaskContainer - Class in fi.paatti.containers
An extended SQLContainer has a possibility to add a listener for getting the new row ID after succesful insert to the database.
TaskContainer(FreeformQuery) - Constructor for class fi.paatti.containers.TaskContainer
Constructor.
TaskData - Class in fi.paatti.paattidatabaseutils.dbobjects
A class for holding TaskData.
TaskData(Object, Object) - Constructor for class fi.paatti.paattidatabaseutils.dbobjects.TaskData
Constructor.
TASKDATA - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
TASKDATA_CHOICE_choiceID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASKDATA_executionTime - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASKDATA_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASKDATA_sequence - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASKDATA_taskDataID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASKDATA_USER_userID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TaskQueryDelegate - Class in fi.paatti.paattidatabaseutils.dbservice.querydelegates
A delegate for TASK table.
TaskQueryDelegate(Object) - Constructor for class fi.paatti.paattidatabaseutils.dbservice.querydelegates.TaskQueryDelegate
Constructor.
TASKTYPE - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
TASKTYPE_binarydataMax - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASKTYPE_binarydataMin - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASKTYPE_description - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASKTYPE_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASKTYPE_taskTypeID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASKTYPE_textMax - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TASKTYPE_textMin - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TEXT - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
TEXT_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TEXT_sequence - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TEXT_TASKDATA_taskDataID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TEXT_textID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TEXTDATA - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
TEXTDATA_data - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TEXTDATA_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TEXTDATA_sequence - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TEXTDATA_TASKDATA_taskDataID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
TEXTDATA_textDataID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 

U

User - Class in fi.paatti.paattidatabaseutils.dbobjects
User object holds the username, ID, groups and roles of the user.
User(int) - Constructor for class fi.paatti.paattidatabaseutils.dbobjects.User
User constructor.
USER - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
USER_description - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USER_firstName - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USER_lastName - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USER_name - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USER_password - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USER_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USER_userID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
UserGroup - Class in fi.paatti.paattidatabaseutils.dbobjects
UserGroup object.
UserGroup(int) - Constructor for class fi.paatti.paattidatabaseutils.dbobjects.UserGroup
Constructor.
UserGroup(int, int) - Constructor for class fi.paatti.paattidatabaseutils.dbobjects.UserGroup
Constructor.
USERGROUP - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiTableNames
 
USERGROUP_description - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USERGROUP_editedBy - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USERGROUP_editTime - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USERGROUP_name - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USERGROUP_RESEARCH_researchID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USERGROUP_ROLE_roleID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USERGROUP_rowStatus - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
USERGROUP_usergroupID - Static variable in class fi.paatti.paattidatabaseutils.names.PaattiColumnNames
 
UserGroupRolesAndResearchDelegate - Class in fi.paatti.paattidatabaseutils.dbservice.querydelegates
Get the users groups and roles and researches that belong to the groups.
UserGroupRolesAndResearchDelegate(int) - Constructor for class fi.paatti.paattidatabaseutils.dbservice.querydelegates.UserGroupRolesAndResearchDelegate
Constructor.
UserUnfinishedEventsDelegate - Class in fi.paatti.paattidatabaseutils.dbservice.querydelegates
Get all the events (with event times that) are available to the user.
UserUnfinishedEventsDelegate(Object) - Constructor for class fi.paatti.paattidatabaseutils.dbservice.querydelegates.UserUnfinishedEventsDelegate
Constructor.

V

VoluntaryEventsDelegate - Class in fi.paatti.paattidatabaseutils.dbservice.querydelegates
Delegate for getting all voluntary events.
VoluntaryEventsDelegate(Object) - Constructor for class fi.paatti.paattidatabaseutils.dbservice.querydelegates.VoluntaryEventsDelegate
Constructor.

A B C E F G H I N P R S T U V

Copyright © 2012. All Rights Reserved.