def generateCreditMail(self, account_name, credit):
mail_body = BimiConfig.option('credit_mail_text').replace('$amount', str(credit) + BimiConfig.option('currency'))\
.replace('$name', account_name)
mail_subj = BimiConfig.option('credit_mail_subject').replace(
'$amount',
str(credit) + BimiConfig.option('currency'))
return {'body': mail_body, 'subject': mail_subj}
def updateTransactionsView(self, widget):
self.transactions_list.clear()
lstore, it = self.accounts_view.get_selection().get_selected()
if it is None:
return
self.transactions = self.db.transactions( lstore.get_value(it, 0) )
if self.transactions:
# show only one row per transaction
cur_symbol = BimiConfig.option('currency')
total = 0.0
tid_date_value = [self.transactions[0][0], str(self.transactions[0][4].date()), 0.0]
for i,item in enumerate(self.transactions):
if tid_date_value[0] == item[0]:
tid_date_value[2] += item[3]/100.0*item[2]
else:
tid_date_value[2] = str(tid_date_value[2]) + cur_symbol
self.transactions_list.append(tid_date_value)
tid_date_value[0] = item[0]
tid_date_value[1] = str(item[4].date())
tid_date_value[2] = item[3]/100.0*item[2]
total += item[3]/100.0*item[2]
tid_date_value[2] = str(tid_date_value[2]) + cur_symbol
self.transactions_list.append(tid_date_value)
if 0.009 < BimiConfig.option('deposit'):
self.transactions_list.append( [-1, 'Deposit', str(-BimiConfig.option('deposit')) + cur_symbol] )
self.transactions_list.append( [-1, 'Balance', str(total - BimiConfig.option('deposit')) + cur_symbol] )
def generateSummaryMail(self):
mail_string = BimiConfig.option('summary_mail_text').split('\n')
mail_body = ''
for i,line in enumerate(mail_string):
# substitute $kings in file with the kings information
if line.find('$kings:') != -1:
parts = list(line.partition('$kings:'))
acc_drink_quaffed = self.db.kings()
# Check if there are kings
if acc_drink_quaffed:
len_acc = max(map(lambda x: len(x[0]), acc_drink_quaffed))
len_drink = max(map(lambda x: len(x[1]), acc_drink_quaffed))
len_quaffed = max(map(lambda x: len(str(x[2])), acc_drink_quaffed))
parts[2] = parts[2].replace('$name', '{name:<'+str(len_acc)+'}', 1)
parts[2] = parts[2].replace('$drink', '{drink:<'+str(len_drink)+'}', 1)
parts[2] = parts[2].replace('$amount', '{amount:>'+str(len_quaffed)+'}', 1)
for item in acc_drink_quaffed:
try:
insert = unicode(parts[0]) + unicode(parts[2]).format(name=item[0], drink=item[1], amount=item[2])
except StandardError as err:
self._logger.error("Line %s in file %s is not as expected! [err: %s]", str(i+1), BimiConfig.option('mail_path'), err)
return
mail_body += insert + '\n'
else:
mail_body += '{}The Rabble is delighted, there are no Kings and Queens!'.format(parts[0]) + '\n'
# substitute $accInfos in file with the account informations
elif line.find('$accInfos:') != -1:
cur_symbol = BimiConfig.option('currency')
parts = list(line.partition('$accInfos:'))
accnames_balances = []
for aid, name in self.db.accounts():
balance = sum(map( lambda x: x[2]*x[3], self.db.transactions(aid) )) / 100.0 - BimiConfig.option('deposit')
accnames_balances.append( (name, balance) )
# Check if there are accounts in DB
if accnames_balances:
len_acc = max(map(lambda x: len(x[0]), accnames_balances))
len_balance = max(map(lambda x: len(str(int(x[1]))), accnames_balances)) + 3 # +3 because .00
parts[2] = parts[2].replace('$name', '{name:<'+str(len_acc)+'}', 1)
parts[2] = parts[2].replace('$balance', '{balance:>'+str(len_balance)+'.2f}'+cur_symbol, 1)
for item in accnames_balances:
try:
insert = parts[0] + parts[2].format(name=item[0], balance=item[1])
except StandardError as err:
self._logger.error("'$accInfos:' line in %s file is broken! [err: %s]", BimiConfig.option('mail_path'), err)
return
mail_body += insert + '\n'
else:
mail_body += '{}No one lives in BimiTool-land ;_;'.format(parts[0]) + '\n'
else:
mail_body += line + '\n'
return {'subject': BimiConfig.option('summary_mail_subject'), 'body': mail_body}
def buildDrinkWindow(self):
widgets = ['drink_window', 'adjustment2', 'adjustment3', 'adjustment4', 'adjustment5', 'adjustment6']
self.gui.add_objects_from_file( BimiConfig.option('gui_path'), widgets )
self.drink_window = self.gui.get_object('drink_window')
self.gui.connect_signals({'drink_window_cancel': self.drinkWindowCancel,
'drink_window_save': self.drinkWindowSave,
'drink_window_destroyed': self.drinkWindowDestroyed})
def openMailProgram(self, mailto_dict):
mail_program = BimiConfig.option('mail_program')
# Build mailto url from dictionary
if mail_program is not None:
if 'to' in mailto_dict:
mailto_url = 'mailto:{}?'.format(
quote(mailto_dict['to'].encode('utf-8')))
else:
mailto_url = 'mailto:?'
if 'subject' in mailto_dict:
mailto_url += 'subject={}&'.format(
quote(mailto_dict['subject'].encode('utf-8')))
if 'body' in mailto_dict:
mailto_url += 'body={}'.format(
quote(mailto_dict['body'].encode('utf-8')))
else:
return mail_program
# Check which program to start
if mail_program == 'icedove' or mail_program == 'thunderbird':
process = subprocess.Popen([mail_program, "-compose", mailto_url],
stdout=subprocess.PIPE)
if process.communicate()[0] != '':
self._logger.debug("%s: %s", mail_program,
process.communicate()[0])
return mail_program
def buildMailWindow(self):
self.gui.add_objects_from_file(BimiConfig.option('gui_path'),
['mail_window', 'mail_buffer'])
self.mail_window = self.gui.get_object('mail_window')
self.gui.connect_signals(
{'mail_window_destroyed': self.mailWindowDestroyed})
text_view = self.gui.get_object('mail_view')
text_view.modify_font(Pango.FontDescription('monospace normal 10'))
def updateDrinksList(self):
self.drinks_list.clear()
cur_symbol = BimiConfig.option('currency')
for item in self.db.drinks():
self.drinks_list.append( [item[0], item[1],\
item[2]/100.0, str(item[2]/100.0) + cur_symbol,\
item[3]/100.0, str(item[3]/100.0) + cur_symbol,\
item[4]/100.0, str(item[4]/100.0) + cur_symbol,\
item[5], item[6], item[7],\
item[1] + ' @ ' + str(item[2]/100.0) + cur_symbol] )
self.updateDrinksComboBoxes()
def updateDrinksList(self):
self.drinks_list.clear()
cur_symbol = BimiConfig.option('currency')
for item in self.db.drinks():
self.drinks_list.append( [item[0], item[1],\
item[2]/100.0, str(item[2]/100.0) + cur_symbol,\
item[3]/100.0, str(item[3]/100.0) + cur_symbol,\
item[4]/100.0, str(item[4]/100.0) + cur_symbol,\
item[5], item[6], item[7],\
item[1] + ' @ ' + str(item[2]/100.0) + cur_symbol] )
self.updateDrinksComboBoxes()
def buildAccountWindow(self):
self.gui.add_objects_from_file(BimiConfig.option('gui_path'),
['account_window', 'adjustment1'])
self.account_window = self.gui.get_object('account_window')
self.gui.connect_signals({
'account_window_cancel':
self.accountWindowCancel,
'account_window_save':
self.accountWindowSave,
'account_window_destroyed':
self.accountWindowDestroyed
})
def buildDrinkWindow(self):
widgets = [
'drink_window', 'adjustment2', 'adjustment3', 'adjustment4',
'adjustment5', 'adjustment6'
]
self.gui.add_objects_from_file(BimiConfig.option('gui_path'), widgets)
self.drink_window = self.gui.get_object('drink_window')
self.gui.connect_signals({
'drink_window_cancel':
self.drinkWindowCancel,
'drink_window_save':
self.drinkWindowSave,
'drink_window_destroyed':
self.drinkWindowDestroyed
})
def updateTransactionsView(self, widget):
self.transactions_list.clear()
lstore, it = self.accounts_view.get_selection().get_selected()
if it is None:
return
self.transactions = self.db.transactions(lstore.get_value(it, 0))
if self.transactions:
# show only one row per transaction
cur_symbol = BimiConfig.option('currency')
total = 0.0
tid_date_value = [
self.transactions[0][0],
str(self.transactions[0][4].date()), 0.0
]
for i, item in enumerate(self.transactions):
if tid_date_value[0] == item[0]:
tid_date_value[2] += item[3] / 100.0 * item[2]
else:
tid_date_value[2] = str(tid_date_value[2]) + cur_symbol
self.transactions_list.append(tid_date_value)
tid_date_value[0] = item[0]
tid_date_value[1] = str(item[4].date())
tid_date_value[2] = item[3] / 100.0 * item[2]
total += item[3] / 100.0 * item[2]
tid_date_value[2] = str(tid_date_value[2]) + cur_symbol
self.transactions_list.append(tid_date_value)
if 0.009 < BimiConfig.option('deposit'):
self.transactions_list.append([
-1, 'Deposit',
str(-BimiConfig.option('deposit')) + cur_symbol
])
self.transactions_list.append([
-1, 'Balance',
str(total - BimiConfig.option('deposit')) + cur_symbol
])
def openMailProgram(self, mailto_dict):
mail_program = BimiConfig.option('mail_program')
# Build mailto url from dictionary
if mail_program is not None:
if 'to' in mailto_dict:
mailto_url = 'mailto:{}?'.format( quote(mailto_dict['to'].encode('utf-8')) )
else:
mailto_url = 'mailto:?'
if 'subject' in mailto_dict:
mailto_url+= 'subject={}&'.format( quote(mailto_dict['subject'].encode('utf-8')) )
if 'body' in mailto_dict:
mailto_url+= 'body={}'.format( quote(mailto_dict['body'].encode('utf-8')) )
else:
return mail_program
# Check which program to start
if mail_program == 'icedove' or mail_program == 'thunderbird':
process = subprocess.Popen([mail_program, "-compose", mailto_url], stdout=subprocess.PIPE)
if process.communicate()[0] != '':
self._logger.debug("%s: %s", mail_program, process.communicate()[0])
return mail_program
def buildAccountWindow(self):
self.gui.add_objects_from_file( BimiConfig.option('gui_path'), ['account_window', 'adjustment1'] )
self.account_window = self.gui.get_object('account_window')
self.gui.connect_signals({'account_window_cancel': self.accountWindowCancel,
'account_window_save': self.accountWindowSave,
'account_window_destroyed': self.accountWindowDestroyed})
def buildMailWindow(self):
self.gui.add_objects_from_file( BimiConfig.option('gui_path'), ['mail_window', 'mail_buffer'] )
self.mail_window = self.gui.get_object('mail_window')
self.gui.connect_signals({'mail_window_destroyed': self.mailWindowDestroyed})
text_view = self.gui.get_object('mail_view')
text_view.modify_font( Pango.FontDescription('monospace normal 10') )
def generateCreditMail(self, account_name, credit):
mail_body = BimiConfig.option('credit_mail_text').replace('$amount', str(credit) + BimiConfig.option('currency'))\
.replace('$name', account_name)
mail_subj = BimiConfig.option('credit_mail_subject').replace('$amount', str(credit) + BimiConfig.option('currency'))
return {'body': mail_body, 'subject': mail_subj}
def __init__(self):
self.account_window = None ##< The most recent popup window to add/edit accounts
self.drink_window = None ##< The most recent popup window to add/edit drinks
self.mail_window = None ##< The most recent popup window to get the mail text
self.edit_acc_infos = [
] ##< Stores [account_id, name] while edit_account window is open
self.edit_drink_infos = [
] ##< Stores row from drinks_list while edit_drink window is open
self.event_pos = [
] ##< [x,y] pos from event object that activated the last context menu popup
self.transactions = [
] ##< Contains all informations and transactions from one account
self.drinks_comboxes_spinbuttons = [
] ##< Contains tuples (combobox,spinbutton)
self.transactions_list = Gtk.ListStore(int, str, str)
self.accounts_list = Gtk.ListStore(int, str)
## \var self.drinks_list for each float a str for visualisation
# (did, dname, sPrice, str sPrice, pPrice, str pPrice, deposit, str deposit, fBottles, eBottles, kings, str for comboboxes)
self.drinks_list = Gtk.ListStore(int, str, float, str, float, str,
float, str, int, int, bool, str)
self._logger = logging.getLogger('BiMiTool')
# Create DataBase-object
self.db = BimiBase(BimiConfig.option('db_path'))
# Load main window from GtkBuilder file
self.gui = Gtk.Builder()
widgets = [
'main_window', 'image1', 'image2', 'image3', 'image1',
'drinks_menu', 'accounts_menu', 'transactions_menu', 'adjustment7',
'adjustment8', 'adjustment9', 'adjustment10'
]
self.gui.add_objects_from_file(BimiConfig.option('gui_path'), widgets)
try:
# Create our dictionay and connect it
dic = {
'consume_clicked': self.consumeDrinks,
'add_account': self.popAddAccWindow,
'edit_account': self.popEditAccWindow,
'acc_view_button_pressed': self.accountsViewClicked,
'tab_switched': self.tabSwitched,
'delete_account': self.deleteAccount,
'acc_view_row_act': self.updateTransactionsView,
'drinks_view_button_pressed': self.drinksViewClicked,
'delete_drink': self.deleteDrink,
'transactions_view_button_pressed':
self.transactionsViewClicked,
'undo_transaction': self.undoTransaction,
'add_drink': self.popAddDrinkWindow,
'edit_drink': self.popEditDrinkWindow,
'generate_mail': self.showSummaryMail,
#"preferences_activate": self.prefsPopup,
'main_window_destroyed': Gtk.main_quit,
'quit_activate': Gtk.main_quit
}
self.gui.connect_signals(dic)
except:
self._logger.critical(
'Autoconnection of widgets failed! Check if %s exists.',
BimiConfig.option('gui_path'))
sys.exit(1)
self.main_window = self.gui.get_object('main_window')
self.accounts_context_menu = self.gui.get_object('accounts_menu')
self.drinks_context_menu = self.gui.get_object('drinks_menu')
self.transactions_context_menu = self.gui.get_object(
'transactions_menu')
# Create column-headers and add accounts from database into rows
self.accounts_view = self.gui.get_object("accounts_view")
self.accounts_view.set_model(self.accounts_list)
self.accounts_name_col = Gtk.TreeViewColumn('Account name',
Gtk.CellRendererText(),
text=1)
self.accounts_view.append_column(self.accounts_name_col)
self.updateAccountsView()
# Create column headers for drinks_view
self.drinks_view = self.gui.get_object("drinks_view")
self.drinks_view.set_model(self.drinks_list)
col_names = [
'Name', 'Sales Price', 'Purchase Price', 'Deposit', 'Full Bottles',
'Empty Bottles', 'Kings'
]
render_cols = [1, 3, 5, 7, 8, 9, 10]
for i in range(len(col_names)):
renderer = Gtk.CellRendererText()
renderer.set_alignment(1.0, 0.5)
drinks_view_col = Gtk.TreeViewColumn(col_names[i],
renderer,
text=render_cols[i])
self.drinks_view.append_column(drinks_view_col)
# Create column headers for transactions_view
self.transactions_view = self.gui.get_object('transactions_view')
self.transactions_view.set_model(self.transactions_list)
col_names = ['Date', 'Value']
for i in range(len(col_names)):
renderer = Gtk.CellRendererText()
renderer.set_alignment(1.0, 0.5)
trans_view_col = Gtk.TreeViewColumn(col_names[i],
renderer,
text=i + 1)
self.transactions_view.append_column(trans_view_col)
# Set up and add text from database to comboboxes and spinbuttons
grid = self.gui.get_object('drinks_grid')
num = BimiConfig.option('num_comboboxes')
for i in range(num):
cbox = Gtk.ComboBox.new_with_model(self.drinks_list)
cbox.set_hexpand(True)
cell = Gtk.CellRendererText()
cbox.pack_start(cell, True)
cbox.add_attribute(cell, 'text', 11)
adjustment = Gtk.Adjustment(0, 0, 999, 1, 10, 0)
spinbutton = Gtk.SpinButton()
spinbutton.set_adjustment(adjustment)
spinbutton.set_numeric(True)
spinbutton.set_alignment(1.0)
self.drinks_comboxes_spinbuttons.append((cbox, spinbutton))
grid.attach(cbox, 0, i, 1, 1)
grid.attach(spinbutton, 1, i, 1, 1)
grid.child_set_property(self.gui.get_object('consume_button'),
'top-attach', num + 1)
grid.child_set_property(self.gui.get_object('scrolledwindow1'),
'top-attach', num + 2)
self.updateDrinksList()
self.main_window.show_all()
def generateSummaryMail(self):
mail_string = BimiConfig.option('summary_mail_text').split('\n')
mail_body = ''
for i, line in enumerate(mail_string):
# substitute $kings in file with the kings information
if line.find('$kings:') != -1:
parts = list(line.partition('$kings:'))
acc_drink_quaffed = self.db.kings()
# Check if there are kings
if acc_drink_quaffed:
len_acc = max(map(lambda x: len(x[0]), acc_drink_quaffed))
len_drink = max(map(lambda x: len(x[1]),
acc_drink_quaffed))
len_quaffed = max(
map(lambda x: len(str(x[2])), acc_drink_quaffed))
parts[2] = parts[2].replace('$name',
'{name:<' + str(len_acc) + '}',
1)
parts[2] = parts[2].replace(
'$drink', '{drink:<' + str(len_drink) + '}', 1)
parts[2] = parts[2].replace(
'$amount', '{amount:>' + str(len_quaffed) + '}', 1)
for item in acc_drink_quaffed:
try:
insert = unicode(parts[0]) + unicode(
parts[2]).format(name=item[0],
drink=item[1],
amount=item[2])
except StandardError as err:
self._logger.error(
"Line %s in file %s is not as expected! [err: %s]",
str(i + 1), BimiConfig.option('mail_path'),
err)
return
mail_body += insert + '\n'
else:
mail_body += '{}The Rabble is delighted, there are no Kings and Queens!'.format(
parts[0]) + '\n'
# substitute $accInfos in file with the account informations
elif line.find('$accInfos:') != -1:
cur_symbol = BimiConfig.option('currency')
parts = list(line.partition('$accInfos:'))
accnames_balances = []
for aid, name in self.db.accounts():
balance = sum(
map(lambda x: x[2] * x[3], self.db.transactions(
aid))) / 100.0 - BimiConfig.option('deposit')
accnames_balances.append((name, balance))
# Check if there are accounts in DB
if accnames_balances:
len_acc = max(map(lambda x: len(x[0]), accnames_balances))
len_balance = max(
map(lambda x: len(str(int(x[1]))),
accnames_balances)) + 3 # +3 because .00
parts[2] = parts[2].replace('$name',
'{name:<' + str(len_acc) + '}',
1)
parts[2] = parts[2].replace(
'$balance',
'{balance:>' + str(len_balance) + '.2f}' + cur_symbol,
1)
for item in accnames_balances:
try:
insert = parts[0] + parts[2].format(
name=item[0], balance=item[1])
except StandardError as err:
self._logger.error(
"'$accInfos:' line in %s file is broken! [err: %s]",
BimiConfig.option('mail_path'), err)
return
mail_body += insert + '\n'
else:
mail_body += '{}No one lives in BimiTool-land ;_;'.format(
parts[0]) + '\n'
else:
mail_body += line + '\n'
return {
'subject': BimiConfig.option('summary_mail_subject'),
'body': mail_body
}
def __init__(self):
self.account_window = None ##< The most recent popup window to add/edit accounts
self.drink_window = None ##< The most recent popup window to add/edit drinks
self.mail_window = None ##< The most recent popup window to get the mail text
self.edit_acc_infos = [] ##< Stores [account_id, name] while edit_account window is open
self.edit_drink_infos = [] ##< Stores row from drinks_list while edit_drink window is open
self.event_pos = [] ##< [x,y] pos from event object that activated the last context menu popup
self.transactions = [] ##< Contains all informations and transactions from one account
self.drinks_comboxes_spinbuttons = [] ##< Contains tuples (combobox,spinbutton)
self.transactions_list = Gtk.ListStore(int, str, str)
self.accounts_list = Gtk.ListStore(int, str)
## \var self.drinks_list for each float a str for visualisation
# (did, dname, sPrice, str sPrice, pPrice, str pPrice, deposit, str deposit, fBottles, eBottles, kings, str for comboboxes)
self.drinks_list = Gtk.ListStore(int, str, float, str, float, str, float, str, int, int, bool, str)
self._logger = logging.getLogger('BiMiTool')
# Create DataBase-object
self.db = BimiBase( BimiConfig.option('db_path') )
# Load main window from GtkBuilder file
self.gui = Gtk.Builder()
widgets = ['main_window', 'image1', 'image2', 'image3', 'image1',
'drinks_menu', 'accounts_menu', 'transactions_menu',
'adjustment7', 'adjustment8', 'adjustment9', 'adjustment10']
self.gui.add_objects_from_file( BimiConfig.option('gui_path'), widgets )
try:
# Create our dictionay and connect it
dic = {'consume_clicked': self.consumeDrinks,
'add_account': self.popAddAccWindow,
'edit_account': self.popEditAccWindow,
'acc_view_button_pressed': self.accountsViewClicked,
'tab_switched': self.tabSwitched,
'delete_account': self.deleteAccount,
'acc_view_row_act': self.updateTransactionsView,
'drinks_view_button_pressed': self.drinksViewClicked,
'delete_drink': self.deleteDrink,
'transactions_view_button_pressed': self.transactionsViewClicked,
'undo_transaction': self.undoTransaction,
'add_drink': self.popAddDrinkWindow,
'edit_drink': self.popEditDrinkWindow,
'generate_mail': self.showSummaryMail,
#"preferences_activate": self.prefsPopup,
'main_window_destroyed': Gtk.main_quit,
'quit_activate' : Gtk.main_quit}
self.gui.connect_signals(dic)
except:
self._logger.critical('Autoconnection of widgets failed! Check if %s exists.', BimiConfig.option('gui_path'))
sys.exit(1)
self.main_window = self.gui.get_object('main_window')
self.accounts_context_menu = self.gui.get_object('accounts_menu')
self.drinks_context_menu = self.gui.get_object('drinks_menu')
self.transactions_context_menu = self.gui.get_object('transactions_menu')
# Create column-headers and add accounts from database into rows
self.accounts_view = self.gui.get_object("accounts_view")
self.accounts_view.set_model(self.accounts_list)
self.accounts_name_col = Gtk.TreeViewColumn('Account name', Gtk.CellRendererText(), text=1)
self.accounts_view.append_column(self.accounts_name_col)
self.updateAccountsView()
# Create column headers for drinks_view
self.drinks_view = self.gui.get_object("drinks_view")
self.drinks_view.set_model(self.drinks_list)
col_names = ['Name', 'Sales Price', 'Purchase Price', 'Deposit', 'Full Bottles', 'Empty Bottles', 'Kings']
render_cols = [1,3,5,7,8,9,10]
for i in range(len(col_names)):
renderer = Gtk.CellRendererText()
renderer.set_alignment(1.0,0.5)
drinks_view_col = Gtk.TreeViewColumn(col_names[i], renderer, text=render_cols[i])
self.drinks_view.append_column(drinks_view_col)
# Create column headers for transactions_view
self.transactions_view = self.gui.get_object('transactions_view')
self.transactions_view.set_model(self.transactions_list)
col_names = ['Date', 'Value']
for i in range(len(col_names)):
renderer = Gtk.CellRendererText()
renderer.set_alignment(1.0,0.5)
trans_view_col = Gtk.TreeViewColumn(col_names[i], renderer, text=i+1)
self.transactions_view.append_column(trans_view_col)
# Set up and add text from database to comboboxes and spinbuttons
grid = self.gui.get_object('drinks_grid')
num = BimiConfig.option('num_comboboxes')
for i in range(num):
cbox = Gtk.ComboBox.new_with_model(self.drinks_list)
cbox.set_hexpand(True)
cell = Gtk.CellRendererText()
cbox.pack_start(cell, True)
cbox.add_attribute(cell, 'text', 11)
adjustment = Gtk.Adjustment(0, 0, 999, 1, 10, 0)
spinbutton = Gtk.SpinButton()
spinbutton.set_adjustment(adjustment)
spinbutton.set_numeric(True)
spinbutton.set_alignment(1.0)
self.drinks_comboxes_spinbuttons.append( (cbox, spinbutton) )
grid.attach(cbox, 0, i, 1, 1)
grid.attach(spinbutton, 1, i, 1, 1)
grid.child_set_property(self.gui.get_object('consume_button'), 'top-attach', num+1)
grid.child_set_property(self.gui.get_object('scrolledwindow1'), 'top-attach', num+2)
self.updateDrinksList()
self.main_window.show_all()