SQLAlchemy 几种查询方式总结

SELECT DISTINCT gradelevel, beginningorendtest 
FROM wordlist 
ORDER BY gradelevel,beginningorendoftest

the equivalent query:

data = wordlist.query.with_entities(wordlist.gradelevel, wordlist.beginningorendtest)
        .distinct().order_by(wordlist.gradelevel).order_by(wordlist.beginningorendtest)

SQLAlchemy 几种查询方式总结

标签：ram   select   any   ack   lis   distinct   creat   name   记录