I solved it like this:

    MyClass.objects.filter(name__iexact=my_parameter)

There is even a way to use it for substring search:

    MyClass.objects.filter(name__icontains=my_parameter)

There&#39;s a [link to the documentation][1].


  [1]: https://docs.djangoproject.com/en/dev/topics/db/queries/#querysets-are-lazy

    DELETE B.* 
    FROM   m_productprice B  
           INNER JOIN m_product C ON B.m_product_id = C.m_product_id 
    WHERE  C.upc = &#39;7094&#39; AND B.m_pricelist_version_id = &#39;1000020&#39;

i am getting the following error PostgreSQL 8.2.11

    ERROR:  syntax error at or near &quot;B&quot;
    LINE 1: DELETE B.* from m_productprice B  INNER JOIN m_product C ON ...


i tried giving 

    DELETE B from m_productprice B  INNER JOIN m_product C ON B....
     ERROR:  syntax error at or near &quot;B&quot;

i tried giving

    ERROR:  syntax error at or near &quot;INNER&quot;
    LINE 1: DELETE from m_productprice B  INNER JOIN m_product C ON B.m_...


what is the problem with my query?

PostgreSQL delete with inner join

I use **hover**, **active** and **disabled** to style Buttons.

But the problem is when the button is disabled the hover and active styles still applies.

How to apply hover and active only on enabled buttons?

Hover and Active only when not disabled

How can I query/filter in Django and ignore the cases of my query-string?

I&#39;ve got something like and like to ignore the case of `my_parameter`:

    MyClass.objects.filter(name=my_parameter)

Django Model - Case-insensitive Query / Filtering

How can I query/filter in Django and ignore the cases of my query-string?
I've got something like and like to ignore the case of <code>my_parameter</code>:
<pre><code class="hljs language-ini">MyClass.objects.filter(name=my_parameter)
</code></pre>

I would like to manage my Heroku database with `pgadmin` client. By now, I&#39;ve been doing this with `psql`.
When I use data from `heroku pg:credentials` to connect de DB using `pgadmin`, I obtain:

&gt; An error has occurred:
&gt; 
&gt; Error connecting to the server: FATAL:  permission denied for database
&gt; &quot;postgres&quot; DETAIL:  User does not have CONNECT privilege.

How to achieve the connection?

Connect to a heroku database with pgadmin

I was wondering if it is possible to get the date that a specific table in a database was created. My employer would like to add this feature and I have been unable to find a solution with Google.

I figured SO is the next best place to look.

How do I get the creation date of a MySQL table?

I&#39;ve recently gone through the database migration process as outlined here:

https://devcenter.heroku.com/articles/migrating-from-shared-database-to-heroku-postgres

Now I&#39;m seeing a number of errors in the logs like this:

PGError: ERROR: permission denied for relation &lt;table-name&gt;

Any ideas on what I should do to fix it?

PGError: ERROR: permission denied for relation (when using Heroku)

I am new to Android and I have to create an application where I need to use a SQLite database.
I am not so well equipped with the SQLite.

Could you tell me what the purpose and use of the `SQLiteOpenHelper` class, and provide a simple database creation and insertion example?

Android SQLite Example

Is it possible in `MS SQL Server 2008` to export database structure into a `T-SQL` file? 

I want to export not only tables schema but also primary keys, foreign keys, constraints, indexes, stored procedures, user defined types/functions. 

Also I don&#39;t want the data to be present in this `T-SQL` file. 

Is there any way to achieve that?

Export database schema into SQL file

Python noob, as in this is my first project, so excuse my unfamiliarity.

The site was working very well until I clicked &quot;log out&quot; on my app. After that, the website would give me this error:
DoesNotExist at /login/
Site matching query does not exist.

I searched everywhere and the only solution I get relates to setting up the site framework, SITE_ID, etc. I think those items on my computer are fine, but I can&#39;t find a walkthrough/guide to help me check on them.

Can anyone tell me what the problem is and how to fix it? Thanks in advance :3


     DATABASES = {
        &#39;default&#39;: {
            &#39;ENGINE&#39;: &#39;django.db.backends.sqlite3&#39;, # Add &#39;postgresql_psycopg2&#39;, &#39;postgresql&#39;, &#39;mysql&#39;, &#39;sqlite3&#39; or &#39;oracle&#39;.
            &#39;NAME&#39;: &#39;/home/dotcloud/nhs.db&#39;,                      # Or path to database file if using sqlite3.
            &#39;USER&#39;: &#39;&#39;,                      # Not used with sqlite3.
            &#39;PASSWORD&#39;: &#39;&#39;,                  # Not used with sqlite3.
            &#39;HOST&#39;: &#39;&#39;,                      # Set to empty string for localhost. Not used with sqlite3.
            &#39;PORT&#39;: &#39;&#39;,                      # Set to empty string for default. Not used with sqlite3.
        }
    }



Site matching query does not exist

I want to start using Twitter&#39;s Bootstrap for a recently started Django app. I have quite a bit of experience with Django, but I&#39;m totally new to Bootstrap.

What&#39;s the best way to proceed? Are there any particular Boostrap apps for Django you would recommend or have experience with?

I understand that I could use Bootstrap directly, without any special Bootstrap-specific Django apps. However, I also read that the form rendering doesn&#39;t come out particularly well without a little server side support (rendering the Bootstrap specific CSS into the form HTML, for example).

There seem to be several projects, such as crispy forms, django-bootstrap-toolkit, etc. Looking at their project pages, I can see different levels of activity and support. If I decide to go with one of those, I would of course like to pick one which has some momentum and therefore a good likelihood of staying supported and maintained for a while. This is very important and so even if the particular app doesn&#39;t have all possible features or is a bit less flexible, it might still be a good choice, due to support/freshness, availability of examples, etc.

Thank you for any recommendations or feedback.


Django and Bootstrap: What app is recommended?

I have a jinja2 template (.html file) that I want to render (replace the tokens with values from my py file).  Instead of sending the rendered result to a browser, however, I want to write it to a new .html file.  I would imagine the solution would also be similar for a django template.

How can I do this?

How do I render jinja2 output to a file in Python instead of a Browser

I have problems understanding how the unit tests should be designed for django.

From my understanding testing the whole view in one go seems impossible. We need to distinguish between pre-post and post states of request. But I have no idea how to design this. Is there any real life example?

Looking at the documentation the examples are too simplified and only focused on the model. 

    @login_required
    def call_view(request, contact_id):
        profile = request.user.get_profile()
        if request.POST:        
            form = CallsForm(profile.company, request.POST)           
            if form.is_valid()
            return HttpResponseRedirect(&#39;/contact/&#39; + contact_id + &#39;/calls/&#39;)
        else:        
            form = CallsForm(profile.company, instance=call)              
        variables = RequestContext(request, {&#39;form&#39;:form}
        return render_to_response(&#39;conversation.html&#39;, variables)

**update:**

trying to make a success test work, but it still fails:

    def test_contact_view_success(self):
        # same again, but with valid data, then
        self.client.login(username=&#39;username1&#39;, password=&#39;password1&#39;)
        response = self.client.post(&#39;/contact/add/&#39;, {u&#39;last_name&#39;: [u&#39;Johnson&#39;], }) 
        self.assertRedirects(response, &#39;/&#39;)

**error message:**

    AssertionError: Response didn&#39;t redirect as expected: Response code was 200 (expected 302)

I think this is because the form.is_valid() fails and it doesn&#39;t redirect, correct?


How to write a unit test for a django view?

I can’t log in to the django admin page. When I enter a valid username and password, it just brings up the login page again, with no error messages

This question is in the [django FAQ][1], but I&#39;ve gone over the answers there and still can&#39;t get past the initial login screen.

I&#39;m using django 1.4 on ubuntu 12.04 with apache2 and modwsgi.

I&#39;ve confirmed that I&#39;m registering the admin in the `admin.py` file, made sure to syncdb after adding `INSTALLED_APPS`.
When I enter the wrong password I *DO* get an error, so my admin user is being authenticated, just not proceeding to the admin page.
     
I&#39;ve tried both setting `SESSION_COOKIE_DOMAIN` to the machine&#39;s IP and None.  (Confirmed that the cookie domain shows as the machine&#39;s IP in chrome)

Also, checked that the user authenticates via the shell:

    &gt;&gt;&gt; from django.contrib.auth import authenticate
    &gt;&gt;&gt; u = authenticate(username=&quot;user&quot;, password=&quot;pass&quot;)
    &gt;&gt;&gt; u.is_staff
    True
    &gt;&gt;&gt; u.is_superuser
    True
    &gt;&gt;&gt; u.is_active 
    True



Attempted login using IE8 and chrome canary, both results in the same return to the login screen.


Is there something else I&#39;m missing????

**settings.py**

    ...
    MIDDLEWARE_CLASSES = (
        &#39;django.middleware.gzip.GZipMiddleware&#39;,
        &#39;django.middleware.common.CommonMiddleware&#39;,
        &#39;django.contrib.sessions.middleware.SessionMiddleware&#39;,
        &#39;django.contrib.auth.middleware.AuthenticationMiddleware&#39;,
        &#39;django.middleware.transaction.TransactionMiddleware&#39;,
        &#39;django.middleware.csrf.CsrfViewMiddleware&#39;,
        &#39;django.contrib.messages.middleware.MessageMiddleware&#39;,
    )
    AUTHENTICATION_BACKENDS = (&#39;django.contrib.auth.backends.ModelBackend&#39;,)
    INSTALLED_APPS = (
        &#39;django.contrib.auth&#39;,
        &#39;django.contrib.contenttypes&#39;,
        &#39;django.contrib.sessions&#39;,
        &#39;django.contrib.sites&#39;,
        &#39;django.contrib.messages&#39;,
        &#39;django.contrib.admin&#39;,    
        &#39;django.contrib.staticfiles&#39;,
        &#39;django.contrib.gis&#39;,
        &#39;myapp.main&#39;,
    )
    
    SESSION_EXPIRE_AT_BROWSER_CLOSE = True
    SESSION_SAVE_EVERY_REQUEST = True
    SESSION_COOKIE_AGE = 86400 # sec
    SESSION_COOKIE_DOMAIN = None
    SESSION_COOKIE_NAME = &#39;DSESSIONID&#39;
    SESSION_COOKIE_SECURE = False

    


**urls.py**

    from django.conf.urls.defaults import * #@UnusedWildImport
    from django.contrib.staticfiles.urls import staticfiles_urlpatterns
    from django.contrib import admin
    
    admin.autodiscover()
    
    urlpatterns = patterns(&#39;&#39;,
        (r&#39;^bin/&#39;, include(&#39;myproject.main.urls&#39;)),    
        (r&#39;^layer/r(?P&lt;layer_id&gt;\d+)/$&#39;, &quot;myproject.layer.views.get_result_layer&quot;),
        (r&#39;^layer/b(?P&lt;layer_id&gt;\d+)/$&#39;, &quot;myproject.layer.views.get_baseline_layer&quot;),
        (r&#39;^layer/c(?P&lt;layer_id&gt;\d+)/$&#39;, &quot;myproject.layer.views.get_candidate_layer&quot;),    
        (r&#39;^layers/$&#39;, &quot;myproject.layer.views.get_layer_definitions&quot;),
        (r&#39;^js/mapui.js$&#39;, &quot;myproject.layer.views.view_mapjs&quot;),
        (r&#39;^tilestache/config/$&#39;, &quot;myproject.layer.views.get_tilestache_cfg&quot;),
        (r&#39;^admin/&#39;, include(admin.site.urls)),  
        (r&#39;^sites/&#39;, include(&quot;myproject.sites.urls&quot;)),  
        (r&#39;^$&#39;, &quot;myproject.layer.views.view_map&quot;),
    )
    
    
    urlpatterns += staticfiles_urlpatterns()



Apache Version:

    Apache/2.2.22 (Ubuntu) mod_wsgi/3.3 Python/2.7.3 configured

Apache apache2/sites-available/default:

    &lt;VirtualHost *:80&gt;
            ServerAdmin ironman@localhost
            DocumentRoot /var/www/bin
            LogLevel warn
            WSGIDaemonProcess lbs processes=2 maximum-requests=500 threads=1
            WSGIProcessGroup lbs
            WSGIScriptAlias / /var/www/bin/apache/django.wsgi
            Alias /static /var/www/lbs/static/
    &lt;/VirtualHost&gt;
    &lt;VirtualHost *:8080&gt;
            ServerAdmin ironman@localhost
            DocumentRoot /var/www/bin
            LogLevel warn
            WSGIDaemonProcess tilestache processes=2 maximum-requests=500 threads=1
            WSGIProcessGroup tilestache
            WSGIScriptAlias / /var/www/bin/tileserver/tilestache.wsgi
    &lt;/VirtualHost&gt;


**UPDATE**

The admin page does proceed when using the development server via `runserver` so it seems like a wsgi/apache issue.  Still haven&#39;t figured it out yet.

**SOLUTION**

The problem was that I had the settings file `SESSION_ENGINE` value set to `&#39;django.contrib.sessions.backends.cache&#39;` *without* having the `CACHE_BACKEND` properly configured. 

I&#39;ve changed the SESSION_ENGINE to `&#39;django.contrib.sessions.backends.db&#39;` which resolved the issue.


  [1]: https://docs.djangoproject.com/en/dev/faq/admin/#i-can-t-log-in-when-i-enter-a-valid-username-and-password-it-just-brings-up-the-login-page-again-with-no-error-messages

Unable log in to the django admin page with a valid username and password

I came across an interesting situation when using this class:

&lt;!-- language: lang-python --&gt;

    class Company(models.Model):
        date = models.DateField()
        time = models.TimeField()

&lt;!-- language: lang-python --&gt;

    c = Company(date=datetime.datetime.now(), time=datetime.datetime.now()) 

Django decides to use `DATETIME_INPUT_FORMATS` defined within the **formats.py** file.
Which makes sense, because I am passing in a `datetime.now()` to both fields.

I think I could make Django to use `DATE_INPUT_FORMATS` and `TIME_INPUT_FORMATS` respectively, if I passed in only the current date and current time in.

Something like this:

    c = Company(date=datetime.date.now(), time=datetime.time.now()) 

But this obviously throws an exception as now doesn&#39;t exist like that.  Is there a different way to achieve this?


How do I get the current date and current time only respectively in Django?

I have a model something like this:

```python
class Task(models.Model):
    progress = models.PositiveIntegerField()
    estimated_days = models.PositiveIntegerField()
```

Now I would like to do a calculation `Sum(progress * estimated_days)` on the database level. Using Django Aggregation I can have the sum for each field but not the summation of multiplication of fields. 

Django Aggregation: Summation of Multiplication of two fields

Is there a way (without using a form) to access a model fields choices value?

I want to do something like `field.choices` and get the list of values either in a view or template.

How to access Django&#39;s field.choices?

One of my models has a deleted flag, which is used to hide objects globally:

    class NondeletedManager(models.Manager):
        &quot;&quot;&quot;Returns only objects which haven&#39;t been deleted&quot;&quot;&quot;

        def get_query_set(self):
            return super(NondeletedManager, self).get_query_set().exclude(deleted=True)

    class Conversation(BaseModel):
        ...
        deleted = models.BooleanField(default=False)
        objects = NondeletedManager()
        all_conversations = models.Manager() # includes deleted conversations

How can I override the default queryset used by Django admin module to include deleted conversations?


Override default queryset in Django admin

How to get the currently logged-in user&#39;s id?

in `models.py`:

    class Game(models.model):
        name = models.CharField(max_length=255)
        owner = models.ForeignKey(User, related_name=&#39;game_user&#39;, verbose_name=&#39;Owner&#39;)
    

in `views.py`:

    gta = Game.objects.create(name=&quot;gta&quot;, owner=?)

How to get the currently logged in user&#39;s user id in Django?

I was told that in ZSH you could do something like `command` and then when you hit up it would filter the history based on the given command. But when I try this it just cycles the history like bash does. Is this disabled by default?

Filtering ZSH history by command

Sorry just getting into Pandas, this seems like it should be a very straight forward question. How can I use the `isin(&#39;X&#39;)` to remove rows that **are in** the list `X`? In R I would write `!which(a %in% b)`.


Remove rows not .isin(&#39;X&#39;)

Is it possible to filter out some requests using Chrome developer tools, say, filter out all image requests?

Is there a way to filter network requests using Google Chrome developer tools?

In the Music app of the new iOS, we can see an album cover behind a view that blurs it. 

How can something like that be accomplished? I&#39;ve read the documentation, but did not find anything there.

![][1]


  [1]: http://i.stack.imgur.com/QXEg4m.jpg

Creating a blurring overlay view

I have a pandas `DataFrame` called `data` with a column called `ms`.  I want to eliminate all the rows where `data.ms` is above the 95% percentile.  For now, I&#39;m doing this:

    limit = data.ms.describe(90)[&#39;95%&#39;]
    valid_data = data[data[&#39;ms&#39;] &lt; limit]

which works, but I want to generalize that to any percentile.  What&#39;s the best way to do that?


Content Type	Original Author	Original Content on Stackoverflow
Question	Ron	View Question on Stackoverflow
Solution 1 - Database	Ron	View Answer on Stackoverflow

Django Model - Case-insensitive Query / Filtering

Database Problem Overview

Database Solutions

Solution 1 - Database

Hover and Active only when not disabled

PostgreSQL delete with inner join

Attributions