Package edu.tufts.hrilab.belief.sql

Class SQL

java.lang.Object

edu.tufts.hrilab.belief.sql.SQL

public class SQL
extends Object

Constructor Summary

Constructors

Constructor	Description
SQL(String dbpath)

Method Summary

Modifier and Type	Method	Description
void	assertSQLString(String str, String table)
void	assertSQLString(String str, String table, String source)
void	closeConnection()
ResultSet	getFacts(MemoryLevel memoryLevel)
ResultSet	getHistory(MemoryLevel memoryLevel)
ResultSet	getRules(MemoryLevel memoryLevel)
ResultSet	getTableResultSet(MemoryLevel memoryLevel)
ResultSet	getTableResultSet(String table)
String	joinConcentricLevels(MemoryLevel memoryLevel, String filter)
void	loadTable(ResultSet resultSet, String tblname)
List<org.apache.commons.lang3.tuple.Pair<Long,Long>>	queryRecency(Term query)
ResultSet	querySql(String sqlStatement)
void	retractSQLString(String str, String table)
List<Term>	translateResultSet(ResultSet resultSet)
List<org.apache.commons.lang3.tuple.Pair<Term,List<Term>>>	translateRuleSet(ResultSet resultSet)
int	updateSql(String sqlStatement)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

SQL

public SQL(String dbpath)

Method Details

assertSQLString

public void assertSQLString(String str,
 String table,
 String source)

assertSQLString

public void assertSQLString(String str,
 String table)

retractSQLString

public void retractSQLString(String str,
 String table)

joinConcentricLevels

public String joinConcentricLevels(MemoryLevel memoryLevel,
 String filter)

getTableResultSet

public ResultSet getTableResultSet(MemoryLevel memoryLevel)

getTableResultSet

public ResultSet getTableResultSet(String table)

getFacts

public ResultSet getFacts(MemoryLevel memoryLevel)

getRules

public ResultSet getRules(MemoryLevel memoryLevel)

getHistory

public ResultSet getHistory(MemoryLevel memoryLevel)

querySql

public ResultSet querySql(String sqlStatement)

updateSql

public int updateSql(String sqlStatement)

translateResultSet

public List<Term> translateResultSet(ResultSet resultSet)

translateRuleSet

public List<org.apache.commons.lang3.tuple.Pair<Term,List<Term>>> translateRuleSet(ResultSet resultSet)

loadTable

public void loadTable(ResultSet resultSet,
 String tblname)

closeConnection

public void closeConnection()

queryRecency

public List<org.apache.commons.lang3.tuple.Pair<Long,Long>> queryRecency(Term query)