import pymysql

from settings import url_dict

class DB():
	def __init__(self):
		print(url_dict)
		self.db = pymysql.connect(host=url_dict['host'], port=url_dict['port'], 
		user=url_dict['user'], passwd=url_dict['passwd'], 
		db=url_dict['db_name'],autocommit=True)

	def __del__(self):
		self.db.close()

	def get_cursor(self):
		cursor = self.db.cursor()
		return self.db, cursor