#django

Guess I'll have to use the trial version of Pycharm.

Do you know any alternatives to django-haystack?

django-watson, if you're against using a real search index, otherwise, just pick the lib you want (elasticsearch, whoosh, etc)

kezabelle: i’ve been using haystack for a few weeks but it’s not really maintained and i’m having problems I have no idea how to solve

it is maintained, just slowly, AFAIK

that’s why i’m looking elsewhere

last change acepted was 14 days ago :p

yeah, really slowly :)

kezabelle: yep, anyhow I’m having strange bugs with the realtime signal processor which is kind of fundamental to reflect changes made in the admin

so I’m considering alternatives

"strange bugs"

kezabelle: it just doesn’t update :)

nice and vague :|

dpaste/gist models, search indexes, relevant settings, etc if you can, or no-one can help

kezabelle: yeah i know. i need to reduce the scope of the problem before I start pasting tons of code eheh. I’ll post later. thanks!

well, I'm no expert really, but I'll look out for it ;)

kezabelle: ahahah i think i’ve already found the bug :D thank god yesterday I started looking from scratch

I'm reading https://docs.djangoproject.com/en/1.6/topics/pa..., if one already passed GET parameters like "www.example.com/?list=contacts" and would like to add pagination - how do you simply add the '<a href="?page={{ contacts.next_page_number }}">next</a>' part to the current URL without losing the '?list=contacts'?

just always append &page=?? to the URL

hey lads: I've added a field to models.py and ran python manage.py syncdb but I am still getting OperationalError

no such column .. what must I do to add a simple field to the model?

?&page=1 is just as valid as ?page=1 :)

isnt it enough to add field to models and run syncdb?

kezabelle: FYI I’m using multiple indexes because it’s a multi language website and I totally forgout about the routers so the signal processor was updating the default index and not the right one

no, syncdb doesn't alter tables

what must I do then?

rhymes: heh, that'd do it

kezabelle: Sorry, I don't follow. Where would you do that? In the URLconf or the templates?

in the templates, which is where I presume your pagination is anyway

oh damn one must manually alter table?:\ this is crappy

yuka: prior to the unreleased 1.7, the go-to for migrations is South

yuka: Try South for migrations unless you have Django 1.7.

Oh, too slow.

:D

kezabelle: Hm okey I need to think about it a bit.

kezabelle totte__ I installed south

and added field migrated project to schema of south etc

after final manage.py migrate myapp

it still gives same error

AttributeError: 'dict' object has no attribute 'iteritems'

python3?

yea

iteritems in python2 is items in python3

ph so dict.items() this is what I need to use

but where should I find those

yuka: there are porting guides to python3 which covers all the python3 specific things

linovia I am kindof lost :( since very new to all this.. I didn't think adding a new field to the table takes all this :\

yuka: There are still some libraries that aren't python3 compatible although most should now be

yes but I am totally confused as to what should I do now to solve this error? really don't know what to look for.. where do I find iteritems?

Hi, I am going through the tutorial and using python3 and mysql connector from oracle (v1.2.2). I tried date_hierarchy and it threw error Incorrect datetime value: '%Y-%m-%d 00:00:00'. http://dpaste.com/2AVZVPH . I saw this in debug: django/db/models/sql/compiler.py in execute_sql line 786 cursor.execute(sql, params) . local vars show sql as having the segment CONVERT_TZ(`polls_poll`.`pub_date`, 'UTC', "

"%s), '%%Y-%%m-%%d 00:00:00'). Should there be %%? Shouldn't it be '%Y-%m-%d...'?

yuka: google for iteritems and python and you should find it in the python's doc

bhargu: it seems to me that the problem comes from mysql though. what “date_hierarchy” does?

In tutorial, it demonstrates the use of a hierarchy filter for selecting data based on dates/months/year, etc.

linovia ok I googled and read stuff. I understand it change in python 3.x however I used south to migrate my existing app.. so I can't make this work? I can't find that anywhere

I can't find anywhere what I need to change, either on official south docs nothing is written abotu this error

list_filter seems to be more useful that date_hierarchy, but may be their uses are different.

Does django have any other database connector for mysql other than the oracle one which works with python3?

yuka: south is for database migration, not code migration

bhargu: if I understood correctly, there are a few that does, but I don't think they are supported by Django

bhargu: what's wrong with the oracle one? :)

I was getting errors Incorrect datetime value: '%Y-%m-%d 00:00:00' . When I checked the trace, it showed an sql segment CONVERT_TZ(`polls_poll`.`pub_date`, 'UTC', "

<bhargu> "%s), '%%Y-%%m-%%d 00:00:00')

CONVERT_TZ(`polls_poll`.`pub_date`, 'UTC', ""%s), '%%Y-%%m-%%d 00:00:00')

well that could be an error in django itself too, dunno

The %% part is what is confusing me. Is the %% some type of escaping or is it an error?

that should be okay

it properly ends up as '%Y-%m-%d 00:00:00'