Get database table content with UAPI
Hello !
I'm try to get a database table content using the UAPI from within a script on an external server.
Here are the ideas I have had so far :
- using the Mysql module to get a query result directly, but it seems there is no function to do this
- using a module to get the result from an SSH command, but I did not find any module to do this
- dumping this table to get the content, but I did not find any module to do this
- thinking a bit outside of UAPI : writing a PHP file that does the database table query and print, calling it in web to get it contents and delete it afterwards, but it's not very clean, would be publicly available for some time, specially since it seems there's no Fileman function to delete a file
- executing an SSH command from the server where my external script resides, to call the hosting server and execute an SQL query, there are some security issues with the password and I'm blocked due to IP/SSH keys restrictions
Using Fileman module, I'm able to get the database name/user/password from a site configuration file, but for now I can't find any use for those.
Any help is greatly appreciated ! :)
Please sign in to leave a comment.
Comments
0 comments