S011 sql - get one table as JSON from a database
###############################;
# Get a table from a database #;
###############################;
#Create a connection 'demo_cm_mysql' to a MySQL Server;
#Do not add this into your code, this is a configuration;
cm set "demo_cm_mysql" {execute "db.mysql.config.get"
"[hostname]" "localhost"
"[port]" "3306"
"[database]" "test_db"
"[user]" "bob"
"[password]" "pwd"
;};
#Connect with the connection;
sql connect "session1" {cm get "demo_cm_mysql";};
#Get a table as JSON object;
json load "table" (sql to json "session1" "products" (concat "select * from products"));
json parse_array "table" "/data" "row" {
if (string starts_with (json select "row" "/name") "PROD") {
"do something ...";
} {
"do something ...";
};
};
#Disconnect a connection;
sql disconnect "session1";
#Disconnect all connections;
sql disconnect all;