Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- result = cursor.fetchone(variable1, variable2, variable3)
- return result
- result1 = connector_mysql(subSerialNum, ldev, today_date)
- print(result1)
- {'ldev_cap': '0938376656', 'ldev_usedcap': '90937763873'}
- used_capacity = result1['ldev_cap']
- cursor.execute(sql_query, {'serial': subSerialNum, 'lun': ldev, 'todayD': today_date})
- result = cursor.fetchone()
- while result:
- ldev_cap = result['ldev_cap']
- ldev_usdcap = result['ldev_usdcap']
- return ldev_cap, ldev_usdcap
- ldev_cap = result['ldev_cap']
- result1 = connector_mysql(subSerialNum, ldev, today_date)
- return ldev_cap, ldev_usdcap
- capacity, usd_capacity = connector_mysql(subSerialNum, ldev, today_date)
- capacity, usd_capacity = connector_mysql(subSerialNum, ldev, today_date)
- print(capacity)
- print(usd_capacity)
- def connector_mysql(subSerialNum, ldev, today_date):
- import pymysql.cursors
- db_server = 'localhost'
- db_name = 'CBDB'
- db_pass = 'secure_password'
- db_user = 'user1'
- sql_query = (
- "SELECT ldev_cap, ldev_usdcap FROM Ldevs WHERE sub_serial=%(serial)s "
- "and ldev_id=%(lun)s and data_date=%(todayD)s")
- connection = pymysql.connect(host=db_server,
- user=db_user,
- password=db_pass,
- db=db_name,
- cursorclass=pymysql.cursors.DictCursor)
- try:
- with connection.cursor() as cursor:
- cursor.execute(sql_query, {'serial': subSerialNum, 'lun': ldev, 'todayD': today_date})
- result = cursor.fetchone()
- #return result #used for returning dict
- while result:
- ldev_cap = result['ldev_cap']
- ldev_usdcap = result['ldev_usdcap']
- print(result)
- return ldev_cap, ldev_usdcap
- finally:
- connection.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement