mongoOperationDeleteAll (Variable type)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

Properties specific to mongoOperationDeleteAll variables:

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

MongoExecuteOperations (Function)

mongoOperationDeleteAll (Variable type)

In french: mongoOpérationSuppressionTout

The mongoOperationDeleteAll type is used to define all the advanced characteristics of a document delete operation that will be added to a bulk operations list. All the documents that match the selection filter will be deleted. You can define and change the characteristics of this operation using different WLanguage properties.

To be executed, this delete operation will have to be added to the array of operations handled by MongoExecuteOperations.

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)

Properties

Properties specific to mongoOperationDeleteAll variables:

The following properties can be used to handle mongoOperationDeleteAll variables:

Property name	Type used	Effect

Filter	Type of filter used	Description of the MongoDB filter(s) that will be applied to select the documents to delete. This filter corresponds to: a JSON document, in string format. a BSON document, in buffer format. a variant.
Option	Type of the format used	Deletion options. These options correspond to: a JSON document, in string format. a BSON document, in buffer format. a variant. For more details on these options, see the Mongo documentation.