ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / Big Data / Managing Mongo files
  • Properties specific to mongoOperationAdd variables:
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
mongoOperationAdd (Type of variable)
In french: mongoOpérationAjout
The mongoOperationAdd type is used to define all the advanced characteristics of a document add operation in bulk. The characteristics of this operation can be defined and changed using different WLanguage properties.
To be executed, this add operation will have to be added to the array of operations handled by MongoExecuteOperations.
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 mongoOperationAdd variables:

The following properties can be used to handle mongoOperationAdd variables:
Property nameType usedEffect
DocumentCharacter stringName of the document to be added.
OptionType corresponding to the format usedAddition options. These options correspond to:
  • a JSON document, in string format.
  • a BSON format, in buffer format.
  • a variant.
For more details on these options, see the Mongo documentation.
Minimum version required
  • Version 28
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/28/2023

Send a report | Local help