Python insert Examples

Example #1

File: card_category.py Project: suchitparikh/saffroncards

def _put(name, code):
    values = {}
    values['category'] = name
    values['code'] = code.strip("'")

    query = cc.insert().values(values)
    try:
        res = _exe(query)
    except Exception as e:
        abort(500, error=e.message)
    else:
        return {'success': res.rowcount}

Example #2

File: add.py Project: suchitparikh/saffroncards

def _add_category(category, code):
    """
    Underlying implementation to add the category to the database
    """
    engine = Engine().getEngine()
    values = {}

    values['category'] = category
    values['code'] = code.strip("'")

    query = cc.insert().values(values)
    result = engine.execute(query)

    return 1