#django

Hi everyone. If I get a list of players and do .select_related('club') then while I loop through players, if I change a status of a club then the consequent iterations won't know about the change. How can this be solved?

siminm: care to share any code?

mlavin, what's the best way? pastebin?

siminm: pastebin is fine. the topic recommend http://dpaste.org/

one moment

Hey guys! So… I was looking at using different databases within my project. I will have multiple users using my app, and each user will be part of a company. I want each company to have its own database. Now, what would be the easiest way in Django whenever I make my queries to use the appropriate DB in question?

abisson: https://docs.djangoproject.com/en/dev/topics/db...

I have to get offline :(

This is an example that I just came up with, but it relays the point

club.notify() is supposed to be called only once per club

but if I use .select_related() it gets called as many times as there are players in that club

abisson: watch out for foreign keys. I don't know if I would do what you're doing. I would probably use the sites framework and restrict company to the current site, if I were you

tbaxter: what do you mean?

or use a multitenant app with a one db per tenant

If I can run django-admin.py without 'python' first - then I have the correct path in my syspath? I changed my syspath to include the path to django-admin.py - the only result virtualenv does not work anymore :)

abisson: you don't do FK across databases

Linovia: I know… and their won't be

For example… I just want company_1_db, company_2_db, company_3_db… and each user connected to the site use the appropriate DB, depending on which company they are from

I think I would have company == site, then everything is keyed to current site

drewtemp: I saw that… but the example is more like "The User Model" use this DB… this model use This DB…. I want more like I said in the previous line

Or, set up a crapload of projects, one for each company, using shared apps

tbaxter: if I use AWS and EC2… that means one EC2 per company?

ok forget Amazon… if it was a normal server, (noob question), how can I host multiple sites on the same physical server?

Django (obv)

abisson: sure

anyone used django-cron recently?

Linovia: not sure what you are agreeing on :P

those imports on default page are invalid

abisson: "if it was a normal server, (noob question), how can I host multiple sites on the same physical server?"

Are there any app-level concerns I should consider when switching all of the mysql tables from MyISAM to InnoDB?

stuff might break

apollo13: any specific examples?

bricker`work: like the migration will fail cause you can already have borked data in MyISAM

Linovia: so… should one one server hosts multiple django sites? Each with its own database?

apollo13: I wonder if there's a way to have innoDB check and report any broken key constraints

innodb does check constraints

If I want to check for the existence of requet.POST['foo'] do I have to do it in try/except block to be safe?

what's a one one server ?

but hey, if you switch off from myisam just switch to postgres

starsinmypockets: if 'foo' in request.POST

ok tx

apollo13: I mean check the data integrity all at once, rather than have someone run into an error on some old record

bricker: well yes it will cry loudly during import

you can't just "switch" the engine anyways

you'll need dump+restore

apollo13: alter table posts engine=InnoDB; ?

I am surprised

that will take long though^^

apollo13: about a minute according to my test

what if I want a field called 'type' in my db model?

probably a little longer on the production server

bricker: oh, you should have said you have no data in it…

apollo13: there is lots of data in it :)

nevermind, someone already asked it on SO and they said you should just rename the variable.

stemid: yeah, exactly. rename it. Don't use reserved terms for fields. It's painful.

I will, but imo, since sql queries can quote reserved names, django should be able to create models in a similar way. but a lot of things should a lot of stuff so it doesn't really matter.

bricker: if it does that in one minute? either that is a noop or it's not much data

bricker: docs talk about hours for a rollback if an error occurs

what would be best way to run something every second?

every second?

isn't that a bit excessive?

well something below cron 30 second limit

use something like celery or so

i made myself django app monitoring my connection to different servers, wanna run it at least every 5 seconds

apollo13: thanks

wouldn't there be some django/python only solution?

ohh looks like it is

drag0nius: import time; time.sleep(5) :)

and loop on that :p

like starting celery tasks every 5 seconds

yeah and i'd have to remember about starting it :)

so amazon.com is down

superdmp: ping

what do i put as broker in django db method?

in celery

How are the Django docs generated?