SequoiaDB.DBQuery Class Reference

Database operation rules. More...

Public Attributes
const int	FLG_QUERY_FORCE_HINT = 0x00000080
	Force to use specified hint to query, if database have no index assigned by the hint, fail to query.
const int	FLG_QUERY_PARALLED = 0x00000100
	Enable parallel sub query, each sub query will finish scanning diffent part of the data.
const int	FLG_QUERY_WITH_RETURNDATA = 0x00000200
	In general, query won't return data until cursor gets from database, when add this flag, return data in query response, it will be more high-performance.
const int	FLG_QUERY_KEEP_SHARDINGKEY_IN_UPDATE = 0x00008000
	The sharding key in update rule is not filtered, when executing querydAndUpdate.
const int	FLG_QUERY_FOR_UPDATE = 0x00010000
	Acquire U lock on the records that are read. When the session is in transaction and setting this flag, the transaction lock will not released until the transaction is committed or rollback. When the session is not in transaction, the flag does not work.
const int	FLG_QUERY_FOR_SHARE = 0x00040000
	Acquire S lock on the records that are read. When the session is in transaction and setting this flag, the transaction lock will not released until the transaction is committed or rollback. When the session is not in transaction, the flag does not work.

Properties
BsonDocument	Matcher [get, set]
	Matching rule.
BsonDocument	Selector [get, set]
	selective rule
BsonDocument	OrderBy [get, set]
	Ordered rule.
BsonDocument	Hint [get, set]
	Sepecified access plan.
BsonDocument	Modifier [get, set]
	Modified rule.
long	SkipRowsCount [get, set]
	Documents to skip.
long	ReturnRowsCount [get, set]
	Documents to return.
int	Flag [get, set]
	Query flag.

Detailed Description

Database operation rules.

Member Data Documentation

const int FLG_QUERY_FOR_SHARE = 0x00040000

Acquire S lock on the records that are read. When the session is in transaction and setting this flag, the transaction lock will not released until the transaction is committed or rollback. When the session is not in transaction, the flag does not work.

0x00040000

const int FLG_QUERY_FOR_UPDATE = 0x00010000

Acquire U lock on the records that are read. When the session is in transaction and setting this flag, the transaction lock will not released until the transaction is committed or rollback. When the session is not in transaction, the flag does not work.

0x00010000

const int FLG_QUERY_FORCE_HINT = 0x00000080

Force to use specified hint to query, if database have no index assigned by the hint, fail to query.

0x00000080

const int FLG_QUERY_KEEP_SHARDINGKEY_IN_UPDATE = 0x00008000

The sharding key in update rule is not filtered, when executing querydAndUpdate.

0x00008000

const int FLG_QUERY_PARALLED = 0x00000100

Enable parallel sub query, each sub query will finish scanning diffent part of the data.

0x00000100

const int FLG_QUERY_WITH_RETURNDATA = 0x00000200

In general, query won't return data until cursor gets from database, when add this flag, return data in query response, it will be more high-performance.

0x00000200

Property Documentation

SequoiaDB.DBQuery.Flag

getset

Query flag.

SequoiaDB.DBQuery.Hint

getset

Sepecified access plan.

SequoiaDB.DBQuery.Matcher

getset

Matching rule.

SequoiaDB.DBQuery.Modifier

getset

Modified rule.

SequoiaDB.DBQuery.OrderBy

getset

Ordered rule.

SequoiaDB.DBQuery.ReturnRowsCount

getset

Documents to return.

SequoiaDB.DBQuery.Selector

getset

selective rule

SequoiaDB.DBQuery.SkipRowsCount

getset

Documents to skip.

---

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

• DBQuery.cs