fi.paatti.paattidatabaseutils.dbservice.querydelegates
Class UserUnfinishedEventsDelegate

java.lang.Object
  extended by fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
      extended by fi.paatti.paattidatabaseutils.dbservice.querydelegates.UserUnfinishedEventsDelegate
All Implemented Interfaces:
com.vaadin.data.util.sqlcontainer.query.FreeformQueryDelegate, com.vaadin.data.util.sqlcontainer.query.FreeformStatementDelegate, Serializable

public class UserUnfinishedEventsDelegate
extends PaattiQueryDelegate

Get all the events (with event times that) are available to the user. Schedule and usergroup are also joined to the list.

Available events are those that have no link to task data. Read only access to data.

Since:
0.0.4
Author:
Lauri Satokangas, lauri.n.satokangas@student.jyu.fi
See Also:
Serialized Form
 

Field Summary
 
Fields inherited from class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
ROWSTATUS_ACTIVE, ROWSTATUS_DELETED
 
Constructor Summary
UserUnfinishedEventsDelegate(Object userID)
          Constructor.
 
Method Summary
 com.vaadin.data.util.sqlcontainer.query.generator.StatementHelper getQueryStatement(int offset, int limit)
          Returns the SELECT-query.
protected  void setRowValues(PreparedStatement statement, com.vaadin.data.util.sqlcontainer.RowItem row)
          Sets the values for the row.
 int storeRow(Connection conn, com.vaadin.data.util.sqlcontainer.RowItem row)
          Stores a row in the database.
 
Methods inherited from class fi.paatti.paattidatabaseutils.dbservice.querydelegates.PaattiQueryDelegate
addNewiRowIdListener, fireNewRowIdEvent, getArrayAsStringWithAddedString, getArrayAsStringWithCommas, getArrayAsStringWithCommasAndWithoutIdColumn, getColumnNames, getContainsRowQueryStatement, getContainsRowQueryString, getCountQuery, getCountStatement, getFilters, getFilterStringWithoutWhere, getIdColumn, getInsertQueryString, getInsertQueryString, getOrderBys, getQueryString, getTableName, getUpdateQueryString, getUpdateQueryString, getValuesString, removeNewRowIdListener, removeRow, setFilters, setOrderBy
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

UserUnfinishedEventsDelegate

public UserUnfinishedEventsDelegate(Object userID)
Constructor.

Parameters:
userID - The ID of the user.
Method Detail

storeRow

public int storeRow(Connection conn,
                    com.vaadin.data.util.sqlcontainer.RowItem row)
             throws SQLException
Stores a row in the database.

Not in use.

Specified by:
storeRow in interface com.vaadin.data.util.sqlcontainer.query.FreeformQueryDelegate
Specified by:
storeRow in class PaattiQueryDelegate
Parameters:
conn - The database connection.
row - The row where the values will be set.
Returns:
The number of affected rows in the database.
Throws:
SQLException

setRowValues

protected void setRowValues(PreparedStatement statement,
                            com.vaadin.data.util.sqlcontainer.RowItem row)
                     throws SQLException
Sets the values for the row.

Not in use.

Specified by:
setRowValues in class PaattiQueryDelegate
Parameters:
statement - The prepared statement where the values will be set.
row - The row where the values will be taken from.
Throws:
SQLException

getQueryStatement

public com.vaadin.data.util.sqlcontainer.query.generator.StatementHelper getQueryStatement(int offset,
                                                                                           int limit)
Returns the SELECT-query. This can be found from the project -- > Other Sources sqlqueries-package.

Parameters:
offset - not in use
limit - not in use
Returns:
The StatementHelper with the select-query


Copyright © 2012. All Rights Reserved.