DBSequence

Read Oracle documentation for better understanding.

Sequences provide an arbitrary number of persistent objects that return an increasing or decreasing sequence of integers. Opening a sequence handle associates it with a record in a database. The handle can maintain a cache of values from the database so that a database update is not needed as the application allocates a value.

More info…

DBSequence Methods

DBSequence(db, flags=0)

Constructor. More info…

open(key, txn=None, flags=0)

Opens the sequence represented by the key. More info…

close(flags=0)

Close a DBSequence handle. More info…

initial_value(value)

Set the initial value for a sequence. This call is only effective when the sequence is being created. More info…

get(delta=1, txn=None, flags=0)

Returns the next available element in the sequence and changes the sequence value by delta. More info…

get_dbp()

Returns the DB object associated to the DBSequence. More info…

get_key()

Returns the key for the sequence. More info…

remove(txn=None, flags=0)

Removes the sequence from the database. This method should not be called if there are other open handles on this sequence. More info…

get_cachesize()

Returns the current cache size. More info…

set_cachesize(size)

Configure the number of elements cached by a sequence handle. More info…

get_flags()

Returns the current flags. More info…

set_flags(flags)

Configure a sequence. More info…

stat(flags=0)

Returns a dictionary of sequence statistics with the following keys:

wait

The number of times a thread of control was forced to wait on the handle mutex.

nowait

The number of times that a thread of control was able to obtain handle mutex without waiting.

current

The current value of the sequence in the database.

value

The current cached value of the sequence.

last_value

The last cached value of the sequence.

min

The minimum permitted value of the sequence.

max

The maximum permitted value of the sequence.

cache_size

The number of values that will be cached in this handle.

flags

The flags value for the sequence.

More info…

stat_print(flags=0)

Prints diagnostic information. More info…

get_range()

Returns a tuple representing the range of values in the sequence. More info…

set_range((min, max))

Configure a sequence range. More info…