Karsten I don't know why it works for not None values but could you try to return the object as json from add_blz_event?

None will not be added !

Hey! Is there a reason Pony does not use LOWER() when using .lower() in the query in Python and instead uses replace? Is there a way to force it? It would make searches faster

Hey! Is there a reason Pony does not use LOWER() when using .lower() in the query in Python and instead uses replace? Is there a way to force it? It would make searches faster

What do you mean? Can you give an example?

Hey! I am trying to work in PonyORM . Please tell me, there is some method that allows you to determine the maximum value ID in the table. Now I use for this loops

select(max(obj.id) for obj in MyEntity) or from pony.orm import max ... max(obj.id for obj in MyEntity) or select(obj.id for obj in MyEntity).max()

Thank you

I have MyEntitys: Product and Tag and relationship. I have line Product1 in Product and tags_set {'tag1', 'tag3'} this Product1. I have lines 'tag1', 'tag2', 'tag3' in Entity “Tag”. When I used code: query_tag = select(t for t in Tag if t.tag_name == tag_name) I can’t connect lines 'tag1', 'tag3' with line Product1. Only using cycles. Please tell me, Can I use pony methods to determine this “id” lines Entity “Tag”.?

# retrieving tags for specific product id product = Product[specific_product_id] for tag in product.tag_set: print(tag.name) # retrieving a product for specific tag name tag = Tag.get(name=specific_tag_name) for product in tag.product_set: print(product.name)

# retrieving tags for specific product id product = Product[specific_product_id] for tag in product.tag_set: print(tag.name) # retrieving a product for specific tag name tag = Tag.get(name=specific_tag_name) for product in tag.product_set: print(product.name)

Thank you!

I have line Product1 in Entity “Product”, lines 't1', 't2', 'q1' in Entity “Tag” They have relationships. and String 't2, t1, q1, tag1, tag10' Please let me know, how do I detect which tags have relationships with an entity Product1 ?

The same as Alexander replied above. product1 = Product.get(Name='product 1') tags = select(t for t in product1.tags) or tag_names = select(t.tag_name for t in product1.tags)[:]

Can someone recommend a video on how yo use pony ORM

🙏?

The same as Alexander replied above. product1 = Product.get(Name='product 1') tags = select(t for t in product1.tags) or tag_names = select(t.tag_name for t in product1.tags)[:]

First way, but select is unnecessary. They are accessible

The same as Alexander replied above. product1 = Product.get(Name='product 1') tags = select(t for t in product1.tags) or tag_names = select(t.tag_name for t in product1.tags)[:]

Thank you very much !!! it works. Please, tell me, where can I find out about these square quotes at the end of a string code?

Thank you very much !!! it works. Please, tell me, where can I find out about these square quotes at the end of a string code?

Here: https://docs.ponyorm.org/firststeps.html#writing-queries

Here: https://docs.ponyorm.org/firststeps.html#writing-queries

🙏

Can someone recommend a video on how yo use pony ORM

Hi Peter. There is this series of videos of youtube, which you probably found as well: https://www.youtube.com/watch?v=YyTGYk1j9N0&list=PLM0LBHjz37LXPeEjSuumB4g4JFCsTwNgn

Personally, I'd recommed just going through the first steps on the docs page: https://docs.ponyorm.org/firststeps.html

Thank you @christiandoes , I appreciate 🙏

Good day everyone please, how can I read and parse four files in these format .CSV,.JSON, .XML and .txt into a single database table using ponyORM Thank you very much in anticipation

Good day everyone please, how can I read and parse four files in these format .CSV,.JSON, .XML and .txt into a single database table using ponyORM Thank you very much in anticipation

You create the database with PonyORM and use python's standard library tools to parse each file and put the contents into your db table. Here are some examples that will help you: https://docs.python.org/3/library/csv.html#examples https://docs.python.org/3/library/json.html https://docs.python.org/3/library/xml.etree.elementtree.html#parsing-xml

Thanks for reminding, I should be able to look at it in a few days

Did you got time to look at it?

You create the database with PonyORM and use python's standard library tools to parse each file and put the contents into your db table. Here are some examples that will help you: https://docs.python.org/3/library/csv.html#examples https://docs.python.org/3/library/json.html https://docs.python.org/3/library/xml.etree.elementtree.html#parsing-xml

Thank you for the above but I am stocked in joining related column in CSV and JSON and parse it as a single file using ponyORM. Still need further assistance

Thank you for the above but I am stocked in joining related column in CSV and JSON and parse it as a single file using ponyORM. Still need further assistance

Sorry, I don't understand. If you have four different filetypes, why would you parse it as a single file?

Do you have some code that shows what you're trying to do?

Thank you for the above but I am stocked in joining related column in CSV and JSON and parse it as a single file using ponyORM. Still need further assistance

Pony isn't a tool that directly helps you to read data from files.

do you know if i can use the pony with pandas.to_sql this typically needs a sqlalchemy connection / engine instance https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_sql.html

Are there any problems with PR #671? Would be nice to have Python 3.11 compatibility, https://github.com/ponyorm/pony/pull/671

Thank you very much !!! it works. Please, tell me, where can I find out about these square quotes at the end of a string code?

Off-topic, but... if you didn't work it out yet, the [:] syntax is how Python slices (i.e. selects parts from) arrays and other iterables (including strings). See https://stackoverflow.com/questions/509211/understanding-slicing

do you know if i can use the pony with pandas.to_sql this typically needs a sqlalchemy connection / engine instance https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_sql.html

Personally, i don't know but i doubt it. Pandas.DataFrame.to_sql only supports SQL Alchemy, or SQLite3 as a "legacy" option according to those docs. Perhaps you could dump the DataFrame to a SQLite database, then connect to that with Pony? I have no idea if that is a Good Plan, though :)

Personally, i don't know but i doubt it. Pandas.DataFrame.to_sql only supports SQL Alchemy, or SQLite3 as a "legacy" option according to those docs. Perhaps you could dump the DataFrame to a SQLite database, then connect to that with Pony? I have no idea if that is a Good Plan, though :)

Got it thank you

how do i declare a text column - I'm running into issues with long strings when I use the orm.Required(str) syntax

how do i declare a text column - I'm running into issues with long strings when I use the orm.Required(str) syntax

Try 'from pony.orm import LongStr'

thank you

Здравствуйте, можете подсказать как мне писать тесты с ponyorm, использую pytest? Буду рад примерам,в интернете не нашёл.

Здравствуйте, можете подсказать как мне писать тесты с ponyorm, использую pytest? Буду рад примерам,в интернете не нашёл.

What exactly are you curious about?

how to properly initialize the database for tests? This is my initialization, but it doesn't separate the tests from each other.

Are you familiar with pytest.fixture?

Are you familiar with pytest.fixture?

yes

There a lot of ways you can achieve this, but the easiest one would be def initialize_db_here(): ... @pytest.fixture() def db(): _db = initialize_db_here() yield _db destruct_db() def test(db): ... # work with your db Probably smth like this could work

I saw this method on the Internet, but it seems incorrect to me, but thanks anyway)

I saw this method on the Internet, but it seems incorrect to me, but thanks anyway)

I use setup_function, but I think it's similar. def setup_function(): db.drop_all_tables(with_all_data=True) db.create_tables() with db_session: # here you can set the data you need for the tests

I use setup_function, but I think it's similar. def setup_function(): db.drop_all_tables(with_all_data=True) db.create_tables() with db_session: # here you can set the data you need for the tests

Hmm.. This fine...

Would Pony work well as the ORM for a many shaded discord bot? or would there be conflicts between shards?

Would Pony work well as the ORM for a many shaded discord bot? or would there be conflicts between shards?

It should probably work well, but the sharding will not be teansparent for your application. You can create a separate db instance for each shard and initialize all of them with the same schema.

Are there any problems with PR #671? Would be nice to have Python 3.11 compatibility, https://github.com/ponyorm/pony/pull/671

I'm sorry, before last weekend I fell off my bike and got a concussion, it slowed down the work on the release. I hope we can release it soon

I'm sorry, before last weekend I fell off my bike and got a concussion, it slowed down the work on the release. I hope we can release it soon

Hope you will be better soon!

I'm sorry, before last weekend I fell off my bike and got a concussion, it slowed down the work on the release. I hope we can release it soon

So sorry to hear! Get well soon!

I'm trying to change a name of a table in mysql - i was hoping to change the models.py file and simply run RENAME TABLE old_table TO new_table somehow through pony but not sure how to run this raw_sql command - if I run it inside a orm.select(orm.raw_sql(XX)) it didn't work - any ideas?

I can suggest using some migrations manager which runs raw sql

ty

I'm trying to copy something from a mysql database to a postgres one - I have the models mysql.Table and postgres.Table and I tried to do something like t = mysql.Table[1] postgres.Table(**t) but this didn't work because t isn't a mapping, the definitions of Table are t he exact same and I've inherited from the right Entity class like in this question - is there an easy way to recreate the Table class?

Not sure whats the problem you're trying to solve

I'm trying to copy something from a mysql database to a postgres one - I have the models mysql.Table and postgres.Table and I tried to do something like t = mysql.Table[1] postgres.Table(**t) but this didn't work because t isn't a mapping, the definitions of Table are t he exact same and I've inherited from the right Entity class like in this question - is there an easy way to recreate the Table class?

Maybe it would be easier to find third party migration tool from mysql to postgres

Or simply dump database data to json and import to postgres

Not sure whats the problem you're trying to solve

just to copy over data from one db to the other

Maybe it would be easier to find third party migration tool from mysql to postgres

do you have any suggestions by any chance?

do you have any suggestions by any chance?

I’ve done such migration using json dump

I’ve done such migration using json dump

Json is too slow if you have a lot of data, I recommend to use pickle instead

Json is too slow if you have a lot of data, I recommend to use pickle instead

Yeah but in my case json was sufficient enough

I wonder if regular sql dump (which is actually tons of inserts) could work

just fyi it wasn't a huge db so I ended up just rewriting the read / insert code - but not ideal as I don't know if I've messed something up or not

I'm trying to change a name of a table in mysql - i was hoping to change the models.py file and simply run RENAME TABLE old_table TO new_table somehow through pony but not sure how to run this raw_sql command - if I run it inside a orm.select(orm.raw_sql(XX)) it didn't work - any ideas?

I think waht I was after here is db.execute (https://docs.ponyorm.org/api_reference.html#Database.execute)

is there an easy way to grant privileges to a postgres db through pony?

Pony is a not a db management tool. You should do it manually

ok got it thank you

Hello everybody! Can you help me? I am working with pony for second day according to specs and official doc "getting started ". I have a problem, I don't get values with select function. I checked DB in pgAgent, and there values exist. Whole code is written from doc. Please, i am waiting for any advices🙏😔

Hello everybody! Can you help me? I am working with pony for second day according to specs and official doc "getting started ". I have a problem, I don't get values with select function. I checked DB in pgAgent, and there values exist. Whole code is written from doc. Please, i am waiting for any advices🙏😔

Hello everybody! Can you help me? I am working with pony for second day according to specs and official doc "getting started ". I have a problem, I don't get values with select function. I checked DB in pgAgent, and there values exist. Whole code is written from doc. Please, i am waiting for any advices🙏😔

Hi, you're missing [:] at the end

Hi, you're missing [:] at the end

Or db session :)

There is no pony object in response

Hi, you're missing [:] at the end

It is not working, forgot to add for this time

He's working at the terminal, it doesnt require db_session

He's working at the terminal, it doesnt require db_session

Ah, I see

There is no pony object in response

I understand. This is my question, why ))

But if I do request to objects, it works correctly