edu.berkeley.cs186.database

Class Database.Transaction

java.lang.Object

edu.berkeley.cs186.database.Database.Transaction

Enclosing class:

Database

public class Database.Transaction
extends Object

Method Summary

Methods

Modifier and Type	Method and Description
RecordID	addRecord(String tableName, List<DataBox> values)
void	createTempTable(Schema schema, String tempTableName) Create a temporary table within this transaction.
void	deleteRecord(String tableName, RecordID rid)
void	deleteTempTable(String tempTableName)
void	end()
Schema	getFullyQualifiedSchema(String tableName)
Record	getRecord(String tableName, RecordID rid)
Iterator<Record>	getRecordIterator(String tableName)
Schema	getSchema(String tableName)
boolean	isActive()
QueryPlan	query(String tableName) Allows the user to query a table.
void	queryAs(String tableName, String alias) Allows the user to provide an alias for a particular table.
void	updateRecord(String tableName, List<DataBox> values, RecordID rid)

Methods inherited from class java.lang.Object

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

Method Detail

isActive

public boolean isActive()

end

public void end()

query

public QueryPlan query(String tableName)
                throws DatabaseException

Allows the user to query a table. See query#QueryPlan

Parameters:

tableName - The name/alias of the table wished to be queried.

Throws:

DatabaseException - if table does not exist

queryAs

public void queryAs(String tableName,
           String alias)
             throws DatabaseException

Allows the user to provide an alias for a particular table. That alias is valid for the remainder of the transaction. For a particular QueryPlan, once you specify an alias, you must use that alias for the rest of the query.

Parameters:

tableName - The original name of the table.

alias - The new Aliased name.

Throws:

DatabaseException - if the alias already exists or the table does not.

createTempTable

public void createTempTable(Schema schema,
                   String tempTableName)
                     throws DatabaseException

Create a temporary table within this transaction.

Parameters:

schema - the table schema

tempTableName - the name of the table

Throws:

DatabaseException

addRecord

public RecordID addRecord(String tableName,
                 List<DataBox> values)
                   throws DatabaseException

Throws:

DatabaseException

deleteRecord

public void deleteRecord(String tableName,
                RecordID rid)
                  throws DatabaseException

Throws:

DatabaseException

getRecord

public Record getRecord(String tableName,
               RecordID rid)
                 throws DatabaseException

Throws:

DatabaseException

getRecordIterator

public Iterator<Record> getRecordIterator(String tableName)
                                   throws DatabaseException

Throws:

DatabaseException

updateRecord

public void updateRecord(String tableName,
                List<DataBox> values,
                RecordID rid)
                  throws DatabaseException

Throws:

DatabaseException

getSchema

public Schema getSchema(String tableName)
                 throws DatabaseException

Throws:

DatabaseException

getFullyQualifiedSchema

public Schema getFullyQualifiedSchema(String tableName)
                               throws DatabaseException

Throws:

DatabaseException

deleteTempTable

public void deleteTempTable(String tempTableName)