mysql - Django form performance -


i asked in code review rejected cause of "broken code." why i'm asking here. site more appropriate question code review one.

in app, user can modify course created. 1 field "teacher" field , user can select different person teacher. foreignkey creates 138 duplicated queries , can't figure out how make more efficient.

model:

class coursecatalog(models.model): course_name = models.charfield(verbose_name="course name", max_length=50) course_desc = models.textfield(verbose_name="course description") teacher = models.foreignkey(teacher, blank=true, null=true, verbose_name='course owner', on_delete=models.protect) ...

view:

class editcoursecatalog(updateview): model = coursecatalog fields = ['course_name','course_desc', 'teacher'] template_name = 'school/course_catalog/new_edit_form.html'

template:

... <h3>course form</h3> {{ user.teacher }} <form action="" method="post">{% csrf_token %}  {{form|crispy}} ...

here query debug duplicated 138 times. difference between queries school_familymember.id = 220.

select `school_familymember`.`id`, `school_familymember`.`password`,

school_familymember.last_login, school_familymember.is_superuser, school_familymember.username, school_familymember.first_name, school_familymember.last_name, school_familymember.email.school_familymember.is_staff, school_familymember.is_active, school_familymember.date_joined, school_familymember.family_id, school_familymember.middle_name, school_familymember.family_member_role_id, school_familymember.address1, school_familymember.address2, school_familymember.city, school_familymember.state, school_familymember.zip_code, school_familymember.notes, school_familymember.gender, school_familymember.phone_number, school_familymember.cell_phone_number school_familymember school_familymember.id = 220

the teacher model foreign key familymember table , think i'm having issue. i'm wondering if there way make 1 single query collect family names , ids , use drop down list in form. can built in form managers or have scrap , create queries in view , pass them form?

class teacher(models.model):     family_member = models.onetoonefield(familymember, verbose_name='name')     notes = models.textfield(blank=true)

create custom model form, , in __init__ method change teachers queryset use select_related more efficient.

class coursecatalogform(forms.modelform):     class meta:         fields = ['course_name','course_desc', 'teacher']      def __init__(self, *args, **kwargs):         super(coursecatalogform, self).__init__(*args, **kwargs)         self.fields['teacher'].queryset = self.fields['teacher'].queryset.select_related('family_member')

then use new model form class in view instead of specifying fields.

class editcoursecatalog(updateview):     model = coursecatalog     template_name = 'school/course_catalog/new_edit_form.html'     form_class = coursecatalogform

Comments

Post a Comment

Popular posts from this blog

searchKeyword not working in AngularJS filter -

i writing app using angularjs on front end. want search through table word/field; 1 search box everything. according article here: http://hello-angularjs.appspot.com/searchtable can use filter: searchkeyword this. this code, , not working expected. <label>search: <input ng-model="searchkeyword"></label> <table ng-repeat="post in posts | orderby: sort | filter: searchkeyword"> <tr> <td> {{index(post)}} </td> <td> {{post.title}} </td> <td> {{post.author}} </td> <td> {{post.content}} </td> <td> {{post.date | date: "d/m/yyyy"}} </td> </tr> </table> what should do? thank you try this: controller $scope.posts = [ {title:'title one', author:'author one', content: 'content one'}, {title:'title two', author:'author two', content: 'cont...
Read more

sequelize.js - Sequelize: sort by enum cases -

i have model ( article ) field (the name type ) of type enum('source', 'translated') , return 1 article ordered type field. source articles should returned before translated articles. like: article.findone(order: [ { type: [ 'source', 'translated' ] } ]); unfortunately there appears no built-in solution sorting enums. instead have sort by case , couldn't find documentation on how sequelize. what conventional approach here? sorting case hard in sequelize, sort field (the second answer in linked post) should possible: order: sequelize.fn('field', sequelize.col('type'), 'source', 'translated') it's supported mysql far know though
Read more

user interface - how to replace an ongoing process of image capture from another process call over the same ImageLabel in python's GUI TKinter -

i trying use following code create interactive gui changes color-space(hsv, rbg, grayscale etc) on event of button click. display opencv video in tkinter using multiprocessing being new python having problems multiprocessing , attempts on making gui change it's color space on button clicks hangs entire system. on it's implementation highly appreciated. thankyou. below code: import cv2 pil import image,imagetk import tkinter tk import numpy np multiprocessing import process , queue def quit_it(root,process): root.destroy() process.terminate() def black_andwhite(root,process): process.terminate p=process(target=capture_image, args=(5,queue, )) p.start() root.after(0, func=lambda: update_all(root, image_label, queue)) def update_image(image_label, queue): frame = queue.get() = image.fromarray(frame) b = imagetk.photoimage(image=a) image_label.configure(image=b) image_label._image_cache = b root.update() def update_all(root...
Read more