merge data from multiple models

unds hopelessly inefficient. Would someone be able to point me to a method to make this more logical? Many thanks Joris {% for GROUP in GROUPS %} {{ GROUP.grnummer}} {% for FIN in FINISH %} {% if FIN.grnummer = GROUP.grnummer %}{{FIN.synthesis_finish}}{% endif %}

Re: MySQL total overheat (somewhat complex database)

If all you do is select data from this set, is by creating the view directly in MySQL, either in 1 or in multiple nested views (subselect or independent views), and using that view as a backend for the django model. This makes optimization easier. -- You received this message because you are

Re: merge data from multiple models

Thank you but that still makes me end up with two models (GROUPS and FINISH), although now both have the same records and are in the same order. When it comes to template rendering I still need a nester for loop yes? I suppose faking a foreign key relation in the FINISH model (which is the CPU

Re: merge data from multiple models

On Monday, July 30, 2012 3:52:31 PM UTC+2, Melvyn Sopacua wrote: > > > If this is not implemented as a OneToOneField, then do so. You can then > access the related object in the same way as the reverse of a ForeignKey > and use related_name to make this more intuitive. > Yes that works great

Re: merge data from multiple models

tField(blank=True) calcfield2= models.TextField(blank=True) SQLstatement = "SELECT rid_fastmodel, calcfield1, calcfield2 from (SELECT ) JOIN (...) JOIN (...) WHERE some_condition = %s" Is this better? thanks joris -- You received this message because you are subscribed to the Googl

Re: Thoughts on web2py?

ll be around in 5 years time is bigger. A second argument was that documentation for django is simply more extensive and the user forum (this forum) is really useful. best joris On 05/08/2012 17:13, Marcin Tustin wrote: Implement a basic version of your site in django. Django has a fair b

django auth against local users

nters? many thanks joris -- 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/-/EiybzBmNEWEJ. To post to this group, send email to django-users@googl

Re: django auth against local users

> > You keep saying "local machine". Do you mean the machine the user is > browsing from? That's not possible, for what should be obvious security > reasons. > -- > DR. > No that would indeed be silly. By local machine I mean local to the django install: i.e. the server. I figured that was o

Re: calling perl script from HTML on submit button

On Tuesday, August 14, 2012 7:15:45 AM UTC+2, Pervez Mulla wrote: > > Thank you for your time and concern, > > Actually the entire back-end is in perl so, Am using Django for front-end. > So am asking is there any why to call perl objects in python . > You can always use subprocess() to run perl

Re: How to use Django with Apache and mod_wsgi

The DocumentRoot directive is missing from the httpd.conf, indicating you did not send all the required data. This may be because your attachment is incomplete: There is an include statement in your httpd.conf: "Include /etc/apache2/conf.d/*.conf" All files from that conf.d folder are also pro

Re: new to django

On Tuesday, August 21, 2012 1:08:04 PM UTC+2, Dhilip wrote: > > Hello, > > Got struct means you got any error or don't know what to do after that > Just follow the tutorial, read out each and every line in the document. > > > also make sure you are following the tutorial related to the Dja

Re: How to use Django with Apache and mod_wsgi

Op woensdag 22 augustus 2012 23:05:03 UTC+2 schreef stikic het volgende: > > Then do I have to delete 00_default_vhost.conf file? > What name can I give to this new created file? > > Well you have not referred or included 00_default_vhost.conf in your httpd.conf so this file is not actually rea

Re: Django project and SVN loads older code versions

The reason why you are seeing this behaviour is because apache caches the compiled python scripts. As apache has multiple threads, some still carry old information, and some new. As HTTP is stateless, this is why you get inconsistent behaviour. The situation is resolved by either reloading apac

Re: select_related problems

sive use of select_related and would say that it works well in 90% of the cases, yet in some it's failing on me. I'm with Django 1.5. Thanks Joris -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group

select_related problems

hy? Could this potentially be because the 'company' table gets read from the Model object and not from the ModelTrans object, from where it was queried? I make extensive use of select_related and would say that it works well in 90% of the cases, yet in some it's failing on me. I'

Re: Django and Jquery UI

Hi Robert Could you please specify more clearly how you "added jqueryui to my settings.py" ? It should be handled like any other static file and doesn't really have a place in settings.py Do your other static files (images, css, etc) load? Best Seems tough to get the Jquery UI code to do an

M2M frustration

Dear all, please help me with this unsolved mystery. Error: "Cannot resolve keyword u'' into field. Choices are: " 1) Error in admin In the admin it only happens when DEBUG=True. Works perfectly when DEBUG=False. The error occurs when opening the form view of the model that has the M2M fiel

Re: M2M frustration

is doesn't happen on the Python debugging webserver... Joris op 18-05-14 21:41, Mark Phillips schreef: Jorris, Have you tried changing the order of imports in your model? From a quick read of the references, that helped some folks. Mark On May 17, 2014 9:24 AM, "Jo

Re: M2M frustration

Hi Russell, Very interesting, now everything makes sense. And thank you for the suggested solution, we tried it today and it works now, no more random import hell. Looking forward to Django 1.7. Best Joris op 19-05-14 06:00, Russell Keith-Magee schreef: Hi Joris, It's an edge case

Re: Django-nested-inlines

I didn't get it to work either. First I got an error from one of the source files, which I fixed, and then it still didn't work. I'm using Grappelli though, thought that could be a reason for the problem. No Thiago it's not silver bullet but still it's pretty good :) and the existance of such

Translations

ou keep duplicates or do you merge them? (How many times does one really want to translate "homepage" and "email" ?) Thanks! Joris -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this

direct_to_template (with same name template) in a multi-app project

Hello all, I am developping a second app in the same project and want to use a simple.direct_to_template view. Both of my app require a login from user, thus I have in both app a login page. With a lot of creativity I named both of my login pages and index pages ; login and index, with the corres

Re: merge data from multiple models

Op maandag 30 juli 2012 16:06:38 UTC+2 schreef Joris het volgende: > > > > On Monday, July 30, 2012 3:52:31 PM UTC+2, Melvyn Sopacua wrote: >> >> >> If this is not implemented as a OneToOneField, then do so. You can then >> access the related object

django select extremely slow on large table

ot;PROD_SCHEMA"."MARKER" WHERE "PROD_SCHEMA"."MARKER"."MARKID" = :arg0' - PARAMS = (u'TO11',); args=('TO11',) As you see, in Django this takes 44 seconds to run. If I run this exact same query with cx_oracle directly the respon

Re: django select extremely slow on large table

quot;, PROD_SCHEMA"."MARKER"."MARKID", "PROD_SCHEMA"."MARKER"."CROP_ID", "PROD_SCHEMA"."MARKER"."INSID", "PROD_SCHEMA"."MARKER"."INSDATE" FROM "PROD_SCHEMA"."MARKER&quo

Re: django select extremely slow on large table

THank you all for your help there's a few things here: * This Oracle table is highly partitioned and optimized.There's indexes everywhere. There's two full time senior Oracle DBAs working on tuning this DB.So a return of 0.1 sec is not strange for this setup. (btw the DBAs are really impressed

Re: django select extremely slow on large table

Very interesting point. In the backend the MARKID column is of type VARCHAR2(20 BYTE). This is not something I can change. But it does seem that the bindvar method forces a unicode lookup onto an ascii table. Is there any way to make django get this field in ascii to test this theory? -- You

Re: django select extremely slow on large table

This seems to be specific for partial text searches (LIKE, STARTSWITH etc). Still, interesting addition. -- 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-

Re: django select extremely slow on large table

As an addition: >>>x=Marker.objects.raw("SELECT * from VARIANT_CLONE.MARKER WHERE MARKID='TO1'") This is also slow so it indeed seems to be a locale issue the database is AL32UTF8 and django uses national character set id "2000" is this a locale issue? -- You received this message because yo

Re: django select extremely slow on large table

Skip that, >>>x=Marker.objects.raw("SELECT * from VARIANT_CLONE.MARKER WHERE MARKID='TO1'") is fast DEBUG (0.001) QUERY = u"SELECT * from SCHEMA_PROD.MARKER WHERE MARKID='mTO1'" - PARAMS = (); args=() -- You received this message because you are subscribed to the Google Groups "Django use

Re: django select extremely slow on large table

And to keep replying to myself: This one is slow: x=Marker.objects.raw("SELECT * from PROD_SCHEMA.MARKER WHERE MARKID= %s",[u'TO1']) print x[0] This one is fast: y=Marker.objects.raw("SELECT * from PROD_SCHEMA.MARKER WHERE MARKID= 'TO1'") print y[0] If I copy the table and make the MARKID fiel

Re: django select extremely slow on large table

That sounds only relevant if Django creates the tables tight? You cannot do that with partitioned Oracle of this size. As much as I like to have django create the schemas, legacy db is all I have. THe entire DB is over 2TB of data, you cannot just change a column field type or add an index witho

oracle syncdb crashes while setting column to NULL when it already is NULL

rror is gone. I can see this is sillyness of oracle, but theres not much I can do about that. Is this a bug that I should report with the devs? thanks Joris -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this gr

treemenus treemenu or sitetree

Hi List I'm currently using django-treemenus to show a site menu, but now that Im migrating to 1.8, Im getting imcompatibility bugs. What modules do you use to display link menus in your site? I found sitetree and treemenu but they are not mentioned at all on this forum. thanks! -- You recei

UUID as primary key for Oracle backend

ly solution here? * Will BinaryField put in in other trouble elsewhere? * would the UUIDfield in dev solve my problems? Any pointer are very welcome. As mentioned, I have no control over the decision to use RAW(16) as primary keys. Sincerely Joris -- You received this message because you are subs

Re: UUID as primary key for Oracle backend

replying to myself: setting the pk to a binaryfield breaks the usage of django-admin as this tries to force the pk into string as well (options.py function action_checkbox()). -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from

Django vs ExtJS

go is better? The free-as-in-beer argument is not very convincing by itself. Thanks Joris -- 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

Re: Django vs ExtJS

S can connect to that). joris On 29-12-14 16:51, Guilherme Leal wrote: Sincerely, I can't see the ExtJS's Models as true models on an MVC (or MVT for instance) context, since the only real uses I've seen of them is to bind form controls to any "model like" (basically a

Re: Django vs ExtJS

he migrations as well. >> >> I've done basically the same thing with Django REST Framework and AngularJS >> for the frontend. Works like a charm, and with the business logic on the >> signals, reduces the dev time by 90%. And worls like a charm. >> >> Em Tue De

Announcing DjHTML: A Django template indender

d hopefully provide me with some feedback, test cases, and bug reports that will help me improve this tool. Greetings, Jaap Joris Vens -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop recei

Re: Django admin application for Android

UTC+2 schreef Derek: > > Can you explain more about the GOLD plan - what is it and how much does it > cost? > > On Monday, 15 July 2019 12:51:58 UTC+2, Jens-Joris Decorte wrote: >> >> Hello Django developers! >> >> Being both a Django developer and a heavy u

Re: Django admin application for Android

UTC+2 schreef Derek: > > Can you explain more about the GOLD plan - what is it and how much does it > cost? > > On Monday, 15 July 2019 12:51:58 UTC+2, Jens-Joris Decorte wrote: >> >> Hello Django developers! >> >> Being both a Django developer and a heavy u

Re: Django admin application for Android

UTC+2 schreef Derek: > > Can you explain more about the GOLD plan - what is it and how much does it > cost? > > On Monday, 15 July 2019 12:51:58 UTC+2, Jens-Joris Decorte wrote: >> >> Hello Django developers! >> >> Being both a Django developer and a heavy u

Re: Django admin application for Android

Hi Alexandre, the app is written in Kotlin. Looked for using flutter but the webview support is not quite there yet.. Op woensdag 17 juli 2019 17:26:04 UTC+2 schreef Alexandre Guignard: > > That's cool, thanks 😉 > Which langage do You use for the app ? -- You received this message because you