# -*- coding:utf-8 -*- import sys sys.path.append('/Users/xcbfreedom/projects/web2py/web2py.app/Contents/Resources/') from gluon.dal import DAL,Field from gluon.sqlhtml import SQLFORM from gluon.validators import IS_NOT_EMPTY, IS_EMAIL, IS_LENGTH db = DAL("sqlite://data/mydb.sqlite") db.define_table('t_contact', Field("name"), Field("email"), Field("phone")) db.t_contact.name.requires = IS_NOT_EMPTY() db.t_contact.email.requires = IS_EMAIL() db.t_contact.phone.requires = IS_LENGTH(14) #====insert print db.t_contact.insert(**dict(name="fx", email="x.comll", phone='123')) print db.t_contact.insert(**dict(name="axbc", email="x.comll", phone='123')) db.commit() print 'insert ok' #====select print "select " print db(db.t_contact.phone=='123').select() print "select one" print db.t_contact(**dict(phone='123'))
#!/usr/bin/env python # -*- coding:utf-8 -*- import sys sys.path.append( '/Users/xcbfreedom/projects/web2py/web2py.app/Contents/Resources/') from gluon.dal import DAL, Field from gluon.sqlhtml import SQLFORM from gluon.validators import IS_NOT_EMPTY, IS_EMAIL, IS_LENGTH db = DAL("sqlite://data/mydb.sqlite") db.define_table('t_contact', Field("name"), Field("email"), Field("phone")) db.t_contact.name.requires = IS_NOT_EMPTY() db.t_contact.email.requires = IS_EMAIL() db.t_contact.phone.requires = IS_LENGTH(14) #====insert print db.t_contact.insert(**dict(name="fx", email="x.comll", phone='123')) print db.t_contact.insert(**dict(name="axbc", email="x.comll", phone='123')) db.commit() print 'insert ok' #====select print "select " print db(db.t_contact.phone == '123').select() print "select one" print db.t_contact(**dict(phone='123'))