mongoOperationsOption (Type of variable)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / Big Data / Managing Mongo files

Properties specific to mongoOperationsOption variables

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

mongoOperationsOption (Type of variable)

In french: mongoLotOpérationsOption

The mongoOperationsOption type is used to define the options of bulk operations. The characteristics of these details can be defined and changed using different WLanguage properties.

Remark: For more details on the declaration of this type of variable and the use of WLanguage properties, see Declaring a variable.

Example

MongoCreateCollection(base, "col1",optCol)
col is mongoCollection = base..Collection["col1"]

MongoDeleteAll(col,"{}")
MongoAdd(col, "{""item1"":""A"",""item2"":1}")
MongoAdd(col, "{""item1"":""a"",""item2"":2}")
MongoAdd(col, "{""item1"":3,""item2"":1}")
MongoAdd(col, "{""item1"":3,""item2"":2}")
MongoAdd(col, "{""item1"":4,""item2"":1}")
MongoAdd(col, "{""item1"":4,""item2"":2}")
MongoAdd(col, "{""item1"":5,""item2"":1}")
MongoAdd(col, "{""item1"":5,""item2"":2}")
MongoAdd(col, "{""item1"":6,""item2"":1}")

t is array of dynamic mongoOpération

opAdd is mongoOperationAdd
opAdd.Document = "{""item1"":1,""item2"":1}"
t.Add(opAdd)

opDeleteOne is mongoOperationDeleteOne
opDeleteOne.Filter = "{""item1"":""a""}"
opDeleteOne.Option = [
{
"collation":
{
"locale":"en_US",
"caseFirst": "lower"
}
}
]
t.Add(opDeleteOne)

opDeleteAll is mongoOperationDeleteAll
opDeleteAll.Filter = "{""item1"":3}"
t.Add(opDeleteAll)

opUpdateOne is mongoOperationUpdateOne
opUpdateOne.Filter = "{""item1"":4}"
opUpdateOne.Update = "{ ""$inc"": {""item2"":10}}"
t.Add(opUpdateOne)

opUpdateAll is mongoOperationUpdateAll
opUpdateAll.Filter = "{""item1"":5}"
opUpdateAll.Update = "{ ""$inc"": {""item2"":20}}"
t.Add(opUpdateAll)

opReplace is mongoOperationReplaceOne
opReplace.Filter = "{""item1"":6}"
opReplace.Document = "{""item1"":6,""item2"":42}"
t.Add(opReplace)

let ret = MongoExecuteOperations(col, t)

opt is mongoOperationsOption
opt.Comment = "My operation"
opt.Ordered = False

optWrite is mongoWriteConcern
optWrite.Mode = mwcMajority

t.DeleteAll()
opdd.Document = "{""item1"":10}"
t.Add(opAdd)
ret = MongoExecuteOperations(col, t)
dbgAssert(ErrorOccurred = True)

opt.BypassDocumentValidation = True
ret = MongoExecuteOperations(col, t, opt, optWrite)
dbgAssert(ErrorOccurred = False)

Properties

Properties specific to mongoOperationsOption variables

The following properties can be used to handle mongoOperationsOption variables:

Property name	Type used	Effect

Comment	Type corresponding to the expected format	Value with the comment to attach to this command. The comment will appear in the log messages, the profiler output and the "currentOp" output. This comment corresponds to: a JSON document, in string format. a BSON document, in buffer format. a variant.
BypassDocumentValidation	Boolean	True to ignore the validation of the documents for all the operations, False otherwise.
Let	Format corresponding to the type used	A BSON/JSON/Variant document consisting of any number of parameter names, each followed by definitions of constants in the MQL Aggregate Expression language.
Ordered	Boolean	True False (default) to try to insert all the documents, continuing after the errors.