#import MySQLdb
import pymysql
import os
import json
from app import app
#from dbWrite import read_cloudsql, sql_read, write_cloudsql, sql_write, read_cloudsql_static, sql_read_static, write_cloudsql_static, sql_write_static
from dbWrite import sql_read_static


def mySettings(arg):
    sql2 = "SELECT nextClub, nextTeam, nextDate, oppoLogo, hkfcLogo, currMotM, currDotD, nextFixture, prevFixture FROM hkfcDAdminSettings"
    settingsInfo = sql_read_static(sql2)
    nextClub = settingsInfo[0]['nextClub']
    nextTeam = settingsInfo[0]['nextTeam']
    nextDate = settingsInfo[0]['nextDate']
    hkfcLogo = settingsInfo[0]['hkfcLogo']
    oppoLogo = settingsInfo[0]['oppoLogo']
    currMotM = settingsInfo[0]['currMotM']
    currDotD = settingsInfo[0]['currDotD']
    fixtureNumber = settingsInfo[0]['nextFixture']
    prevFixture = settingsInfo[0]['prevFixture']

    if arg == 'club':
        return nextClub
    elif arg == 'team':
        return nextTeam
    elif arg == 'date':
        return nextDate
    elif arg == 'motm':
        return currMotM
    elif arg == 'dotd':
        return currDotD
    elif arg == 'fixture':
        return fixtureNumber
    elif arg == 'prevFixture':
        return prevFixture
    else:
        return settingsInfo