Mark ☢️
i'd like to take a moment and thank you for introducing me to this stallman sticker pack
Сначала я рускурил, что ты из России по незаглавной букве i и незаглавной у Столлмана. Настоящие онглечане всегда уделяют шифту много внимания.
Mark ☢️
затем я посмотрел твои фоточки в телеграме. он хранит историю всех фоточек. СЮРПРАЙЗ
Rozen
wasn't there a rule that stablishes english only?
Angel
I think so
Mark ☢️
А смысл?
Mikki
We don't really have rules here yet :p
Romet
some of us don't speak russian
Romet
that includes me
Romet
i understand a little, but that's it
Angel
Ok
Angel
That's my cue
Alexander
Yeah, please in English, guys :) Not all here speak Russian :)
Mark ☢️
some of us don't speak russian
I can't believe. Your photos in Telegram show us opposite.
Mark ☢️
Alexander
I think that's a good idea :)
Rozen
sorry, i didn't wanted to annoy :(
Alexander
No problem, I think, I doubt your posts annoyed anybody
Mark ☢️
https://github.com/ponyorm/pony/issues/162
Mark ☢️
So, how to run tests ?
Mark ☢️
ImportError: No module named ponytest
Alexander
We start refactoring of tests in order to execute them with all supported databases, and not only with SQLite. Right now to run tests you need to clone this module: https://github.com/abetkin/ponytest. Currently we are discussing should this part of code be separate package which pony depends on, or it should be part of pony itself. Before making new release we should choose what to do.
Mark ☢️
I'm sure that it should be bundled together with pony itself
Mark ☢️
What is the reason to split ponytest into separate project ?
Alexander
The creator of this module (Vitalii Abetkin) thinks it may be useful outside of Pony. I think tomorrow he can comment on this
Mark ☢️
Looks like asyncio module for Python. It is developed in separate git-repo and when Python release is coming, it is COPIED into Python's VCS.
Mark ☢️
I think you may use same strategy regarding ponytest module.
Alexander
May be, thanks for the suggestion
Mark ☢️
This is important, since we run tests for every package we build. Without that we should either disable tests (as we do) or package ponytest and make it as build-dependency.
Lucky
In https://editor.ponyorm.com I still can't scroll the Attribute properties, making it impossible to remove attributes.
Lucky
Lucky
Romet
ah i see
Lucky
Ok, will check that on a small screen
Actually I can scroll it, but the minimap is in the way
Romet
it's scroll-y but the minimap is rendering over it
Romet
yeah
Lucky
Also DB settings are not reflected in the generated code.
Lucky
Lucky
it's scroll-y but the minimap is rendering over it
If I delete the DOM node of the map, the Delete button is still slightly out of the frame, without giving me scrollbars.
Romet
it'll be because the sidebar is set top top:60px or something
Romet
it's actually taller but gets clipped by the browser window
Mikki
Welcome!
Max
Thanks :)
Lucky
Pony is raising ImportError: No module named 'psycopg2' During handling of the above exception, another exception occurred: ImportError: No module named 'psycopg2cffi'
Alexander
If you want to use Pony with PostgreSQL, you need to install psycopg2 database driver: http://initd.org/psycopg/docs/
Max
On which language Pony is written?
Alexander
Python
Max
spasibo
Alexander
sure
Lucky
Pony is raising ImportError: No module named 'psycopg2' During handling of the above exception, another exception occurred: ImportError: No module named 'psycopg2cffi'
Huh. I searched the documentation, and could only find https://docs.ponyorm.com/firststeps.html?highlight=dependencies
Lucky
It states it doesn't need anything
Alexander
psycopg2 is not required to use Pony. It is possible to use just Pony if the database that you use is SQLite. But for other databases it is necessary to use specific database connectors. Pony does not specify these connectors as dependencies, because they are necessary only for some people who use specific database
Lucky
Maybe you should include that in that paragraph, that depending on the database there is something needed.
Max
Agreed
Alexander
I think this is a good point, thanks
Michael
this is how pewee describe it
Michael
http://docs.peewee-orm.com/en/latest/peewee/installation.html
Lucky
I think this is a good point, thanks
Maybe link to https://docs.ponyorm.com/database.html, and list the requirements per database there?
Lucky
http://docs.peewee-orm.com/en/latest/peewee/installation.html
You mean the "Optional dependencies" part, right? http://docs.peewee-orm.com/en/latest/peewee/installation.html#optional-dependencies
Michael
yeah the note section there
Lucky
If you want to use Pony with PostgreSQL, you need to install psycopg2 database driver: http://initd.org/psycopg/docs/
It seems it isn't checking for drivers or whatever when I create the database as a "postgres" DB, but waits for the first actually usage?
Lucky
Never mind, that might be a import failure on my end
Alexander
If provider specified when the Database instance is defined (i.e. Database('postgres', ...)) then it will be checked at this point. Otherwise, if Database is created without arguments, the connection have place on db.bind(...) method call
Lucky
Was my fault, I imported the database objects locally, in a function
Lucky
How would I upsert a object? Say I have a Ùser` with id (Primary key, but given, not auto incremet) and a name. Now I want to create him if a User with that id doesn't exist, else update the value.
Lucky
Alexander
We plan to add special upsert method. Right now you can write something like that: user = User.get(id=user_id) if user is not None: user.name = user_name else: user = User(id=user_id, name=user_name)
Alexander
In a more simple case (if name is unique secondary key and id is auto-incement) you can write: user = User.get(name=user_name) or User(name=user_name)
Lucky
Cool. Thanks!
Lucky
I noticed, If you edit at the online editor, and have text changes in the properties pane, the text only gets saved if I unfocus that field, by clicking in some other field. It doesn't store the content if I click on the "Python Code" tab, and if I come back, the change is lost.
Alexander
Thanks for reporting, we should fix it
Lucky
ValueError: Value -1001032895287 of attr StickerMessage.chat_id is less than the minimum allowed value -2147483648
Lucky
What can I do?
Lucky
Using Postgres.
Lucky
Found https://github.com/ponyorm/pony/issues/18#issuecomment-60963183
Lucky
The datatypes in the docs is somehow lacking. It just is a list, without any description
Lucky
so size=64 and unsigned=False
Lucky
But got pony.orm.core.UnexpectedError: Object StickerMessage[-1001032895287] cannot be stored in the database. DataError: integer out of range
James
An unsigned attribute with size 64 can be represented only in MySQL and Oracle.
James
Could that be the issue