<html> <head> <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> </head> <body text="#000000" bgcolor="#FFFFFF"> Yes, my fault ! Thank you Alexander. And the second mistake is the 'date' name for the field variable. It's reserved in python. I had to rename it to 'insdate' and now everithyng works fine. Thanks a lot for the Pony ORM and immediate support )) <div class="moz-cite-prefix">31.07.2014 16:55, Alexander Kozlovsky пишет: </div> <blockquote cite="mid:CAGM6z1uDWx74ajTUa_RMTGP3XpxTXr5i4DTfFnhG0qxH7Sh_ng@mail.gmail.com" type="cite"> <div dir="ltr">Hi Vadim! The datatype that is specifed in attribute definition is a normal Python type. In Python, `int` and `str` types can be used immediately, but `date` and `datetime` types must be imported from stadard `datetime` module. You can add this import to the beginning of your program: from datetime import date, datetime After that, all should work without the exception: date = Required(date) updated_at = Optional(datetime) Alternatively, you can just import `datetime` module itself: import datetime After that, refer to `date` and `datetime` types as `datetime.date` and `datetime.datetime`: date = Required(datetime.date) updated_at = Optional(datetime.datetime) Regards, Alexander Kozlovsky </div> <div class="gmail_extra"> <div class="gmail_quote">On Thu, Jul 31, 2014 at 2:33 PM, Вадим Бажов <<a moz-do-not-send="true" href="mailto:vadim@ideco.ru" target="_blank">vadim@ideco.ru</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> Hi people ! Whenever i create a date or datetime field in entity python always gives me an exception: "NameError: name 'date' is not defined" for "date = Required(date)" record according your documentation documentation "pony.orm.core.ERDiagramError: Entity definition date was not found" for "date = Required('date')" I am trying to run i file with folowing code: #!/usr/bin/python # -*- coding: utf-8 -*- from pony.orm import * db = Database('sqlite', 'db.sqlite', create_db=True) class subscribers(db.Entity): id = PrimaryKey(int, auto=True) email = Optional(str) date = Required(date) sql_debug(True) db.generate_mapping(create_tables=True) Running that code from python shell gives me the following: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> from pony.orm import * </blockquote> </blockquote> </blockquote> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> db = Database('sqlite', '/tmp/db.sqlite', create_db=True) </blockquote> </blockquote> </blockquote> GET NEW CONNECTION RELEASE CONNECTION <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> class subscribers(db.Entity): </blockquote> </blockquote> </blockquote> ... id = PrimaryKey(int, auto=True) ... email = Optional(str) ... date = Required('date') ... <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> sql_debug(True) </blockquote> </blockquote> </blockquote> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> db.generate_mapping(create_tables=True) </blockquote> </blockquote> </blockquote> Traceback (most recent call last): File "<stdin>", line 1, in <module> File "<auto generated wrapper of generate_mapping() function>", line 2, in generate_mapping File "/usr/local/lib/python2.7/dist-packages/pony/orm/core.py", line 2698, in _resolve_attr_types_ throw(ERDiagramError, 'Entity definition %s was not found' % py_type) File "/usr/local/lib/python2.7/dist-packages/pony/utils.py", line 126, in throw raise exc # Set "pony.options.CUT_TRACEBACK = False" to see full traceback pony.orm.core.ERDiagramError: Entity definition date was not found So database can't be created after all. Pony version installed with pip: pony - Pony Object-Relational Mapper INSTALLED: 0.5.1 LATEST: 0.5-beta Is it a bug or something? How i should create a datefield with Pony ? I've couldn't create a table with several tables with Pony until i commented out all datefields strings from the code. So Pony works if i don't use datetime fields. -- С уважением, Бажов Вадим, Инженер отдела технической поддержки, Компания Айдеко -- Телефоны: +7 (495) 987-32-70; +7 (495) 662-87-34 (тех. поддержка); +7 (343) 345-15-75; Факс: +7 (343) 383-75-13 Электронная почта: Вопросы по приобретению: <a moz-do-not-send="true" href="mailto:sales@ideco.ru" target="_blank">sales@ideco.ru</a> Технические вопросы: <a moz-do-not-send="true" href="mailto:support@ideco.ru" target="_blank">support@ideco.ru</a> Партнерство: <a moz-do-not-send="true" href="mailto:partners@ideco.ru" target="_blank">partners@ideco.ru</a> Общие вопросы: <a moz-do-not-send="true" href="mailto:info@ideco.ru" target="_blank">info@ideco.ru</a> Сайт: <a moz-do-not-send="true" href="http://www.ideco.ru/" target="_blank">http://www.ideco.ru/</a> Форум: <a moz-do-not-send="true" href="http://www.ideco.ru/forum/" target="_blank">http://www.ideco.ru/forum/</a> _______________________________________________ ponyorm-list mailing list <a moz-do-not-send="true" href="mailto:ponyorm-list@ponyorm.org" target="_blank">ponyorm-list@ponyorm.org</a> <a moz-do-not-send="true" href="/ponyorm-list" target="_blank">/ponyorm-list</a> </blockquote> </div> </div> <fieldset class="mimeAttachmentHeader"></fieldset> <pre wrap="">_______________________________________________ ponyorm-list mailing list <a class="moz-txt-link-abbreviated" href="mailto:ponyorm-list@ponyorm.org">ponyorm-list@ponyorm.org</a> <a class="moz-txt-link-freetext" href="/ponyorm-list">/ponyorm-list</a> </pre> </blockquote> <pre class="moz-signature" cols="72">-- С уважением, Бажов Вадим, Инженер отдела технической поддержки, Компания Айдеко -- Телефоны: +7 (495) 987-32-70; +7 (495) 662-87-34 (тех. поддержка); +7 (343) 345-15-75; Факс: +7 (343) 383-75-13 Электронная почта: Вопросы по приобретению: <a class="moz-txt-link-abbreviated" href="mailto:sales@ideco.ru">sales@ideco.ru</a> Технические вопросы: <a class="moz-txt-link-abbreviated" href="mailto:support@ideco.ru">support@ideco.ru</a> Партнерство: <a class="moz-txt-link-abbreviated" href="mailto:partners@ideco.ru">partners@ideco.ru</a> Общие вопросы: <a class="moz-txt-link-abbreviated" href="mailto:info@ideco.ru">info@ideco.ru</a> Сайт: <a class="moz-txt-link-freetext" href="http://www.ideco.ru/">http://www.ideco.ru/</a> Форум: <a class="moz-txt-link-freetext" href="http://www.ideco.ru/forum/">http://www.ideco.ru/forum/</a> </pre> </body> </html>