SQL for python

.gitignore

*.log*
secret.py

main.py

...

import MySQLdb
from secret import credentials

    cnx = MySQLdb.connect(user=credentials['user'], db=credentials['database'], passwd=credentials['password'])
    cursor = cnx.cursor()

    query = ("SELECT * FROM `q2` WHERE `id`='{}' ORDER BY RAND() LIMIT 1".format(id))
    cursor.execute(query)

    if cursor.rowcount < 1:
        query = ("SELECT * FROM `q2` ORDER BY RAND() LIMIT 1")
        cursor.execute(query)

    for (id,quote,author,date,_,_) in cursor:
        print("ID: {}\nFROM: {}\nDATE: {}\nQUOTE: {}".format(id,author,date,quote))

    cursor.close()
    cnx.close()
    
...

client.run(credentials['oauth_token'],bot=true)

secret.py

credentials = {
    'sql'      = 'themork.co.uk'
    'user'     = 'readonly',
    'password' = '',
    'database' = 'my_themork',
    
    'oauth_token' = '',
}