Python Mysql.selectData Examples

Example #1

File: views.py Project: TsinghuaCloud/horizon

def get_account(userid): 
#	userid = get_userid()
	print userid
	sql = "select account from user where userid = '%s'" % (userid)
	account = Mysql.selectData(sql)
	print account 
	totalmoney =  account[0][0] 
	return totalmoney

Example #2

File: views.py Project: jackieli123723/TsinghuaCloud2.0-gui

def get_account(userid):
    #	userid = get_userid()
    print userid
    sql = "select account from user where userid = '%s'" % (userid)
    account = Mysql.selectData(sql)
    print account
    totalmoney = account[0][0]
    return totalmoney

Example #3

File: base.py Project: TsinghuaCloud/TsinghuaCloud2.0-gui

def get_account(userid):
        sql = "select account from user where userid = '%s'" % (userid)
        account = Mysql.selectData(sql)
        #print account[0]['account']
        totalmoney =  account[0]['account']
        return totalmoney

Example #4

def get_account(userid):
    sql = "select account from user where userid = '%s'" % (userid)
    account = Mysql.selectData(sql)
    #print account[0]['account']
    totalmoney = account[0]['account']
    return totalmoney

Example #5

def query_info(userid):
    sql = "select * from user_info where userid = '%s'" % (userid)
    userinfo = Mysql.selectData(sql)
    return userinfo

Example #6

File: views.py Project: TsinghuaCloud/TsinghuaCloud2.0-gui

def query_info(userid):
	sql = "select * from user_info where userid = '%s'" % (userid)
	userinfo = Mysql.selectData(sql)
	return userinfo