mongoOperation (Variable type)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

mongoOperation (Variable type)

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.

Note: 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, "{""rub1"":""A"",""rub2"":1}")
MongoAdd(col, "{""rub1"":""a"",""rub2"":2}")
MongoAdd(col, "{""rub1"":3,""rub2"":1}")
MongoAdd(col, "{""rub1"":3,""rub2"":2}")
MongoAdd(col, "{""rub1"":4,""rub2"":1}")
MongoAdd(col, "{""rub1"":4,""rub2"":2}")
MongoAdd(col, "{""rub1"":5,""rub2"":1}")
MongoAdd(col, "{""rub1"":5,""rub2"":2}")
MongoAdd(col, "{""rub1"":6,""rub2"":1}")

t is array of mongoOperation dynamic

opAjout is mongoOperationAdd
opAjout.Document = "{""rub1"":1,""rub2"":1}"
t.Add(opAjout)

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

opSupprimeTout is mongoOperationDeleteAll
opSupprimeTout.Filter = "{""rub1"":3}"
t.Add(opSupprimeTout)

opModifieOne is mongoOperationUpdateOne
opModifieOne.Filter = "{""rub1"":4}"
opModifieOne.Update = "{ ""$inc"" : {""rub2"":10}}"
t.Add(opModifieOne)

opModifieTout is mongoOperationUpdateAll
opModifieTout.Filter	= "{""rub1"":5}"
opModifieTout.Update = "{ ""$inc"" : {""rub2"":20}}"
t.Add(opModifieTout)

opRemplace is mongoOperationReplaceOne
opRemplace.Filter = "{""rub1"":6}"
opRemplace.Document = "{""rub1"":6,""rub2"":42}"
t.Add(opRemplace)


let ret = MongoExecuteOperations(col, t)

opt is mongoOperationsOption
opt.Comment = "Ma belle opération"
opt.Ordered = False

optWrite is mongoWriteConcern
optWrite.Mode = mwcMajority

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

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