#pyramid

read&write random data?

being a russina born and raised in far north, above the polar circle, I'd really like to come over to Iceland and try some of their dishes... if only to compare them to "our" native stuff

*russian even

hehe, give link for native stuff =)

well, all sorts of raw or dried fish and reindeer meat, although nothing fermented

ljosberinn: I personally have no experience with using postgres in a multi-master setup... normally you have 1 master and multiple read-only connections

well, my db colleague made it a bit different this time =)

so "read&write random data" using postgres sounds technically not possible to me without some extra conditions like sharding constraints

i see... although i don't fully understand :/

i mean, it's not "random" data... it is a proper data, all the way from html frontend =)

sure, but does each database have the same schema?

they are redundant?

nope, they serve for different purposes

so instead of 0, 1, 2, etc what should they be named?

if they are not sharing the same schema then my issues with the multi-master stuff go away

(array kind of implies they all share the same purpose)

i'm fine with naming... everything is fine with db names... i was just thinking whether is it possible to the first database have a property like "main_psql" or whatevers, so i can later on during the request reference it by that prop...

sure

hey everyone, i've recently gotten back into web dev. after a few years, and noticed pylons is now pyramid. am i correct in assuming that there is no tmpl_context anymore?

config.add_request_method(lambda r: r.db_0, 'db_main', reify=True)

ljosberinn: ^

O_O

uramaget: that's sort of true... there's no global but there are several other ways to affect what's available in the template

uramaget, pylons and pyramid dont share any code, only spirit 8)))

uramaget: http://docs.pylonsproject.org/projects/pyramid-... is probably a good place to start

zart: haha. yeah, i notice that it's a lot more compact, which is actually pretty nice

though I've tried to write a pylons app recently... what a mess of middlewares and thread locals it was 8(

uramaget: also http://docs.pylonsproject.org/projects/pyramid-...

raydeo: i've read a bit on the renderer globals which seem to address my concern, but just wanted to ask around and check if i'm not doing anything stupid x)

you'd better learn pyramid from scratch. it shares only pastedeploy afafik

and webob

ah, yes

btw, pyramid 1.0 doesnt work with modern webob properly

returns iterator of unicode strings on 2.x

had to downgrade webob for it to work. pyramid 1.1+ is ok

D: ah

that's no good

thank you guys, you're the best :)

Zart: tiny violin for using something released 6 years ago ;-)

raydeo, I was trying to write a simple app in multiple frameworks and check how far compat can go

https://hg.zartsoft.ru/zart/demosite/file/309e3... if curious

that was when I suddenly realized that flask has no 1.0 yet

flask is the nodejs of python web dev

django as usual wants a couple of global modules for no good reason..

for routing they require *module name* to import which must have urlpatterns variable. why? beats me

opinionated design

interestingly modern django insist on validating host header, claiming security issues - https://docs.djangoproject.com/en/1.9/topics/se...

maybe pyramid should provide similar default out-of-the-box, though I dont understand how wrong host header matters much

typical host headers are sanitized by nginx and we consider it a non-issue from pyramid's perspective

if you are forwarding all traffic to pyramid without a virtual host in front then it's more of an issue

they claim that webserver validation turned out not to be enough in docs

in nginx you can use the $host variable which is the same as your virtualhost

whereas $http_host is the raw, unsanitized header

nginx isnt the only option

of course

it should be done in middleware

if you need a generic solution

true

hi guys, i have a question. I'm using a transaction manager (pyramid_tm) and I like to catch Integrity exception (for case where someone try to register a User with a username that is already taken). Is it possible to catch it so that i can let my form response with the error or this is not recommended

I mean in that case a better solution might be to manually made a query first before adding.

lxcid: if you want to handle the error in a form-specific way you may wish to catch it inside your view

you can put a try except around an explicit flush()

cool! thanks!

then transaction.rollback() manually iirc

yes

you will need to use transaction.rollback() in the except

wait no

(if you want to recover) then you need to create a sp = transaction.savepoint()

then in except: sp.rollback()

if you don't want to recover then you should just transaction.abort()

lxcid: http://paste.ofcode.org/apdsiwRK7ZfaTu7HzbQQRw

wow! thanks! thats help a lot! :D

raydeo Zart I haven't gone through this experience yet.. what is meant by "let my form response with the error" ? what can a form do with the exception?

return the appropriate error for a duplicate record?

:(

raydeo: what's going on from line 7 on

the transaction is aborted above, then it looks like the savepoint logic finishes unwinding something

oh shit they're independent scenarios aren't they

it's 2 examples, yes

you just put them together in the same code

k got it

good evening!

hello vyndion :)

is anyone running nspawn containers instead of Docker containers?