def handler(event, context): sql = db.table('work') query_params = event.get('queryStringParameters') or {} authors = split(query_params.get('authors')) categories = split(query_params.get('categories')) if authors: sql = ( sql.join('workRole', 'work.id', '=', 'workRole.workId') .where('workRole.type', 'author') .where_in('workRole.userId', authors) ) if categories: sql = ( sql.join( JoinClause('categoryMap') .on('work.id', '=', 'categoryMap.categorizableId') .where('categoryMap.categorizableType', '=', 'work') ) .join('category', 'category.id', '=', 'categoryMap.categoryId') .where_in('category.key', categories) ) return { 'body': dumps({'data': list(map(lambda x: parse(x), sql.get()))}), 'headers': {'Access-Control-Allow-Origin': '*'}, 'statusCode': 200, }
def handler(event, context): try: body = json.loads(event.get('body')) except: body = {} id_ = body.get('id') contents = body.get('contents') work = db.table('work').where('id', id_).first() try: if work is None: db.table('work').insert({ 'id': id_, 'contents': json.dumps(contents) }) work = db.table('work').where('id', id_).first() else: db.table('work').where('id', id_).update( {'contents': json.dumps(contents)}) except Exception as e: return abort(400, parse_sql_error(e)) return { 'body': dumps({'data': parse(work)}), 'headers': { 'Access-Control-Allow-Origin': '*' }, 'statusCode': 201, }
def handler(event, context): return { 'body': dumps({ 'data': db.table('category').lists('key'), }), 'headers': {'Access-Control-Allow-Origin': '*'}, 'statusCode': 200, }
def handler(event, context): path_params = event.get('pathParameters') work_id = path_params.get('id') work = db.table('work').where('id', work_id).first() if work is None: return abort(404, 'not found') return { 'body': dumps({'data': parse(work)}), 'headers': { 'Access-Control-Allow-Origin': '*' }, 'statusCode': 200, }
def handler(event, context): try: body = json.loads(event.get('body')) except: body = {} categorizable_id = body.get('categorizableId') categorizable_type = body.get('categorizableType') if categorizable_type is not None and categorizable_type not in types: return abort(403, new_error('invalid categorizable type', 1)) category_ids = [] for key in body.get('keys') or []: category_id = db.table('category').where('key', key).pluck('id') if category_id is None: category_id = db.table('category').insert_get_id({'key': key}) category_ids.append(category_id) if categorizable_id is not None and categorizable_type is not None: db.table('categoryMap').where({ 'categorizableId': categorizable_id, 'categorizableType': categorizable_type, }).delete() for category_id in category_ids: db.table('categoryMap').insert({ 'categoryId': category_id, 'categorizableId': categorizable_id, 'categorizableType': categorizable_type, }) return { 'body': dumps({'data': True}), 'headers': { 'Access-Control-Allow-Origin': '*' }, 'statusCode': 201, }
def handler(event, context): user_id = new_id() while db.table('user').where({'id': user_id}).first(): user_id = new_id() try: body = json.loads(event.get('body')) except: body = {} props = body.get('props') or {} verbose = body.get('verbose') unique_props = {k: v for k, v in props.items() if k in UNIQUE_KEYS} custom_props = {k: v for k, v in props.items() if k not in unique_props} if 'password' in custom_props: custom_props['password'] = password(custom_props['password']) try: set_props(user_id, props=unique_props, unique=True) set_props(user_id, props=custom_props) db.table('user').insert(id=user_id) except Exception as e: return abort(400, parse_sql_error(e)) return { 'body': dumps({ 'data': get( user_id, keys=props.keys(), verbose=verbose, is_me=True, ) }), 'headers': { 'Access-Control-Allow-Origin': '*' }, 'statusCode': 201, }