Welcome!

Hey! Thanks :)

5

Welcome!

Hello!

from enum import Enum from pony.orm.dbapiprovider import IntConverter class EnumConverter(IntConverter): def validate(self, val): if not isinstance(val, Enum): raise ValueError('Must be an Enum. Got {}'.format(type(val))) return val def py2sql(self, val): return val.value def sql2py(self, val): return self.py_type(val) db.provider.converter_classes.append((Enum, EnumConverter)) class Models(db.Entity): id = PrimaryKey(int, auto=True) model_type = Required(ModelType, default=ModelType.PREPARING) class ModelType(Enum): PREPARER = 0

Hello!

I tryed to use custom converter.

its work if i do smth as: Models[1].model_type

use ` to make the code less ugly in the chat

but not in queries: select(x.model_type for x in Models)

print ('hello wurld')

ok

`class EnumConverter(IntConverter): def validate(self, val): if not isinstance(val, Enum): raise ValueError('Must be an Enum. Got {}'.format(type(val))) return val def py2sql(self, val): return val.value def sql2py(self, val): return self.py_type(val) db.provider.converter_classes.append((Enum, EnumConverter))`

` class EnumConverter(IntConverter): def validate(self, val): if not isinstance(val, Enum): raise ValueError('Must be an Enum. Got {}'.format(type(val))) return val def py2sql(self, val): return val.value def sql2py(self, val): return self.py_type(val) db.provider.converter_classes.append((Enum, EnumConverter)) `

oh sheee

http://pastebin.com/yidQy0X6

is it possible?

Multiline examples are wrapped with three backquotes. What error do you get when using select?

TypeError: Unsupported type 'ModelType'

select(x.id for x in Models if x.model_type == ModelType.PREPARER)

I tryed this and got TypeError: Expression ModelType.PREPARER has unsupported type 'ModelType'

если можно на русском, то: я предположил что маппер автоматом раскрывает Енам в число и выполняет запрос. вот и решил сделать так.

D:

We plan to add support of enums, I think it is a bit more complex than in your example. Right now the simplest you can do is to manualy convert enum items to values inside query: select(x.id for x in Models if x.model_type == ModelType.PREPARER.value)

Thank You for quick response!

Sure

As a short explanation: It is possible to embed arbitrary Python expression inside a PonyORM query if that expression does not use loop variables. For example x = 10 y = 'hello' select(p for p in Person if p.name > foo(bar(x), baz(y))) In that query foo(bar(x), baz(y)) is external expression which can be evaluated outside of the query. For such expression Pony does eval and get its result. Pony does not analyze what is inside such an expression. The only thing that mater for Pony is the type of the resulted value of a whole external expression. PonyORM threats ModelType.PREPARER.value as external expression. At this moment PonyORM does not know anything about Enum type, but the resulted type of a whole external expression is int and Pony can process it without any problem.

если можно на русском, то: я предположил что маппер автоматом раскрывает Енам в число и выполняет запрос. вот и решил сделать так.

I can't even read that

No worries, the reply that follows was in English

Hi Alexey, i have seen http://stackoverflow.com/questions/16115713/how-pony-orm-does-its-tricks question in stack overflow. There are 3 steps in translation and step 1 is described in detail. Can you explain about step2 ? Also is there any good reference on abstract SQL ?

Hi Alexey, i have seen http://stackoverflow.com/questions/16115713/how-pony-orm-does-its-tricks question in stack overflow. There are 3 steps in translation and step 1 is described in detail. Can you explain about step2 ? Also is there any good reference on abstract SQL ?

Hi Sai Rahul! The second step is better explained in the Europython video https://youtu.be/xjikvIHjvHs?t=10m35s

as per the Abstract SQL - it is not documented yet, because it is not a part of the public API. But at some point I think we should provide the documentation for it.

Thanks a lot Alexey

Hi! I see the asyncio/futures issue keeps getting bumped on github. Are there any actual plans for this?

Welcome!

Thanks

Hi! I see the asyncio/futures issue keeps getting bumped on github. Are there any actual plans for this?

Before planning the next features we'd like to release what we have at hands now - migrations, MS SQL server support, to_json() and the an ability to get Python app template from the online editor After that we can make plans

migrations migrations! :D

Makes sense, godspeed :)

Before planning the next features we'd like to release what we have at hands now - migrations, MS SQL server support, to_json() and the an ability to get Python app template from the online editor After that we can make plans

I'm interested how that would work

I'm personally a huge fan of Django's ORM. If the migration system ends up being anything like it, it would be pretty great :)

I'm interested how that would work

What exactly?

I'm interested how that would work

In terms of usage

I'm personally a huge fan of Django's ORM. If the migration system ends up being anything like it, it would be pretty great :)

I'm now using pony in Django because it kinda scared me

I'm personally a huge fan of Django's ORM. If the migration system ends up being anything like it, it would be pretty great :)

The migrations workflow is similar to Django migrations

In terms of usage

The app template or what?

How I would use it, in general

I will see

What data pattern does the pony use?

What data pattern does the pony use?

The Identity Map

Thanks for the answer. I guess Im not very familiar with the nomenclature but, I was referring to as active record or data mapper?

Data Mapper

Thanks

I still think, this logo feels like Pöny

всем привет, на русском общение приветствуется?

I cant read that

Do anybody use pony with tornado?

How about threading-safe?

всем привет, на русском общение приветствуется?

ТАК

ДОЛБОЕБ

УВИЖУ ЕЩЕ ОДНО РУССКОЕ СЛОВО

И ПОЛУЧИШЬ ЛЮЛЕЙ

Goodbye guys, have a good day

This feels like capslock xD

Goodbye guys, have a good day

Huh. Good bye.

I'm not fluent in russian

But he was being a bit rude

But he was being a bit rude

Not a bit, technically extremly rude

I think he joined, said (in Russian) that Russian is bad and left again.

Not a bit, technically extremly rude

Bits and bytes.

«SO, MOTHERF**KER IF I'LL SEE ANY RUSSIAN WORD IN HERE AGAIN I'LL BEAT YOU IN THE FACE»

If this is ok — welp, this means where is something wrong.

I couldn't read it before. Welp thank you.

may be reason is he was ukrainian? :)

so, does anybody used pony orm in async apps?

Nope, me did not.

I wanted to, but apparently no asyncio support

Guys, may I use Pony's json type for describing array field in postgres?

sorry

Guys, may I use Pony's json type for describing array field in postgres?

Yes

please disregard

as is and without creating own array class?