Re: [pylons-discuss] request for help upgrading the cookiecutter to support sqlalchemy 2.0

[Michael Merickel]

I've chatted a little bit with Laurent Daverio on the side but yeah for the
most part:

- I upgraded the cookiecutter-starter to use pyproject.toml and SQLAlchemy
2.0 patterns. That branch is here
https://github.com/Pylons/pyramid-cookiecutter-starter/tree/main
- I skimmed alembic changes and didn't see something worth fixing in our
setup, but open to feedback.
- I upgraded the wiki2 tutorial in Pyramid to use the new SQLA 2.0
patterns. That PR is here https://github.com/Pylons/pyramid/pull/3747 and I
left it open for a bit in case someone wanted to look.

I would love if someone synced the pyproject.toml and SQLA changes into the
quick tutorial and the zodb tutorial (should be a lot easier than the wiki2
tutorial I did above).

Other than that - I'm trying to evaluate the feasibility of making
pkg_resources optional in Pyramid before cutting a new release. My
ramblings about that topic are here if you want to track it for any reason.
https://github.com/Pylons/pyramid/issues/3731

Thanks!

On Mon, Feb 5, 2024 at 2:55 PM Jonathan Vanasco  wrote:

> I don't have time to do this, but would be happy to be looped in for code
> review if there is another PR.
>
> It looks like you've gotten most things done already.
>
> I think the alembic integration may be out of date, as those files haven't
> been touched for a while.  I can ask Federico on the SqlAlchemy team to
> take a look at the current setup, he's been the main force behind
> maintaining and expanding Alembic.  The core devs meet on Wednesdays on
> gitter.
>
>
> On Monday, January 29, 2024 at 5:08:54 AM UTC-5 Laurent Daverio wrote:
>
>> Hello list,
>>
>> I think I could do that, unless someone has volunteered already (I have A
>> LOT to do these days, wouldn't want to duplicate someone else's work).
>>
>> Laurent.
>>
>>
>> Le lun. 29 janv. 2024 à 07:51, Michael Merickel  a
>> écrit :
>>
>>> Hey folks,
>>>
>>> I'd really appreciate it if someone was willing to take the time to
>>> upgrade the pyramid-cookiecutter-starter to use SQLAlchemy 2.0 best
>>> practices. Things like rewriting the queries away from Query to simple
>>> select(), and using the more modern declarative mapper that is typing
>>> friendly.
>>>
>>> https://github.com/Pylons/pyramid-cookiecutter-starter/tree/main
>>>
>>> Once we get that upgraded, we'd need to fix up the wiki2 tutorial to
>>> reference the updated files accurately - but first step is just getting the
>>> cookiecutter updated.
>>>
>>> https://github.com/Pylons/pyramid/tree/main/docs/tutorials/wiki2
>>>
>>> Thanks!
>>>
>>> - Michael
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "pylons-discuss" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to pylons-discus...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/pylons-discuss/54913600-1D9F-47E9-B991-136D0B5A73F3%40gmail.com
>>> 
>>> .
>>>
>> --
> You received this message because you are subscribed to the Google Groups
> "pylons-discuss" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to pylons-discuss+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/pylons-discuss/ea574da1-7b7e-4a88-ac4b-83950161a5dcn%40googlegroups.com
> 
> .
>


-- 

Michael

-- 
You received this message because you are subscribed to the Google Groups 
"pylons-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to pylons-discuss+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/pylons-discuss/CAKdhhwHHL1NKsmJ7VemuKSAiKM3sXKm6-1M9JJ1B5iQ9CcQgLw%40mail.gmail.com.

Re: [pylons-discuss] request for help upgrading the cookiecutter to support sqlalchemy 2.0

[Jonathan Vanasco]

I don't have time to do this, but would be happy to be looped in for code 
review if there is another PR.

It looks like you've gotten most things done already.

I think the alembic integration may be out of date, as those files haven't 
been touched for a while.  I can ask Federico on the SqlAlchemy team to 
take a look at the current setup, he's been the main force behind 
maintaining and expanding Alembic.  The core devs meet on Wednesdays on 
gitter. 


On Monday, January 29, 2024 at 5:08:54 AM UTC-5 Laurent Daverio wrote:

> Hello list,
>
> I think I could do that, unless someone has volunteered already (I have A 
> LOT to do these days, wouldn't want to duplicate someone else's work).
>
> Laurent.
>
>
> Le lun. 29 janv. 2024 à 07:51, Michael Merickel  a 
> écrit :
>
>> Hey folks,
>>
>> I'd really appreciate it if someone was willing to take the time to 
>> upgrade the pyramid-cookiecutter-starter to use SQLAlchemy 2.0 best 
>> practices. Things like rewriting the queries away from Query to simple 
>> select(), and using the more modern declarative mapper that is typing 
>> friendly.
>>
>> https://github.com/Pylons/pyramid-cookiecutter-starter/tree/main
>>
>> Once we get that upgraded, we'd need to fix up the wiki2 tutorial to 
>> reference the updated files accurately - but first step is just getting the 
>> cookiecutter updated.
>>
>> https://github.com/Pylons/pyramid/tree/main/docs/tutorials/wiki2
>>
>> Thanks!
>>
>> - Michael
>>
>> -- 
>> You received this message because you are subscribed to the Google Groups 
>> "pylons-discuss" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to pylons-discus...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/pylons-discuss/54913600-1D9F-47E9-B991-136D0B5A73F3%40gmail.com
>>  
>> 
>> .
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"pylons-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to pylons-discuss+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/pylons-discuss/ea574da1-7b7e-4a88-ac4b-83950161a5dcn%40googlegroups.com.

[pylons-discuss] Re: Enabling Github Discussions

[Jonathan Vanasco]

After using github discussions as a secondary support channel, SqlAlchemy 
froze the Google Group a few months ago and uses it as the only official 
channel now.  It has worked fairly well.

On Wednesday, January 31, 2024 at 8:57:29 PM UTC-5 Michael Merickel wrote:

> Hey folks,
>
> I've enabled the discussions feature on the pyramid repository as an 
> alternative form of communication if it simplifies communication for 
> anyone. We shall see!
>
> https://github.com/Pylons/pyramid/discussions
>
> - Michael
>

-- 
You received this message because you are subscribed to the Google Groups 
"pylons-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to pylons-discuss+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/pylons-discuss/5ff2c175-97a7-4f61-8806-370fc4eed8c6n%40googlegroups.com.