Re: [sqlalchemy] Documentation options
On Fri, 29 Mar 2019, Mike Bayer wrote: I'd prefer any code samples are shared on-list here for the benefit of all to see, thanks. Mike, I was unsure about the proper protocol. I'll post the module here Real Soon Now. Thanks, Rich -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
Re: [sqlalchemy] Documentation options
On Tue, Mar 26, 2019 at 6:28 PM Rich Shepard wrote: > > On Thu, 21 Mar 2019, Mike Bayer wrote: > > > sounds like automap: > > https://docs.sqlalchemy.org/en/latest/orm/extensions/automap.html > > Mike, > > May I send you models.py (off the mail list) to check that I have correctly > applied automap? Hi Rich - I'd prefer any code samples are shared on-list here for the benefit of all to see, thanks. > > TIA, > > Rich > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
Re: [sqlalchemy] Documentation options
On Thu, 21 Mar 2019, Mike Bayer wrote: sounds like automap: https://docs.sqlalchemy.org/en/latest/orm/extensions/automap.html Mike, May I send you models.py (off the mail list) to check that I have correctly applied automap? TIA, Rich -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
Re: [sqlalchemy] Documentation options
On Thu, Mar 21, 2019 at 7:01 PM Rich Shepard wrote: > > On Thu, 21 Mar 2019, Mike Bayer wrote: > > > sounds like automap: > > https://docs.sqlalchemy.org/en/latest/orm/extensions/automap.html > > Mike, > > While this does not look familiar, I'll carefully read the page again until > I really understand it. > > Now, model.py contains classes for each table in the postgres database, and > I thought there was a way to associate the classes with the tables yet > automap doesn't tickle my memory. So, more study is on the schedule. there's also just using `__table__ = Table(..., autoload_with=engine)` as well as DeferredReflection which is kind of a more primitive automap, maybe you saw that: https://docs.sqlalchemy.org/en/latest/orm/extensions/declarative/table_config.html#using-reflection-with-declarative > > Thanks again, > > Rich > > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
Re: [sqlalchemy] Documentation options
On Thu, 21 Mar 2019, Mike Bayer wrote: sounds like automap: https://docs.sqlalchemy.org/en/latest/orm/extensions/automap.html Mike, While this does not look familiar, I'll carefully read the page again until I really understand it. Now, model.py contains classes for each table in the postgres database, and I thought there was a way to associate the classes with the tables yet automap doesn't tickle my memory. So, more study is on the schedule. Thanks again, Rich -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
Re: [sqlalchemy] Documentation options
sounds like automap: https://docs.sqlalchemy.org/en/latest/orm/extensions/automap.html On Thu, Mar 21, 2019 at 6:07 PM Rich Shepard wrote: > > On Thu, 21 Mar 2019, Mike Bayer wrote: > > > oh sure, I meant it uses up an enormous amount of memory / CPU to build > > the PDF. it looks terrible too because sphinx's templates aren't very > > good, plus SQLAlchemy's docs have a bunch of custom things going on that > > format even more badly. > > Mike, > > Okay. You convinced me to stick with the on-line versions. > > I have the database tables created and populated, and the tkinter GUI views > (at least, most of them) written, and now I need to learn how to apply SA > between the two. > > Long ago I saw the docs that explained how to work with an existing database > rather than using the classes to create the tables. I'm trying to find that > again in my e-mail archives. > > Regards, > > Rich > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
Re: [sqlalchemy] Documentation options
On Thu, 21 Mar 2019, Mike Bayer wrote: oh sure, I meant it uses up an enormous amount of memory / CPU to build the PDF. it looks terrible too because sphinx's templates aren't very good, plus SQLAlchemy's docs have a bunch of custom things going on that format even more badly. Mike, Okay. You convinced me to stick with the on-line versions. I have the database tables created and populated, and the tkinter GUI views (at least, most of them) written, and now I need to learn how to apply SA between the two. Long ago I saw the docs that explained how to work with an existing database rather than using the classes to create the tables. I'm trying to find that again in my e-mail archives. Regards, Rich -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
Re: [sqlalchemy] Documentation options
On Thu, Mar 21, 2019 at 5:11 PM Rich Shepard wrote: > > On Thu, 21 Mar 2019, Mike Bayer wrote: > > > not currently, however you can do a sphinx pdf build yourself if you > > feel like installing LaTeX, > > Mike, > > I write > 90% of my documents using LaTeX (with the LyX GUI front end). > Sphinx is a new one for me so I'll go look at it. > > > unfortunately SQLAlchemy's PDF is enormous, has a lot of formatting > > problems, and the readthedocs site wasn't able to build it, the > > current tools are not reliable enough for me to publish this myself. > > Postgres docs are also rather large and I find it easier to search for > specific information in a PDF. oh sure, I meant it uses up an enormous amount of memory / CPU to build the PDF. it looks terrible too because sphinx's templates aren't very good, plus SQLAlchemy's docs have a bunch of custom things going on that format even more badly. > > Thanks, > > Rich > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
Re: [sqlalchemy] Documentation options
On Thu, 21 Mar 2019, Mike Bayer wrote: not currently, however you can do a sphinx pdf build yourself if you feel like installing LaTeX, Mike, I write > 90% of my documents using LaTeX (with the LyX GUI front end). Sphinx is a new one for me so I'll go look at it. unfortunately SQLAlchemy's PDF is enormous, has a lot of formatting problems, and the readthedocs site wasn't able to build it, the current tools are not reliable enough for me to publish this myself. Postgres docs are also rather large and I find it easier to search for specific information in a PDF. Thanks, Rich -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
Re: [sqlalchemy] Documentation options
On Thu, Mar 21, 2019 at 4:20 PM Rich Shepard wrote: > > Are there PDF versions of the docs available for downloading and reading? I > don't find an answer on the web site. not currently, however you can do a sphinx pdf build yourself if you feel like installing LaTeX, there also seems to be some new project https://github.com/brechtm/rinohtype that wants to replace LaTeX, could be helpful. unfortunately SQLAlchemy's PDF is enormous, has a lot of formatting problems, and the readthedocs site wasn't able to build it, the current tools are not reliable enough for me to publish this myself. > > TIA, > > Rich > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.