public class MySQLBooleanPrefJDBCDataModel extends AbstractBooleanPrefJDBCDataModel
See also MySQLJDBCDataModel
-- same except deals with a table without preference info:
CREATE TABLE taste_preferences ( user_id BIGINT NOT NULL, item_id BIGINT NOT NULL, PRIMARY KEY (user_id, item_id), INDEX (user_id), INDEX (item_id) )
DEFAULT_ITEM_ID_COLUMN, DEFAULT_PREFERENCE_COLUMN, DEFAULT_PREFERENCE_TABLE, DEFAULT_PREFERENCE_TIME_COLUMN, DEFAULT_USER_ID_COLUMN
DEFAULT_DATASOURCE_NAME
Constructor and Description |
---|
MySQLBooleanPrefJDBCDataModel()
Creates a
MySQLBooleanPrefJDBCDataModel using the default DataSource (named
AbstractJDBCComponent.DEFAULT_DATASOURCE_NAME and default table/column names. |
MySQLBooleanPrefJDBCDataModel(DataSource dataSource)
Creates a
MySQLBooleanPrefJDBCDataModel using the given DataSource and default
table/column names. |
MySQLBooleanPrefJDBCDataModel(DataSource dataSource,
String preferenceTable,
String userIDColumn,
String itemIDColumn,
String timestampColumn)
Creates a
MySQLBooleanPrefJDBCDataModel using the given DataSource and default
table/column names. |
MySQLBooleanPrefJDBCDataModel(String dataSourceName)
Creates a
MySQLBooleanPrefJDBCDataModel using the default DataSource found
under the given name, and using default table/column names. |
Modifier and Type | Method and Description |
---|---|
protected int |
getFetchSize() |
buildPreference, getMaxPreference, getMinPreference, hasPreferenceValues, setPreference
doGetPreferencesForItem, exportWithIDsOnly, exportWithPrefs, getDataSource, getItemIDColumn, getItemIDs, getItemIDsFromUser, getLongColumn, getNumItems, getNumUsers, getNumUsersWithPreferenceFor, getNumUsersWithPreferenceFor, getPreferenceColumn, getPreferencesForItem, getPreferencesFromUser, getPreferenceTable, getPreferenceTime, getPreferenceValue, getUserIDColumn, getUserIDs, refresh, removePreference, setLongParameter
checkNotNullAndLog, checkNotNullAndLog, lookupDataSource
public MySQLBooleanPrefJDBCDataModel() throws TasteException
Creates a MySQLBooleanPrefJDBCDataModel
using the default DataSource
(named
AbstractJDBCComponent.DEFAULT_DATASOURCE_NAME
and default table/column names.
TasteException
- if DataSource
can't be foundpublic MySQLBooleanPrefJDBCDataModel(String dataSourceName) throws TasteException
Creates a MySQLBooleanPrefJDBCDataModel
using the default DataSource
found
under the given name, and using default table/column names.
dataSourceName
- name of DataSource
to look upTasteException
- if DataSource
can't be foundpublic MySQLBooleanPrefJDBCDataModel(DataSource dataSource)
Creates a MySQLBooleanPrefJDBCDataModel
using the given DataSource
and default
table/column names.
dataSource
- DataSource
to usepublic MySQLBooleanPrefJDBCDataModel(DataSource dataSource, String preferenceTable, String userIDColumn, String itemIDColumn, String timestampColumn)
Creates a MySQLBooleanPrefJDBCDataModel
using the given DataSource
and default
table/column names.
dataSource
- DataSource
to usepreferenceTable
- name of table containing preference datauserIDColumn
- user ID column nameitemIDColumn
- item ID column nametimestampColumn
- timestamp column name (may be null)protected int getFetchSize()
getFetchSize
in class AbstractJDBCComponent
Copyright © 2008–2017 The Apache Software Foundation. All rights reserved.