#pyramid

goodwill yes, agreed, don't know yet what that should be, but this discussion should go into the reopened issue

dudepare the new SQLAlchemy + URL Dispatch tutorial is the best example http://docs.pylonsproject.org/projects/pyramid/...

for a step-by-step approach that is

stevepiercy: thanks! will give this a run through as well. I'm interested in the testing bit.

hey, i've got a column with datatype datetime and as values the current timestamp on creating this entry, e.g. func.now(). is there any chance for filtering like *.filter(and_(Column.timestamp >= yesterday, Column.timestamp < today)).all()? i've tried pythons datetime class, but this does not work :\

moo-_- https://github.com/Pylons/trypyramid.com/pull/103 :)

datetime has yesterday()? ♪ all my troubles seemed so far away. now() it seems as if they're here to stay. ♪

tokra100 got anything concrete to show? code example, traceback?

stevepiercy: http://pastebin.com/NiY9tjQV i want to create a query, where i can filter for individual dates

is there any way to say something like: func.now().setDate('...')?

tokra100: now

no

then how to filter for specific dates?

tokra100 you can use a range, but i think you need to use actual dates

timestamps usually aren't datetimes

moo-_- pyramid_sms now on https://trypyramid.com/resources-extending-pyra...

Charlie_X the column name is timestamp, but its type is datetime

which is a really confusing convention

Well the filter should work

Though the and_ isn't necessary

tokra100: Take a look at <https://sqlalchemy-utils.readthedocs.io/en/late...;, which ought to work with what you have and make life easier.

Simply chain the filters

the date format being used might not align with the datasource, but maybe something in the process converts it

SQLa can handle that.

tokra100 also, just to confirm, are you using SQLAlchemy and postgresql?

yes

i'll have a look at the ArrowType :)

ok, so one thing i see here is that the date string could be ambiguous

nah

05.04.2016

is that may 4, or apr 5?

no

if yer merkin, yer backward

But ISO is 2016-04-04

is april, 5th

Using datetimes is the safest way.

may 4 only when / is used as a separator

i just don't know whether SQLA knows that

otherwise clearly apr 5

still better to use iso format

Yes. Dates are only a problem when Americans are in the room

Or religious holidays: happy Easter Zart

♪ tomorrow. all my troubles seemed so far oh. then it seems to borrow ♪

Stop singing

took me 3 days to make mysql replication work 8\

Impressive

and i'm not sure it wont break in next few minutes

That's part of the fun.

shitty db, shitty docs, shitty support...

"but it's free!"

Why can't you use pg?

Charlie_X https://youtu.be/g3YiPC91QUk?t=56

And Oracle's support is better than MySQL's ever was.

this is for php web app for helpdesk, that's in core of our business..

oracle owns mysql

i know that. And they're doing a reasonable job.

MySQL is far less shitty (unpredictable) than it was.

turd polishing

guides and docs on "how to enable crash-safe slave". why it isnt default?..

stevepiercy: sure

oracle should have bronzed mysql and put it up on the mantel

They have paying customers and know how to milk them.

then take a wrecking ball to the house and set it on fire

The freetards moaned and left.

tokra100 so when you say it doesn't work, is it that you are finding no records?

i dont even know, how to filter for a specific time. like: i want all data from last week

in the paste, only records with the date of 19.04.2016 would be retrieved

tokra use intervals

yeah

intervals are your friend

or you can do date math and pass in that value

but that gets hairy

oh... there are people who do something like WHERE datetime_column LIKE '201604%'

lovely

it burns!

sounds very mysqlly

i've tried date math with datetime.timedelta, but thats weird

tokra100: you should be letting the db do the maths for you.

is there any docs/example for an interval-query ?

if you include a time component, then it gets really weird

yay for timezones and daylight saving time

like some days have 25 hours in them

stray ) in there

yeah, it's from a bigger query

Just shows interval

Read the pg docs

or http://docs.sqlalchemy.org/en/rel_1_0/core/type...