As far as I know the Django ORM encapsulates SQL queries, so you can't put
arbitrary python code in there (".strip()")If I remember correctly SQL does not have a standard TRIM method, but individual database engines do, for example for Postgres http://www.postgresql.org/docs/9.1/static/functions-string.html So you can run a raw SQL command or just iterate over all the rows in your data I think. On Tue, Nov 3, 2015 at 6:57 AM, DJ-Tom <[email protected]> wrote: > Hi, > > I have several character fields with leading and trailing spaces and would > like to know if it is possible to clean them up with a one-liner... > > I tried the following but none of this works: > > > rooms.objects.all().update(name=F('name').strip()) // AttributeError: 'F' > object has no attribute 'strip' > > rooms.objects.all().update(name=Value(F('name')).strip()) // AttributeError: > 'Value' object has no attribute 'strip' > > rooms.objects.all().update(name=name.strip()) // NameError: name 'name' is > not defined > > Also searching via Google did not help. > > Of course I could do some loop, but this seems to be not very efficient to me. > > Any Idea? > > Thomas > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/django-users. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/f018f0a5-3a8a-4c28-a1d6-2fb96807093e%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/f018f0a5-3a8a-4c28-a1d6-2fb96807093e%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CALn3ei3uvS62R3Aju350frKQJZhHSkK8S1qiLTxq6q%3DJeSBg6A%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
