python数据库

数据库的表全部建立

@blue.route(’/createstudent/’)
def create_student():
db.create_all()
return ‘创建数据库成功！’

@blue.route(’/adduser/’)
def add_user():
user = User()
user.username = {{}}
db.session.add(user)
db.session.commit()
return ‘添加数据成功！’

把新增学生的信息

@blue.route(’/addstudent/’)
def add_student():
student = Student()
student.studentname = ‘小华’
db.session.add(student)
db.session.commit()
return ‘添加数据成功！’

展示所有的学生

@blue.route(’/studentlist/’)
def student_list():
students = Student.query.all()
students = Student.query.filter(Student.studentname.like("%小张4%"))
students = Student.query.filter(Student.id.lt(10))
students = Student.query.filter(Student.id < 10)
students = Student.query.filter(Student.id.le(10))
students = Student.query.filter(Student.id.gt(30))
students = Student.query.filter(Student.id > 30)
students = Student.query.filter(Student.id.ge(10))
students = Student.query.filter(Student.studentname.contains(‘4’))
students = Student.query.filter(Student.studentname == ‘小张10’)
# students = Student.query.all()
students = Student.query.filter(Student.studentname.startswith(‘小张1’))
students = Student.query.filter(Student.studentname.endswith(‘0’))
students = Student.query.filter_by(id=1) # 常用在级联数据上
students = Student.query.limit(3) # 限制
students = Student.query.offset(3) # 偏移
# students = Student.query.offset(1).order_by(“id”) # 错误组合
students = Student.query.order_by(“id”).limit(11).offset(1) # 正确组合
# students = Student.query.order_by("-id") # 排序

for ss in students:
    print(ss.id)
return render_template('studentlist.html', studentlist=students)

开发者环境配置

class DevelopConfig(Config):
DEBUG = True

DATEBASE = {
    "ENGINE": 'mysql',
    "DRIVER": 'pymysql',
    "USER": 'root',
    "PASSWORD": '123456',
    "HOST": 'localhost',
    "PORT": '3306',
    "NAME": 'test',
}
# SQLALCHEMY_DATABASE_URI=""
SQLALCHEMY_DATABASE_URI = get_db_uri(DATEBASE)

envs = {
‘develop’: DevelopConfig,
‘testing’: TestConfig,
‘staging’: StagingConfig,
‘produce’: ProduceConfig

• {% for kk in studentlist %}
• {{ kk.studentname }}
• {% endfor %} {% for oooo in studentlist %} {{ oooo.id }} {% endfor %}

  {#   <table>#}
  {#       {% for st in studentlist %}#}
  {#       <tr>#}
  {#       <td>{{ st.id }}</td>#}
  {#       </tr>#}
  {#       {% endfor %}#}
  {##}
  {#   </table>#}