#django

ironbeard: A through model could store percentage.

something like the sql group by and limit? anyone?

mattmcc: I'm not familiar with those, I'll look them up. Thanks for the direction!

kline: got it?

airstrike, depends what there was to get - if anyone sent me anything, i didnt get that, but the site is now running. i suspect "sudo -e" on a file doesnt flush changes back until the editor is closed :v

Frenchiie: what is your ORM query like?

so i was saving these config changes but emperor would never see them until i gave up to fix IRC falling over

kline: I proposed an alternative way to structure your stuff on github

kline: and explained it here

sorry, i missed it here

mattmcc: Oh, this is perfect! Great!

i probably agree fwiw, but its not me whos written it, i was just pulled in as someone who can admin the nginx/emperor stuff

and i was deadly confused about why it would/wouldnt load it. played around with the venv (could launch from console fine inside the venv, but obviously not outwith) and drawn from that i needed to add venv stuff to the vassal ini, which never got flushed back, embarrassingly

I want to filter a query set with .filter() but I want to exclude objects with action_date that is later than timezone.now(). How do I do that?

action_date is the date of an action. I want ot get all the objefts that have action_date that has already passed

.filter(action_date__lt=timezone.now())

.exclude()

not .filter

what is __lt?

less than

aaaah

read the docs

thanks!

ok

np

do read that, please

it's literally what you're asking and it will help you understand it better

hello, i'm having some trouble re-installing a postgres dump file and getting permissions correct.

usually, i don't require any permissions locally, but for some reason after i install the dump permission is needed

furthermore, i can't seem to get the permissions to work, even when i apply the server password

hello, i'm having trouble with saving my form data. https://dpaste.de/t8Es plz help

jtri: we need details

jtri: because i am a lazy bum, i always do dump / restore operations as the postgres user :p

you could always ask in #postgresql

I'm stuck, I'm make inspectdb, some of tables don't have primary key by default, because they have only 2 foreign key by design and I can't add id = AutoField to this model. Without primary key, I can't make a dumpdata and use it in my real DB

ddiet: apparently it's a m2m table... maybe it would help if you defined it as a `ManyToManyField` on one of the tables it has a foreign key to?

sjoerdjob: Actually, start to think about using 2 DBs, one SQLite3 for this app and as main PostgreSQL because have no idea, how to bypass it and make fixture.

besides the inspectdb thing. What is the actual problem you want to solve?

this is the line that's giving me the problem with the non-english characters: https://dpaste.de/nFav#L85

should I just throw an exception here?

dviola: which variable has the non english characters

sjoerdjob: https://github.com/schirinos/nutrient-db SQLite3 DB is nutrients.db from this repo. https://dpaste.de/ZAyU -- code that fit to specification. https://dpaste.de/P29S - code that generated after inspectdb

pembo13: name

but the content of that is an XML file and it's being parsed, which also has non-english characters

it blows up when trying to parse as well

I want to transfer data from SQLite3DB to PostgresSQL3

dviola: have you tried name.encode('utf-8')?