def dumpRecipes(self):
logger.started()
i = 0
for r in self.recipes:
logger.info('Recipe name = ' + str(r['name']))
for i in r['ingreds']:
logger.info(str(r['name']) + ' ingred = ' + str(self.ingreds[i]['name']) + ' Qty =' + str(r['ingreds'][i]))
logger.completed()
def ingestRecipiesIngredients(self):
logger.started()
tmp = []
if self.pm.get('USE_DB') == 'N':
logger.info('reading from file')
try:
myfile = open(self.pm.get('RECIPE_INGREDIENTS_FILE'), 'r')
except:
logger.err("failed to find recipesingredients, aborting")
sys.exit()
else:
self.recipesIngredients = {}
for line in myfile:
l = line[0:len(line)-1]
elements = l.split(',')
recipeId = elements[0]
ingredId = elements[1]
qty = elements[2]
if recipeId in self.recipesIngredients:
logger.info('recipeId=' + str(recipeId) + ' exists')
else:
logger.info('adding recipeId=' + str(recipeId))
self.recipesIngredients[recipeId] = {}
self.recipesIngredients[recipeId][ingredId] = int(qty)
else:
# initialize a cursor on the connection. a cursor is essentially a reference to a SELECT stmt and the rows that it returns once executed
logger.info('ingestRecipeIngreds: reading from database')
cur = self.conn.cursor()
# load up the cursor with the SELECT stmt and execute it
cur.execute('select recipe_id, ingred_id, qty from recipeingredients')
# iterate thru the rows of the cursor via the cur.fetchall method. that method returns a list for each row. each such list contains values corresponding to the columns in the SELECT clause
for (row) in cur.fetchall():
tmp.append({'rid':row[0],'iid':row[1],'q':row[2]})
self.recipesIngredients = {}
for ri in tmp:
if ri['rid'] in self.recipesIngredients:
logger.info('recipeId =' + str(ri['rid']) + ' exists')
self.recipesIngredients[ri['rid']][ri['iid']] = int(ri['q'])
else:
logger.info('adding recipeId =' + str(ri['rid']) + ' ingred ID =' + str(ri['iid']))
self.recipesIngredients[ri['rid']] = {}
self.recipesIngredients[ri['rid']][ri['iid']] = int(ri['q'])
#self.dumpRecipesIngredients()
logger.completed()
def setReqQtys(self):
logger.started()
for i in self.ingreds:
self.ingreds[i]['total_req_qty'] = 0
for r in self.recipes:
if r['is_make'].get() == 1:
for i in r['ingreds']:
self.ingreds[i]['total_req_qty'] += r['ingreds'][i]
for i in self.ingreds:
if self.ingreds[i]['total_req_qty'] >0:
self.ingreds[i]['total_req_qty_disp'].set(str(self.ingreds[i]['total_req_qty']) + self.ingreds[i]['units'])
logger.completed()
def execute(self):
logger.started()
myrow = 0
mycol = 1
self.dumpRecipes()
for r in self.recipes:
label = Label(self.recipesCanv, text=r['name'])
label.grid(row=myrow, column=mycol, sticky=W)
chk = Checkbutton(self.recipesCanv, text="", variable=r['is_make'], command=self.handleRecipeSelections)
chk.grid(row=myrow, column=mycol+1, sticky=W)
myrow += 1
logger.completed()
def initRecipes(self):
logger.started()
tmp = []
if self.pm.get('USE_DB') == 'Y':
# initialize a cursor on the connection. a cursor is essentially a reference to a SELECT stmt and the rows that it returns once executed
logger.info('using database')
cur = self.conn.cursor()
# load up the cursor with the SELECT stmt and execute it
cur.execute('select recipe_id, recipe_name from recipes')
for (row) in cur.fetchall():
tmp.append({'id':row[0], 'name':row[1]})
else:
logger.info('using file')
try:
myfile = open(self.pm.get('RECIPES_FILE'), 'r')
except:
logger.err("failed to find recipes, aborting")
sys.exit()
else:
for line in myfile:
l = line[0:len(line)-1]
elements = l.split(',')
tmp.append({'id':elements[0], 'name':elements[1]})
for r in tmp:
temp_ingreds = []
try:
temp_ingreds = self.recipesIngredients[r['id']]
logger.info('added ingred, recipe id=' + str(r['id']))
except:
logger.info('no ingred found, recipe id=' + str(r['id']))
temp_ingreds = {}
recipe = {
'id':int(r['id']),
'name':r['name'],
'ingreds':temp_ingreds,
'is_make':IntVar()
}
self.recipes.append(recipe)
logger.completed()
def __init__(self):
logger.started()
logger.info('about to create the prop mgr')
self.pm = propManager.propManager()
logger.info('about to create the mysql conn')
self.conn = mysqlConn.mysqlConn()
self.recipes = []
self.ingreds = {}
self.recipesIngredients = {}
root = Tk()
root.title('Shopping Manager')
logger.info('about to init ingredients')
self.initIngreds()
logger.info('about to ingest recipes ingredients')
self.ingestRecipiesIngredients()
logger.info('about to init recipes')
self.initRecipes()
self.frame = Frame(root,width=1000, height=200)
self.frame.pack(expand=YES, fill=BOTH)
self.recipesFrame = Frame(self.frame, bg='Blue', bd=10)
self.recipesFrame.pack(expand=YES, fill=BOTH, side=LEFT)
self.ingredsFrame = Frame(self.frame, bg='Green', bd=10)
self.ingredsFrame.pack(expand=YES, fill=BOTH, side=LEFT)
self.listFrame = Frame(self.frame, bg='Red', bd=10)
self.listFrame.pack(expand=YES, fill=BOTH, side=LEFT)
self.recipesCanv = Canvas(self.recipesFrame, bg='Yellow')
self.recipesCanv.pack(expand=YES, fill=BOTH, side=TOP)
self.ingredsCanv = Canvas(self.ingredsFrame, bg='pink')
self.ingredsCanv.pack(expand=YES, fill=BOTH, side=TOP)
self.listCanv = Canvas(self.listFrame, bg='orange')
self.listCanv.pack(expand=YES, fill=BOTH, side=TOP)
def initIngreds(self):
logger.started()
tmp = []
if self.pm.get('USE_DB') == 'N':
try:
path = self.pm.get('INGREDIENTS_FILE')
self.l.info('path=' + path)
myfile = open(path, 'r')
except:
logger.err( "failed to find ingredients file, aborting")
sys.exit()
else:
for line in myfile:
l = line[0:len(line)-1]
elements = l.split(',')
tmp.append({'id':elements[0], 'name':elements[1], 'units':elements[2]})
else:
# initialize a cursor on the connection. a cursor is essentially a reference to a SELECT stmt and the rows that it returns once executed
self.conn.connect()
logger.info('connection to db')
cur = self.conn.cursor()
# load up the cursor with the SELECT stmt and execute it
cur.execute("SELECT ingred_id, ingred_name, ingred_uom from ingredients")
# iterate thru the rows of the cursor via the cur.fetchall method. that method returns a list for each row. each such list contains values corresponding to the columns in the SELECT clause
for (row) in cur.fetchall():
tmp.append({'id':row[0], 'name':row[1], 'units':row[2]})
for i in tmp:
ingred = {'name':i['name'],
'units':i['units'],
'is_needed':IntVar(),
'is_buy':IntVar(),
'total_req_qty':0,
'total_req_qty_disp':StringVar()}
self.ingreds[i['id']] = ingred
logger.completed()
def renderIngredsCanvas(self):
logger.started()
myrow = 0
mycol = 1
logger.info('about to add recipe ingreds')
for i in self.ingreds:
logger.info('adding recipe ingreds')
label = Label(self.ingredsCanv, text=self.ingreds[i]['name'])
label.grid(row=myrow, column=mycol, sticky=W)
# chk = Checkbutton(self.ingredsCanv, text="", variable=self.ingreds[i]['is_needed'])
# chk.grid(row=myrow, column=mycol+1, sticky=W)
#
# chk = Checkbutton(self.ingredsCanv, text="", variable=self.ingreds[i]['is_buy'])
# chk.grid(row=myrow, column=mycol+2, sticky=W)
label = Label(self.ingredsCanv, textvariable=self.ingreds[i]['total_req_qty_disp'])
label.grid(row=myrow, column=mycol+3, sticky=W)
myrow += 1
logger.completed()
def handleRecipeSelections(self):
logger.started()
self.setReqQtys()
self.renderIngredsCanvas()
logger.completed()
def dumpRecipesIngredients(self):
logger.started()
for i in self.recipesIngredients:
logger.info('recipe id =' + str([i]))
logger.completed()
mycol = 1
self.dumpRecipes()
for r in self.recipes:
label = Label(self.recipesCanv, text=r['name'])
label.grid(row=myrow, column=mycol, sticky=W)
chk = Checkbutton(self.recipesCanv, text="", variable=r['is_make'], command=self.handleRecipeSelections)
chk.grid(row=myrow, column=mycol+1, sticky=W)
myrow += 1
logger.completed()
if __name__ == '__main__':
logger.started()
s = ShoppingManager()
s.execute()
s.frame.mainloop()
logger.completed()
logger.terminate()
openfile = emaillogfile.textEmailPayloadFromFile('c:\\temp\\log_file.txt')