Re: django multi db routing doesnt work wich multiple schemas

2012-10-12 Thread Michał Nowotka
First of all the error is not from django but from database. Secondly I'm not using different databases but different schemas so relations are possible. The error has nothing to do with foreign key or any relation. It just looks like django is ignoring router suggestion and directs sql query to wro

Re: django multi db routing doesnt work wich multiple schemas

2012-10-12 Thread Michał Nowotka
Unfortunately not exactly. Schema in Oracle is a synonym of user so you need name and password. That's why it doesn't fit into tablespaces solution you pointed. There is open ticket about support for multiple schemas but it's still unfinished. This is why I was looking for solution that would work

Re: django multi db routing doesnt work wich multiple schemas

2012-10-12 Thread Michał Nowotka
Anyway, look at the query that needs to be executed. This doesn't contain any joins. The only problem is that this perfectly correct query is send to wrong schema although the router suggests a good one. I don't know why, is there anyone who can explain this to me? -- You received this message be

How to get oracle NUMBER with syncdb

2012-10-17 Thread Michał Nowotka
Hello, I have some legacy oracle database against which I run inspectdb command. One column in the DB has type NUMBER (without precision and scale) and what I got from django is: entity_id = models.DecimalField(unique=True, null=True, max_digits=0, decimal_places=-127, blank=True) If I now run sy

Re: How to get oracle NUMBER with syncdb

2012-10-17 Thread Michał Nowotka
Even if I don't mention inspectdb the problem still persists. The basic question is how to map oracle NUMBER type from some model type. If I understand this correctly, currently this is not supported. In principle models.FloatField should handle it and give and option to decide if the filed should

Re: How to get oracle NUMBER with syncdb

2012-10-17 Thread Michał Nowotka
Anyway, Jani, thank you for pointing me to the software, I will give it a try. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to dja

Status of bug #11580 ?

2012-11-06 Thread Michał Nowotka
Hello, There is a bug submitted 3 years ago: https://code.djangoproject.com/ticket/11580 I have exact the same problem using django 1.4. Are there any plans to fix that in near future? -- You received this message because you are subscribed to the Google Groups "Django users" group. To post t

Re: Status of bug #11580 ?

2012-11-07 Thread Michał Nowotka
OK, so first of all I'm new to both lists. I already asked some questions here and usually I get email with my question 5 minutes after post (I mean my original question not the answer). I was waiting long and I though my question didn't pass moderation so maybe it would be better to ask it on prob

reading raw binary data from clob columns using oracle backend

2012-11-07 Thread Michał Nowotka
Hello, I'm working with oracle legacy DB and need to read and write binary data (png images, and and MDL *Molfiles*). Django's inspectdb command generated text fields for these columns, saying that's only a guess. Now, when I'm trying to retrieve a value from this class fields i get: DjangoUnicodeD

Re: reading raw binary data from clob columns using oracle backend

2012-11-07 Thread Michał Nowotka
I mean BLOB, sorry. -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/nI-3ngGIdA8J. To post to this group, send email to django-users@googlegroups.com. To uns

IntegerField and SmallIntegerFields maps to the same db type on Oracle.

2012-12-13 Thread Michał Nowotka
Does anyone knows the reason why IntegerField and SmallIntegerFields both map to NUMBER(11,0) in Orcale? I would expect SmallIntegerFiled map to something smaller ;) -- You received this message because you are subscribed to the Google Groups "Django users" group. To view this discussion on the

Re: IntegerField and SmallIntegerFields maps to the same db type on Oracle.

2012-12-13 Thread Michał Nowotka
I agree, but if you map SmallIntegerField to say NUMBER(9) you will save some space, correct? -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, sen

Re: IntegerField and SmallIntegerFields maps to the same db type on Oracle.

2012-12-13 Thread Michał Nowotka
OK, then why django makes a difference between BigIntegerField (maps to NUMBER(19)) and IntegerField (maps to NUMBER (11)). Thinking this way BigIntegerField, IntegerField and SmallIntegerField should all map to NUMBER(39). -- You received this message because you are subscribed to the Google Gro

Re: Kindly help for an interview with Google on python django

2013-01-31 Thread Michał Nowotka
Didn't you know that whole google search thing is actually just django + tastyPie + solr? -- 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 django-users+unsubscr..

django server ignores POST requests?

2013-02-13 Thread Michał Nowotka
This is really strange behaviour. When I issue POST request to many times django suddenly starts to ignore them all. I can see then in firebug but debug server shows nothing. Restarting server doesn't help. Even more, when I try to restart server when this happens I always get: Error: That por

[no subject]

2013-05-02 Thread Michał Nowotka
According to that webpage: http://www.techempower.com/benchmarks/#section=data-r4 django performance is really bad comparing to other popular web frameworks. Are there any plans to change this situation? Regards, Michal Nowotka -- You received this message because you are subscribed to the Googl

Django accessing related fields prefetched by prefetch_related

2013-05-07 Thread Michał Nowotka
So I have this loop: for t in ts.prefetch_related('u__v_set'): bla = t.x ... Running this code in debugsqlshell I see three (constant amount in general) sql statements: - one getting all t's - second one getting related u's - third one getting related v's Now, in the same l

djnago xml model specification?

2013-05-20 Thread Michał Nowotka
I'm using django with many related projects. All those projects are using their own models. But unfortunately this is not DRY, because each model differ from each other very slightly, for example some columns or tables from one model are missing in other, or some model defines custom save metho