__author__ = 'chenzhao' import datetime import re import hashlib from flask.ext.sqlalchemy import SQLAlchemy from sqlalchemy.schema import UniqueConstraint from sqlalchemy.orm import backref db = SQLAlchemy() GEO_NUMBER_TYPE = db.REAL() #python any is stupid def good_any(l): for i in l: if i: return i return False def get_or_create(model, **kwargs): instance = db.session.query(model).filter_by(**kwargs).first() if instance: return instance else: instance = model(**kwargs) db.session.add(instance) db.session.flush() return instance