mike bayer :python_logo: @zzzeek@hachyderm.io
Public

here's a cool problem someone asked about, I tried to be lazy and have Claude do it but Claude couldn't figure it out, except it was nice enough to show me the LAG and LEAD window functions.

Select a bunch of objects, and each has a link to its "previous" and "next" entry in order of table insertion.

github.com/sqlalchemy/sqlalche

I am hoping this is a fairly simple ask, but I cannot seem to figure it out! I have a simple table with products in: class ProductModel(db.Model): __tablename__ = "Products" id = db.Column("id") na...

Finding the next and previous records based on ID · sqlalchemy sqlalchemy · Discussion #13027

I am hoping this is a fairly simple ask, but I cannot seem to figure it out! I have a simple table with products in: class ProductModel(db.Model): __tablename__ = "Products" id = db.Column("id") na...

github.com · GitHub

0
0
0

If you have a fediverse account, you can quote this note from your own instance. Search https://hachyderm.io/users/zzzeek/statuses/115698061054289356 on your instance and quote it. (Note that quoting is not supported in Mastodon.)