especificos-videos/back/db.py

import pymysql

class db():
	DB = "EBA_STOCK"
	USER = "root"
	PASSWORD = "howdoiturnthison"
	def __init__(self):
		self.conn = pymysql.connect(unix_socket='/var/run/mysqld/mysqld.sock', user=db.USER, passwd=db.PASSWORD, db=db.DB)	

	def products(self, _id=None):
		ret=[]
		if _id is None:
			cur = self.conn.cursor()
			cur.execute("SELECT id,nombre,precio FROM productos where id between 1000 and 2999")
			for row in cur:
				ret.append({"id":row[0],"nombre":row[1],"precio":row[2],"cantidad":0})
		else:
			pass

		return ret