Add update & delete to Store class

[Timu57]

For simple queries conveniently update and delete documents without the need of QueryBuilder.

Update one or multiple documents.

function update($documents): bool

Delete one document.

function deleteDocument($id, $returnOption = Query::DELETE_RETURN_RESULTS): array|bool|int

For more return options look into #77

[rakibtg]

@Timu57 deleteDocument would it be a public API or internal method?

[Timu57]

@rakibtg it will be a public method.
Because the Store class already has a delete method to delete a store we can not name the method delete and have to name it differently.

I also thought about naming the method deleteById

What do you think what could be the best fitting name?

[rakibtg]

@Timu57 Can't we already do that? Example:

$qb = $store->getQueryBuilder();

$foo = $qb->where("name", "=", "Foo")->getQuery();

print_r($foo->fetch());

$foo->delete();

[Timu57]

@rakibtg yes we can.
But the following is much more convenient:

$store->deleteById($id);

We also could create a deleteBy method:

function deleteBy($criteria, $returnOption = Query::DELETE_RETURN_BOOL): bool|int|array

• $criteria
  • ["city" => "london", "age" => 18]
• $returnOption
  • see return options constants at Change delete method of Query class to accept return options #77

[rakibtg]

@Timu57 I have mixed feeling for findBy or deleteBy because

• it might be a query consistency issue
• What if we add more conditional methods, or if i want to add search in the findBy method then every time we will need to add a new parameter, which i think would create more confusion