Changeset 99
- Timestamp:
- 04/10/08 19:59:02 (6 months ago)
- Files:
-
- sucrose/trunk/python/api/sucrose.py (modified) (4 diffs)
- sucrose/trunk/python/cardswipe.py (modified) (4 diffs)
- sucrose/trunk/python/keypad.py (deleted)
- sucrose/trunk/python/keypad_gtk.py (added)
- sucrose/trunk/python/keypad_tk.py (deleted)
- sucrose/trunk/python/mysql/db.py (modified) (1 diff)
- sucrose/trunk/python/sucrose (modified) (1 diff)
- sucrose/xorg.conf (added)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
sucrose/trunk/python/api/sucrose.py
r98 r99 11 11 import authenticator 12 12 import magicalpic 13 from mysql import db 13 14 14 15 class Sucrose(object): 15 16 16 def netid_from_uin(self, uin):17 return self.users.filter_by(uin=uin).first() .netid17 def user_from_uin(self, uin): 18 return self.users.filter_by(uin=uin).first() 18 19 19 def uid_from_uin(self, uin):20 return self.users.filter_by(uin=uin).first().uid21 22 def location_from_id(self, id):23 return self.trays.filter_by(item_id=id).first().machine_tray_id24 25 def cost_from_id(self, id):26 return self.trays.filter_by(item_id=id).first().cur_price27 28 def balance_from_uid(self, uid):29 self.session.clear()30 return self.users.filter_by(uid=uid).first().balance31 20 32 21 def tray_from_location(self, location): … … 37 26 return self.trays.filter_by(machine_tray_id=int(location)).first() 38 27 39 def vend(self, location, uin): 28 29 def item_from_tray(self, tray): 30 return self.items.filter_by(item_id = tray.item_id).first() 31 32 33 def vend(self, tray, uin): 40 34 transaction = self.session.begin() 41 35 try: … … 44 38 raise ValueError('no such user') 45 39 46 tray = self.tray_from_location(location)47 40 if not tray: 48 41 raise ValueError('no such tray!?') … … 68 61 raise 69 62 70 def item_name_from_id(self, id):71 return self.items.filter_by(item_id=id).first().name72 63 73 64 def __init__(self, db, dbonly=False): sucrose/trunk/python/cardswipe.py
r80 r99 6 6 7 7 from api import sucrose, authenticator 8 from mysql import db 8 9 9 10 """ … … 15 16 def authenticate_purchase(self, location): 16 17 return True # XXX wit, fix it 18 17 19 18 20 def authenticate_session(self): … … 36 38 37 39 # Authenticate the UIN 38 return self.sucrose.netid_from_uin(self.uin) 40 return self.sucrose.user_from_uin(self.uin) 41 39 42 40 43 def __init__(self, sucrose): … … 44 47 return 45 48 49 46 50 def __del__(self): 47 51 self.cardreader.close() 48 52 return 53 sucrose/trunk/python/mysql/db.py
r83 r99 30 30 Column('item_id', Integer, primary_key=True, autoincrement=True), 31 31 Column('num_consumed', Integer), 32 Column('name', String(255))) 32 Column('name', String(255)), 33 Column('caffeine', Integer), 34 Column('calories', Integer), 35 Column('sugar', Integer), 36 Column('carbohydrates', Integer), 37 Column('fiber', Integer), 38 Column('sodium', Integer), 39 Column('fat', Integer), 40 Column('saturated_fat', Integer), 41 Column('protein', Integer), 42 Column('cholesterol', Integer)) 33 43 34 44 _trays = Table('trays', _sucrose_Base.metadata, sucrose/trunk/python/sucrose
r72 r99 18 18 19 19 while True: 20 netid= card.authenticate_session()20 user = card.authenticate_session() 21 21 22 if not netid:23 print " Failed to get netid"22 if not user: 23 print "User does not exist" 24 24 continue 25 25
