Deveel.Data.SystemSchema.TableColumnsTable Class Reference

Inheritance diagram for Deveel.Data.SystemSchema.TableColumnsTable:

Public Member Functions
	TableColumnsTable (ITransaction transaction)
override DataObject	GetValue (long rowNumber, int columnOffset)
	Gets a single cell within the table that is located at the given column offset and row. More...
Public Member Functions inherited from Deveel.Data.Sql.Tables.GeneratedTable
IEnumerator< Row >	GetEnumerator ()
virtual ColumnIndex	GetIndex (int columnOffset)
	Gets an index for given column that can be used to select values from this table. More...
void	Dispose ()

Protected Member Functions
override void	Dispose (bool disposing)
Protected Member Functions inherited from Deveel.Data.Sql.Tables.GeneratedTable
	GeneratedTable (IContext dbContext)
DataObject	GetColumnValue (int column, ISqlObject obj)

Properties
override TableInfo	TableInfo [get]
override int	RowCount [get]
Properties inherited from Deveel.Data.Sql.Tables.GeneratedTable
IContext	Context [get, private set]
ObjectName IDbObject.	FullName [get]
DbObjectType IDbObject.	ObjectType [get]
abstract TableInfo	TableInfo [get]
abstract int	RowCount [get]
Properties inherited from Deveel.Data.Sql.Tables.ITable
IContext	Context [get]
TableInfo	TableInfo [get]
	Gets the metadata information of the table, used to resolve the column sources. More...
int	RowCount [get]
	Gets the total number of rows in the table. More...
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
int	GetRowCount ()

Private Attributes
ITransaction	transaction

Detailed Description

Definition at line 522 of file SystemSchema.cs.

Constructor & Destructor Documentation

Deveel.Data.SystemSchema.TableColumnsTable.TableColumnsTable ( ITransaction  transaction )

inline

Definition at line 525 of file SystemSchema.cs.

                : base(transaction.Database.Context) {
                this.transaction = transaction;
            }

Member Function Documentation

override void Deveel.Data.SystemSchema.TableColumnsTable.Dispose ( bool  disposing )

inlineprotectedvirtual

Reimplemented from Deveel.Data.Sql.Tables.GeneratedTable.

Definition at line 607 of file SystemSchema.cs.

                                                            {
                transaction = null;
                base.Dispose(disposing);
            }

int Deveel.Data.SystemSchema.TableColumnsTable.GetRowCount ( )

inlineprivate

Definition at line 538 of file SystemSchema.cs.

                                      {
                // All the tables
                var tableManager = transaction.GetTableManager();
                var list = tableManager.GetTableNames();

                int colCount = 0;
                foreach (var tableName in list) {
                    var info = tableManager.GetTableInfo(tableName);
                    if (info == null)
                        throw new InvalidOperationException(String.Format("Table information not found for '{0}'.", tableName));

                    colCount += info.ColumnCount;
                }

                return colCount;
            }

override DataObject Deveel.Data.SystemSchema.TableColumnsTable.GetValue ( long  rowNumber, int  columnOffset  )

inlinevirtual

Gets a single cell within the table that is located at the given column offset and row.

Parameters

rowNumber	The unique number of the row where the cell is located.
columnOffset	The zero-based offset of the column of the cell to return.

Returns

Returns an instance of DataObject that is contained in the cell located by the row and column coordinates provided.

Exceptions

ArgumentOutOfRangeException

If the given columnOffset is less than zero or greater or equal than the number of columns defined in the table metadata.

See also

Tables.TableInfo.IndexOfColumn(string)

Implements Deveel.Data.Sql.Tables.GeneratedTable.

Definition at line 555 of file SystemSchema.cs.

                                                                                  {
                // All the tables
                var tableManager = transaction.GetTableManager();
                var list = tableManager.GetTableNames();
                var visibleTables = list.Select(name => transaction.GetTableInfo(name));

                int rs = 0;
                foreach (var info in visibleTables) {
                    var schemaName = info.SchemaName == null ? null : info.SchemaName.FullName;

                    int b = rs;
                    rs += info.ColumnCount;
                    if (rowNumber >= b && rowNumber < rs) {
                        // This is the column that was requested,
                        var seqNo = rowNumber - b;
                        var colInfo = info[(int)seqNo];

                        var defaultExpression = colInfo.HasDefaultExpression ? colInfo.DefaultExpression.ToString() : null;

                        switch (columnOffset) {
                            case 0:  // schema
                                return GetColumnValue(columnOffset, new SqlString(schemaName));
                            case 1:  // table
                                return GetColumnValue(columnOffset, new SqlString(info.Name));
                            case 2:  // column
                                return GetColumnValue(columnOffset, new SqlString(colInfo.ColumnName));
                            case 3:  // sql_type
                                return GetColumnValue(columnOffset, new SqlNumber((int)colInfo.ColumnType.TypeCode));
                            case 4:  // type_desc
                                return GetColumnValue(columnOffset, new SqlString(colInfo.ColumnType.ToString()));
                            case 5:  // size
                                return GetColumnValue(columnOffset, new SqlNumber(colInfo.Size));
                            case 6:  // scale
                                return GetColumnValue(columnOffset, new SqlNumber(colInfo.Scale));
                            case 7:  // not_null
                                return GetColumnValue(columnOffset, (SqlBoolean) colInfo.IsNotNull);
                            case 8:  // default
                                return GetColumnValue(columnOffset, new SqlString(defaultExpression));
                            case 9:  // index_str
                                return GetColumnValue(columnOffset, new SqlString(colInfo.IndexType));
                            case 10:  // seq_no
                                return GetColumnValue(columnOffset, new SqlNumber(seqNo));
                            default:
                                throw new ArgumentOutOfRangeException("columnOffset");
                        }
                    }

                }  // for each visible table

                throw new ArgumentOutOfRangeException("rowNumber", "Row out of bounds.");
            }

Member Data Documentation

ITransaction Deveel.Data.SystemSchema.TableColumnsTable.transaction

private

Definition at line 523 of file SystemSchema.cs.

Property Documentation

override int Deveel.Data.SystemSchema.TableColumnsTable.RowCount

get

Definition at line 534 of file SystemSchema.cs.

override TableInfo Deveel.Data.SystemSchema.TableColumnsTable.TableInfo

get

Definition at line 530 of file SystemSchema.cs.

---

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

• /var/calculate/remote/distfiles/egit-src/deveeldb.git/src/deveeldb/Deveel.Data/SystemSchema.cs