#django

idiots, I know, but what can I do?

Gen1us2k1: So provide them with reports that show them how many orders have been made

I can't quit.

nickjohnson: Fair enough. Maybe I will stick to your suggestion. Thanks for help :)

is a foreign key acting difrant in postgresql then sql

NBhosting: huh?

in sql they appear for example as form item in my admin, in postgresql not

its shows in pgadmin, but not in the admin for

form.

erm... exactly what do you mean by "sql"?

mysql

ah

best to say "mysql" so we know you're talking about that toy

k\

but did u get what i ment? with sql i get an list select field in admin

with postgresql i dont get that

foreign key is a field whose value must be a current value in the primary key column of a designated table

stop saying "sql" when you mean mysql!

sorry habbit :D

fucking stupid habit

:D

incredibly misleading

lol

where do you get this magic list?

please link me some good beginners article for django, anything text/video is fine paid or free, thanks alot!

if you're talking about django's admin... it treats all fkeys the same

dev11: well, there's the tutorial in the official docs

ok thanks

dev11 lookup Mike Hibbert on yuoutube

thanks !

and check the google python videos

NBhosting: i wouldn't use mysql as the baseline to compare things with... best practice is to use a database that doesn't magically throw away data.

I'm trying to do search_fields = ['get_speakers'] where get_speakers is a function to get a comma separated string of speakers which is a many to many field. It tells me there's a field error and if I do search_fields = ['speakers'] I get the error "Related Field has invalid lookup: icontains"

does mysql do that?

never noticed

yeah

NBhosting: i'll hunt down a link that explains it

this is my first project ussing postgresql

dont notice much difrance yet

yet

NBhosting: the difference is in data integrity

try reading this - http://sql-info.de/mysql/gotchas.html

ah k, weird that i never notice data lose on mysql

will do

Heyas!

but there are other differences. integrity is the first one you should care about though.

NBhosting: http://www.youtube.com/watch?v=emgJtr9tIME

NBhosting: but the good thing is that most of your mysql sql knowledge will make transferring to postgresql easy

So im looking to insert some text into a pdf file and show it as a webpage or pdf file. Any suggestions on the easiest way? I have been adding template code to the pdf and converting it to html with pdf2htmlEX, but the results are very hit and miss with font and size :(

yeah , its all going well so far

NBhosting: that video seems to be doing a good job of "tl;dr" it for me

I'm trying to do search_fields = ['get_speakers'] where get_speakers is a function to get a comma separated string of speakers which is a many to many field. It tells me there's a field error and if I do search_fields = ['speakers'] I get the error "Related Field has invalid lookup: icontains"

Any idea how I can search a many to many field?

hmm, are there any builtin ways to detect that code is being run as part of a test? at middleware or view level for instance

Nanor: you search a field on the target model of the m2m

sokmar: arguably, the code shouldn't care.

kezabelle: need to emulate an external service in my api for accessing it

NBhosting: also http://grimoire.ca/mysql/choose-something-else

FunkyBob, I don't follow, could you elaborate

sokmar: then use something like mock

ah k , i did notice that in mysql

specialy on decimal fields

NBhosting: yeah it's pretty eye opening right?

yeah

Nanor: you don't search the m2m itself, unless you're searching on pk values...

its kinda silly but not a uge problem, ussualy

i always copy my tables when i do such thing

Nanor: you search on the fields on the related model

Ah

NBhosting: well if you're not dealing with money and your database schema is perfect first go out the door and never needs migrations

FunkyBob, that makes a lot of sense.. oops! thanks

but the NULL thing is really silly

NULL should be null not 0

FunkyBob, So what would the syntax be? I'm doing this in the talkAdmin Admin Model. search_fields = ['speaker.name']?

speaker__name

FunkyBob, It tells me it can't resolve the keyword to a field

does it tell you what it can?

man that guy goes fast http://www.youtube.com/watch?v=uOzdG3lwcB4

FunkyBob, yes. It gives me all the fields in my talk class

FunkyBob, Perhaps I should put this on pastebin. I fear I may be omitting something

FunkyBob, would that help?

Nanor: yes

FunkyBob, https://gist.github.com/TehNanor/30f884811c2ed9...

good idea to follow conventions, like ProperCaps for class names

hi, we've a test that fails when we run it together with another totally separate test method, but passes if we run our test only. The other method is in tests/models.py, this one is in tests/views.py. They have nothing in common at all. The view test fails, but there is a response object that seems to be OK, but our view code is never called. Did anyone have similar issues already? We're stuck with this for hours now!

so, the m2m field is called "speakers"... so ... speakers__name

Hi. I need a log formatter to write the date as a timestamp

tapia: ok...?

tapia: can't figure it out from the Python logging docs?

viktornagy, it happened to me when the test modified some global (cache) data that wasn't cleared between tests

I've seen the datefmt uses the strftime format, and (afaik) it doesn't include a timestamp

something similar may happen at the database level if your data isn't properly reset between tests

at least, not the directives shown in http://docs.python.org/2/library/datetime.html#...

it even has a formatTime method to override

FunkyBob, I know that doc

but in the django settings I've got this:

'formatters': {

'standard': {

'format' : "[%(asctime)s] %(message)s",

'datefmt' : "%d/%m/%Y %H:%M:%S"

},

FunkyBob, THANKS!

And I don't know how to set the 'datefmt' to print a timestamp

or what should I override

arrgh, wrong test user instance!

Hi. How well does djanog's ORM search scale, before I need to give up and use a search engine like Apache Solr or Elastic Search?

tapia: don't paste in here... use dpaste like the topic says

tapia: you really should read the PYTHON docs on LOGGING

siovene: that really depends on your DBMS, not django

FunkyBob, it's Postgres.

siovene: well, there's some extensions to let Django use the Full Text Search

FunkyBob, well luckily my searches are not about text, but about properties on models.

So only the occasional __icontains, but mostly just checking for numbers or whole strings.