return BOTO_CLIENT.create_worker_block(**params) def add_turk_fees(hit_price): return max(.005, hit_price + hit_price*.1) # ================================== # Logging hits to database # ================================== #now=datetime.now() database = 'hits.db' if SANDBOXP else 'hits-sandbox.db' db = DAL('sqlite://' + database) db.define_table('hits', db.Field('hitid', 'text'), db.Field('status', 'text', default='open'), db.Field('xmlcache', 'text'), # Local copy of mturk xml db.Field('jsoncache', 'text'), db.Field('launch_date', 'datetime'), db.Field('other', 'text')) # Not used yet... db.define_table('assignments', db.Field('assid', 'text'), db.Field('hitid', 'text'), db.Field('workerid', 'text'), db.Field('ip', 'text'), db.Field('status', 'text'), db.Field('xmlcache', 'text'), db.Field('jsoncache', 'text'), # How did I use this flag? Don't recall.
import datetime from xmldict import dict_to_xml, xml_to_dict from dal import DAL db = DAL('sqlite://movie.db') # TODO: Some field validation is needed db.define_table('tbl_clip', \ db.Field('name', 'string', length = 32, unique = True), \ db.Field('description', 'string', length = 256), \ db.Field('start_time', 'datetime'), \ db.Field('stop_time', 'datetime') ) db.define_table('tbl_show', \ db.Field('name', 'string', length = 32, unique = True) ) db.define_table('tbl_producer', \ db.Field('name', 'string', length = 32, unique = True), \ db.Field('phone', 'string', length = 32), \ db.Field('email', 'string', length = 32) ) db.define_table('tbl_producer_show', \ db.Field('producer_id', 'reference tbl_producer'), \ db.Field('show_id', 'reference tbl_show') ) db.define_table('tbl_selected_clip', \ db.Field('clip_id', 'reference tbl_clip'), \ db.Field('ps_id', 'reference tbl_producer_show') )