Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you how the search function of Django combination conditions is realized. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

Have been thinking about how to do the search of combination conditions!

For example, there are three input boxes at the front end. Filter after input, and write a statement in the background to match all possible combinations at the front end. There are seven kinds in total

The pseudo-sql is roughly as follows:

Select * from t where aura?

Or

Select * from t where baked?

Or

Select * from t where canals?

Or

Select * from t where aura? And b =

Or

Select * from t where aura? And c =

Or

Select * from t where baked? And c =

Or

Select * from t where aura? And b = and c

The more combination conditions, the more complex, using if and so on to judge, too complex! Try to use the Q () F () function to achieve, but also very troublesome! Finally, with reference to the ideas of others, use * * kargs reverse matching to solve!

The ideas are as follows:

If you meet the requirements, put it in the dictionary and filter it in reverse filter!

> condition = {}

> condition ['db_type'] = 1

> condition ['dport'] = 3306

> result=edatabase.objects.filter (* * condition)

> result

> for i in result:

... Print i.id,i.db_type,i.dport

...

1 1 3306

2 1 3306

9 1 3306

The above is how the search function of the Django combination conditions shared by the editor is realized. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.