ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / Big Data / Managing Mongo files
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
mongoOperation (Type of variable)
In french: mongoOperation
The mongoOperation type is used to define the different operations to be performed in bulk. These operations are stored in an array of mongoOperation variables.
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)
Minimum version required
  • Version 28
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/14/2023

Send a report | Local help