Push database to server by code

[CacaceNicolas]

I am currently working on a game using the Godot engine with a plugin called "GodotSQLite". it is a TCG and i was trying to make it possible for players to trade cards online. In order to do this they should all be able to read and write on the same database at the same time. Im using DBHub.io for this, and it worked, but, i can only submit changes to the database using the "Push currently opened database to server" button on the DB Browser. I was wondering if there was a way to do this using a query or some kind of command, so i can update the database from the game itself

TLDR: is there a way to push the currently opened database to server using a query or command from an external app?

Thanks!

[FriedrichFroebel]

DBHub.io has its own API: https://api.dbhub.io/ Nevertheless, I am not sure if this is the correct approach in your case and probably would recommend writing your own web API to talk to a database on your own machine.

[justinclift]

This seems to be a successful example of sending multipart form data using Godot 3.x:

https://forum.godotengine.org/t/uploading-file-to-server-through-rest/6402/2

[CacaceNicolas]

Can you tell whats wrong? because it is still not working. I think that sending the body as JSON is wrong, but if i leave it as a PoolByteArray, the engine doesn't let me send the request. I tried sending it as a string too, but the same happened. Maybe there is some useful info at the server end. thanks for all your help. 😄

[justinclift]

Cool, I think we're on the right track.

I'll get that code which captures POST data to a local file finished and deployed on the server so we can tell what's actually going wrong, then figure out how to fix it.

It could take me a few hours, as I've just woken up after getting some sleep and need to get food/coffee/check-email-for-anything-super-urgent etc. 😄

[justinclift]

Oh, in your $HTTPRequest.request() call, is there a way to convert body to a string directly rather than use to_json()?

---

Looking at the Godot 3.x docs, it looks like there's a function called get_string_from_utf8() which might be what's needed instead:

https://docs.godotengine.org/en/3.0/classes/class_poolbytearray.html#class-poolbytearray-get-string-from-utf8

So, that'd make it something like this:

$HTTPRequest.request(url, headers, true, HTTPClient.METHOD_POST, body.get_string_from_utf8())

[justinclift]

Ok, the Execute end point (and just that one) on the API server is now logging the POST data for your requests. So we should be able to tell what's going wrong from here on.

Let me know when you've tried the execute end point so I can take a look. 😄

[CacaceNicolas]

IT WORKED!!! FINALLY!!!

Thank you so much! you've been really helpful! 😄😄😄

[justinclift]

Sweet! I guess that means I can remove the code that captures the POST data then. 😄

As a thought, it might be worth trying to use a PoolStringArray instead of a PoolByteArray:

https://docs.godotengine.org/en/3.0/classes/class_poolstringarray.html

The example that I pointed to earlier was probably using a byte array because they wanted to upload a file or something. In this case though, you're mostly just working with string data.

Oh... with the exception that for the Upload API end point you'd probably still want to use a ByteArray.

Hmmm, maybe ignore that as I might just be overcomplicating things. 😄

[CacaceNicolas]

Thanks for the advice! I'll give it a shot

[justinclift]

@SanmiCace Hmmm, are you seeing errors on your end when trying to retrieve the table list for your databases?

I'm seeing what looks like an error message being spat out on the back end, which looks like something caused by a uppercase vs lowercase issue (a problem on our end, not yours).

But I'm not sure if that error is making its way to you or not. ?

[justinclift]

Hmmm, I'm going to track down that error regardless. I don't like seeing errors in our backend logs, and it could mean something isn't quite right...

[justinclift]

Ahhh, found the cause. It's just a side effect of capitalisation stuff, so won't have any real effect. All good. 😄