Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer Class Reference

Inheritance diagram for Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer:

Public Member Functions
	SequenceTableContainer (SequenceManager manager)
int	FindByName (ObjectName tableName)
	Finds the index in this container of the given table by its name. More...
ObjectName	GetTableName (int offset)
	Gets the name of the table at the given index in this container. More...
TableInfo	GetTableInfo (int offset)
	Gets the information of the table at the given offset in this container. More...
string	GetTableType (int offset)
	Gets the type of the table at the given offset. More...
bool	ContainsTable (ObjectName name)
	Checks if a table with the given name is contained in the current context. More...
ITable	GetTable (int offset)
	Gets the table contained at the given offset within the context. More...

Properties
int	TableCount [get]
Properties inherited from Deveel.Data.Sql.Tables.ITableContainer
int	TableCount [get]
	Returns the total count of tables that this object is maintaining. More...

Static Private Member Functions
static TableInfo	CreateTableInfo (ObjectName schema, string name)

Private Attributes
readonly ITransaction	transaction
readonly SequenceManager	manager

Detailed Description

Definition at line 83 of file SequenceManager.cs.

Constructor & Destructor Documentation

Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer.SequenceTableContainer ( SequenceManager  manager )

inline

Definition at line 87 of file SequenceManager.cs.

                                                                   {
                transaction = manager.Transaction;
                this.manager = manager;
            }

Member Function Documentation

bool Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer.ContainsTable ( ObjectName  name )

inline

Checks if a table with the given name is contained in the current context.

Parameters

name	The name of the table to search.

Returns

Returns true if any table with the given name was found in the container, false otherwise.

Implements Deveel.Data.Sql.Tables.ITableContainer.

Definition at line 178 of file SequenceManager.cs.

                                                       {
                var seqInfo = SystemSchema.SequenceInfoTableName;

                // This set can not contain the table that is backing it, so we always
                // return false for that.  This check stops an annoying recursive
                // situation for table name resolution.
                if (name.Equals(seqInfo))
                    return false;

                return FindByName(name) != -1;
            }

static TableInfo Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer.CreateTableInfo ( ObjectName  schema, string  name  )

inlinestaticprivate

Definition at line 99 of file SequenceManager.cs.

                                                                                     {
                var info = new TableInfo(new ObjectName(schema, name));
                info.AddColumn("last_value", PrimitiveTypes.Numeric());
                info.AddColumn("current_value", PrimitiveTypes.Numeric());
                info.AddColumn("top_value", PrimitiveTypes.Numeric());
                info.AddColumn("increment_by", PrimitiveTypes.Numeric());
                info.AddColumn("min_value", PrimitiveTypes.Numeric());
                info.AddColumn("max_value", PrimitiveTypes.Numeric());
                info.AddColumn("start", PrimitiveTypes.Numeric());
                info.AddColumn("cache", PrimitiveTypes.Numeric());
                info.AddColumn("cycle", PrimitiveTypes.Boolean());
                info = info.AsReadOnly();
                return info;
            }

int Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer.FindByName ( ObjectName  name )

inline

Finds the index in this container of the given table by its name.

Parameters

name	The name of the table to find.

Returns

Returns a zero-based index that represents the offset of the table identified by the given name within the context, ot -1 of not found.

Implements Deveel.Data.Sql.Tables.ITableContainer.

Definition at line 114 of file SequenceManager.cs.

                                                        {
                if (tableName == null)
                    throw new ArgumentNullException("tableName");

                if (tableName.Parent == null)
                    return -1;

                var seqInfo = SystemSchema.SequenceInfoTableName;
                if (transaction.RealTableExists(seqInfo)) {
                    // Search the table.
                    var table = transaction.GetTable(seqInfo);
                    var name = DataObject.VarChar(tableName.Name);
                    var schema = DataObject.VarChar(tableName.Parent.FullName);

                    int p = 0;
                    foreach (var row in table) {
                        var seqType = row.GetValue(3);
                        if (!seqType.IsEqualTo(OneValue)) {
                            var obName = row.GetValue(2);
                            if (obName.IsEqualTo(name)) {
                                var obSchema = row.GetValue(1);
                                if (obSchema.IsEqualTo(schema)) {
                                    // Match so return this
                                    return p;
                                }
                            }
                            ++p;
                        }
                    }
                }

                return -1;
            }

ITable Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer.GetTable ( int  offset )

inline

Gets the table contained at the given offset within the context.

Parameters

offset

The zero-based offset of the table to return.

Returns

Returns an instance of ITable that provides access to the backed informaion for an object provided by the context.

Exceptions

ArgumentOutOfRangeException

If the given offset is smaller than 0 or greater or equal than TableCount.

Implements Deveel.Data.Sql.Tables.ITableContainer.

Definition at line 190 of file SequenceManager.cs.

                                               {
                var table = transaction.GetTable(SystemSchema.SequenceInfoTableName);
                int p = 0;
                int rowIndex = -1;

                foreach (var row in table) {
                    var seqType = row.GetValue(3);
                    if (seqType.IsEqualTo(OneValue)) {
                        if (p == offset) {
                            rowIndex = row.RowId.RowNumber;
                            break;
                        }

                        p++;
                    }
                }

                if (rowIndex == -1)
                    throw new ArgumentOutOfRangeException("offset");

                var seqId = table.GetValue(rowIndex, 0);
                var schema = ObjectName.Parse(table.GetValue(rowIndex, 1).Value.ToString());
                var name = table.GetValue(rowIndex, 2).Value.ToString();

                var tableName = new ObjectName(schema, name);

                // Find this id in the 'sequence' table
                var seqTable = transaction.GetTable(SystemSchema.SequenceTableName);

                var index = seqTable.GetIndex(0);
                var list = index.SelectEqual(seqId);

                if (!list.Any())
                    throw new Exception("No SEQUENCE table entry for sequence.");

                int seqRowI = list.First();

                // Generate the DataTableInfo
                var tableInfo = CreateTableInfo(schema, name);

                // Last value for this sequence generated by the transaction
                DataObject lastValue;
                try {
                    var sequence = manager.GetSequence(tableName);
                    if (sequence == null)
                        throw new ObjectNotFoundException(tableName);

                    lastValue = DataObject.Number(sequence.GetCurrentValue());
                } catch (Exception) {
                    lastValue = DataObject.BigInt(-1);
                }

                // The current value of the sequence generator
                var currentValue = DataObject.Number(manager.GetCurrentValue(tableName));

                // Read the rest of the values from the SEQUENCE table.
                var topValue = seqTable.GetValue(seqRowI, 1);
                var incrementBy = seqTable.GetValue(seqRowI, 2);
                var minValue = seqTable.GetValue(seqRowI, 3);
                var maxValue = seqTable.GetValue(seqRowI, 4);
                var start = seqTable.GetValue(seqRowI, 5);
                var cache = seqTable.GetValue(seqRowI, 6);
                var cycle = seqTable.GetValue(seqRowI, 7);


                return new SequenceTable(transaction.Database.Context, tableInfo) {
                    TopValue = topValue,
                    LastValue = lastValue,
                    CurrentValue = currentValue,
                    Increment = incrementBy,
                    MinValue = minValue,
                    MaxValue = maxValue,
                    Start = start,
                    Cache = cache,
                    Cycle = cycle
                };
            }

TableInfo Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer.GetTableInfo ( int  offset )

inline

Gets the information of the table at the given offset in this container.

Parameters

offset

The zero-based offset of the table whose information to return.

Returns

Returns an instance of

See also

TableInfo

that describes the metadata of a table at the given offset within the context.

Exceptions

ArgumentOutOfRangeException

If the given offset is smaller than 0 or greater or equal than TableCount.

Implements Deveel.Data.Sql.Tables.ITableContainer.

Definition at line 169 of file SequenceManager.cs.

                                                      {
                var tableName = GetTableName(offset);
                return CreateTableInfo(tableName.Parent, tableName.Name);
            }

ObjectName Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer.GetTableName ( int  offset )

inline

Gets the name of the table at the given index in this container.

Parameters

offset

The zero-based offset of the table whose name to return.

Returns

Returns a

See also

ObjectName

that identifies the table.

Exceptions

ArgumentOutOfRangeException

If the given offset is smaller than 0 or greater or equal than TableCount.

Implements Deveel.Data.Sql.Tables.ITableContainer.

Definition at line 148 of file SequenceManager.cs.

                                                       {
                var seqInfo = SystemSchema.SequenceInfoTableName;
                if (transaction.RealTableExists(seqInfo)) {
                    var table = transaction.GetTable(seqInfo);
                    int p = 0;
                    foreach (var row in table) {
                        var seqType = row.GetValue(3);
                        if (!seqType.IsEqualTo(OneValue)) {
                            if (offset == p) {
                                var obSchema = row.GetValue(1);
                                var obName = row.GetValue(2);
                                return new ObjectName(ObjectName.Parse(obSchema.Value.ToString()), obName.Value.ToString());
                            }
                            ++p;
                        }
                    }
                }

                throw new ArgumentOutOfRangeException("offset");
            }

string Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer.GetTableType ( int  offset )

inline

Gets the type of the table at the given offset.

Parameters

offset

The zero-based offset of the table whose type to return.

Returns

Returns a String that describes the type of table at the given offset.

Exceptions

ArgumentOutOfRangeException

If the given offset is smaller than 0 or greater or equal than TableCount.

Implements Deveel.Data.Sql.Tables.ITableContainer.

Definition at line 174 of file SequenceManager.cs.

                                                   {
                return TableTypes.Sequence;
            }

Member Data Documentation

readonly SequenceManager Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer.manager

private

Definition at line 85 of file SequenceManager.cs.

readonly ITransaction Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer.transaction

private

Definition at line 84 of file SequenceManager.cs.

Property Documentation

int Deveel.Data.Sql.Sequences.SequenceManager.SequenceTableContainer.TableCount

get

Definition at line 92 of file SequenceManager.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.Sequences/SequenceManager.cs