A single row in a table of a database. More...

Inheritance diagram for Deveel.Data.Sql.Tables.Row:

Classes
class	RowVariableResolver

Public Member Functions
	Row (ITable table, RowId rowId)
	Constructs a new row object for the table given, identified by the given RowId. More...

	Row (ITable table, int rowNumber)

	Row (ITable table)
	Constructs a new row on the given table that is not established into that table. More...

DataObject	GetValue (int columnOffset)
	Gets or the value of a cell of the row at the given offset. More...

void	SetValue (int columnOffset, DataObject value)
	Sets the value of a cell of the row at the given offset. More...

DataObject	GetValue (string columnName)
	Gets a value for a cell of the row that corresponds to the column of the table with the given name. More...

void	SetValue (string columnName, DataObject value)

void	SetValue (int columnIndex, string value)

void	SetValue (int columnIndex, int value)

void	SetValue (int columnIndex, long value)

void	SetValue (int columnIndex, short value)

void	SetValue (int columnIndex, float value)

void	SetValue (int columnIndex, double value)

void	SetValue (int columnIndex, SqlNumber value)

void	SetValue (int columnIndex, bool value)

void	SetValue (int columnIndex, byte[] bytes)

void	SetValue (int columnIndex, SqlBinary binary)

void	SetNull (int columnOffset)
	Sets the value of a cell of the row at the given offset to `NULL`. More...

void	SetDefault (int columnOffset, IQuery context)
	Sets the value of a cell of the row at the given offset to the `DEFAULT` set at the column definition. More...

void	SetDefault (IQuery context)
	Sets the `DEFAULT` value of all cells in the row as configured in the columns definition corresponding to the cells. More...

void	SetNumber (int number)
	Sets the row number part of the identificator More...

void	SetRowNumber (int rowNumber)
	Sets the number component of the ID of this column. More...

void	SetFromTable ()
	Gathers the original values from the table for the row number corresponding and populates this row with those values, making it ready to be accessed. More...

void	EvaluateAssignment (SqlAssignExpression assignExpression, IQuery context)

Properties
ITable	Table `[get, private set]`
	Gets the instance of the table that contains the row. More...

RowId	RowId `[get, private set]`
	Gets the row unique identifier within the database. More...

ObjectName IDbObject.	FullName `[get]`

DbObjectType IDbObject.	ObjectType `[get]`

DataObject	this[int columnOffset] `[get, set]`
	Gets or sets the value of a cell of the row at the given offset. More...

DataObject	this[string columnName] `[get, set]`
	Gets or sets the value of a cell of the row for the given column. More...

IVariableResolver	VariableResolver `[get]`

int	ColumnCount `[get]`
	Gets the number of columns in the parent table of this row. More...

bool	Exists `[get]`
	Gets a boolean value indicating if the column exists in the parent table. More...

bool	CanBeCached `[get]`

Properties inherited from Deveel.Data.Sql.IDbObject
ObjectName	FullName `[get]`
	Gets the fully qualified name of the object used to resolve it uniquely within the database. More...

DbObjectType	ObjectType `[get]`
	Gets the type of database object that the implementation is for More...

Private Member Functions
DataObject	Evaluate (SqlExpression expression, IQuery queryContext)

Private Attributes
RowVariableResolver	variableResolver

Dictionary< int, DataObject >	values

bool	canBeCached

Detailed Description

A single row in a table of a database.

This object is a convenience to access the data provided by a ITable implementation, preserving the behavior of a tabular model.

Any row in a database can be identified by a unique RowId coordinate, formed by the id of the table that contains it and its unique number within the table.

See also: ITable.GetValue, TableInfo.Id, RowId

Definition at line 44 of file Row.cs.

Constructor & Destructor Documentation

Deveel.Data.Sql.Tables.Row.Row	(	ITable	table,
		RowId	rowId
	)

inline

Constructs a new row object for the table given, identified by the given RowId.

Parameters

table	The table that contains the row.
rowId	The unique identifier of the row within the database.

Exceptions

ArgumentNullException	If the provided table is `null`.
ArgumentException	If the table defines any id and this does not match the given rowId .

Definition at line 61 of file Row.cs.

                                               {
             if (table == null)
                 throw new ArgumentNullException("table");
 
             if (!rowId.IsNull &&
                 table.TableInfo.Id >= 0 &&
                 table.TableInfo.Id != rowId.TableId)
                 throw new ArgumentException(String.Format("The table ID {0} does not match the identifier specified by the row ID ({1})",
                     table.TableInfo.Id,
                     rowId.TableId));
 
             Table = table;
             RowId = rowId;
         }

Deveel.Data.Sql.Tables.Row.Row	(	ITable	table,
		int	rowNumber
	)

inline

Definition at line 76 of file Row.cs.

77 : this(table, new RowId(table.TableInfo.Id, rowNumber)) {

78 }

Deveel.Data.Sql.Tables.Row.RowId

RowId RowId

Gets the row unique identifier within the database.

Definition: Row.cs:101

Deveel.Data.Sql.Tables.Row.Row ( ITable table )

inline

Constructs a new row on the given table that is not established into that table.

Parameters

table The parent table of the row.

Definition at line 85 of file Row.cs.

86 : this(table, RowId.Null) {

87 }

Deveel.Data.Sql.Tables.RowId.Null

static readonly RowId Null

Gets a NULL instance of RowId.

Definition: RowId.cs:28

Deveel.Data.Sql.Tables.Row.RowId

RowId RowId

Gets the row unique identifier within the database.

Definition: Row.cs:101

Member Function Documentation

DataObject Deveel.Data.Sql.Tables.Row.Evaluate	(	SqlExpression	expression,
		IQuery	queryContext
	)

inlineprivate

Definition at line 401 of file Row.cs.

                                                                                    {
             var ignoreCase = queryContext.IgnoreIdentifiersCase();
             // Resolve any variables to the table_def for this expression.
             expression = Table.TableInfo.ResolveColumns(ignoreCase, expression);
             // Get the variable resolver and evaluate over this data.
             IVariableResolver vresolver = VariableResolver;
             var reduced = expression.Evaluate(queryContext, vresolver, null);
             if (reduced.ExpressionType != SqlExpressionType.Constant)
                 throw new InvalidOperationException("The DEFAULT expression of the column cannot be reduced to a constant");
 
             return ((SqlConstantExpression) reduced).Value;
         }

void Deveel.Data.Sql.Tables.Row.EvaluateAssignment	(	SqlAssignExpression	assignExpression,
		IQuery	context
	)

inline

Definition at line 500 of file Row.cs.

                                                                                              {
             var colRef = (SqlReferenceExpression) assignExpression.ReferenceExpression;
             var valueExp = assignExpression.ValueExpression;
             var value = valueExp.EvaluateToConstant(context, VariableResolver);
 
             // Check the column name is within this row.
             var columnName = colRef.ReferenceName;
             int column = Table.FindColumn(columnName);
 
             if (column == -1)
                 throw new ObjectNotFoundException(columnName,
                     String.Format("Table '{0}' has none column named '{1}': cannot assign.", Table.TableInfo.TableName, columnName));
 
             SetValue(column, value);
         }

DataObject Deveel.Data.Sql.Tables.Row.GetValue ( int columnOffset )

inline

Gets or the value of a cell of the row at the given offset.

Parameters

columnOffset The zero-based column offset identifying the value to get from the table.

This methods keeps a cached versions of the values after the first time it is called: that means the

Returns: Returns a DataObject that encapsulates the type and value of the cell stored in the database.

Exceptions

ArgumentOutOfRangeException	If the given columnOffset is smaller than zero or greater than the number of columns in the table.
InvalidOperationException	If the id of this row does not point to any row in the underlying table.

See also: TableInfo.ColumnCount

Definition at line 203 of file Row.cs.

                                                      {
             if (columnOffset < 0 || columnOffset >= Table.TableInfo.ColumnCount)
                 throw new ArgumentOutOfRangeException("columnOffset");
 
             if (values == null) {
                 if (RowId.IsNull)
                     throw new InvalidOperationException("Row was not established to any table.");
 
                 var colCount = Table.TableInfo.ColumnCount;
                 values = new Dictionary<int, DataObject>(colCount);
 
                 for (int i = 0; i < colCount; i++) {
                     values[i] = Table.GetValue(RowId.RowNumber, i);
                 }
             }
 
             DataObject value;
             if (!values.TryGetValue(columnOffset, out value)) {
                 var columnType = Table.TableInfo[columnOffset].ColumnType;
                 return DataObject.Null(columnType);
             }
 
             return value;
         }

DataObject Deveel.Data.Sql.Tables.Row.GetValue ( string columnName )

inline

Gets a value for a cell of the row that corresponds to the column of the table with the given name.

Parameters

columnName The name of the column corresponding to the cell to get.

Returns: Returns a DataObject that encapsulates the type and value of the cell stored in the database.

Exceptions

ArgumentNullException	If the columnName is empty or `null`.
ArgumentException	If no column with the given name was found in the parent table.

See also: GetValue(int)

Definition at line 285 of file Row.cs.

                                                       {
             if (String.IsNullOrEmpty(columnName))
                 throw new ArgumentNullException("columnName");
 
             var offset = Table.TableInfo.IndexOfColumn(columnName);
             if (offset < 0)
                 throw new ArgumentException(String.Format("Could not find column '{0}' in the table '{1}'.", columnName, Table.FullName));
 
             return GetValue(offset);
         }

void Deveel.Data.Sql.Tables.Row.SetDefault	(	int	columnOffset,
		IQuery	context
	)

inline

Sets the value of a cell of the row at the given offset to the DEFAULT set at the column definition.

Parameters

columnOffset	The zero based offset of the column.
context	The context that is used to evaluate the `DEFAULT` SqlExpression of the column.

Exceptions

ArgumentOutOfRangeException	If the given columnOffset is smaller than zero or greater than the number of columns in the table.
InvalidOperationException	If the column has no `DEFAULT` value defined.

Definition at line 374 of file Row.cs.

                                                                  {
             if (columnOffset < 0 || columnOffset >= Table.TableInfo.ColumnCount)
                 throw new ArgumentOutOfRangeException("columnOffset");
 
             var column = Table.TableInfo[columnOffset];
             if (!column.HasDefaultExpression)
                 throw new InvalidOperationException(String.Format("Column '{0}' in table '{1}' has no DEFAULT set.", column.ColumnName, Table.FullName));
 
             var value = Evaluate(column.DefaultExpression, context);
             SetValue(columnOffset, value);
         }

void Deveel.Data.Sql.Tables.Row.SetDefault ( IQuery context )

inline

Sets the DEFAULT value of all cells in the row as configured in the columns definition corresponding to the cells.

Parameters

context The context that is used to evaluate the DEFAULT SqlExpression of the column.

See also: SetDefault(int, IQuery)

Definition at line 393 of file Row.cs.

                                                {
             for (int i = 0; i < Table.TableInfo.ColumnCount; ++i) {
                 if (!values.ContainsKey(i)) {
                     SetDefault(i, context);
                 }
             }
         }

void Deveel.Data.Sql.Tables.Row.SetFromTable ( )

inline

Gathers the original values from the table for the row number corresponding and populates this row with those values, making it ready to be accessed.

See also: SetValue(int, DataObject)

Definition at line 494 of file Row.cs.

                                    {
             for (int i = 0; i < Table.TableInfo.ColumnCount; i++) {
                 SetValue(i, Table.GetValue(RowId.RowNumber, i));
             }
         }

void Deveel.Data.Sql.Tables.Row.SetNull ( int columnOffset )

inline

Sets the value of a cell of the row at the given offset to NULL.

Parameters

columnOffset The zero based offset of the column.

See also: SetValue(int, DataObject)

Definition at line 352 of file Row.cs.

                                               {
             if (columnOffset < 0 || columnOffset >= Table.TableInfo.ColumnCount)
                 throw new ArgumentOutOfRangeException("columnOffset");
 
             var columnType = Table.TableInfo[columnOffset].ColumnType;
             SetValue(columnOffset, new DataObject(columnType, null));
         }

void Deveel.Data.Sql.Tables.Row.SetNumber ( int number )

inline

Sets the row number part of the identificator

Parameters

number The unique row number within the underlying table

When a row is made permanent in a table (by a call to IMutableTable.AddRow), this method is called to update the address of the

If a row has no number locator to the underlying table all access methods will throw exceptions.

Definition at line 428 of file Row.cs.

                                           {
             RowId = new RowId(Table.TableInfo.Id, number);
         }

void Deveel.Data.Sql.Tables.Row.SetRowNumber ( int rowNumber )

inline

Sets the number component of the ID of this column.

Parameters

rowNumber The zero-based number to set for identifying this row.

See also: Tables.RowId.RowNumber, RowId

Definition at line 484 of file Row.cs.

                                                 {
             RowId = new RowId(Table.TableInfo.Id, rowNumber);
         }

void Deveel.Data.Sql.Tables.Row.SetValue	(	int	columnOffset,
		DataObject	value
	)

inline

Sets the value of a cell of the row at the given offset.

Parameters

columnOffset	The zero-based column offset identifying the value to get from the table.
value	The value to set to the cell.

Returns: Returns a DataObject that encapsulates the type and value of the cell stored in the database.

Exceptions

ArgumentOutOfRangeException	If the given columnOffset is smaller than zero or greater than the number of columns in the table.
InvalidOperationException	If the id of this row does not point to any row in the underlying table.

See also: TableInfo.ColumnCount

Definition at line 247 of file Row.cs.

                                                                  {
             var colCount = Table.TableInfo.ColumnCount;
 
             if (columnOffset < 0 || columnOffset >= Table.TableInfo.ColumnCount)
                 throw new ArgumentOutOfRangeException("columnOffset");
 
             if (values == null)
                 values = new Dictionary<int, DataObject>(colCount);
 
             var column = Table.TableInfo[columnOffset];
             var columnType = column.ColumnType;
 
             if (!value.Type.IsComparable(columnType)) {
                 throw new ArgumentException(
                     String.Format("The specified value of type '{0}' is not comparable to '{1}' defined by '{2}'.",
                         value.Type, columnType, column.FullColumnName));
             }
 
             values[columnOffset] = value;
         }

void Deveel.Data.Sql.Tables.Row.SetValue	(	string	columnName,
		DataObject	value
	)

inline

Definition at line 296 of file Row.cs.

                                                                   {
             if (String.IsNullOrEmpty(columnName))
                 throw new ArgumentNullException("columnName");
 
             var offset = Table.TableInfo.IndexOfColumn(columnName);
             if (offset < 0)
                 throw new ArgumentException(String.Format("Could not find column '{0}' in the table '{1}'.", columnName, Table.FullName));
 
             SetValue(offset, value);
         }

void Deveel.Data.Sql.Tables.Row.SetValue	(	int	columnIndex,
		string	value
	)

inline

Definition at line 307 of file Row.cs.

                                                             {
             SetValue(columnIndex, DataObject.String(value));
         }

void Deveel.Data.Sql.Tables.Row.SetValue	(	int	columnIndex,
		int	value
	)

inline

Definition at line 311 of file Row.cs.

                                                          {
             SetValue(columnIndex, DataObject.Integer(value));
         }

void Deveel.Data.Sql.Tables.Row.SetValue	(	int	columnIndex,
		long	value
	)

inline

Definition at line 315 of file Row.cs.

                                                           {
             SetValue(columnIndex, DataObject.BigInt(value));
         }

void Deveel.Data.Sql.Tables.Row.SetValue	(	int	columnIndex,
		short	value
	)

inline

Definition at line 319 of file Row.cs.

                                                            {
             SetValue(columnIndex, DataObject.SmallInt(value));
         }

void Deveel.Data.Sql.Tables.Row.SetValue	(	int	columnIndex,
		float	value
	)

inline

Definition at line 323 of file Row.cs.

                                                            {
             SetValue(columnIndex, new SqlNumber(value));
         }

void Deveel.Data.Sql.Tables.Row.SetValue	(	int	columnIndex,
		double	value
	)

inline

Definition at line 327 of file Row.cs.

                                                             {
             SetValue(columnIndex, DataObject.Number(new SqlNumber(value)));
         }

void Deveel.Data.Sql.Tables.Row.SetValue	(	int	columnIndex,
		SqlNumber	value
	)

inline

Definition at line 331 of file Row.cs.

                                                                {
             SetValue(columnIndex, DataObject.Number(value));
         }

void Deveel.Data.Sql.Tables.Row.SetValue	(	int	columnIndex,
		bool	value
	)

inline

Definition at line 335 of file Row.cs.

                                                           {
             SetValue(columnIndex, DataObject.Boolean(value));
         }

void Deveel.Data.Sql.Tables.Row.SetValue	(	int	columnIndex,
		byte[]	bytes
	)

inline

Definition at line 339 of file Row.cs.

                                                             {
             SetValue(columnIndex, DataObject.Binary(bytes));
         }

void Deveel.Data.Sql.Tables.Row.SetValue	(	int	columnIndex,
		SqlBinary	binary
	)

inline

Definition at line 343 of file Row.cs.

                                                                 {
             SetValue(columnIndex, DataObject.Binary(binary));
         }

Member Data Documentation

bool Deveel.Data.Sql.Tables.Row.canBeCached

private

Definition at line 168 of file Row.cs.

Dictionary<int, DataObject> Deveel.Data.Sql.Tables.Row.values

private

Definition at line 46 of file Row.cs.

RowVariableResolver Deveel.Data.Sql.Tables.Row.variableResolver

private

Definition at line 45 of file Row.cs.

Property Documentation

bool Deveel.Data.Sql.Tables.Row.CanBeCached

get

Definition at line 170 of file Row.cs.

int Deveel.Data.Sql.Tables.Row.ColumnCount

get

Gets the number of columns in the parent table of this row.

Definition at line 156 of file Row.cs.

bool Deveel.Data.Sql.Tables.Row.Exists

get

Gets a boolean value indicating if the column exists in the parent table.

Definition at line 164 of file Row.cs.

ObjectName IDbObject. Deveel.Data.Sql.Tables.Row.FullName

getprivate

Definition at line 103 of file Row.cs.

DbObjectType IDbObject. Deveel.Data.Sql.Tables.Row.ObjectType

getprivate

Definition at line 107 of file Row.cs.

RowId Deveel.Data.Sql.Tables.Row.RowId

getprivate set

Gets the row unique identifier within the database.

When a row is not established in the parent table, this value is Tables.RowId.Null.

Definition at line 101 of file Row.cs.

ITable Deveel.Data.Sql.Tables.Row.Table

getprivate set

Gets the instance of the table that contains the row.

Definition at line 92 of file Row.cs.

DataObject Deveel.Data.Sql.Tables.Row.this[int columnOffset]

getset

Gets or sets the value of a cell of the row at the given offset.

Parameters

columnOffset The zero-based column offset identifying the value to get from the table.

Returns: Returns a DataObject that encapsulates the type and value of the cell stored in the database.

See also: GetValue(int), SetValue(int, DataObject)

Definition at line 122 of file Row.cs.

DataObject Deveel.Data.Sql.Tables.Row.this[string columnName]

getset

Gets or sets the value of a cell of the row for the given column.

Parameters

columnName The name of the column in the table.

Returns: Returns a DataObject that encapsulates the type and value of the cell stored in the database.

See also: GetValue(string), SetValue(string, DataObject)

Definition at line 137 of file Row.cs.

IVariableResolver Deveel.Data.Sql.Tables.Row.VariableResolver

getprivate

Definition at line 142 of file Row.cs.

The documentation for this class was generated from the following file:

/var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb/Deveel.Data.Sql.Tables/Row.cs

Classes

Public Member Functions

Properties

Private Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation

Property Documentation