def purchase_beer(self, beer_barcode, user_barcode): """User purchases beer""" beer_price = self.bar_database.get_item(beer_barcode, statement='price') user_name, user_id = self.bar_database.get_user(user_barcode) user_name = to_ascii_utf8(user_name) if beer_price <= self.bar_database.sum_log(user_id): # Since the beer_barcode may be both the real barcode or the alternative # barcode we need to get the real barcode from the db for the transactions log real_beer_barcode = int( self.bar_database.get_item(beer_barcode, statement='barcode')) self.bar_database.insert_log(user_id, user_barcode, "purchase", beer_price, item=real_beer_barcode) beer_name = self.bar_database.get_item(beer_barcode, statement='name') beer_name = to_ascii_utf8(beer_name) balance = self.bar_database.sum_log(user_id) self.picaso.clear_screen() self.picaso.move_cursor(1, 0) self.picaso.put_string("User: {}".format(user_name)) self.picaso.move_cursor(3, 0) self.picaso.put_string("Beer purchased:") self.picaso.move_cursor(4, 0) self.picaso.text_factor(2) self.picaso.put_string("{}".format(beer_name)) self.picaso.move_cursor(5, 0) self.picaso.text_factor(1) self.picaso.put_string("Account balance: {}".format(balance)) self.timer(3) else: self.picaso.clear_screen() x_screen_resolution = self.picaso.get_graphics_parameters('x_max') y_screen_resolution = self.picaso.get_graphics_parameters('y_max') self.picaso.draw_filled_rectangle( (0, 0), (x_screen_resolution, y_screen_resolution), (1, 0, 0)) self.picaso.move_cursor(1, 0) self.picaso.text_factor(3) self.picaso.text_foreground_color((0, 0, 0)) self.picaso.text_background_color((1, 0, 0)) self.picaso.put_string("Insufficient") self.picaso.move_cursor(2, 0) self.picaso.put_string("Funds!") self.picaso.move_cursor(4, 0) self.picaso.text_factor(2) self.picaso.put_string("Get a job") self.picaso.text_foreground_color((0, 1, 0)) self.picaso.text_background_color((0, 0, 0)) self.timer(5)
def main(): """Run the decoding steps""" con = MySQLdb.connect('servcinf-sql', 'fridays', 'fridays', 'cinfdata', charset='utf8', use_unicode=False) cursor = con.cursor() print('\n========= Users ========') cursor.execute('select name from fridays_user') users = cursor.fetchall() for user in users: user = user[0] print(type(user)) norm_user = to_ascii_utf8(user) try: norm_user.encode('ascii') except UnicodeDecodeError: print('Encoding to ascii failed for this entry') print(user) raise print('Name: {:<30} -> {}'.format(user, norm_user)) print('\n========= Items ========') cursor.execute('select name, brewery from fridays_items') items = cursor.fetchall() for name, brewery in items: print("--------------------") norm_name = to_ascii_utf8(name) try: norm_name.encode('ascii') except UnicodeDecodeError: print('Encoding to ascii failed for this entry') print(name) raise print('Name: {:<30} -> {}'.format(name, norm_name)) if brewery is None: continue norm_brewery = to_ascii_utf8(brewery) try: norm_brewery.encode('ascii') except UnicodeDecodeError: print('Encoding to ascii failed for this entry') print(brewery) raise print('Brewery: {:<30} -> {}'.format(brewery, norm_brewery))
def present_user(self, user_barcode): """Present user info, i.e. user name and balance""" user_name, user_id = self.bar_database.get_user(user_barcode) user_name = to_ascii_utf8(user_name) balance = self.bar_database.sum_log(user_id) # Screen layout, username self.picaso.clear_screen() #self.picaso.move_cursor(1, 0) self.picaso.move_origin(0, 5) self.picaso.put_string("User:"******"Balance:") self.picaso.text_factor(3) self.picaso.move_cursor(3, 0) self.picaso.put_string("{}".format(balance)) # Timeout for number in range(10, 0, -1): self.picaso.move_cursor(5, 0) self.picaso.put_string("Timeout: {: <2} ".format(number)) self.timer(1)
def present_user(self, user_barcode): """Present user info, i.e. user name and balance""" user_name, user_id = self.bar_database.get_user(user_barcode) user_name = to_ascii_utf8(user_name) balance = self.bar_database.sum_log(user_id) # Screen layout, username self.picaso.clear_screen() #self.picaso.move_cursor(1, 0) self.picaso.move_origin(0, 5) self.picaso.put_string("User:"******"Balance:") self.picaso.text_factor(3) self.picaso.move_cursor(3, 0) self.picaso.put_string("{}".format(balance)) # Timeout for number in range(10, 0, -1): self.picaso.move_cursor(5, 0) self.picaso.put_string("Timeout: {: <2} ".format(number)) self.timer(1)
def purchase_beer(self, beer_barcode, user_barcode): """User purchases beer""" beer_price = self.bar_database.get_item(beer_barcode, statement='price') user_name, user_id = self.bar_database.get_user(user_barcode) user_name = to_ascii_utf8(user_name) if beer_price <= self.bar_database.sum_log(user_id): # Since the beer_barcode may be both the real barcode or the alternative # barcode we need to get the real barcode from the db for the transactions log real_beer_barcode = int(self.bar_database.get_item(beer_barcode, statement='barcode')) self.bar_database.insert_log(user_id, user_barcode, "purchase", beer_price, item=real_beer_barcode) beer_name = self.bar_database.get_item(beer_barcode, statement='name') beer_name = to_ascii_utf8(beer_name) balance = self.bar_database.sum_log(user_id) self.picaso.clear_screen() self.picaso.move_cursor(1, 0) self.picaso.put_string("User: {}".format(user_name)) self.picaso.move_cursor(3, 0) self.picaso.put_string("Beer purchased:") self.picaso.move_cursor(4, 0) self.picaso.text_factor(2) self.picaso.put_string("{}".format(beer_name)) self.picaso.move_cursor(5, 0) self.picaso.text_factor(1) self.picaso.put_string("Account balance: {}".format(balance)) self.timer(3) else: self.picaso.clear_screen() x_screen_resolution = self.picaso.get_graphics_parameters('x_max') y_screen_resolution = self.picaso.get_graphics_parameters('y_max') self.picaso.draw_filled_rectangle( (0, 0), (x_screen_resolution, y_screen_resolution), (1, 0, 0) ) self.picaso.move_cursor(1, 0) self.picaso.text_factor(3) self.picaso.text_foreground_color((0, 0, 0)) self.picaso.text_background_color((1, 0, 0)) self.picaso.put_string("Insufficient") self.picaso.move_cursor(2, 0) self.picaso.put_string("Funds!") self.picaso.move_cursor(4, 0) self.picaso.text_factor(2) self.picaso.put_string("Get a job") self.picaso.text_foreground_color((0, 1, 0)) self.picaso.text_background_color((0, 0, 0)) self.timer(5)
def main(): """Run the decoding steps""" con = MySQLdb.connect('servcinf', 'fridays', 'fridays', 'cinfdata', charset='utf8', use_unicode=False) cursor = con.cursor() print('\n========= Users ========') cursor.execute('select name from fridays_user') users = cursor.fetchall() for user in users: user = user[0] print(type(user)) norm_user = to_ascii_utf8(user) try: norm_user.encode('ascii') except UnicodeDecodeError: print('Encoding to ascii failed for this entry') print(user) raise print('Name: {:<30} -> {}'.format(user, norm_user)) print('\n========= Items ========') cursor.execute('select name, brewery from fridays_items') items = cursor.fetchall() for name, brewery in items: print("--------------------") norm_name = to_ascii_utf8(name) try: norm_name.encode('ascii') except UnicodeDecodeError: print('Encoding to ascii failed for this entry') print(name) raise print('Name: {:<30} -> {}'.format(name, norm_name)) if brewery is None: continue norm_brewery = to_ascii_utf8(brewery) try: norm_brewery.encode('ascii') except UnicodeDecodeError: print('Encoding to ascii failed for this entry') print(brewery) raise print('Brewery: {:<30} -> {}'.format(brewery, norm_brewery))
def present_beer(self, barcode): """INSERT Show beer""" self.picaso.clear_screen() beer_price = str(self.bar_database.get_item(barcode, statement='price')) self.picaso.move_cursor(4, 4) self.picaso.put_string("Special price for you my friend:") self.picaso.move_cursor(7, 5) self.picaso.text_factor(5) self.picaso.put_string("{} DKK".format(beer_price)) self.timer(3) # INSERT Show spiffy comment self.picaso.clear_screen() self.picaso.move_cursor(1, 0) self.picaso.put_string(cowsay("Enjoy your delicious {}".format( to_ascii_utf8(self.bar_database.get_item(barcode, statement='name')) ))) self.timer(4)
def present_beer(self, barcode): """INSERT Show beer""" self.picaso.clear_screen() beer_price = str(self.bar_database.get_item(barcode, statement='price')) self.picaso.move_cursor(4, 4) self.picaso.put_string("Special price for you my friend:") self.picaso.move_cursor(7, 5) self.picaso.text_factor(5) self.picaso.put_string("{} DKK".format(beer_price)) self.timer(3) # INSERT Show spiffy comment self.picaso.clear_screen() self.picaso.move_cursor(1, 0) self.picaso.put_string( cowsay("Enjoy your delicious {}".format( to_ascii_utf8( self.bar_database.get_item(barcode, statement='name'))))) self.timer(4)