javatools.database

Class DummyDatabase

java.lang.Object

javatools.database.Database

javatools.database.DummyDatabase

public class DummyDatabase
extends Database

This class is part of the Java Tools (see http://mpii.de/yago-naga/javatools). It is licensed under the Creative Commons Attribution License (see http://creativecommons.org/licenses/by/3.0) by the YAGO-NAGA team (see http://mpii.de/yago-naga). This class provides a dummy database that knows just one single table. All queries run on this table and the WHERE clause is ignored. Example:

   Database d=new DummyDatabase(Arrays.asList("arg1","relation","arg2"),
                                "Albert_Einstein","bornOnDate","1879-03-14",
                                "Elvis_Presley","bornIn","Tupelo"
                                );
  

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	DummyDatabase.DummyResultSet Wraps just the data

Nested classes/interfaces inherited from class javatools.database.Database

Database.CommitTransactionSQLException, Database.ConnectionBrokenSQLException, Database.InitTransactionSQLException, Database.Inserter, Database.RollbackTransactionSQLException, Database.StartAutoCommitSQLException, Database.TransactionSQLException

Field Summary

Fields

Modifier and Type	Field and Description
java.util.List<java.lang.String>	columnNames Holds the column names
java.util.List<java.util.List<java.lang.String>>	columns Holds the table
int	numRows Number of rows

Fields inherited from class javatools.database.Database

connection, description, driver, fetchsize, inserters, java2SQL, MINCOLUMNWIDTH, resultSetConcurrency, resultSetType, SCREENWIDTH, type2SQL

Constructor Summary

Constructors

Constructor and Description
DummyDatabase() Creates a dummy database
DummyDatabase(java.util.List<java.lang.String> columnNames, java.io.File values) Creates a dummy database with values from a TSV file
DummyDatabase(java.util.List<java.lang.String> columnNames, java.util.List<java.util.List<java.lang.String>> columns) Creates a dummy database
DummyDatabase(java.util.List<java.lang.String> columnNames, java.lang.String... valuesAsRows) Creates a dummy database

Method Summary

Modifier and Type	Method and Description
void	connect() connects to the database specified
int	executeUpdate(java.lang.CharSequence sqlcs) Executes an SQL update query, returns the number of rows added/deleted
static void	main(java.lang.String[] args)
java.sql.ResultSet	query(java.lang.CharSequence sqlcs, int resultSetType, int resultSetConcurrency) Executes a query

Methods inherited from class javatools.database.Database

appendFixedLen, attemptReconnect, autoincrementColumn, cast, close, close, close, close, commitTransaction, connected, createIndex, createIndexCommand, createIndices, createPrimaryKey, createTable, createView, describe, describe, dumpCSV, dumpQueryAsCSV, endTransaction, endTransaction, executeQuery, executeUpdateQuery, exists, existsTable, finalize, flush, format, formatNullToNull, getConnection, getFetchsize, getResultSetConcurrency, getResultSetType, getSQLStmntIFNULL, getSQLType, getSQLType, getSQLType, getValidityCheckTimeout, indexName, isAutoReconnectingOnSelect, isAutoReconnectingOnUpdate, jarAvailable, limit, loadCSV, lockTableReadAccess, lockTableWriteAccess, makeCSV, makeCSVForQuery, newInserter, newInserter, newInserter, offset, prepareQuery, query, query, query, queryValue, reconnect, releaseLocksAndEndTransaction, resetTransaction, runInterface, setAutoReconnectOnSelect, setAutoReconnectOnUpdate, setFetchsize, setResultSetConcurrency, setResultSetType, setValidityCheckTimeout, startTransaction, toString

Methods inherited from class java.lang.Object

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

Field Detail

columns

public java.util.List<java.util.List<java.lang.String>> columns

Holds the table

columnNames

public java.util.List<java.lang.String> columnNames

Holds the column names

numRows

public int numRows

Number of rows

Constructor Detail

DummyDatabase

public DummyDatabase()

Creates a dummy database

DummyDatabase

public DummyDatabase(java.util.List<java.lang.String> columnNames,
                     java.util.List<java.util.List<java.lang.String>> columns)

Creates a dummy database

DummyDatabase

public DummyDatabase(java.util.List<java.lang.String> columnNames,
                     java.lang.String... valuesAsRows)

Creates a dummy database

DummyDatabase

public DummyDatabase(java.util.List<java.lang.String> columnNames,
                     java.io.File values)
              throws java.sql.SQLException

Creates a dummy database with values from a TSV file

Throws:

java.io.IOException

java.sql.SQLException

Method Detail

executeUpdate

public int executeUpdate(java.lang.CharSequence sqlcs)
                  throws java.sql.SQLException

Executes an SQL update query, returns the number of rows added/deleted

Overrides:

executeUpdate in class Database

Throws:

java.sql.SQLException

query

public java.sql.ResultSet query(java.lang.CharSequence sqlcs,
                                int resultSetType,
                                int resultSetConcurrency)
                         throws java.sql.SQLException

Executes a query

Overrides:

query in class Database

Throws:

java.sql.SQLException

main

public static void main(java.lang.String[] args)

connect

public void connect()
             throws java.sql.SQLException

Description copied from class: Database

connects to the database specified

Specified by:

connect in class Database

Throws:

java.sql.SQLException