Flask常用操作记录

 

sqlAlchemy使用多数据库：

config:

SQLALCHEMY_BINDS = {
        'pg': 'postgresql://user:pw@xx.xx.xx.xx:1988/db',
        'mysql': 'mysql://user:pw@xx.xx.xx.xx:3306/db'
    }

 models:

class pic_search(db.Model):
    __tablename__='table'
    __bind_key__ = 'mysql'
    createtime= db.Column(db.DateTime, nullable=False)

sqlAlchemy 模糊查询+逻辑：

DBSession().query(user).filter(user.u_name.like('%三%')).filter(user.u_name.like('%猫%'))

或者可以用 and_ or_

DBSession().query(user).filter(and_(user.u_name.like('%三%'), user.u_name.like('%猫%')))

street_pic_search.query.filter(or_(street_pic_search.tags.like(w) for w in like_list))

 

flask复选框：

 

form.py

class SimpleForm(FlaskForm):
    string_of_files = [('价格', '价格'), ('版型', '版型'), ('款式', '款式'), ('面料', '面料'), ('品质', '品质'), ('颜色', '颜色')]
    tag = SelectMultipleField('tag', choices=string_of_files)
    items8 = StringField("UserId", validators=[Length(0, 64)])
    submit = SubmitField('提交')

html

<link href="/static/select2.min.css" rel="stylesheet">
   <script src="/static/jquery.min.js"></script>
   <script src="/static/select2.min.js"></script>
   <script type="text/javascript">
      $("select").select2({
          allowClear: true,
          placeholder: '按 CTRL+A 全选所有项 || 点击某项上的 x 去除该项 || 点击选项右上角的 x 清除所有项'
          });
      $(document).on(
        "keyup",
        ".select2-search__field",
        function (e) {
            selectAllSelect2($(this));
        });
      function selectAllSelect2(that)
{
            $("select")
            .find("option")
            .prop('selected','selectAll')
            .trigger('change');
        }
   </script>