Its really easy to write one in Python.

But with telegram bot, you loose thr thread thing

I agree on the facr that telegram bot is very easy to work with

i looked into making a telegram bot at one point, as ive made a fully working discord bot (that has pony in it)

the function is already implemeted https://core.telegram.org/method/messages.getHistory

still would need a program to do it automaticly

Hey, short question into the crowd (but not very important, since it's just syntactic sugar): Is there a way to clone an Entity-Instance (except for the id) to add a copy of it to the db?

x = X[1] d = x.to_dict() del(d['id']) X(**d)

I think that may work, but may not handle some relationships?

I guess this should work for my case (no child-relationships). So maybe I should just add some baseClass which adds this behaviour as a clone operator.

shorter: ``` new = X(*old.to_dict(exclude=['id']))

https://docs.ponyorm.com/api_reference.html#Entity.to_dict

More universal solution: X(**old.to_dict(exclude=[a.name for a in X._pk_attrs_]) Primary key is not necessary can be id, moreover it can be composite

Hi, how to can instance an db and tables existent whit pony, sorry for my english

Say in your native language please

He wants to apply pony models to existing database, I think

Looking at bufixes maybe you should remove the new releases after 7.3 and put evertyhing after 7.3 in a new 8.0 ? It could prevent auto update of dependencies since they are some backward incompatibility.

I think it is better at this moment to specify exact version of Pony in requirements, as for projects with version < 1.0 minor version can break compatibility. Hopefully most compatibility problems should be fixed in 0.7.6 that we plan to release soon The version 0.8-dev is used in migration branch. Because of this, it is better to release 0.8 when migrations will be ready. Hopefully it will be soon

I have a question about coalese function. If I try to coalesce Json attribute pomy throws TypeError: All arguments of coalesce() function should have the same type, but in case with Json field we can not known what exactly type has an attribute. Maybe it should omit type check for Json attributes?

Here is example code: select(coalesce(u.settings['remind_period'], 7) for u in User)

Como hacer uso de una base de datos existente en pony y hacer hacer actualizaciones en los registros

Vitaliy, I think I need to fix it. Can you open an issue for this?

Ok

Luis, what database do you use? SQLite, PostgreSQL?

You can define entities and attributes so the resulted table and columns corresponds to the original tables and columns: class Person(db.Entity): _table_ = 'Table1' id = PrimaryKey(int, auto=True, coulmn='ID') name = Required(str, column='ColumnA') age = Required(int, column='ColumnB') and then, when you call generate_mapping, you should not specify create_tables=True, because you want to use existing tables: db.generate_mapping(check_tables=True) If some tables has less number of columns than entity expects, you will get an error. Also, you can define entities using site editor.ponyorm.com and check SQL tab corresponding to the database that you use in order to check that the existing table has the same columns.

Also, you can try this script to automatically generate entity defnitions from existing tables: https://github.com/abetkin/pony-inspect

Also, you can try this script to automatically generate entity defnitions from existing tables: https://github.com/abetkin/pony-inspect

Permanent link to the abetkin/pony-inspect project you mentioned. (?)

Luis, what database do you use? SQLite, PostgreSQL?

Mysql

Also, you can try this script to automatically generate entity defnitions from existing tables: https://github.com/abetkin/pony-inspect

Thanks

I share my andvance

Thanks 👏

So you were able to connect to existing database and select data from a table. Congrats!

Yes, its fantastic pony

Also, keep in mind that it is not necessary to define all attributes at once in all entities. It is enough to define primary key and the most important attributes, and add the rest columns later

You would be able to read such entities, but to create a new objects it is necessary to define all required attributes

It is much the diference😅

Yeah, with ORM it looks a bit more concise ;)

@admin could you remove those spam accounts?

Yes, but he's offline now. They are joining like 10 per day.

@admin could you remove those spam accounts?

👍

Yes, but he's offline now. They are joining like 10 per day.

You can send an email to the spammer and they will whitelist this group

Proof

Spam 2.0 :) Weird

im looking into making a bot to automatically deal with them

Alexander , is it possible/safe to automatically generate PrimaryKey based on other attributes of the object that is being created? For example, I have some routine that concatenates some fields of my object and then takes cryptographic hash of the result. Is it possible to use this result as a PrimaryKey without writing my own classmethods? Say, I want to be able to write something like: class HashedEntry(db.Entity): propertyA = orm.Optional(buffer) propertyB = orm.Optional(buffer) hash = orm.PrimaryKey(buffer, default=calculateHash(str(self.propertyA)+str(self.PropertyB)) HashedEntry(propertyA="foo", propertyB="bar") instead of having to call HashedEntry.my_create_routine(propertyA="foo", propertyB="bar") ? Thanks!

you can override __init__ method: def __init__(self, propertyA, propertyB): hash = calculateHash(propertyA, propertyB) super().__init__(hash=hash, propertyA=propertyA, propertyB=propertyB)

WTF

Alexander , thanks! It's really cool that Pony does not break with this things.

im looking into making a bot to automatically deal with them

Yeah, There is a bot could remove spams and manage blacklist for group automatically.

Yeah, There is a bot could remove spams and manage blacklist for group automatically.

Bot: @TWBlackList_Bot Author: @TW_Audit_bot

Bot: @TWBlackList_Bot Author: @TW_Audit_bot

This bot is popular for the Chinese groups.

Hi, everyone! Is there a way to track changes on Sets (M2M relationship)? I see only one way: to introduce intermediate entity and create before/after_insert callbacks, but it is not comfortable to work with (to much refactoring of existing code needed). So can I track changes of M2M Sets without intermediate entity?

Hi Alex, how to can declarate this relationship

class Cliente(db.Entity): _table_ = "clientes" id = PrimaryKey(int, column="idClientes") empresa = Optional(str, column="Empresa") alta = Optional(str, column="Alta") facturas = Set("Factura") class Factura(db.Entity): _table_ = "factura" id = PrimaryKey(int, column="idFactura") total = Optional(Decimal, column="Total") ... cliente = Optional("Cliente", column="Clientes_idClientes")

Thanks, i try and and comment 👍

class Clientes(db.Entity): _table_ = "clientes" id = PrimaryKey(int, column = "idClientes") Empresa = Optional(str, column = "Empresa") Alta = Optional(str, column = "Alta") facturas = set("Factura") class Factura(db.Entity): _table_ = "factura" id = PrimaryKey(int, column = "idFactura") Total = Optional(Decimal, column = "Total") Fecha = Optional(datetime, column = "Fecha") Resta = Optional(Decimal, column = "Resta") Pagos = Optional(str, column = "Pagos") clientes = Optional(Clientes, column = "Clientes_idClientes")

pony.orm.core.ERDiagramError: Reverse attribute for Factura.clientes not found

facturas = set("Factura") You need to use Set, not set Also, it is more traditional to name all models in singular, not in plural, because an object represent a single instance of a model. It looks strange when Factura is singular, but Clientes is plural

Wow, great i am a noob 😔

Thanks Alex

Sure

Work!

Hi, everyone! Is there a way to track changes on Sets (M2M relationship)? I see only one way: to introduce intermediate entity and create before/after_insert callbacks, but it is not comfortable to work with (to much refactoring of existing code needed). So can I track changes of M2M Sets without intermediate entity?

Hi Vitaliy! Currently there is no way to track many-to-many relationships. Maybe we can add it. For what purpose do you want to track them and what database do you use?

Work!

Cool. It is more traditional in Python to start attributes names with a lowercase letter, although it is not absolutely necessary

I need read the pep's

Hi, does pony orm work in aws lambda ?

Hi Vitaliy! Currently there is no way to track many-to-many relationships. Maybe we can add it. For what purpose do you want to track them and what database do you use?

Alexander, thank you for reply. I try to design my application to be consistent depend on data in DB. For example, the Server entity has a Set of additional Service. One of them is '1Gbps port speed'. So when this Service has been bound to the Server I need to change port speed to 1Gbps on the Switch device (through external API), which the Server is connected to. And switch speed back to 100Mbps when the Service is unbound from the Server. Currently I do it manually, but it would be great to make this changes automatically via insert/delete callbacks.

Hi guys! We just released Pony ORM 0.7.6 Release Candidate 1 This release should fix most bugs introduced in 0.7.4 during a massive refactoring Also it adds some nice things like support of Python 3.6 f-strings (literal string interpolation): https://github.com/ponyorm/pony/releases/tag/0.7.6rc1 Changelog: # Pony ORM Release 0.7.6rc1 (2018-08-08) ## New features * f-strings support in queries: select(f'{s.name} - {s.age}' for s in Student) * #344: It is now possible to specify offset without limit: query.limit(offset=10) * #371: Support of explicit casting of JSON expressions to str, int or float * #367 @db.on_connect decorator added ## Bugfixes * Fix bulk delete bug introduced in 0.7.4 * #370 Fix memory leak introduced in 0.7.4 * Now exists() in query does not throw away condition in generator expression: exists(s.gpa > 3 for s in Student) * #373: 0.7.4/0.7.5 breaks queries using the in operator to test membership of another query result * #374: auto=True can be used with all PrimaryKey types, not only int * #369: Make QueryResult looks like a list object again: add concatenation with lists, .shuffle() and .to_list() methods * #355: Fix binary primary keys PrimaryKey(buffer) in Python2 * Interactive mode support for PyCharm console * Fix wrong table aliases in complex queries * Fix query optimization code for complex queries

As it is a pre-release, it will not be installed using an usual pip install pony command. You can install it using pip install pony --upgrade --pre or pip install pony==0.7.6rc1 Tomorrow we plan to release official 0.7.6 release

Cool! What is f-strings? Are there any docs?

https://realpython.com/python-f-strings/

It seems I have discovered a bug. I have a following entity (simpified): class IpAddress(db.Entity): network = Required(lambda: IpNetwork) host = Required(int, size=8, unsigned=True, min=1, index=True) PrimaryKey(network, host) @property def str(self): """Hybrid property""" return concat(self.network.octets, self.host) @classmethod def find1(cls, ipaddr): return cls.get(lambda ip: concat(ip.network.octets, ip.host) == ipaddr) @classmethod def find2(cls, ipaddr): return cls.get(lambda ip: ip.str == ipaddr) If I call IpAddress.find1('127.0.0.1') it is OK. If I call IpAddress.find2('127.0.0.1') once it is OK, but further calls throwing exception like this: File ".../pony/orm/core.py", line 5304, in extract_vars try: value = extractor(globals, locals) TypeError: 'str' object is not callable

To make my app works before you'll resolve this issue I have replaced func.__globals__ to {} at line #5438 in core.py

Thanks for reporting! I found the reson for a bug and will wix it soon

@vitalium, I fixed the bug and pushed the fix on GitHub. Thanks again, your help with finding bugs is invaluable