#coding:utf-8 from flask.ext.sqlalchemy import SQLAlchemy from sqlalchemy import desc,text,or_,and_ from flask import Flask from datetime import datetime app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///app.db' app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True db = SQLAlchemy(app) db.text_factory = str def str_to_date(date_str,format="%Y-%m-%d %H:%M"): return datetime.strptime(date_str,format) if date_str is not None and len(date_str) != 0 else None def date_to_str(dt,format="%Y-%m-%d %H:%M"): if dt is None or dt == '': return None elif not isinstance(dt,datetime): return None # raise TypeError('param is not a datetime object') return dt.strftime(format) class Device(db.Model): id = db.Column(db.Integer,primary_key=True,autoincrement=True) device_brand = db.Column(db.String(30),nullable=False) device_model = db.Column(db.String(40),nullable=False) system = db.Column(db.String(10),default="android") system_version = db.Column(db.String(10)) amount = db.Column(db.Integer,default=1)