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

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

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

java2SQL, MINCOLUMNWIDTH, SCREENWIDTH, type2SQL

Constructor Summary

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

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

autoincrementColumn, cast, close, close, close, close, connected, createIndex, createIndexCommand, createIndices, createPrimaryKey, createTable, createView, describe, describe, dumpCSV, dumpQueryAsCSV, endTransaction, endTransaction, 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, query, query, query, queryValue, reconnect, releaseLocksAndEndTransaction, resetTransaction, runInterface, setAutoReconnectOnSelect, setAutoReconnectOnUpdate, setFetchsize, setResultSetConcurrency, setResultSetType, setValidityCheckTimeout, startTransaction, toString

Methods inherited from class java.lang.Object

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