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