For thoroughness sake, let&#39;s just mention the [`Q`][1] object method:

    from django.db.models import Q
    criterion1 = Q(question__contains=&quot;software&quot;)
    criterion2 = Q(question__contains=&quot;java&quot;)
    q = Question.objects.filter(criterion1 &amp; criterion2)

Note the other answers here are simpler and better adapted for your use case, but if anyone with a similar but slightly more complex problem (such as needing &quot;not&quot; or &quot;or&quot;) sees this, it&#39;s good to have the reference right here.


  [1]: https://docs.djangoproject.com/en/3.0/topics/db/queries/#complex-lookups-with-q-objects

(**update**: this answer will not work anymore and give the syntax error `keyword argument repeated`)


    mymodel.objects.filter(first_name__icontains=&quot;Foo&quot;, first_name__icontains=&quot;Bar&quot;)

**update**: Long time since I wrote this answer and done some django, but I am sure to this days the best approach is to use the Q object method like David Berger shows here: [How do I use AND in a Django filter?][1]


  [1]: http://stackoverflow.com/a/770078/63097

You can chain filter expressions in Django:

    q = Question.objects.filter(question__contains=&#39;software&#39;).filter(question__contains=&#39;java&#39;)

You can find more info in the Django docs at &quot;[Chaining Filters][1]&quot;.


  [1]: https://docs.djangoproject.com/en/dev/topics/db/queries/#chaining-filters

I want tabs along the left side of the page instead of across the top.  I&#39;m already loading jQuery for other reasons (effects), so I prefer using jQuery to another UI framework.  Searches on &quot;vertical tabs jquery&quot; yield links to works-in-progress.  


Is getting Vertical Tabs to work across browsers fraught, or is it so trivial that, once you have a solution, it doesn&#39;t seem worthwhile to post example code?

Vertical Tabs with JQuery?

I&#39;m surprised this hasn&#39;t been posted yet. Any interesting tricks that you know about in Postgres? Obscure config options and scaling/perf tricks are particularly welcome. 

I&#39;m sure we can beat the 9 comments on the corresponding [MySQL thread][1] :)


  [1]: https://stackoverflow.com/questions/368858/hidden-features-of-mysql/600830#600830

Hidden Features of PostgreSQL

How do I create an &quot;AND&quot; filter to retrieve objects in Django? e.g I would like to retrieve a row which has a combination of two words in a single field.

For example the following SQL query does exactly that when I run it on mysql database:

    select * from myapp_question
    where ((question like &#39;%software%&#39;) and (question like &#39;%java%&#39;))

How do you accomplish this in Django using filters?


How do I use AND in a Django filter?

How do I create an "AND" filter to retrieve objects in Django? e.g I would like to retrieve a row which has a combination of two words in a single field.
For example the following SQL query does exactly that when I run it on mysql database:
<pre><code class="hljs language-sql">select * from myapp_question
where ((question like '%software%') and (question like '%java%'))
</code></pre>
How do you accomplish this in Django using filters?

While idly surfing the namespace I noticed an odd looking object called `Ellipsis`, it does not seem to be or do anything special, but it&#39;s a globally available builtin. 

After a search I found that it is used in some obscure variant of the slicing syntax by Numpy and Scipy... but almost nothing else. 

Was this object added to the language specifically to support Numpy + Scipy? Does Ellipsis have any generic meaning or use at all?

    D:\workspace\numpy&gt;python
    Python 2.4.4 (#71, Oct 18 2006, 08:34:43) [MSC v.1310 32 bit (Intel)] on win32
    Type &quot;help&quot;, &quot;copyright&quot;, &quot;credits&quot; or &quot;license&quot; for more information.
    &gt;&gt;&gt; Ellipsis
    Ellipsis

What does the Ellipsis object do?

Surely a 0d array is scalar, but Numpy does not seem to think so... am I missing something or am I just misunderstanding the concept? 

    &gt;&gt;&gt; foo = numpy.array(1.11111111111, numpy.float64)
    &gt;&gt;&gt; numpy.ndim(foo)
    0
    &gt;&gt;&gt; numpy.isscalar(foo)
    False
    &gt;&gt;&gt; foo.item()
    1.11111111111

Why are 0d arrays in Numpy not considered scalar?

I want to plot a graph with one logarithmic axis using matplotlib. 

I&#39;ve been reading the docs, but can&#39;t figure out the syntax. I know that it&#39;s probably something simple like `&#39;scale=linear&#39;` in the plot arguments, but I can&#39;t seem to get it right


Sample program: 

    import pylab
    import matplotlib.pyplot as plt
    a = [pow(10, i) for i in range(10)]
    fig = plt.figure()
    ax = fig.add_subplot(2, 1, 1)
    
    line, = ax.plot(a, color=&#39;blue&#39;, lw=2)
    pylab.show()

Plot logarithmic axes with matplotlib in python

I&#39;ve read the documentation on egg entry points in Pylons and on the Peak pages, and I still don&#39;t really understand. Could someone explain them to me?

Explain Python entry points?

I have a function that returns information in seconds, but I need to store that information in hours:minutes:seconds.

Is there an easy way to convert the seconds to this format in Python?




How do I convert seconds to hours, minutes and seconds?

Is there a good way to do this in Django without rolling my own authentication system?  I want the username to be the user&#39;s email address instead of them creating a username.

Please advise

Accepting email address as username in Django

With inspectdb I was able to get a &quot;interval&quot; field from postgres into django. In Django, it was a TextField. The object that I retrieved was indeed a timedelta object!

Now I want to put this timedelta object in a new model. What&#39;s the best way to do this? Because putting a timedelta in a TextField results in the str version of the object...

How to put timedelta in django model?

I&#39;m trying to build a simple website with login functionality very similar to the one here on SO.
The user should be able to browse the site as an anonymous user and there will be a login link on every page. When clicking on the login link the user will be taken to the login form. After a successful login the user should be taken back to the page from where he clicked the login link in the first place.
I&#39;m guessing that I have to somehow pass the url of the current page to the view that handles the login form but I can&#39;t really get it to work.


EDIT:
I figured it out. I linked to the login form by passing the current page as a GET parameter and then used &#39;next&#39; to redirect to that page. Thanks!

EDIT 2:
My explanation did not seem to be clear so as requested here is my code:
Lets say we are on a page foo.html and we are not logged in. Now we would like to have a link on foo.html that links to login.html. There we can login and are then redirected back to foo.html.
The link on foo.html looks like this:

          &lt;a href=&#39;/login/?next={{ request.path }}&#39;&gt;Login&lt;/a&gt; 
Now I wrote a custom login view that looks somewhat like this:

    def login_view(request):
       redirect_to = request.REQUEST.get(&#39;next&#39;, &#39;&#39;)
       if request.method==&#39;POST&#39;:
          #create login form...
          if valid login credentials have been entered:
             return HttpResponseRedirect(redirect_to)  
       #...
       return render_to_response(&#39;login.html&#39;, locals())

And the important line in login.html:

    &lt;form method=&quot;post&quot; action=&quot;./?next={{ redirect_to }}&quot;&gt;
So yeah thats pretty much it, hope that makes it clear.

Django: Redirect to previous page after login

I am trying to set the field to a certain value after the form is initialized. 

For example, I have the following class.

    class CustomForm(forms.Form):
    	Email = forms.EmailField(min_length=1, max_length=200)

In the view, I want to be able to do something like this:

	form = CustomForm()
	form[&quot;Email&quot;] = GetEmailString()

	return HttpResponse(t.render(c))

Django set field value after a form is initialized

I&#39;m having trouble overriding a `ModelForm` save method. This is the error I&#39;m receiving:

    Exception Type:  	TypeError  
    Exception Value: 	save() got an unexpected keyword argument &#39;commit&#39;

My intentions are to have a form submit many values for 3 fields, to then create an object for each combination of those fields, and to save each of those objects. Helpful nudge in the right direction would be ace.

###File `models.py`

    class CallResultType(models.Model):
        id = models.AutoField(db_column=&#39;icontact_result_code_type_id&#39;, primary_key=True)
        callResult = models.ForeignKey(&#39;CallResult&#39;, db_column=&#39;icontact_result_code_id&#39;)
        campaign = models.ForeignKey(&#39;Campaign&#39;, db_column=&#39;icampaign_id&#39;)
        callType = models.ForeignKey(&#39;CallType&#39;, db_column=&#39;icall_type_id&#39;)
        agent = models.BooleanField(db_column=&#39;bagent&#39;, default=True)
        teamLeader = models.BooleanField(db_column=&#39;bTeamLeader&#39;, default=True)
        active = models.BooleanField(db_column=&#39;bactive&#39;, default=True)


###File `forms.py`

    from django.forms import ModelForm, ModelMultipleChoiceField
    from callresults.models import *

    class CallResultTypeForm(ModelForm):
        callResult = ModelMultipleChoiceField(queryset=CallResult.objects.all())
        campaign = ModelMultipleChoiceField(queryset=Campaign.objects.all())
        callType = ModelMultipleChoiceField(queryset=CallType.objects.all())
    
        def save(self, force_insert=False, force_update=False):
            for cr in self.callResult:
                for c in self.campain:
                    for ct in self.callType:
                        m = CallResultType(self) # this line is probably wrong
                        m.callResult = cr
                        m.campaign = c
                        m.calltype = ct
                        m.save()
    
        class Meta:
            model = CallResultType

###File `admin.py`

    class CallResultTypeAdmin(admin.ModelAdmin):
        form = CallResultTypeForm

Content Type	Original Author	Original Content on Stackoverflow
Question	gath	View Question on Stackoverflow
Solution 1 - Python	David Berger	View Answer on Stackoverflow
Solution 2 - Python	Andrea Di Persio	View Answer on Stackoverflow
Solution 3 - Python	mipadi	View Answer on Stackoverflow

How do I use AND in a Django filter?

Python Problem Overview

Python Solutions

Solution 1 - Python

Solution 2 - Python

Solution 3 - Python

Hidden Features of PostgreSQL

Vertical Tabs with JQuery?

Attributions