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 <tirengar...@gmail.com> 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 <deb name> > > (venv) jgarcia@Javier-PC:/var/www$ sqlacodegen --version > 2.3.0 > > On Tue, Jun 14, 2022 at 5:25 PM Javier Garcia <tirengar...@gmail.com> > 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 <tiren...@gmail.com> >>> 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&utm_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 >> <https://groups.google.com/d/msgid/sqlalchemy/203ea204-b6a2-4a04-84b4-d37eb509aaebn%40googlegroups.com?utm_medium=email&utm_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/CABtaONT50AL6-Xw1gO6wTmpXxPpZ_jYqVX0j5OGjFL5eo_8ZdQ%40mail.gmail.com > <https://groups.google.com/d/msgid/sqlalchemy/CABtaONT50AL6-Xw1gO6wTmpXxPpZ_jYqVX0j5OGjFL5eo_8ZdQ%40mail.gmail.com?utm_medium=email&utm_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/CAFHwexeu2wSXpMLet85RHa%3DT%2B4WfJWJUtLeRT6uG8x%2BsG%3DTHZg%40mail.gmail.com.