Re: [sqlalchemy] Just starting with sqlacodegen: wrong command?
Thanks both! El miércoles, 15 de junio de 2022 a las 9:42:53 UTC+1, Simon King escribió: > Here's the command you ran: > > (venv) jgarcia@Javier-PC:/var/www$ sudo pip install sqlacodegen==3.0.0b3 > > The "(venv)" at the beginning of your prompt suggests that you are in an > activated virtualenv. But when you run "sudo pip", you are installing the > package globally. You now have 2 different versions of sqlacodegen > installed in different locations. > > You should probably have run "pip install" *without* "sudo". If you *need* > sudo (because your virtualenv is owned by root), you must ensure that you > run the "pip" that is installed in the virtualenv, by using an absolute > path. > > Hope that helps, > > Simon > > On Tue, Jun 14, 2022 at 5:32 PM Javier Garcia wrote: > >> This is what I'm getting when I try to upgrade to 3.0.0b3. >> >> (venv) jgarcia@Javier-PC:/var/www$ sudo pip install sqlacodegen==3.0 >> ERROR: Could not find a version that satisfies the requirement >> sqlacodegen==3.0 (from versions: 1.0.0, 1.1.0, 1.1.1, 1.1.2, 1.1.3, 1.1.4, >> 1.1.5, 1.1.6, 2.0.0, 2.0.1, 2.1.0, 2.2.0, 2.3.0, 3.0.0b1, 3.0.0b2, 3.0.0b3, >> 3.0.0rc1) >> ERROR: No matching distribution found for sqlacodegen==3.0 >> (venv) jgarcia@Javier-PC:/var/www$ sudo pip install sqlacodegen==3.0.0b3 >> Collecting sqlacodegen==3.0.0b3 >> Downloading sqlacodegen-3.0.0b3-py3-none-any.whl (19 kB) >> Requirement already satisfied: inflect>=4.0.0 in >> /usr/local/lib/python3.8/dist-packages (from sqlacodegen==3.0.0b3) (5.6.0) >> Requirement already satisfied: SQLAlchemy>=1.4.0 in >> /usr/local/lib/python3.8/dist-packages (from sqlacodegen==3.0.0b3) (1.4.37) >> Collecting importlib-metadata; python_version < "3.10" >> Downloading importlib_metadata-4.11.4-py3-none-any.whl (18 kB) >> Requirement already satisfied: greenlet!=0.4.17; python_version >= "3" >> and (platform_machine == "aarch64" or (platform_machine == "ppc64le" or >> (platform_machine == "x86_64" or (platform_machine == "amd64" or >> (platform_machine == "AMD64" or (platform_machine == "win32" or >> platform_machine == "WIN32")) in /usr/local/lib/python3.8/dist-packages >> (from SQLAlchemy>=1.4.0->sqlacodegen==3.0.0b3) (1.1.2) >> Collecting zipp>=0.5 >> Downloading zipp-3.8.0-py3-none-any.whl (5.4 kB) >> Installing collected packages: zipp, importlib-metadata, sqlacodegen >> Attempting uninstall: sqlacodegen >> Found existing installation: sqlacodegen 2.3.0 >> Uninstalling sqlacodegen-2.3.0: >> Successfully uninstalled sqlacodegen-2.3.0 >> Successfully installed importlib-metadata-4.11.4 sqlacodegen-3.0.0b3 >> zipp-3.8.0 >> (venv) jgarcia@Javier-PC:/var/www$ sqlscodegen --version >> >> Command 'sqlscodegen' not found, did you mean: >> >> command 'sqlacodegen' from deb sqlacodegen (1.1.6-2build1) >> >> Try: sudo apt install >> >> (venv) jgarcia@Javier-PC:/var/www$ sqlacodegen --version >> 2.3.0 >> >> On Tue, Jun 14, 2022 at 5:25 PM Javier Garcia wrote: >> >>> Thanks Simon, do you know how could I install that version as when I >>> upgrade the sqlacodegen I still get the version 2.3.0? >>> >>> Javier >>> >>> El martes, 14 de junio de 2022 a las 17:21:31 UTC+1, Simon King escribió: >>> >>>> Based on the CHANGES file, it looks like --generator is a new option in >>>> v3.0.0: >>>> >>>> https://github.com/agronholm/sqlacodegen/blob/master/CHANGES.rst >>>> >>>> Simon >>>> >>>> On Tue, Jun 14, 2022 at 5:06 PM Javier Garcia >>>> wrote: >>>> >>>>> Hi, >>>>> >>>>> I have tried to run something like this: >>>>> >>>>> sqlacodegen --generator tables >>>>> mysql+pymysql://user:password@localhost/dbname >>>>> >>>>> but I get: >>>>> >>>>> usage: sqlacodegen [-h] [--version] [--schema SCHEMA] [--tables >>>>> TABLES] [--noviews] [--noindexes] [--noconstraints] [--nojoined] >>>>> [--noinflect] [--noclasses] [--nocomments] [--outfile OUTFILE] [url] >>>>> sqlacodegen: error: unrecognized arguments: --generator >>>>> mysql+pymysql://root:***@localhost/test_user >>>>> >>>>> My sqlacodegen version is 2.3.0. >>>>> >>>&
Re: [sqlalchemy] Just starting with sqlacodegen: wrong command?
This is what I'm getting when I try to upgrade to 3.0.0b3. (venv) jgarcia@Javier-PC:/var/www$ sudo pip install sqlacodegen==3.0 ERROR: Could not find a version that satisfies the requirement sqlacodegen==3.0 (from versions: 1.0.0, 1.1.0, 1.1.1, 1.1.2, 1.1.3, 1.1.4, 1.1.5, 1.1.6, 2.0.0, 2.0.1, 2.1.0, 2.2.0, 2.3.0, 3.0.0b1, 3.0.0b2, 3.0.0b3, 3.0.0rc1) ERROR: No matching distribution found for sqlacodegen==3.0 (venv) jgarcia@Javier-PC:/var/www$ sudo pip install sqlacodegen==3.0.0b3 Collecting sqlacodegen==3.0.0b3 Downloading sqlacodegen-3.0.0b3-py3-none-any.whl (19 kB) Requirement already satisfied: inflect>=4.0.0 in /usr/local/lib/python3.8/dist-packages (from sqlacodegen==3.0.0b3) (5.6.0) Requirement already satisfied: SQLAlchemy>=1.4.0 in /usr/local/lib/python3.8/dist-packages (from sqlacodegen==3.0.0b3) (1.4.37) Collecting importlib-metadata; python_version < "3.10" Downloading importlib_metadata-4.11.4-py3-none-any.whl (18 kB) Requirement already satisfied: greenlet!=0.4.17; python_version >= "3" and (platform_machine == "aarch64" or (platform_machine == "ppc64le" or (platform_machine == "x86_64" or (platform_machine == "amd64" or (platform_machine == "AMD64" or (platform_machine == "win32" or platform_machine == "WIN32")) in /usr/local/lib/python3.8/dist-packages (from SQLAlchemy>=1.4.0->sqlacodegen==3.0.0b3) (1.1.2) Collecting zipp>=0.5 Downloading zipp-3.8.0-py3-none-any.whl (5.4 kB) Installing collected packages: zipp, importlib-metadata, sqlacodegen Attempting uninstall: sqlacodegen Found existing installation: sqlacodegen 2.3.0 Uninstalling sqlacodegen-2.3.0: Successfully uninstalled sqlacodegen-2.3.0 Successfully installed importlib-metadata-4.11.4 sqlacodegen-3.0.0b3 zipp-3.8.0 (venv) jgarcia@Javier-PC:/var/www$ sqlscodegen --version Command 'sqlscodegen' not found, did you mean: command 'sqlacodegen' from deb sqlacodegen (1.1.6-2build1) Try: sudo apt install (venv) jgarcia@Javier-PC:/var/www$ sqlacodegen --version 2.3.0 On Tue, Jun 14, 2022 at 5:25 PM Javier Garcia wrote: > Thanks Simon, do you know how could I install that version as when I > upgrade the sqlacodegen I still get the version 2.3.0? > > Javier > > El martes, 14 de junio de 2022 a las 17:21:31 UTC+1, Simon King escribió: > >> Based on the CHANGES file, it looks like --generator is a new option in >> v3.0.0: >> >> https://github.com/agronholm/sqlacodegen/blob/master/CHANGES.rst >> >> Simon >> >> On Tue, Jun 14, 2022 at 5:06 PM Javier Garcia wrote: >> >>> Hi, >>> >>> I have tried to run something like this: >>> >>> sqlacodegen --generator tables mysql+pymysql://user:password@localhost >>> /dbname >>> >>> but I get: >>> >>> usage: sqlacodegen [-h] [--version] [--schema SCHEMA] [--tables TABLES] >>> [--noviews] [--noindexes] [--noconstraints] [--nojoined] [--noinflect] >>> [--noclasses] [--nocomments] [--outfile OUTFILE] [url] >>> sqlacodegen: error: unrecognized arguments: --generator >>> mysql+pymysql://root:***@localhost/test_user >>> >>> My sqlacodegen version is 2.3.0. >>> >>> Any help? >>> >>> -- >>> 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+...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/sqlalchemy/6bea9449-3c19-491f-ace7-c17a8440a03an%40googlegroups.com >>> <https://groups.google.com/d/msgid/sqlalchemy/6bea9449-3c19-491f-ace7-c17a8440a03an%40googlegroups.com?utm_medium=email_source=footer> >>> . >>> >> -- > 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 view this
Re: [sqlalchemy] Just starting with sqlacodegen: wrong command?
Thanks Simon, do you know how could I install that version as when I upgrade the sqlacodegen I still get the version 2.3.0? Javier El martes, 14 de junio de 2022 a las 17:21:31 UTC+1, Simon King escribió: > Based on the CHANGES file, it looks like --generator is a new option in > v3.0.0: > > https://github.com/agronholm/sqlacodegen/blob/master/CHANGES.rst > > Simon > > On Tue, Jun 14, 2022 at 5:06 PM Javier Garcia wrote: > >> Hi, >> >> I have tried to run something like this: >> >> sqlacodegen --generator tables >> mysql+pymysql://user:password@localhost/dbname >> >> but I get: >> >> usage: sqlacodegen [-h] [--version] [--schema SCHEMA] [--tables TABLES] >> [--noviews] [--noindexes] [--noconstraints] [--nojoined] [--noinflect] >> [--noclasses] [--nocomments] [--outfile OUTFILE] [url] >> sqlacodegen: error: unrecognized arguments: --generator >> mysql+pymysql://root:***@localhost/test_user >> >> My sqlacodegen version is 2.3.0. >> >> Any help? >> >> -- >> 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+...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/sqlalchemy/6bea9449-3c19-491f-ace7-c17a8440a03an%40googlegroups.com >> >> <https://groups.google.com/d/msgid/sqlalchemy/6bea9449-3c19-491f-ace7-c17a8440a03an%40googlegroups.com?utm_medium=email_source=footer> >> . >> > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/203ea204-b6a2-4a04-84b4-d37eb509aaebn%40googlegroups.com.
[sqlalchemy] Just starting with sqlacodegen: wrong command?
Hi, I have tried to run something like this: sqlacodegen --generator tables mysql+pymysql://user:password@localhost/dbname but I get: usage: sqlacodegen [-h] [--version] [--schema SCHEMA] [--tables TABLES] [--noviews] [--noindexes] [--noconstraints] [--nojoined] [--noinflect] [--noclasses] [--nocomments] [--outfile OUTFILE] [url] sqlacodegen: error: unrecognized arguments: --generator mysql+pymysql://root:***@localhost/test_user My sqlacodegen version is 2.3.0. Any help? -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/6bea9449-3c19-491f-ace7-c17a8440a03an%40googlegroups.com.