Increase integer without fetching doc

Completly possible in mysql 😄

TL;DR

The user wants to increase an integer value without fetching the document. Other users suggest using the `updateDocument()` function in the Appwrite Server SDK to update the value. However, it is uncertain if this solution will work and the user is asked to test it. The possibility of performing this task in MySQL is mentioned.

as far as i know, you will have to fetch the document in order to read the values in it. There's no way for your app to know what to update in your document without fetching it first.

Ah yes it works in vanilla SQL, but I don't think appwrite has that functionality yet. Let me check just to be sure

Okay so this might do what you want. Not a 100% sure as I haven't tested it myself.

Update Document in the Server SDK: https://appwrite.io/docs/server/databases?sdk=nodejs-default#databasesUpdateDocument

According to the docs, you can pass something in the data param.

TypeScript

const promise = databases.updateDocument('[DATABASE_ID]', '[COLLECTION_ID]', '[DOCUMENT_ID]', {'logins': 'logins+1'});

Maybe something like this?

Please test and let me know if it works!

I have a function right here 😄

I can test it

{"code":400,"type":"document_invalid_structure","response":{"message":"Invalid document structure: Attribute \"CurrentStation\" has invalid format. Value must be a valid range between 1 and 99","code":400,"type":"document_invalid_structure","version":"1"}}

Can you share your code snippet?

I think I know what the issue is, just want to be sure.

Pretty funny btw if you do this

it just turns the value to 69

ignoring the +

Ah yes. In the example I provided pseudo-code. 'CurrentStation+1' needs to hold some sort of operation

The CurrentStation attribute in your collection is of type integer right? Well in this code you're passing a string. Which is why you're getting the above error.

Now that I think about it, it might not be possible to directly update it

<a:rollsad:826037118953586699>

@Steven You are good in this stuff 😄 Do you have an idea?