Welcome! :)

Hello guys :)

Hello

Hey

Welcome :)

welcome!

Hi!

It seems it won't delete correctly.

I realized I probably just could replace (reassign) the .state :D Not sure why that above happens, tho.

The real operation is postponed until commit or flush. I'm not sure it is a good idea to delete a row and right after that create a new row with the same primary key. Maybe it is better to assign new state field to a existing row. And even better is probably to have state field directly inside the User object

The real operation is postponed until commit or flush. I'm not sure it is a good idea to delete a row and right after that create a new row with the same primary key. Maybe it is better to assign new state field to a existing row. And even better is probably to have state field directly inside the User object

Yeah, probably :/ Anyway this makes state cleanup a bit easier (drop table), and can also be extendet to chat groups later. But you are probably right, and I am just a bad programmer, still sticking to this 😜

I think you are overmodest :) If each object type (User, Chat, Message, etc.) has corresponding type attribute, the cleanup may be relatively simple too, something like that: @db_session def do_cleanup() db.execute('update "user" set "state" = 0') db.execute('update "message" set "state" = 0') db.execute('update "chat" set "state" = 0')

Welcome!

Hey everyone!

Just join the group

starting to learn pony

welcome

on a non related question, in: def send_message(text, chat_id=169582347, parse_mode=None):

def send_message(text, chat_id=169582347, parse_mode=None):

which are *arg and **kwargs

mmm if i were you i'd ask here: https://telegram.me/pythontelegrambotgroup

mmm if i were you i'd ask here: https://telegram.me/pythontelegrambotgroup

thanks

on a non related question, in: def send_message(text, chat_id=169582347, parse_mode=None):

This could be pytgbot actually. In that case I can help you https://telegram.me/pytg_group

which are *arg and **kwargs

Arg are the positional arguments, kwargs are the keyword arguments (with foo=value)

I realize my mistake thanks it is decided on the call not the definition

Arg are the positional arguments, kwargs are the keyword arguments (with foo=value)

thanks

Hello guy I would like to discuss a diagram for the web creator. This is about relations and that relations always have fields on both tables involved. I would suggest something like this as an option (see image)

Guys* :)

Pony genernates you Fields in both classes, so you can reach one from another

that's correct - having the relationship attributes in both entities allows traversing these attributes, so you can reach one object from another. Colin, let me understand, why you'd like to omit the relationship attribute in the User entity? How does it help?

Actually, you are not the first person asking about this. My understanding is that this way it is more SQL table oriented, because in the database there is no column for this relationship in the 'User' table

probably we could have two views in the editor 'object view' and 'table view'. Another option is to have the relation attributes separated from the regular attributes - say data attributes at the top and relationship attributes under a line at the bottom in each entity

are both relational fields created by pony actually created in the database or is this just in the code for representation?

the code only for one-to-many relationship the field is created in one table only

you can see that if you open one of the specific database with SQL tab (SQLite, MySQL, etc)

okey so in this case it only helps me in the overview of the online tool

the "object" and "table" view would be very nice

what technology are you using for working with the database, once the diagram is created?

for now i using django models

and for sure postgres as database

btw, we plan to add Django tab, where you can get Django models for your diagram

🙏 thanks :)

what about having the attributes which will not be created as fields in the database of different color on the diagram? say gray?

would be helpful as well

the problem i have is that is gets very fast unclear

Another thing which struck me, was that you can't Zoom.

yes me 2

have you ever used enterprise architect?

currently you can zoom using the browser zoom

never used the enterprise architect. what we can pick from it?

Is there planned to be able to import pony code?

one cool thing is to create modules with specific models in each of them from that you have a view in each module to see only the tables related and the relations to other module-tables

Is there planned to be able to import pony code?

how that could be heplful? what workflow do you see in this case?

one cool thing is to create modules with specific models in each of them from that you have a view in each module to see only the tables related and the relations to other module-tables

yes, this needs to be done. We use the Editor ourselves and the diagram becomes too overwhelmed too fast. But what if you need to see all entities at a glance? Anyways all of them are interconnected

one cool thing is to create modules with specific models in each of them from that you have a view in each module to see only the tables related and the relations to other module-tables

Can you share an image of how this can be done?

sure

and the diagram?

these are the modules and models inside

is just an example

ok, I see, thanks!

Sorry guys, I need to step out for an hour But let's continue this conversation, it is very cool that you can give us your feedback

oke bye :)

how that could be heplful? what workflow do you see in this case?

2 cases: - apply changes in code easily or be able to create them in code first, and later visualize them - there is currently no import at all, It would be handy if I could enter a database i created hundreds of commits earlier, to have a look at the data at that time. Having really big databases/many tables, entering then manually can be a hassle. Maybe there could be an import module for other models too. That part maybe open source, so users can contribute other mappers, e.g. Importing Django Models into Pony

yes would be very nice

But I often change models in Source code, and manual doing that in the editor later sometimes I tend to forget something.

But I often change models in Source code, and manual doing that in the editor later sometimes I tend to forget something.

Currently I have the code generated from pony in one file, to track the changes I made online in the diagram, while using a different file where I wont overwrite modifications I didn't "draw" yet, where I merge it together once in a while

But I often change models in Source code, and manual doing that in the editor later sometimes I tend to forget something.

ok, I got you, thanks

The line db_user.last_used = orm.raw_sql("NOW()") Fails with TypeError: Attribute WebSession.last_used: expected type is 'datetime'. Got: <pony.orm.ormtypes.RawSQL object at 0x7eff3eaf3b38> The schema looks like this: class WebSession(db.Entity): id = PrimaryKey(UUID) bot_token = Optional(str, nullable=True) user = Optional(User) web_token = Optional(str) created = Required(datetime, sql_default='NOW()') last_used = Required(datetime, sql_default='NOW()')

RawSQL is just a text inside an SQL query. It evaluates on the database side. If you perform change in Python, assign Python value: from datetime import datetime ... db_user.last_user = datetime.now()

I was hoping I could have used NOW() to be independent of the script time(zone).

Hmm, so you mean that that Raw SQL value just used when UPDATE command will be sent to the database later? Maybe we can add this in the future. Until that, you can add a trigger which will update the column automatically: http://stackoverflow.com/questions/9556474/how-do-i-automatically-update-a-timestamp-in-postgresql/26284695#26284695

Hmm, so you mean that that Raw SQL value just used when UPDATE command will be sent to the database later? Maybe we can add this in the future. Until that, you can add a trigger which will update the column automatically: http://stackoverflow.com/questions/9556474/how-do-i-automatically-update-a-timestamp-in-postgresql/26284695#26284695

Yep, that would be great!

Having my boring old Sticker search query again: pairs = orm.select( (st.sticker.file_id, max(st.date)) for st in StickerMessage for t in st.sticker.tags if (query_text.lower() in t.string.lower() or query_text == st.sticker.emoji) ).order_by(orm.desc(2), 1).limit(50, offset=offset) How would I best exclude StickerMessages where any of the Tags t.string.lower() == "blocked tag"?

and not exists(t for t in st.sticker.tags if t.string.lower() == "blocked tag")

I already have for t in st.sticker.tags, this can't be integrated?