gmane.comp.python.django.user

Problem counting names by letters

Brian Millham — 2013-05-24T20:53:55

With this simple database table:

class Artist(models.Model):
    id = models.IntegerField(primary_key=True)
    name = models.CharField(max_length=255L, blank=True)
    prefix = models.CharField(max_length=32L, blank=True)
    class Meta:
        db_table = 'artist'

I want to be able to get a list of the first letter of the names with a
count, for example with these artists in the table:

ABBA, America, Asia, Blondie, Billy Joel, Charo

I want this result

letter=A lcount=3
letter=B lcount=2
letter=C lcount=1

To complicate things, the database is not the default database.

I've tried this raw query

letters = Artist.objects.using('database_name').raw('SELECT id,
UPPER(LEFT(name,1)) AS letter, COUNT(DISTINCT name) AS lcount FROM
artist GROUP BY UPPER(LEFT(name,1)) ORDER BY UPPER(name)')

but I get this error: AttributeError: 'QuerySet' object has no attribute
'raw'

I've been able to do it using a cursor directly. Is that the only way?
Or am I missing something. I'm trying to limit my use of raw and direct

Problem counting names by letter

Brian Millham — 2013-05-24T20:40:47

With this simple database table:

class Artist(models.Model):
    id = models.IntegerField(primary_key=True)
    name = models.CharField(max_length=255L, blank=True)
    prefix = models.CharField(max_length=32L, blank=True)
    class Meta:
        db_table = 'artist'

I want to be able to get a list of the first letter of the names with a
count, for example with these artists in the table:

ABBA, America, Asia, Blondie, Billy Joel, Charo

I want this result

letter=A lcount=3
letter=B lcount=2
letter=C lcount=1

To complicate things, the database is not the default database.

I've tried this raw query

letters = Artist.objects.using('database_name').raw('SELECT id,
UPPER(LEFT(name,1)) AS letter, COUNT(DISTINCT name) AS lcount FROM
artist GROUP BY UPPER(LEFT(name,1)) ORDER BY UPPER(name)')

but I get this error: AttributeError: 'QuerySet' object has no attribute
'raw'

I've been able to do it using a cursor directly. Is that the only way?
Or am I missing something. I'm trying to limit my use of raw and direct

object is not iterable

Olivier — 2013-05-24T16:43:07

Hello all,

I have an insoluble problem when I try to use the formsets...

*This is my models:*
class Relais(models.Model): 
nom = models.CharField(max_length=100,blank=True)
competition = models.ForeignKey(Competition)
sport = models.ForeignKey(Sport)
ordre = models.IntegerField()

def __unicode__(self):
if self.nom:
return self.nom 
else:
return "%s - %d - %s" % (self.competition.nom,self.ordre,self.sport.nom)

*my forms.py:*
class RelaisForm(ModelForm):
class Meta:
model = Relais

*and the part of my views.py which cause this problem:*
        relaisList = competition.relais_set.all()
RelaisFormSet = formset_factory(RelaisForm)
formset = RelaisFormSet(initial=relaisList) # <== this line


The error is:
Exception Type:TypeErrorException Value:

'Relais' object is not iterable




Have you got an idea on what cause this problem ?
Thank you ;)

Help with robots.txt

frocco — 2013-05-24T12:04:43

Hello,

Can someone give me an example of configuring robots.txt?

I want to block the admin site.

and anything else?

current transaction is aborted, commands ignored until end of transaction block

Andreas Kuhne — 2013-05-24T08:55:57

Hi all,

I am working on upgrading our system from django 1.3.1 to django 1.5.1, and
have run into a huge problem. The site we are running has multilingual
support and the platform has multiple top level domain sites connected to
it. Running locally on my machine I get an error when I try to switch
languages.

The error is : "current transaction is aborted, commands ignored until end
of transaction block", so I guess that something is not being commited
correctly to the database. If i change the database setttings to
"autocommit = True" then the site works perfectly. It doesn't matter which
page I go to, when there is a database lookup it will not work. It does
work in english (default language) and oddly enough swedish (can be because
that is "our" language, which I test first).

I was wondering if there is anyone out there that has any ideas why a
change from 1.3.1 to 1.5.1 would result in these errors or if anyone has
any suggestions on what this could be?

Regards,

Andréas

upload image with Django

Gianluca Dileo — 2013-05-24T10:48:32

Hi guy,
I've created a form in a page html that upload a image.
After capturing the image and edit it, I need to have it appear in a window 
j
How can i do?

Django - Tastypie and mongoengine

Hélio Miranda — 2013-05-24T10:56:19

Hi!
Has anyone used Tastypie and mongoengine for an application in django and 
mongodb?

It's just that I have a problem and needed help.
I'm having trouble doing the many to many relationships.

If someone has already done something with tastypie mongoengine and tell me 
to put my doubts.

thank you

hi Why the page is showing in this way?

lx — 2013-05-24T09:11:15

hi all:
      I'm learning the django-cms, and the page is:

[image: 内嵌图片 1]

How to solve it?
Thank you

Cache witin a single transaction / session ?

brycenesbitt — 2013-05-24T06:50:52

Does there exist a lightweight cache option for django which persists data
in a single session. For example:

{{gallery.tiles.count}} item{% if gallery.tiles.count != 1 %}s{% endif %}

Produces two count() operations on the underlying database.  Is there a way 
to make that one operation?

Integrating NoSQL-persisted custom Models

Kurtis — 2013-05-24T05:26:46

A project I am working on uses a hybrid SQL/NoSQL data backend.

I'd like to build custom Models which "behave" exactly like the traditional 
Django Models but are tied into my MongoDB backend.

Where should I start to make sure I cover all bases? Implementing  my own 
instance Model? I imagine I'll also need custom Model Managers as well.

I'm guessing there are some problems with this approach since they forked 
Django for a full non-relational release several versions ago. I imagine 
3rd party components may also throw their own set of problems at me as well.

If anyone has given this a shot before, can you share some tips or pitfalls 
you ran into during the process? 

Thanks!
- Kurtis

Problem with ~ in url prefix

Hordur Heidarsson — 2013-05-23T23:05:47

Hello,

I'm trying to deploy django in my public_html directory which is served via 
http://servername/~username/ by mod_wsgi in apache.
However, I'm running into some errors in the admin interface:

--------
Environment:

Request Method: GET
Request URL: https://192.168.0.2/~hordur/django/admin/sites/site/

Django Version: 1.5.1
Python Version: 2.7.3
Installed Applications:
('django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'django.contrib.admin',
 'django.contrib.admindocs',
 'django.contrib.flatpages',
 'south',
 'django_extensions',
 'debug_toolbar',
 'micawber.contrib.mcdjango',
 'hordur')
Installed Middleware:
('django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middle

Inlines problem under admin: on production server I'm unable to add more lines in the inline section

Victor — 2013-05-23T18:18:17

In admin.py I have
.......................................
class MovimentomagInline(admin.TabularInline):
    model=Movimentomag
    extra=3
    save_on_top=True

class MovimentoOperazioneOption(admin.ModelAdmin):
    list_display = ('segno', 'data_movimento', 'paziente','operatore')
    fields=(('segno','data_movimento'),('paziente','operatore'))
    inlines=[MovimentomagInline,]
    save_on_top=True
    order_by=['-data_movimento',]

admin.site.register(MovimentoOperazione,MovimentoOperazioneOption)


Now it happens that - under admin -  when I use "python manage.py runserver" in the developping context I can see in the inline section the "Add another ..." with the plus sign and I can add more lines in the inline section itself.
Submitting the same django procedure by means of Apache 2 I see the lines specified in the extra option but there's no longer the   "Add another ..." with the plus sign, therefore I cannot add more lines in the inline section.

How can I fix that?

Thanks
Vittorio

Display each language in its own language.

Cody Scott — 2013-05-23T19:26:04

 

I would like the language selector to display each language in its own 
language. So for example English will always be displayed as 'English'. 
Even if the current language is French it will still be 'English' and not 
Anglais.


<li>  <form id="locale_switcher" method="POST" action="{% url 'localeurl_change_locale' %}">    {% csrf_token %}    <select name="locale" onchange="$('#locale_switcher').submit()" class="btn btn-inverse">      {% for lang in LANGUAGES %}        <option class="btn btn-inverse" value="{{ lang.0 }}"           {% ifequal lang.0 LANGUAGE_CODE %}            selected="selected"          {% endifequal %}>          {{ lang.1 }}</option>      {% endfor %}    </select>  </form></li>


I think all language selector forms should be like this.

DeserializationError while loading a datamigration for auth data

Alexandre Provencio — 2013-05-23T17:20:02

Hello guys, I'd like to auto populate my app recently converted to
south, with permission group and user data. However, after generating
a fixture and calling it from the datamigration I'm getting this
error. I've put the steps I'm taking detailed here
http://stackoverflow.com/questions/16470492/deserializationerror-while-loading-a-datamigration-for-auth-data

Any help is welcome.

-Alexandre

Django tutorial - change history 24h time format?

Pepsodent Cola — 2013-05-23T13:47:44

Hi,

I'm reading Part 2 and this chapter *"Explore the free admin functionality"*of the Django tutorial.
https://docs.djangoproject.com/en/1.5/intro/tutorial02/#explore-the-free-admin-functionality

I have a question regarding the *"Change history"* part where you can see a 
screenshot at the end of that chapter.

The time format used in the "Change history" administration pages uses *AM/PM 
time format*.  How can I make it display *24h time format* instead?

Multiprocess and Global State

christophe de saint leger — 2013-05-23T12:30:27

I all, 

Environment:
- Django 1.5.1 
- mongoengine 0.8.1  

I use mongoengine to store and manage user accounts authentication.

it work fine with the development server and uwsgi : only if I use a single 
process or thread mode.

If i use more than 1 process, sometime ( when i refresh my application ), i 
am redirected on my login form.

All my request must be authentified, i use a middleware to do this : 

from django.http import HttpResponse,HttpResponseRedirect


I think , there are unshared data between the processes who causes this 
problem.

What do you think?


Note : it works well with gunicorn

Ch.

Testing with complex database setups

Jani Tiainen — 2013-05-23T12:09:08

Hi,

I've product that uses complex setup scripts - tens of SQL scripts that creates tables, views, complex triggers, grants permissions and such and finally populates database with some pre-data.

So how I should proceed with unit testing with database like that, since some operations rely heavily that there really exists all that trigger-function mess in the database? So that I don't need everytime to start from the scratch but from some known state of the db?

Filter

Hélio Miranda — 2013-05-23T10:58:07

Hi
I have the following code, in which the player have a reference to the club:
*class Club(mongoengine.Document):*
*    ClubName = StringField()*
*
*
*class Player(mongoengine.Document):*
*    PlayerName = StringField()*
*    PlayerAge = IntField()*
*    PlayerClub = fields.ListField(fields.ReferenceField(Club,*
*                        reverse_delete_rule=CASCADE, dbref=False))*
*
*
*------------------------------*
*
class PlayerResource(resources.MongoEngineResource):
    
    PlayerClub = fields.ReferencedListField(of='Rela.Resource.ClubResource',
         attribute='PlayerClub', full=True, null=True)
    
    class Meta:
        queryset = Player.objects.all()
        allowed_methods = ('get', 'post', 'put', 'delete')
        list_allowed_methods = ['get', 'post','put', 'delete']
        authorization = Authorization()
        resource_name = 'Player'
        filtering = {
            'PlayerClub': ALL_WITH_RELATIONS,
        }
 
    def determine_format(self, request): 
        return "application/json

Looking for beta testers for new Django hosting

Michael Anckaert — 2013-05-23T09:48:23

Hello everyone

We are developing a new Python/wsgi hosting solution and are looking for
beta testers.
The solution we are developing will focus on ease of deployment (git
integration, management of application versions, ...)

Beta testers will receive a free instance on our platform. Don't expect a
stable or production ready environment. Your (testing) projects will live a
bleeding edge fast changing environment!

We would very much appreciate you help in developing this new product. You
can expect to work closely with our developers and your input will be used
in further defining our roadmap.
If you would like to help us out, please send an email to
platform< at >sinax.bewith some info about you. Ideas about what a good
hosting solution should
have are also very much appreciated.

*Kind regards*

Michael Anckaert
michael.anckaert< at >sinax.be
http://www.sinax.be

No module named wsgi

Luggaz — 2013-05-23T09:41:04

Good day,

I am having a problem making my website live.
It works fine on the development server and I do get(http:127.0.0.1:8000 ) 
running but when I make it live I get an error saying there's no module 
named wsgi.


I am using a virtualenv and when I activate virtualenv(locally) and import 
django.core.wsgi it does import

I viewed this error on file: /var/log/apache2/error.log

I also have: /etc/apache2/sites-available/www.bushbucksfc.co.za
which looks like this:
<VirtualHost *:80>
  ServerName www.bushbucksfc.co.za
  ServerAlias bushbucksfc.co.za
  DocumenRoot /home/websites/busbucksfc
  WSGIDaemonProcess bushbucksfc 
python-path=/home/websites/bushbucksfc:/home/websites/.bushenv/lib/python2.7/site-packages
 WSGIProcessGroup bushbucksfc
 WSGIScriptAlias / /home/websites/bushbucksfc/bushucksfc/wsgi.py
...
...
</VirtualHost>

Regards,
Luggaz

View pictures from the template via models.FilePathField

Federico Erbea — 2013-05-23T07:57:02

I'm not sure this is the correct method to use, so I'm open to suggestions.
Practically I want to display the image retrieving the path where they are 
saved from the database.

In a class in models.py I have inserted:

locandina = models.FilePathField( path = "C:/Users/Federico.Erbea/Google 
Drive/Umore/apps/Database/static/Film/Locandina/", recursive=True)

In the Admin the pull-down menu perfectly recovers the files I'm interested 
in, allowing me to select the appropriate one
I didn't understand very well how works FilePathField, so I don't know how 
to pass the information to the template ... I need help, thanks