Hi Vasiliy! Pony should be able to reconnect automatically, if the connection was lost not in the middle of transaction. I think that your problem caused by the following sequense of actions: 1) An application code performs some query; 2) Due to some problem in configuration (for example, an insufficient size of some buffer) the server drops the connection, and Pony gets an exception from psycopg2; 3) Exception unrolling leads to exiting from db_session; 4) Pony tries to handle exit from db_session and attempts to peform rollback, assuming that the connection is stlii active; 5) At this moment we got another exception, "connection already closed" which masks previous exception. I think we need to improve handling of rollback so it does not mask previous exception in case the connection is closed already. Regarding your situation, I think the right way is not to attempt to reconnect, but to prevent an exception which lead to connection closing. After we fix handling of rollback, you should be able to see this original exception and will be able to fix its root

Thanx 4 answer. I found a solution with your help.

Vasiliy can you open a new GitHub issue? https://github.com/ponyorm/pony/issues Solving this issue should fix @dadecar problem too

Yes, please! ?

Vasiliy can you open a new GitHub issue? https://github.com/ponyorm/pony/issues Solving this issue should fix @dadecar problem too

https://github.com/ponyorm/pony/issues/219

Thanks!

I think I fixed the bug. Previously the "connection already closed" exception masked the original exception which causes the connection closing. Now you can see the reason for connection closing, and if it is caused by some bug in Pony you can open another issue related to that specific problem.

https://github.com/ponyorm/pony/commit/1146ff1f4c3525393d4636406ae41213a628f4b1

Welcome :)

Thank you

Thanks, now i receive another exception, your patch is really help me! For example: File ".../pony/orm/dbapiprovider.py", line 55, in wrap_dbapi_exceptions except dbapi_module.DatabaseError as e: raise DatabaseError(e) DatabaseError: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

You need to check, maybe your PostgreSQL client and server versions differ: http://stackoverflow.com/questions/15934364/psql-server-closed-the-connection-unexepectedly/15977710#15977710

Hello! Is it possible to use fixed-length bit string dtype of postgres in pony?

Hello! Is it possible to use fixed-length bit string dtype of postgres in pony?

You can specify the type this way https://docs.ponyorm.com/api_reference.html?highlight=sql_type#cmdoption-arg-sql_type

ok. if I specify sql_type('bit(8)') then which type I get in Python?

Which type in Python do you need?

Ideally https://pythonhosted.org/bitstring/bitarray.html

I want to implement search by Jaccard/tanimoto similarity on bitstrings (popcount(bs1 & bs2)/popcount(bs1 | bs2))

moreover. I want to use postgres GIN, but I can't find normal documentation with examples for implementing it

@nougmanoff you can define column in the following way: data = Required(str, sql_type='bit(8)') Then in Python you can work with data as with strings: obj.data = '10101010' When working with data in Python, you can manually convert them to bitarray format if you want: array = bitstring.BitArray('0b' + obj.data) I just checked, and it works. Maybe some time in the future we will add specific support for bitstrings in Python.

Thank You!

Can you tell a bit more about how do you want to use GIN?

I found https://github.com/jirutka/smlar/

with implemented GIN support. but this module don't support tanimoto metric. also I found https://github.com/eulerto/pg_similarity

but this module works only with text

Huh, looks interesting

Anyone stumbled about a good text search Postgres plugin, e.g. like what elasticsearch offers?

I want implement this: http://pubs.acs.org/doi/abs/10.1021/ci200552r

and I think GIN is suitable for this

I want implement this: http://pubs.acs.org/doi/abs/10.1021/ci200552r

Site is 404

Never mind, my wifi derped.

for text search http://blog.scoutapp.com/articles/2016/07/12/how-to-make-text-searches-in-postgresql-faster-with-trigram-similarity

for text search http://blog.scoutapp.com/articles/2016/07/12/how-to-make-text-searches-in-postgresql-faster-with-trigram-similarity

Thanks!

Noticed, on the online editor still strg+A (or cmd+A on mac) isn't working in text fields

Also I am missing an option to set sql_default='NOW()'

Also the comment is not included in the Postgres database?

Also, cascade delete isn't working in the GUI, if I select False, the python code will still contain True

do you press save button ?

do you press save button ?

Normally it autosaves

And got pony.orm.core.DBSchemaError: Table "StickerPack" cannot be created, because table "stickerpack" (with a different letter case) already exists in the database. Try to delete "stickerpack" table first. with case insensitive Postgres SQL

And got pony.orm.core.DBSchemaError: Table "StickerPack" cannot be created, because table "stickerpack" (with a different letter case) already exists in the database. Try to delete "stickerpack" table first. with case insensitive Postgres SQL

Now tracked as https://github.com/ponyorm/pony/issues/222

Lol, dat number

hi

hi

Hello!

i am currently new to pony orm, and now trying to create simple app with pony-orm and flask

Good combo

i've separated models.py, controllers.py

but when i want to call Model.select() it gives error ERDiagramError: Mapping is not generated for entity 'Model'

did i call it wrong?

did i call it wrong?

did you call generate_mapping before the select?

did you call generate_mapping before the select?

i've already have the table, it's from mySQL table

should i call generate_mapping?

when i call generate_mapping i've got this error pony.orm.core.ERDiagramError: Cannot define entity 'Employee': database mapping has already been generated

when i call generate_mapping i've got this error pony.orm.core.ERDiagramError: Cannot define entity 'Employee': database mapping has already been generated

Would you be okay with posting your code, preferably on something like pastebin?

Would you be okay with posting your code, preferably on something like pastebin?

http://pastebin.com/qUVcqeKe

I would handle all of your DB setup in models

http://pastebin.com/T8xE6nxz

Looks like db.bind is getting called *before* Employee is created by the interpreter

hmm .. ok i'll try to fix it

Hi Ngalim! db.bind(...) is used to specify database type and parameters of database connection. db.generate_mapping(...) is used to notify Pony: "all necessary entities are defined". At this moment Pony understands which tables should be used to represent specified entities. It is possible to specify create_tables=True option to generate tables, but even if tables are already created, calling generate_mapping is necessary, because this is the moment when Pony creates internal linking between entities and tables. When application is imported, the sequence of operations should be the following: from pony import orm db = Database() class X(db.Entity): ... class Y(db.Entity): ... db.bind(...) db.generate_mapping(...) with db_session: result = select(...) That is, generate_mapping should be called after all entities are defined, but before first select is issued. If you want to put entities in a separate module, I suggest you to define db right in that module, but perform bind and generate_mapping outside of it. This way you separate entity definitions and database configuration options. It may looks something like that: models.py: db = Database() class Person(db.Entity): name = Required(str) controllers.py: from flask import Blueprint from model import db, Person employee_bp = Blueprint(...) main.py: from flask import Flask from controllers import employee_bp from models import db app = Flask(__name__) ... app.register_blueprint(employee_bp) if __name__ == '__main__': db.bind(...) db.generate_mapping() app.run(...)

Hi Ngalim! db.bind(...) is used to specify database type and parameters of database connection. db.generate_mapping(...) is used to notify Pony: "all necessary entities are defined". At this moment Pony understands which tables should be used to represent specified entities. It is possible to specify create_tables=True option to generate tables, but even if tables are already created, calling generate_mapping is necessary, because this is the moment when Pony creates internal linking between entities and tables. When application is imported, the sequence of operations should be the following: from pony import orm db = Database() class X(db.Entity): ... class Y(db.Entity): ... db.bind(...) db.generate_mapping(...) with db_session: result = select(...) That is, generate_mapping should be called after all entities are defined, but before first select is issued. If you want to put entities in a separate module, I suggest you to define db right in that module, but perform bind and generate_mapping outside of it. This way you separate entity definitions and database configuration options. It may looks something like that: models.py: db = Database() class Person(db.Entity): name = Required(str) controllers.py: from flask import Blueprint from model import db, Person employee_bp = Blueprint(...) main.py: from flask import Flask from controllers import employee_bp from models import db app = Flask(__name__) ... app.register_blueprint(employee_bp) if __name__ == '__main__': db.bind(...) db.generate_mapping() app.run(...)

Thank you

i'll fix mine now

@luckydonald thank you for reporting bugs and suggesting regarding the editor. We'll fix that. Also, would like to let you know that currently we are working on a new version of the editor. The old version was done using KnockoutJS and it proved to be not very convenient in the long run. The new version is done using React+Redux. Such architecture makes it easier and faster to add new features.

+1 for react&redux

JS ?

+1 for react&redux

Where is a good place to learn react+redux in a Python context?

Not sure what you mean by in a Python context but at work we work almost exclusively with a python/django/DRF + react/redux stack

Don't think there are any guides that talk about specific backends in combination with react/redux that aren't node-based.

Okay thanks!

I'm on code academy and it looks like it is using some node extensions in the background to compile the JSX, what would you use with Django (or in my case Flask) to compile JSX?

@micaiahparker try https://github.com/facebookincubator/create-react-app

It's allow you to start working with react without writing tons of configs for webpack/babel/jest etc

You will run node (webpack) during development and as result you get compiled js file

And then I can link to the compiled JS in a Jinja template for prod?

Yeah

Sweet! Thanks

Wow, looks like JSX has changed quite a bit since when this code-academy lesson was made.

anyone try to use djony this new version Pony & Django? djony is very old... i think project is dead https://github.com/nnseva/djony

I doubt that someone recently used djony, and it may not work with the current version of Pony/Django, but it is possible that the code can be fixed. It may be consiered as a proof of concept that Django/Pony integration is possible

is there any working concept of django and pony now?

I think there are no production-ready code at this moment

We personally just use Pony+Flask+ReactJS, so integration with Django was not our priority, but later we can add it

I was wrote some logic modules on Python with ponyOrm ) it works and im happy. I will want develop web application with Django like java + spring MVC. And i dont know there any known working methodics what can help me.

ok ) i will read about flask maybe this way better

We personally just use Pony+Flask+ReactJS, so integration with Django was not our priority, but later we can add it

What do you guys use for compiling React?

Webpack is best solution for now

I was wrote some logic modules on Python with ponyOrm ) it works and im happy. I will want develop web application with Django like java + spring MVC. And i dont know there any known working methodics what can help me.

Wasn't spring the one where you write java code, which gets translated into html/js ?

Wasn't spring the one where you write java code, which gets translated into html/js ?

nowhere ) I dont develop front-end I am just supporting old java project with Java+Spring now. Fron-end was developing with GWT.

Webpack is best solution for now

With webpack is bundle.js path dependent? IE, can I move it to ./static

@micaiahparker What do you mean? In webpack you can set any (relative or absolute) destination path include './static'

http://webpack.github.io/docs/configuration.html#output

This is about baking a big app.js file right? I was looking into https://github.com/miracle2k/webassets (and flask https://github.com/miracle2k/flask-assets)

This is about baking a big app.js file right? I was looking into https://github.com/miracle2k/webassets (and flask https://github.com/miracle2k/flask-assets)

This looks perfect!

But I couldn't get around to test it myself

I'm not sure what route webasset wants one to take to actually install javascript libraries..