Flask connecting to the database to play the blame upgrade tour

Objective

In the beginner Flask, in the database connection this part also with each beginner. But with the work of the project to take over more, code to write more, more experience and have their own experience and skills. After a continuous upgrade of the code, we have compiled a learning experience of connecting to the database part of the connection database, which is the journey of the monster upgrade that we shared today. I hope we can provide some references on the way to learn Python.

Primary Stage

Install the Mysql expansion pack first

650) this.width=650; "Src=" https://mmbiz.qpic.cn/mmbiz_png/ Mzws9obx0p4auvmg4wjujqx0ipukyv8xmnpia5ibzjavwvbwd05kkymicdiat7toegw3duo1whqian8vrzvs8mjoj1w/0?wx_fmt=png "Style = "Margin:0px;padding:0px;height:auto;" alt= "0?wx_fmt=png"/>

Establish a database link

650) this.width=650; "Src=" https://mmbiz.qpic.cn/mmbiz_png/ Mzws9obx0p4auvmg4wjujqx0ipukyv8xdoljvsaemibrznjqxhuiiahryoqdvahblpjh4jtigkjprwmkbg0ictoa/0?wx_fmt=png "Style=" Margin:0px;padding:0px;height:auto; "alt=" 0?wx_fmt=png "/>

Open the road to the strange upgrade

In daily development, the most common application scenario for connecting to a database is to query all data and query individual data. Take the example of querying all data scenarios.

Small white version --Upload to front-end rendering on back-end tables

650) this.width=650; "Src=" https://mmbiz.qpic.cn/mmbiz_png/ Mzws9obx0p4auvmg4wjujqx0ipukyv8xy8zo3l4ctv3eibotutsmeuxyzvtutpdwdsp61ivowmlxhsifib1ilibaa/0?wx_fmt=png "Style=" Margin:0px;padding:0px;height:auto; "alt=" 0?wx_fmt=png "/>

Advanced Stage

First off--back end eliminates HTML tags

Back end:

650) this.width=650; "Src=" https://mmbiz.qpic.cn/mmbiz_png/ Mzws9obx0p4auvmg4wjujqx0ipukyv8xs8icmczzm3yfajmthao93gszsibqwt0yxqs1jutlxkjj5zwd5gd7jncq/0?wx_fmt=png "Style=" Margin:0px;padding:0px;height:auto; "alt=" 0?wx_fmt=png "/>

Front:

650) this.width=650; "Src=" https://mmbiz.qpic.cn/mmbiz_png/ Mzws9obx0p4auvmg4wjujqx0ipukyv8xp2cb0gtica86ziap5e3uwgib5iboaiawf2p8rqrj8kfkldxqtxxusy5ziauq/0?wx_fmt=png " Style= "Margin:0px;padding:0px;height:auto;" alt= "0?wx_fmt=png"/>

Second level--make the return values elegant

650) this.width=650; "Src=" https://mmbiz.qpic.cn/mmbiz_png/ Mzws9obx0p4auvmg4wjujqx0ipukyv8xia3kbj6ibaxz2aetiag5wbfrhlzynwoeu44x2hwvadhsgklqbxdqd5o9a/0?wx_fmt=png "Style=" Margin:0px;padding:0px;height:auto; "alt=" 0?wx_fmt=png "/>

Third level--make the code more concise

650) this.width=650; "Src=" https://mmbiz.qpic.cn/mmbiz_png/ Mzws9obx0p4auvmg4wjujqx0ipukyv8xhdigmx3xpbtbofiaqlhwmfadciaopiwe9dtbalwgdbjlkzavrqqxzfha/0?wx_fmt=png "Style=" Margin:0px;padding:0px;height:auto; "alt=" 0?wx_fmt=png "/>

A more efficient way--directly converting the returned nested progenitor to a nested dictionary, commonly used with query ID only, Username scenario

650) this.width=650; "Src=" https://mmbiz.qpic.cn/mmbiz_png/ Mzws9obx0p4auvmg4wjujqx0ipukyv8xvxclajmomnauialoibogibwkyx3jgcbrmswag4nibxp7marylfzth3cw5g/0?wx_fmt=png "style= "Margin:0px;padding:0px;height:auto;" alt= "0?wx_fmt=png"/>

Today's upgrade to a strange trip to the introduction is complete.

This article is from the "Python & Golang Learning" blog, reproduced please contact the author!

Flask connecting to the database to play the blame upgrade tour