blob: f3b4aacfdaf923171a4a223b27d4d2ae27b75aa5 [file] [log] [blame]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- NewPage -->
<html lang="en">
<head>
<!-- Generated by javadoc (1.8.0_121) on Fri Apr 14 22:12:45 PDT 2017 -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>PostgreSQLJDBCDataModel (Mahout Integration 0.13.0 API)</title>
<meta name="date" content="2017-04-14">
<link rel="stylesheet" type="text/css" href="../../../../../../../../stylesheet.css" title="Style">
<script type="text/javascript" src="../../../../../../../../script.js"></script>
</head>
<body>
<script type="text/javascript"><!--
try {
if (location.href.indexOf('is-external=true') == -1) {
parent.document.title="PostgreSQLJDBCDataModel (Mahout Integration 0.13.0 API)";
}
}
catch(err) {
}
//-->
var methods = {"i0":10};
var tabs = {65535:["t0","All Methods"],2:["t2","Instance Methods"],8:["t4","Concrete Methods"]};
var altColor = "altColor";
var rowColor = "rowColor";
var tableTab = "tableTab";
var activeTableTab = "activeTableTab";
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a name="navbar.top">
<!-- -->
</a>
<div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div>
<a name="navbar.top.firstrow">
<!-- -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/PostgreSQLJDBCDataModel.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/PostgreSQLBooleanPrefJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><span class="typeNameLink">Prev&nbsp;Class</span></a></li>
<li><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/ReloadFromJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><span class="typeNameLink">Next&nbsp;Class</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../../../../index.html?org/apache/mahout/cf/taste/impl/model/jdbc/PostgreSQLJDBCDataModel.html" target="_top">Frames</a></li>
<li><a href="PostgreSQLJDBCDataModel.html" target="_top">No&nbsp;Frames</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../../../../../allclasses-noframe.html">All&nbsp;Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
allClassesLink = document.getElementById("allclasses_navbar_top");
if(window==top) {
allClassesLink.style.display = "block";
}
else {
allClassesLink.style.display = "none";
}
//-->
</script>
</div>
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li>Nested&nbsp;|&nbsp;</li>
<li><a href="#fields.inherited.from.class.org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel">Field</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor.summary">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.summary">Method</a></li>
</ul>
<ul class="subNavList">
<li>Detail:&nbsp;</li>
<li>Field&nbsp;|&nbsp;</li>
<li><a href="#constructor.detail">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.detail">Method</a></li>
</ul>
</div>
<a name="skip.navbar.top">
<!-- -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
<!-- ======== START OF CLASS DATA ======== -->
<div class="header">
<div class="subTitle">org.apache.mahout.cf.taste.impl.model.jdbc</div>
<h2 title="Class PostgreSQLJDBCDataModel" class="title">Class PostgreSQLJDBCDataModel</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">
<li><a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">java.lang.Object</a></li>
<li>
<ul class="inheritance">
<li><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">org.apache.mahout.cf.taste.impl.common.jdbc.AbstractJDBCComponent</a></li>
<li>
<ul class="inheritance">
<li><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc">org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel</a></li>
<li>
<ul class="inheritance">
<li><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/SQL92JDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc">org.apache.mahout.cf.taste.impl.model.jdbc.SQL92JDBCDataModel</a></li>
<li>
<ul class="inheritance">
<li>org.apache.mahout.cf.taste.impl.model.jdbc.PostgreSQLJDBCDataModel</li>
</ul>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</li>
</ul>
<div class="description">
<ul class="blockList">
<li class="blockList">
<dl>
<dt>All Implemented Interfaces:</dt>
<dd><a href="http://docs.oracle.com/javase/7/docs/api/java/io/Serializable.html?is-external=true" title="class or interface in java.io">Serializable</a>, <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/common/Refreshable.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.common">Refreshable</a>, <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/model/DataModel.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.model">DataModel</a>, <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/model/JDBCDataModel.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.model">JDBCDataModel</a></dd>
</dl>
<hr>
<br>
<pre>public class <span class="typeNameLabel">PostgreSQLJDBCDataModel</span>
extends <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/SQL92JDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc">SQL92JDBCDataModel</a></pre>
<div class="block"><p>
A <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/model/JDBCDataModel.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.model"><code>JDBCDataModel</code></a> backed by a PostgreSQL database and
accessed via JDBC. It may work with other JDBC databases. By default, this class
assumes that there is a <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> available under the JNDI name
"jdbc/taste", which gives access to a database with a "taste_preferences" table with the following schema:
</p>
<p>
<pre>
CREATE TABLE taste_preferences (
user_id BIGINT NOT NULL,
item_id BIGINT NOT NULL,
preference REAL NOT NULL,
PRIMARY KEY (user_id, item_id)
)
CREATE INDEX taste_preferences_user_id_index ON taste_preferences (user_id);
CREATE INDEX taste_preferences_item_id_index ON taste_preferences (item_id);
</pre>
</p></div>
<dl>
<dt><span class="seeLabel">See Also:</span></dt>
<dd><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/PostgreSQLJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><code>PostgreSQLJDBCDataModel</code></a>,
<a href="../../../../../../../../serialized-form.html#org.apache.mahout.cf.taste.impl.model.jdbc.PostgreSQLJDBCDataModel">Serialized Form</a></dd>
</dl>
</li>
</ul>
</div>
<div class="summary">
<ul class="blockList">
<li class="blockList">
<!-- =========== FIELD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="field.summary">
<!-- -->
</a>
<h3>Field Summary</h3>
<ul class="blockList">
<li class="blockList"><a name="fields.inherited.from.class.org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel">
<!-- -->
</a>
<h3>Fields inherited from class&nbsp;org.apache.mahout.cf.taste.impl.model.jdbc.<a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc">AbstractJDBCDataModel</a></h3>
<code><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#DEFAULT_ITEM_ID_COLUMN">DEFAULT_ITEM_ID_COLUMN</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#DEFAULT_PREFERENCE_COLUMN">DEFAULT_PREFERENCE_COLUMN</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#DEFAULT_PREFERENCE_TABLE">DEFAULT_PREFERENCE_TABLE</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#DEFAULT_PREFERENCE_TIME_COLUMN">DEFAULT_PREFERENCE_TIME_COLUMN</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#DEFAULT_USER_ID_COLUMN">DEFAULT_USER_ID_COLUMN</a></code></li>
</ul>
<ul class="blockList">
<li class="blockList"><a name="fields.inherited.from.class.org.apache.mahout.cf.taste.impl.common.jdbc.AbstractJDBCComponent">
<!-- -->
</a>
<h3>Fields inherited from class&nbsp;org.apache.mahout.cf.taste.impl.common.jdbc.<a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">AbstractJDBCComponent</a></h3>
<code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#DEFAULT_DATASOURCE_NAME" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">DEFAULT_DATASOURCE_NAME</a></code></li>
</ul>
</li>
</ul>
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
<ul class="blockList">
<li class="blockList"><a name="constructor.summary">
<!-- -->
</a>
<h3>Constructor Summary</h3>
<table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Constructor Summary table, listing constructors, and an explanation">
<caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colOne" scope="col">Constructor and Description</th>
</tr>
<tr class="altColor">
<td class="colOne"><code><span class="memberNameLink"><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/PostgreSQLJDBCDataModel.html#PostgreSQLJDBCDataModel--">PostgreSQLJDBCDataModel</a></span>()</code>
<div class="block">
Creates a using the default <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> (named
<a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#DEFAULT_DATASOURCE_NAME" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc"><code>AbstractJDBCComponent.DEFAULT_DATASOURCE_NAME</code></a> and default table/column names.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colOne"><code><span class="memberNameLink"><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/PostgreSQLJDBCDataModel.html#PostgreSQLJDBCDataModel-javax.sql.DataSource-">PostgreSQLJDBCDataModel</a></span>(<a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql">DataSource</a>&nbsp;dataSource)</code>
<div class="block">
Creates a using the given <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> and default table/column names.</div>
</td>
</tr>
<tr class="altColor">
<td class="colOne"><code><span class="memberNameLink"><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/PostgreSQLJDBCDataModel.html#PostgreSQLJDBCDataModel-javax.sql.DataSource-java.lang.String-java.lang.String-java.lang.String-java.lang.String-java.lang.String-">PostgreSQLJDBCDataModel</a></span>(<a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql">DataSource</a>&nbsp;dataSource,
<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;preferenceTable,
<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;userIDColumn,
<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;itemIDColumn,
<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;preferenceColumn,
<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;timestampColumn)</code>
<div class="block">
Creates a using the given <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> and default table/column names.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colOne"><code><span class="memberNameLink"><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/PostgreSQLJDBCDataModel.html#PostgreSQLJDBCDataModel-java.lang.String-">PostgreSQLJDBCDataModel</a></span>(<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;dataSourceName)</code>
<div class="block">
Creates a using the default <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> found under the given name, and
using default table/column names.</div>
</td>
</tr>
</table>
</li>
</ul>
<!-- ========== METHOD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="method.summary">
<!-- -->
</a>
<h3>Method Summary</h3>
<table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation">
<caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd">&nbsp;</span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">Instance Methods</a></span><span class="tabEnd">&nbsp;</span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd">&nbsp;</span></span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Method and Description</th>
</tr>
<tr id="i0" class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/PostgreSQLJDBCDataModel.html#setPreference-long-long-float-">setPreference</a></span>(long&nbsp;userID,
long&nbsp;itemID,
float&nbsp;value)</code>
<div class="block">Override since PostgreSQL doesn't have the same non-standard capability that MySQL has, to optionally
insert or update in one statement.</div>
</td>
</tr>
</table>
<ul class="blockList">
<li class="blockList"><a name="methods.inherited.from.class.org.apache.mahout.cf.taste.impl.model.jdbc.SQL92JDBCDataModel">
<!-- -->
</a>
<h3>Methods inherited from class&nbsp;org.apache.mahout.cf.taste.impl.model.jdbc.<a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/SQL92JDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc">SQL92JDBCDataModel</a></h3>
<code><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/SQL92JDBCDataModel.html#getUpdatePreferenceSQL--">getUpdatePreferenceSQL</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/SQL92JDBCDataModel.html#getVerifyPreferenceSQL--">getVerifyPreferenceSQL</a></code></li>
</ul>
<ul class="blockList">
<li class="blockList"><a name="methods.inherited.from.class.org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel">
<!-- -->
</a>
<h3>Methods inherited from class&nbsp;org.apache.mahout.cf.taste.impl.model.jdbc.<a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc">AbstractJDBCDataModel</a></h3>
<code><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#buildPreference-java.sql.ResultSet-">buildPreference</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#doGetPreferencesForItem-long-">doGetPreferencesForItem</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#exportWithIDsOnly--">exportWithIDsOnly</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#exportWithPrefs--">exportWithPrefs</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getDataSource--">getDataSource</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getItemIDColumn--">getItemIDColumn</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getItemIDs--">getItemIDs</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getItemIDsFromUser-long-">getItemIDsFromUser</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getLongColumn-java.sql.ResultSet-int-">getLongColumn</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getMaxPreference--">getMaxPreference</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getMinPreference--">getMinPreference</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getNumItems--">getNumItems</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getNumUsers--">getNumUsers</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getNumUsersWithPreferenceFor-long-">getNumUsersWithPreferenceFor</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getNumUsersWithPreferenceFor-long-long-">getNumUsersWithPreferenceFor</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getPreferenceColumn--">getPreferenceColumn</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getPreferencesForItem-long-">getPreferencesForItem</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getPreferencesFromUser-long-">getPreferencesFromUser</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getPreferenceTable--">getPreferenceTable</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getPreferenceTime-long-long-">getPreferenceTime</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getPreferenceValue-long-long-">getPreferenceValue</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getUserIDColumn--">getUserIDColumn</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getUserIDs--">getUserIDs</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#hasPreferenceValues--">hasPreferenceValues</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#refresh-java.util.Collection-">refresh</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#removePreference-long-long-">removePreference</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#setLongParameter-java.sql.PreparedStatement-int-long-">setLongParameter</a></code></li>
</ul>
<ul class="blockList">
<li class="blockList"><a name="methods.inherited.from.class.org.apache.mahout.cf.taste.impl.common.jdbc.AbstractJDBCComponent">
<!-- -->
</a>
<h3>Methods inherited from class&nbsp;org.apache.mahout.cf.taste.impl.common.jdbc.<a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">AbstractJDBCComponent</a></h3>
<code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#checkNotNullAndLog-java.lang.String-java.lang.Object-" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">checkNotNullAndLog</a>, <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#checkNotNullAndLog-java.lang.String-java.lang.Object:A-" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">checkNotNullAndLog</a>, <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#getFetchSize--" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">getFetchSize</a>, <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#lookupDataSource-java.lang.String-" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">lookupDataSource</a></code></li>
</ul>
<ul class="blockList">
<li class="blockList"><a name="methods.inherited.from.class.java.lang.Object">
<!-- -->
</a>
<h3>Methods inherited from class&nbsp;java.lang.<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a></h3>
<code><a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#clone--" title="class or interface in java.lang">clone</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#equals-java.lang.Object-" title="class or interface in java.lang">equals</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#finalize--" title="class or interface in java.lang">finalize</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#getClass--" title="class or interface in java.lang">getClass</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#hashCode--" title="class or interface in java.lang">hashCode</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#notify--" title="class or interface in java.lang">notify</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#notifyAll--" title="class or interface in java.lang">notifyAll</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#toString--" title="class or interface in java.lang">toString</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#wait--" title="class or interface in java.lang">wait</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#wait-long-" title="class or interface in java.lang">wait</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#wait-long-int-" title="class or interface in java.lang">wait</a></code></li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
<div class="details">
<ul class="blockList">
<li class="blockList">
<!-- ========= CONSTRUCTOR DETAIL ======== -->
<ul class="blockList">
<li class="blockList"><a name="constructor.detail">
<!-- -->
</a>
<h3>Constructor Detail</h3>
<a name="PostgreSQLJDBCDataModel--">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PostgreSQLJDBCDataModel</h4>
<pre>public&nbsp;PostgreSQLJDBCDataModel()
throws <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/common/TasteException.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.common">TasteException</a></pre>
<div class="block"><p>
Creates a using the default <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> (named
<a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#DEFAULT_DATASOURCE_NAME" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc"><code>AbstractJDBCComponent.DEFAULT_DATASOURCE_NAME</code></a> and default table/column names.
</p></div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/common/TasteException.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.common">TasteException</a></code> - if <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> can't be found</dd>
</dl>
</li>
</ul>
<a name="PostgreSQLJDBCDataModel-java.lang.String-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PostgreSQLJDBCDataModel</h4>
<pre>public&nbsp;PostgreSQLJDBCDataModel(<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;dataSourceName)
throws <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/common/TasteException.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.common">TasteException</a></pre>
<div class="block"><p>
Creates a using the default <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> found under the given name, and
using default table/column names.
</p></div>
<dl>
<dt><span class="paramLabel">Parameters:</span></dt>
<dd><code>dataSourceName</code> - name of <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> to look up</dd>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/common/TasteException.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.common">TasteException</a></code> - if <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> can't be found</dd>
</dl>
</li>
</ul>
<a name="PostgreSQLJDBCDataModel-javax.sql.DataSource-">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>PostgreSQLJDBCDataModel</h4>
<pre>public&nbsp;PostgreSQLJDBCDataModel(<a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql">DataSource</a>&nbsp;dataSource)</pre>
<div class="block"><p>
Creates a using the given <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> and default table/column names.
</p></div>
<dl>
<dt><span class="paramLabel">Parameters:</span></dt>
<dd><code>dataSource</code> - <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> to use</dd>
</dl>
</li>
</ul>
<a name="PostgreSQLJDBCDataModel-javax.sql.DataSource-java.lang.String-java.lang.String-java.lang.String-java.lang.String-java.lang.String-">
<!-- -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>PostgreSQLJDBCDataModel</h4>
<pre>public&nbsp;PostgreSQLJDBCDataModel(<a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql">DataSource</a>&nbsp;dataSource,
<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;preferenceTable,
<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;userIDColumn,
<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;itemIDColumn,
<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;preferenceColumn,
<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a>&nbsp;timestampColumn)</pre>
<div class="block"><p>
Creates a using the given <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> and default table/column names.
</p></div>
<dl>
<dt><span class="paramLabel">Parameters:</span></dt>
<dd><code>dataSource</code> - <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> to use</dd>
<dd><code>preferenceTable</code> - name of table containing preference data</dd>
<dd><code>userIDColumn</code> - user ID column name</dd>
<dd><code>itemIDColumn</code> - item ID column name</dd>
<dd><code>preferenceColumn</code> - preference column name</dd>
<dd><code>timestampColumn</code> - timestamp column name (may be null)</dd>
</dl>
</li>
</ul>
</li>
</ul>
<!-- ============ METHOD DETAIL ========== -->
<ul class="blockList">
<li class="blockList"><a name="method.detail">
<!-- -->
</a>
<h3>Method Detail</h3>
<a name="setPreference-long-long-float-">
<!-- -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>setPreference</h4>
<pre>public&nbsp;void&nbsp;setPreference(long&nbsp;userID,
long&nbsp;itemID,
float&nbsp;value)
throws <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/common/TasteException.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.common">TasteException</a></pre>
<div class="block">Override since PostgreSQL doesn't have the same non-standard capability that MySQL has, to optionally
insert or update in one statement.</div>
<dl>
<dt><span class="overrideSpecifyLabel">Specified by:</span></dt>
<dd><code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/model/DataModel.html?is-external=true#setPreference-long-long-float-" title="class or interface in org.apache.mahout.cf.taste.model">setPreference</a></code>&nbsp;in interface&nbsp;<code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/model/DataModel.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.model">DataModel</a></code></dd>
<dt><span class="overrideSpecifyLabel">Overrides:</span></dt>
<dd><code><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/SQL92JDBCDataModel.html#setPreference-long-long-float-">setPreference</a></code>&nbsp;in class&nbsp;<code><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/SQL92JDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc">SQL92JDBCDataModel</a></code></dd>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/common/TasteException.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.common">TasteException</a></code></dd>
</dl>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
</div>
<!-- ========= END OF CLASS DATA ========= -->
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a name="navbar.bottom">
<!-- -->
</a>
<div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div>
<a name="navbar.bottom.firstrow">
<!-- -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/PostgreSQLJDBCDataModel.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/PostgreSQLBooleanPrefJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><span class="typeNameLink">Prev&nbsp;Class</span></a></li>
<li><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/ReloadFromJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><span class="typeNameLink">Next&nbsp;Class</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../../../../index.html?org/apache/mahout/cf/taste/impl/model/jdbc/PostgreSQLJDBCDataModel.html" target="_top">Frames</a></li>
<li><a href="PostgreSQLJDBCDataModel.html" target="_top">No&nbsp;Frames</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_bottom">
<li><a href="../../../../../../../../allclasses-noframe.html">All&nbsp;Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
allClassesLink = document.getElementById("allclasses_navbar_bottom");
if(window==top) {
allClassesLink.style.display = "block";
}
else {
allClassesLink.style.display = "none";
}
//-->
</script>
</div>
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li>Nested&nbsp;|&nbsp;</li>
<li><a href="#fields.inherited.from.class.org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel">Field</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor.summary">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.summary">Method</a></li>
</ul>
<ul class="subNavList">
<li>Detail:&nbsp;</li>
<li>Field&nbsp;|&nbsp;</li>
<li><a href="#constructor.detail">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.detail">Method</a></li>
</ul>
</div>
<a name="skip.navbar.bottom">
<!-- -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
<p class="legalCopy"><small>Copyright &#169; 2008&#x2013;2017 <a href="http://www.apache.org/">The Apache Software Foundation</a>. All rights reserved.</small></p>
</body>
</html>