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')
)
