Re: Able to run statement in CLI and return a correct value but when run in a script it returns None

[Nick Davies]

Thank you for the suggestion but it's not a permissions issue as I use the same credentials in Grafana and they work. Only in the python script do I get the return as None

Here is relevant parts of the code from the script;
import mariadb
import sys

# Connect to MariaDB Platform
try:
conn = mariadb.connect(
user="*****",
password="*****",
host="localhost",
port=3306,
database="cryptodb"
)
cur = conn.cursor()

pricevar = "SELECT SUM(CASE type WHEN 'purchase' THEN TokenAmount WHEN 'sale' THEN -TokenAmount WHEN 'swap' THEN -TokenAmount WHEN 'gain' THEN TokenAmount END) FROM cryptotbl WHERE Token = '" + (data['data'][coin]['symbol'] + "'")
print(pricevar)
currentvalue = cur.execute(pricevar)

I've got a JSON payload that provides the coin symbol: (data['data'][coin]['symbol'])


I load the statement into the pricevar variable and then execute it, this is where it returns None.

All these steps work in the CLI so I'm not sure why I can't replicate that in the script.