meerschaum.utils.packages._packages

Directory of necessary packages

packages dictionary is structured in the following schema: { : { : } }

  1#! /usr/bin/env python
  2# -*- coding: utf-8 -*-
  3# vim:fenc=utf-8
  4
  5"""
  6Directory of necessary packages
  7
  8packages dictionary is structured in the following schema:
  9    {
 10        <group> : {
 11            <import_name> : <install_name>
 12        }
 13    }
 14"""
 15
 16from typing import Dict, List
 17
 18_MRSM_PACKAGE_ARCHIVES_PREFIX: str = "https://meerschaum.io/files/archives/wheels/"
 19
 20packages: Dict[str, Dict[str, str]] = {
 21    ### Meerschaum installs its own dependencies into the `mrsm` venv at runtime,
 22    ### so the base package requires nothing.
 23    'required': {},
 24    'minimal': {},
 25    'formatting': {
 26        'pprintpp'                   : 'pprintpp>=0.4.0',
 27        'asciitree'                  : 'asciitree>=0.3.3',
 28        'typing_extensions'          : 'typing-extensions>=4.7.1',
 29        'pygments'                   : 'pygments>=2.7.2',
 30        'colorama'                   : 'colorama>=0.4.3',
 31        'rich'                       : 'rich>=13.4.2',
 32        'more_termcolor'             : 'more-termcolor>=1.1.3',
 33        'humanfriendly'              : 'humanfriendly>=10.0.0',
 34        'tabulate'                   : 'tabulate>=0.9.0',
 35    },
 36    'core': {
 37        'wheel'                      : 'wheel>=0.34.2',
 38        'setuptools'                 : 'setuptools>=63.3.0',
 39        'yaml'                       : 'PyYAML>=5.3.1',
 40        'pip'                        : 'pip>=22.0.4',
 41        'update_checker'             : 'update-checker>=0.18.0',
 42        'semver'                     : 'semver>=3.0.2',
 43        'pathspec'                   : 'pathspec>=0.9.0',
 44        'dateutil'                   : 'python-dateutil>=2.7.5',
 45        'requests'                   : 'requests>=2.32.5',
 46        'certifi'                    : 'certifi>=2024.8.30',
 47        'idna'                       : 'idna>=3.10.0',
 48        'binaryornot'                : 'binaryornot>=0.4.4',
 49        'pyvim'                      : 'pyvim>=3.0.2',
 50        'ptpython'                   : 'ptpython>=3.0.27',
 51        'aiofiles'                   : 'aiofiles>=0.6.0',
 52        'packaging'                  : 'packaging>=21.3.0',
 53        'prompt_toolkit'             : 'prompt-toolkit>=3.0.39',
 54        'more_itertools'             : 'more-itertools>=8.7.0',
 55        'virtualenv'                 : 'virtualenv>=20.1.0',
 56        'attrs'                      : 'attrs>=24.2.0',
 57        'uv'                         : 'uv>=0.2.11',
 58        'pydantic'                   : 'pydantic>=2.11.7',
 59        'annotated-types'            : 'annotated-types>=0.7.0',
 60        'importlib_metadata'         : 'importlib-metadata>=4.12.0',
 61    },
 62    '_internal'                      : {
 63        'dataclass_wizard'           : 'dataclass-wizard>=0.35.0',
 64    },
 65    'jobs': {
 66        'dill'                       : 'dill>=0.4.0',
 67        'daemon'                     : 'python-daemon>=3.1.2',
 68        'watchfiles'                 : 'watchfiles>=1.1.0',
 69        'psutil'                     : 'psutil>=7.0.0',
 70    },
 71    'drivers': {
 72        'cryptography'               : 'cryptography>=38.0.1',
 73        'psycopg'                    : 'psycopg[binary]>=3.2.9',
 74        'psycopg2'                   : 'psycopg2-binary>=2.9.11',
 75        'pymysql'                    : 'PyMySQL>=0.9.0',
 76        'aiomysql'                   : 'aiomysql>=0.0.21',
 77        'sqlalchemy_cockroachdb'     : 'sqlalchemy-cockroachdb>=2.0.0',
 78        'duckdb'                     : 'duckdb>=1.5.6',
 79        'duckdb_engine'              : 'duckdb-engine>=0.17.0',
 80    },
 81    'drivers-extras': {
 82        'pyodbc'                     : 'pyodbc>=4.0.30',
 83        'oracledb'                   : 'oracledb>=2.5.0',
 84        'adbc_driver_postgresql'     : 'adbc-driver-postgresql>=1.7.0',
 85        'adbc_driver_sqlite'         : 'adbc-driver-sqlite>=1.7.0',
 86    },
 87    'cli': {
 88        'pgcli'                      : 'pgcli>=3.1.0',
 89        'mycli'                      : 'mycli>=1.23.2',
 90        'litecli'                    : 'litecli>=1.5.0',
 91        'mssqlcli'                   : 'mssql-cli>=1.0.0',
 92        'gadwall'                    : 'gadwall>=0.2.0',
 93    },
 94    'gis'                            : {
 95        'pyproj'                     : 'pyproj>=3.7.1',
 96        'geopandas'                  : 'geopandas>=1.0.1', 
 97        'shapely'                    : 'shapely>=2.0.7',
 98        'geoarrow'                   : 'geoarrow-types>=0.3.0',
 99    },
100    'stack': {
101        'compose'                    : 'docker-compose>=1.29.2',
102    },
103    'compose': {
104        'envyaml'                    : 'envyaml>=1.10.211231',
105    },
106    'build': {
107        'cx_Freeze'                  : 'cx_Freeze>=7.0.0',
108        'PyInstaller'                : 'pyinstaller>6.6.0',
109    },
110    'dev-tools': {
111        'twine'                      : 'twine>=3.2.0',
112        'tuna'                       : 'tuna>=0.5.3',
113        'snakeviz'                   : 'snakeviz>=2.1.0',
114        'mypy'                       : 'mypy>=0.812.0',
115        'pytest'                     : 'pytest>=6.2.2',
116        'pytest_xdist'               : 'pytest-xdist>=3.2.1',
117        'heartrate'                  : 'heartrate>=0.2.1',
118        'build'                      : 'build>=1.2.1',
119        'attrs'                      : 'attrs>=24.2.0',
120    },
121    'setup': {
122    },
123    'docs': {
124        'zensical'                   : 'zensical>=0.0.30',
125    },
126    'gui': {
127        'webview'                    : 'pywebview>=3.6.3',
128        'pycparser'                  : 'pycparser>=2.21.0',
129    },
130    'extras': {
131        'cmd2'                       : 'cmd2>=1.4.0',
132        'ruamel.yaml'                : 'ruamel.yaml>=0.16.12',
133        'modin'                      : 'modin[ray]>=0.8.3',
134        'nanoid'                     : 'nanoid>=2.0.0',
135    },
136}
137packages['sql'] = {
138    'numpy'                          : 'numpy>=2.3.1',
139    'pandas'                         : 'pandas[parquet]>=3.0.0',
140    'pyarrow'                        : 'pyarrow>=20.0.0',
141    'polars'                         : 'polars>=1.43.2',
142    'dask'                           : 'dask[complete]>=2024.12.1',
143    'partd'                          : 'partd>=1.4.2',
144    'pytz'                           : 'pytz',
145    'joblib'                         : 'joblib>=1.5.1',
146    'sqlalchemy'                     : 'SQLAlchemy>=2.0.41',
147    'geoalchemy2'                    : 'GeoAlchemy2>=0.18.0',
148    'databases'                      : 'databases>=0.9.0',
149    'aiosqlite'                      : 'aiosqlite>=0.21.0',
150    'asyncpg'                        : 'asyncpg>=0.30.0',
151}
152packages['sql'].update(packages['drivers'])
153packages['sql'].update(packages['core'])
154packages['sql'].update(packages['gis'])
155packages['polars'] = {
156    'polars'                         : packages['sql']['polars'],
157    'pandas'                         : packages['sql']['pandas'],
158    'pyarrow'                        : packages['sql']['pyarrow'],
159    'geoarrow'                       : packages['gis']['geoarrow'],
160}
161### The web console (Plotly Dash, served by the API host; design D21). `dash_daq`, `flask_compress`,
162### `terminado` and `tornado` (v4's console) are not used any more: the terminal is the Rust server's.
163packages['dash'] = {
164    'dash'                           : 'dash>=4.1.0',
165    'pygments'                       : 'pygments>=2.21.0',
166    'dash_bootstrap_components'      : 'dash-bootstrap-components>=2.0.4',
167    'dash_ace'                       : 'dash-ace>=0.2.1',
168    'dash_extensions'                : 'dash-extensions>=2.0.5',
169    'a2wsgi'                         : 'a2wsgi>=1.10.0',
170}
171packages['api'] = {
172    'uvicorn'                        : 'uvicorn[standard]>=0.35.0',
173    'gunicorn'                       : 'gunicorn>=23.0.0',
174    'dotenv'                         : 'python-dotenv>=1.1.1',
175    'websockets'                     : 'websockets>=15.0.1',
176    'fastapi'                        : 'fastapi>=0.128.0',
177    'fastapi_login'                  : 'fastapi-login>=1.10.3',
178    'multipart'                      : 'python-multipart>=0.0.20',
179    'httpx'                          : 'httpx>=0.28.1',
180    'httpcore'                       : 'httpcore>=1.0.9',
181    'valkey'                         : 'valkey>=6.1.0',
182    'jose'                           : 'python-jose>=3.5.0',
183}
184packages['api'].update(packages['sql'])
185packages['api'].update(packages['formatting'])
186packages['api'].update(packages['dash'])
187packages['api'].update(packages['jobs'])
188
189all_packages = {}
190for group, import_names in packages.items():
191    all_packages.update(import_names)
192install_names = {}
193def get_install_names():
194    """
195    Initialize the mapping between install names and import names.
196    """
197    if not install_names:
198        from meerschaum.utils.packages import get_install_no_version
199        for _import_name, _install_name in all_packages.items():
200            install_names[get_install_no_version(_install_name)] = _import_name
201    return install_names
202
203
204skip_groups = {
205    'docs',
206    'build',
207    'cli',
208    'dev-tools',
209    'portable',
210    'extras',
211    'stack',
212    'drivers-extras',
213    '_internal',
214}
215full = []
216_full = {}
217for group, import_names in packages.items():
218    ### omit 'cli' and 'docs' from 'full'
219    if group in skip_groups or group.startswith('_'):
220        continue
221    full += [ install_name for import_name, install_name in import_names.items() ]
222    for import_name, install_name in import_names.items():
223        _full[import_name] = install_name
224packages['full'] = _full
225
226### The v5 distribution extras (docs/design/v5.0.0.md ยง12.1, D20): `pip install meerschaum[<extra>]`.
227### This is the source for `[project.optional-dependencies]` in the root pyproject.toml;
228### `scripts/check_packaging.py` fails if the two drift apart. `{import_name: install_name}`.
229### The v4 groups above stay for the transitional Python code (`attempt_import`, `mrsm upgrade
230### packages <group>`, `mrsm show packages <group>`): the groups that share a name with an extra
231### (`sql`, `api`, `dash`, `polars`, `gui`, `full`) keep their v4 contents until that code moves
232### to Rust, while the new-only names (`pandas`, `geo`, `shell`, `cli-tools`, `sql-*`) are real
233### groups too.
234_extras_packages: Dict[str, Dict[str, str]] = {
235    'pandas': {
236        'pandas'                     : 'pandas>=3.0.0',
237        'pyarrow'                    : 'pyarrow>=20.0.0',
238    },
239    'polars': {
240        'polars'                     : 'polars>=1.43.2',
241    },
242    'geo': {
243        'shapely'                    : 'shapely>=2.0.7',
244        'pyproj'                     : 'pyproj>=3.7.1',
245        'geopandas'                  : 'geopandas>=1.0.1',
246        'geoarrow'                   : 'geoarrow-types>=0.3.0',
247    },
248    'sql': {
249        'sqlalchemy'                 : 'SQLAlchemy>=2.0.41',
250        'psycopg'                    : 'psycopg[binary]>=3.2.9',
251        'pymysql'                    : 'PyMySQL>=0.9.0',
252    },
253    'sql-mssql': {
254        'pyodbc'                     : 'pyodbc>=4.0.30',
255    },
256    'sql-oracle': {
257        'oracledb'                   : 'oracledb>=2.5.0',
258    },
259    'sql-duckdb': {
260        'duckdb'                     : 'duckdb>=1.5.6',
261        'duckdb_engine'              : 'duckdb-engine>=0.17.0',
262    },
263    'sql-cockroachdb': {
264        'sqlalchemy_cockroachdb'     : 'sqlalchemy-cockroachdb>=2.0.0',
265    },
266    'api': {
267        'fastapi'                    : 'fastapi>=0.128.0',
268        'uvicorn'                    : 'uvicorn>=0.35.0',
269        'a2wsgi'                     : 'a2wsgi>=1.10.0',
270        'multipart'                  : 'python-multipart>=0.0.20',
271        'jwt'                        : 'PyJWT>=2.15.0',
272        'websockets'                 : 'websockets>=15.0.1',
273    },
274    'dash': {
275        'dash'                       : 'dash>=4.1.0',
276        'pygments'                   : 'pygments>=2.21.0',
277        'a2wsgi'                     : 'a2wsgi>=1.10.0',
278        'dash_bootstrap_components'  : 'dash-bootstrap-components>=2.0.4',
279        'dash_ace'                   : 'dash-ace>=0.2.1',
280        ### The console builds its app with `dash_extensions.enrich.DashProxy` (`Trigger` and
281        ### duplicate outputs, which plugins written for v4's console use).
282        'dash_extensions'            : 'dash-extensions>=2.0.5',
283    },
284    'shell': {
285        'ptpython'                   : 'ptpython>=3.0.27',
286    },
287    'cli-tools': {
288        'pgcli'                      : 'pgcli>=3.1.0',
289        'mycli'                      : 'mycli>=1.23.2',
290        'litecli'                    : 'litecli>=1.5.0',
291        'gadwall'                    : 'gadwall>=0.2.0',
292    },
293    'gui': {
294        'webview'                    : 'pywebview>=3.6.3',
295    },
296}
297### `[full]` is the union of these extras (`cli-tools` and `gui` are excluded, as in v4).
298_full_extras = ('pandas', 'polars', 'geo', 'sql', 'api', 'dash', 'shell')
299
300### Make the new-only groups available to `show/upgrade packages` and the install-name lookup.
301for _group, _import_names in _extras_packages.items():
302    if _group not in packages:
303        packages[_group] = dict(_import_names)
304    for _import_name, _install_name in _import_names.items():
305        all_packages.setdefault(_import_name, _install_name)
306
307extras: Dict[str, List[str]] = {
308    group: list(dict.fromkeys(_import_names.values()))
309    for group, _import_names in _extras_packages.items()
310}
311### The console runs in the API host and shows pipe data as pandas frames, so `[dash]` brings the
312### `api` and `pandas` extras with it (`pip install meerschaum[dash]` is a working console).
313extras['dash'] = list(dict.fromkeys(extras['dash'] + extras['api'] + extras['pandas']))
314extras['full'] = list(dict.fromkeys(
315    install_name
316    for group in _full_extras
317    for install_name in extras[group]
318))
packages: Dict[str, Dict[str, str]] = {'required': {}, 'minimal': {}, 'formatting': {'pprintpp': 'pprintpp>=0.4.0', 'asciitree': 'asciitree>=0.3.3', 'typing_extensions': 'typing-extensions>=4.7.1', 'pygments': 'pygments>=2.7.2', 'colorama': 'colorama>=0.4.3', 'rich': 'rich>=13.4.2', 'more_termcolor': 'more-termcolor>=1.1.3', 'humanfriendly': 'humanfriendly>=10.0.0', 'tabulate': 'tabulate>=0.9.0'}, 'core': {'wheel': 'wheel>=0.34.2', 'setuptools': 'setuptools>=63.3.0', 'yaml': 'PyYAML>=5.3.1', 'pip': 'pip>=22.0.4', 'update_checker': 'update-checker>=0.18.0', 'semver': 'semver>=3.0.2', 'pathspec': 'pathspec>=0.9.0', 'dateutil': 'python-dateutil>=2.7.5', 'requests': 'requests>=2.32.5', 'certifi': 'certifi>=2024.8.30', 'idna': 'idna>=3.10.0', 'binaryornot': 'binaryornot>=0.4.4', 'pyvim': 'pyvim>=3.0.2', 'ptpython': 'ptpython>=3.0.27', 'aiofiles': 'aiofiles>=0.6.0', 'packaging': 'packaging>=21.3.0', 'prompt_toolkit': 'prompt-toolkit>=3.0.39', 'more_itertools': 'more-itertools>=8.7.0', 'virtualenv': 'virtualenv>=20.1.0', 'attrs': 'attrs>=24.2.0', 'uv': 'uv>=0.2.11', 'pydantic': 'pydantic>=2.11.7', 'annotated-types': 'annotated-types>=0.7.0', 'importlib_metadata': 'importlib-metadata>=4.12.0'}, '_internal': {'dataclass_wizard': 'dataclass-wizard>=0.35.0'}, 'jobs': {'dill': 'dill>=0.4.0', 'daemon': 'python-daemon>=3.1.2', 'watchfiles': 'watchfiles>=1.1.0', 'psutil': 'psutil>=7.0.0'}, 'drivers': {'cryptography': 'cryptography>=38.0.1', 'psycopg': 'psycopg[binary]>=3.2.9', 'psycopg2': 'psycopg2-binary>=2.9.11', 'pymysql': 'PyMySQL>=0.9.0', 'aiomysql': 'aiomysql>=0.0.21', 'sqlalchemy_cockroachdb': 'sqlalchemy-cockroachdb>=2.0.0', 'duckdb': 'duckdb>=1.5.6', 'duckdb_engine': 'duckdb-engine>=0.17.0'}, 'drivers-extras': {'pyodbc': 'pyodbc>=4.0.30', 'oracledb': 'oracledb>=2.5.0', 'adbc_driver_postgresql': 'adbc-driver-postgresql>=1.7.0', 'adbc_driver_sqlite': 'adbc-driver-sqlite>=1.7.0'}, 'cli': {'pgcli': 'pgcli>=3.1.0', 'mycli': 'mycli>=1.23.2', 'litecli': 'litecli>=1.5.0', 'mssqlcli': 'mssql-cli>=1.0.0', 'gadwall': 'gadwall>=0.2.0'}, 'gis': {'pyproj': 'pyproj>=3.7.1', 'geopandas': 'geopandas>=1.0.1', 'shapely': 'shapely>=2.0.7', 'geoarrow': 'geoarrow-types>=0.3.0'}, 'stack': {'compose': 'docker-compose>=1.29.2'}, 'compose': {'envyaml': 'envyaml>=1.10.211231'}, 'build': {'cx_Freeze': 'cx_Freeze>=7.0.0', 'PyInstaller': 'pyinstaller>6.6.0'}, 'dev-tools': {'twine': 'twine>=3.2.0', 'tuna': 'tuna>=0.5.3', 'snakeviz': 'snakeviz>=2.1.0', 'mypy': 'mypy>=0.812.0', 'pytest': 'pytest>=6.2.2', 'pytest_xdist': 'pytest-xdist>=3.2.1', 'heartrate': 'heartrate>=0.2.1', 'build': 'build>=1.2.1', 'attrs': 'attrs>=24.2.0'}, 'setup': {}, 'docs': {'zensical': 'zensical>=0.0.30'}, 'gui': {'webview': 'pywebview>=3.6.3', 'pycparser': 'pycparser>=2.21.0'}, 'extras': {'cmd2': 'cmd2>=1.4.0', 'ruamel.yaml': 'ruamel.yaml>=0.16.12', 'modin': 'modin[ray]>=0.8.3', 'nanoid': 'nanoid>=2.0.0'}, 'sql': {'numpy': 'numpy>=2.3.1', 'pandas': 'pandas[parquet]>=3.0.0', 'pyarrow': 'pyarrow>=20.0.0', 'polars': 'polars>=1.43.2', 'dask': 'dask[complete]>=2024.12.1', 'partd': 'partd>=1.4.2', 'pytz': 'pytz', 'joblib': 'joblib>=1.5.1', 'sqlalchemy': 'SQLAlchemy>=2.0.41', 'geoalchemy2': 'GeoAlchemy2>=0.18.0', 'databases': 'databases>=0.9.0', 'aiosqlite': 'aiosqlite>=0.21.0', 'asyncpg': 'asyncpg>=0.30.0', 'cryptography': 'cryptography>=38.0.1', 'psycopg': 'psycopg[binary]>=3.2.9', 'psycopg2': 'psycopg2-binary>=2.9.11', 'pymysql': 'PyMySQL>=0.9.0', 'aiomysql': 'aiomysql>=0.0.21', 'sqlalchemy_cockroachdb': 'sqlalchemy-cockroachdb>=2.0.0', 'duckdb': 'duckdb>=1.5.6', 'duckdb_engine': 'duckdb-engine>=0.17.0', 'wheel': 'wheel>=0.34.2', 'setuptools': 'setuptools>=63.3.0', 'yaml': 'PyYAML>=5.3.1', 'pip': 'pip>=22.0.4', 'update_checker': 'update-checker>=0.18.0', 'semver': 'semver>=3.0.2', 'pathspec': 'pathspec>=0.9.0', 'dateutil': 'python-dateutil>=2.7.5', 'requests': 'requests>=2.32.5', 'certifi': 'certifi>=2024.8.30', 'idna': 'idna>=3.10.0', 'binaryornot': 'binaryornot>=0.4.4', 'pyvim': 'pyvim>=3.0.2', 'ptpython': 'ptpython>=3.0.27', 'aiofiles': 'aiofiles>=0.6.0', 'packaging': 'packaging>=21.3.0', 'prompt_toolkit': 'prompt-toolkit>=3.0.39', 'more_itertools': 'more-itertools>=8.7.0', 'virtualenv': 'virtualenv>=20.1.0', 'attrs': 'attrs>=24.2.0', 'uv': 'uv>=0.2.11', 'pydantic': 'pydantic>=2.11.7', 'annotated-types': 'annotated-types>=0.7.0', 'importlib_metadata': 'importlib-metadata>=4.12.0', 'pyproj': 'pyproj>=3.7.1', 'geopandas': 'geopandas>=1.0.1', 'shapely': 'shapely>=2.0.7', 'geoarrow': 'geoarrow-types>=0.3.0'}, 'polars': {'polars': 'polars>=1.43.2', 'pandas': 'pandas[parquet]>=3.0.0', 'pyarrow': 'pyarrow>=20.0.0', 'geoarrow': 'geoarrow-types>=0.3.0'}, 'dash': {'dash': 'dash>=4.1.0', 'pygments': 'pygments>=2.21.0', 'dash_bootstrap_components': 'dash-bootstrap-components>=2.0.4', 'dash_ace': 'dash-ace>=0.2.1', 'dash_extensions': 'dash-extensions>=2.0.5', 'a2wsgi': 'a2wsgi>=1.10.0'}, 'api': {'uvicorn': 'uvicorn[standard]>=0.35.0', 'gunicorn': 'gunicorn>=23.0.0', 'dotenv': 'python-dotenv>=1.1.1', 'websockets': 'websockets>=15.0.1', 'fastapi': 'fastapi>=0.128.0', 'fastapi_login': 'fastapi-login>=1.10.3', 'multipart': 'python-multipart>=0.0.20', 'httpx': 'httpx>=0.28.1', 'httpcore': 'httpcore>=1.0.9', 'valkey': 'valkey>=6.1.0', 'jose': 'python-jose>=3.5.0', 'numpy': 'numpy>=2.3.1', 'pandas': 'pandas[parquet]>=3.0.0', 'pyarrow': 'pyarrow>=20.0.0', 'polars': 'polars>=1.43.2', 'dask': 'dask[complete]>=2024.12.1', 'partd': 'partd>=1.4.2', 'pytz': 'pytz', 'joblib': 'joblib>=1.5.1', 'sqlalchemy': 'SQLAlchemy>=2.0.41', 'geoalchemy2': 'GeoAlchemy2>=0.18.0', 'databases': 'databases>=0.9.0', 'aiosqlite': 'aiosqlite>=0.21.0', 'asyncpg': 'asyncpg>=0.30.0', 'cryptography': 'cryptography>=38.0.1', 'psycopg': 'psycopg[binary]>=3.2.9', 'psycopg2': 'psycopg2-binary>=2.9.11', 'pymysql': 'PyMySQL>=0.9.0', 'aiomysql': 'aiomysql>=0.0.21', 'sqlalchemy_cockroachdb': 'sqlalchemy-cockroachdb>=2.0.0', 'duckdb': 'duckdb>=1.5.6', 'duckdb_engine': 'duckdb-engine>=0.17.0', 'wheel': 'wheel>=0.34.2', 'setuptools': 'setuptools>=63.3.0', 'yaml': 'PyYAML>=5.3.1', 'pip': 'pip>=22.0.4', 'update_checker': 'update-checker>=0.18.0', 'semver': 'semver>=3.0.2', 'pathspec': 'pathspec>=0.9.0', 'dateutil': 'python-dateutil>=2.7.5', 'requests': 'requests>=2.32.5', 'certifi': 'certifi>=2024.8.30', 'idna': 'idna>=3.10.0', 'binaryornot': 'binaryornot>=0.4.4', 'pyvim': 'pyvim>=3.0.2', 'ptpython': 'ptpython>=3.0.27', 'aiofiles': 'aiofiles>=0.6.0', 'packaging': 'packaging>=21.3.0', 'prompt_toolkit': 'prompt-toolkit>=3.0.39', 'more_itertools': 'more-itertools>=8.7.0', 'virtualenv': 'virtualenv>=20.1.0', 'attrs': 'attrs>=24.2.0', 'uv': 'uv>=0.2.11', 'pydantic': 'pydantic>=2.11.7', 'annotated-types': 'annotated-types>=0.7.0', 'importlib_metadata': 'importlib-metadata>=4.12.0', 'pyproj': 'pyproj>=3.7.1', 'geopandas': 'geopandas>=1.0.1', 'shapely': 'shapely>=2.0.7', 'geoarrow': 'geoarrow-types>=0.3.0', 'pprintpp': 'pprintpp>=0.4.0', 'asciitree': 'asciitree>=0.3.3', 'typing_extensions': 'typing-extensions>=4.7.1', 'pygments': 'pygments>=2.21.0', 'colorama': 'colorama>=0.4.3', 'rich': 'rich>=13.4.2', 'more_termcolor': 'more-termcolor>=1.1.3', 'humanfriendly': 'humanfriendly>=10.0.0', 'tabulate': 'tabulate>=0.9.0', 'dash': 'dash>=4.1.0', 'dash_bootstrap_components': 'dash-bootstrap-components>=2.0.4', 'dash_ace': 'dash-ace>=0.2.1', 'dash_extensions': 'dash-extensions>=2.0.5', 'a2wsgi': 'a2wsgi>=1.10.0', 'dill': 'dill>=0.4.0', 'daemon': 'python-daemon>=3.1.2', 'watchfiles': 'watchfiles>=1.1.0', 'psutil': 'psutil>=7.0.0'}, 'full': {'pprintpp': 'pprintpp>=0.4.0', 'asciitree': 'asciitree>=0.3.3', 'typing_extensions': 'typing-extensions>=4.7.1', 'pygments': 'pygments>=2.21.0', 'colorama': 'colorama>=0.4.3', 'rich': 'rich>=13.4.2', 'more_termcolor': 'more-termcolor>=1.1.3', 'humanfriendly': 'humanfriendly>=10.0.0', 'tabulate': 'tabulate>=0.9.0', 'wheel': 'wheel>=0.34.2', 'setuptools': 'setuptools>=63.3.0', 'yaml': 'PyYAML>=5.3.1', 'pip': 'pip>=22.0.4', 'update_checker': 'update-checker>=0.18.0', 'semver': 'semver>=3.0.2', 'pathspec': 'pathspec>=0.9.0', 'dateutil': 'python-dateutil>=2.7.5', 'requests': 'requests>=2.32.5', 'certifi': 'certifi>=2024.8.30', 'idna': 'idna>=3.10.0', 'binaryornot': 'binaryornot>=0.4.4', 'pyvim': 'pyvim>=3.0.2', 'ptpython': 'ptpython>=3.0.27', 'aiofiles': 'aiofiles>=0.6.0', 'packaging': 'packaging>=21.3.0', 'prompt_toolkit': 'prompt-toolkit>=3.0.39', 'more_itertools': 'more-itertools>=8.7.0', 'virtualenv': 'virtualenv>=20.1.0', 'attrs': 'attrs>=24.2.0', 'uv': 'uv>=0.2.11', 'pydantic': 'pydantic>=2.11.7', 'annotated-types': 'annotated-types>=0.7.0', 'importlib_metadata': 'importlib-metadata>=4.12.0', 'dill': 'dill>=0.4.0', 'daemon': 'python-daemon>=3.1.2', 'watchfiles': 'watchfiles>=1.1.0', 'psutil': 'psutil>=7.0.0', 'cryptography': 'cryptography>=38.0.1', 'psycopg': 'psycopg[binary]>=3.2.9', 'psycopg2': 'psycopg2-binary>=2.9.11', 'pymysql': 'PyMySQL>=0.9.0', 'aiomysql': 'aiomysql>=0.0.21', 'sqlalchemy_cockroachdb': 'sqlalchemy-cockroachdb>=2.0.0', 'duckdb': 'duckdb>=1.5.6', 'duckdb_engine': 'duckdb-engine>=0.17.0', 'pyproj': 'pyproj>=3.7.1', 'geopandas': 'geopandas>=1.0.1', 'shapely': 'shapely>=2.0.7', 'geoarrow': 'geoarrow-types>=0.3.0', 'envyaml': 'envyaml>=1.10.211231', 'webview': 'pywebview>=3.6.3', 'pycparser': 'pycparser>=2.21.0', 'numpy': 'numpy>=2.3.1', 'pandas': 'pandas[parquet]>=3.0.0', 'pyarrow': 'pyarrow>=20.0.0', 'polars': 'polars>=1.43.2', 'dask': 'dask[complete]>=2024.12.1', 'partd': 'partd>=1.4.2', 'pytz': 'pytz', 'joblib': 'joblib>=1.5.1', 'sqlalchemy': 'SQLAlchemy>=2.0.41', 'geoalchemy2': 'GeoAlchemy2>=0.18.0', 'databases': 'databases>=0.9.0', 'aiosqlite': 'aiosqlite>=0.21.0', 'asyncpg': 'asyncpg>=0.30.0', 'dash': 'dash>=4.1.0', 'dash_bootstrap_components': 'dash-bootstrap-components>=2.0.4', 'dash_ace': 'dash-ace>=0.2.1', 'dash_extensions': 'dash-extensions>=2.0.5', 'a2wsgi': 'a2wsgi>=1.10.0', 'uvicorn': 'uvicorn[standard]>=0.35.0', 'gunicorn': 'gunicorn>=23.0.0', 'dotenv': 'python-dotenv>=1.1.1', 'websockets': 'websockets>=15.0.1', 'fastapi': 'fastapi>=0.128.0', 'fastapi_login': 'fastapi-login>=1.10.3', 'multipart': 'python-multipart>=0.0.20', 'httpx': 'httpx>=0.28.1', 'httpcore': 'httpcore>=1.0.9', 'valkey': 'valkey>=6.1.0', 'jose': 'python-jose>=3.5.0'}, 'pandas': {'pandas': 'pandas>=3.0.0', 'pyarrow': 'pyarrow>=20.0.0'}, 'geo': {'shapely': 'shapely>=2.0.7', 'pyproj': 'pyproj>=3.7.1', 'geopandas': 'geopandas>=1.0.1', 'geoarrow': 'geoarrow-types>=0.3.0'}, 'sql-mssql': {'pyodbc': 'pyodbc>=4.0.30'}, 'sql-oracle': {'oracledb': 'oracledb>=2.5.0'}, 'sql-duckdb': {'duckdb': 'duckdb>=1.5.6', 'duckdb_engine': 'duckdb-engine>=0.17.0'}, 'sql-cockroachdb': {'sqlalchemy_cockroachdb': 'sqlalchemy-cockroachdb>=2.0.0'}, 'shell': {'ptpython': 'ptpython>=3.0.27'}, 'cli-tools': {'pgcli': 'pgcli>=3.1.0', 'mycli': 'mycli>=1.23.2', 'litecli': 'litecli>=1.5.0', 'gadwall': 'gadwall>=0.2.0'}}
all_packages = {'pprintpp': 'pprintpp>=0.4.0', 'asciitree': 'asciitree>=0.3.3', 'typing_extensions': 'typing-extensions>=4.7.1', 'pygments': 'pygments>=2.21.0', 'colorama': 'colorama>=0.4.3', 'rich': 'rich>=13.4.2', 'more_termcolor': 'more-termcolor>=1.1.3', 'humanfriendly': 'humanfriendly>=10.0.0', 'tabulate': 'tabulate>=0.9.0', 'wheel': 'wheel>=0.34.2', 'setuptools': 'setuptools>=63.3.0', 'yaml': 'PyYAML>=5.3.1', 'pip': 'pip>=22.0.4', 'update_checker': 'update-checker>=0.18.0', 'semver': 'semver>=3.0.2', 'pathspec': 'pathspec>=0.9.0', 'dateutil': 'python-dateutil>=2.7.5', 'requests': 'requests>=2.32.5', 'certifi': 'certifi>=2024.8.30', 'idna': 'idna>=3.10.0', 'binaryornot': 'binaryornot>=0.4.4', 'pyvim': 'pyvim>=3.0.2', 'ptpython': 'ptpython>=3.0.27', 'aiofiles': 'aiofiles>=0.6.0', 'packaging': 'packaging>=21.3.0', 'prompt_toolkit': 'prompt-toolkit>=3.0.39', 'more_itertools': 'more-itertools>=8.7.0', 'virtualenv': 'virtualenv>=20.1.0', 'attrs': 'attrs>=24.2.0', 'uv': 'uv>=0.2.11', 'pydantic': 'pydantic>=2.11.7', 'annotated-types': 'annotated-types>=0.7.0', 'importlib_metadata': 'importlib-metadata>=4.12.0', 'dataclass_wizard': 'dataclass-wizard>=0.35.0', 'dill': 'dill>=0.4.0', 'daemon': 'python-daemon>=3.1.2', 'watchfiles': 'watchfiles>=1.1.0', 'psutil': 'psutil>=7.0.0', 'cryptography': 'cryptography>=38.0.1', 'psycopg': 'psycopg[binary]>=3.2.9', 'psycopg2': 'psycopg2-binary>=2.9.11', 'pymysql': 'PyMySQL>=0.9.0', 'aiomysql': 'aiomysql>=0.0.21', 'sqlalchemy_cockroachdb': 'sqlalchemy-cockroachdb>=2.0.0', 'duckdb': 'duckdb>=1.5.6', 'duckdb_engine': 'duckdb-engine>=0.17.0', 'pyodbc': 'pyodbc>=4.0.30', 'oracledb': 'oracledb>=2.5.0', 'adbc_driver_postgresql': 'adbc-driver-postgresql>=1.7.0', 'adbc_driver_sqlite': 'adbc-driver-sqlite>=1.7.0', 'pgcli': 'pgcli>=3.1.0', 'mycli': 'mycli>=1.23.2', 'litecli': 'litecli>=1.5.0', 'mssqlcli': 'mssql-cli>=1.0.0', 'gadwall': 'gadwall>=0.2.0', 'pyproj': 'pyproj>=3.7.1', 'geopandas': 'geopandas>=1.0.1', 'shapely': 'shapely>=2.0.7', 'geoarrow': 'geoarrow-types>=0.3.0', 'compose': 'docker-compose>=1.29.2', 'envyaml': 'envyaml>=1.10.211231', 'cx_Freeze': 'cx_Freeze>=7.0.0', 'PyInstaller': 'pyinstaller>6.6.0', 'twine': 'twine>=3.2.0', 'tuna': 'tuna>=0.5.3', 'snakeviz': 'snakeviz>=2.1.0', 'mypy': 'mypy>=0.812.0', 'pytest': 'pytest>=6.2.2', 'pytest_xdist': 'pytest-xdist>=3.2.1', 'heartrate': 'heartrate>=0.2.1', 'build': 'build>=1.2.1', 'zensical': 'zensical>=0.0.30', 'webview': 'pywebview>=3.6.3', 'pycparser': 'pycparser>=2.21.0', 'cmd2': 'cmd2>=1.4.0', 'ruamel.yaml': 'ruamel.yaml>=0.16.12', 'modin': 'modin[ray]>=0.8.3', 'nanoid': 'nanoid>=2.0.0', 'numpy': 'numpy>=2.3.1', 'pandas': 'pandas[parquet]>=3.0.0', 'pyarrow': 'pyarrow>=20.0.0', 'polars': 'polars>=1.43.2', 'dask': 'dask[complete]>=2024.12.1', 'partd': 'partd>=1.4.2', 'pytz': 'pytz', 'joblib': 'joblib>=1.5.1', 'sqlalchemy': 'SQLAlchemy>=2.0.41', 'geoalchemy2': 'GeoAlchemy2>=0.18.0', 'databases': 'databases>=0.9.0', 'aiosqlite': 'aiosqlite>=0.21.0', 'asyncpg': 'asyncpg>=0.30.0', 'dash': 'dash>=4.1.0', 'dash_bootstrap_components': 'dash-bootstrap-components>=2.0.4', 'dash_ace': 'dash-ace>=0.2.1', 'dash_extensions': 'dash-extensions>=2.0.5', 'a2wsgi': 'a2wsgi>=1.10.0', 'uvicorn': 'uvicorn[standard]>=0.35.0', 'gunicorn': 'gunicorn>=23.0.0', 'dotenv': 'python-dotenv>=1.1.1', 'websockets': 'websockets>=15.0.1', 'fastapi': 'fastapi>=0.128.0', 'fastapi_login': 'fastapi-login>=1.10.3', 'multipart': 'python-multipart>=0.0.20', 'httpx': 'httpx>=0.28.1', 'httpcore': 'httpcore>=1.0.9', 'valkey': 'valkey>=6.1.0', 'jose': 'python-jose>=3.5.0', 'jwt': 'PyJWT>=2.15.0'}
install_names = {}
def get_install_names():
194def get_install_names():
195    """
196    Initialize the mapping between install names and import names.
197    """
198    if not install_names:
199        from meerschaum.utils.packages import get_install_no_version
200        for _import_name, _install_name in all_packages.items():
201            install_names[get_install_no_version(_install_name)] = _import_name
202    return install_names

Initialize the mapping between install names and import names.

skip_groups = {'build', '_internal', 'docs', 'cli', 'dev-tools', 'stack', 'drivers-extras', 'extras', 'portable'}
full = ['pprintpp>=0.4.0', 'asciitree>=0.3.3', 'typing-extensions>=4.7.1', 'pygments>=2.7.2', 'colorama>=0.4.3', 'rich>=13.4.2', 'more-termcolor>=1.1.3', 'humanfriendly>=10.0.0', 'tabulate>=0.9.0', 'wheel>=0.34.2', 'setuptools>=63.3.0', 'PyYAML>=5.3.1', 'pip>=22.0.4', 'update-checker>=0.18.0', 'semver>=3.0.2', 'pathspec>=0.9.0', 'python-dateutil>=2.7.5', 'requests>=2.32.5', 'certifi>=2024.8.30', 'idna>=3.10.0', 'binaryornot>=0.4.4', 'pyvim>=3.0.2', 'ptpython>=3.0.27', 'aiofiles>=0.6.0', 'packaging>=21.3.0', 'prompt-toolkit>=3.0.39', 'more-itertools>=8.7.0', 'virtualenv>=20.1.0', 'attrs>=24.2.0', 'uv>=0.2.11', 'pydantic>=2.11.7', 'annotated-types>=0.7.0', 'importlib-metadata>=4.12.0', 'dill>=0.4.0', 'python-daemon>=3.1.2', 'watchfiles>=1.1.0', 'psutil>=7.0.0', 'cryptography>=38.0.1', 'psycopg[binary]>=3.2.9', 'psycopg2-binary>=2.9.11', 'PyMySQL>=0.9.0', 'aiomysql>=0.0.21', 'sqlalchemy-cockroachdb>=2.0.0', 'duckdb>=1.5.6', 'duckdb-engine>=0.17.0', 'pyproj>=3.7.1', 'geopandas>=1.0.1', 'shapely>=2.0.7', 'geoarrow-types>=0.3.0', 'envyaml>=1.10.211231', 'pywebview>=3.6.3', 'pycparser>=2.21.0', 'numpy>=2.3.1', 'pandas[parquet]>=3.0.0', 'pyarrow>=20.0.0', 'polars>=1.43.2', 'dask[complete]>=2024.12.1', 'partd>=1.4.2', 'pytz', 'joblib>=1.5.1', 'SQLAlchemy>=2.0.41', 'GeoAlchemy2>=0.18.0', 'databases>=0.9.0', 'aiosqlite>=0.21.0', 'asyncpg>=0.30.0', 'cryptography>=38.0.1', 'psycopg[binary]>=3.2.9', 'psycopg2-binary>=2.9.11', 'PyMySQL>=0.9.0', 'aiomysql>=0.0.21', 'sqlalchemy-cockroachdb>=2.0.0', 'duckdb>=1.5.6', 'duckdb-engine>=0.17.0', 'wheel>=0.34.2', 'setuptools>=63.3.0', 'PyYAML>=5.3.1', 'pip>=22.0.4', 'update-checker>=0.18.0', 'semver>=3.0.2', 'pathspec>=0.9.0', 'python-dateutil>=2.7.5', 'requests>=2.32.5', 'certifi>=2024.8.30', 'idna>=3.10.0', 'binaryornot>=0.4.4', 'pyvim>=3.0.2', 'ptpython>=3.0.27', 'aiofiles>=0.6.0', 'packaging>=21.3.0', 'prompt-toolkit>=3.0.39', 'more-itertools>=8.7.0', 'virtualenv>=20.1.0', 'attrs>=24.2.0', 'uv>=0.2.11', 'pydantic>=2.11.7', 'annotated-types>=0.7.0', 'importlib-metadata>=4.12.0', 'pyproj>=3.7.1', 'geopandas>=1.0.1', 'shapely>=2.0.7', 'geoarrow-types>=0.3.0', 'polars>=1.43.2', 'pandas[parquet]>=3.0.0', 'pyarrow>=20.0.0', 'geoarrow-types>=0.3.0', 'dash>=4.1.0', 'pygments>=2.21.0', 'dash-bootstrap-components>=2.0.4', 'dash-ace>=0.2.1', 'dash-extensions>=2.0.5', 'a2wsgi>=1.10.0', 'uvicorn[standard]>=0.35.0', 'gunicorn>=23.0.0', 'python-dotenv>=1.1.1', 'websockets>=15.0.1', 'fastapi>=0.128.0', 'fastapi-login>=1.10.3', 'python-multipart>=0.0.20', 'httpx>=0.28.1', 'httpcore>=1.0.9', 'valkey>=6.1.0', 'python-jose>=3.5.0', 'numpy>=2.3.1', 'pandas[parquet]>=3.0.0', 'pyarrow>=20.0.0', 'polars>=1.43.2', 'dask[complete]>=2024.12.1', 'partd>=1.4.2', 'pytz', 'joblib>=1.5.1', 'SQLAlchemy>=2.0.41', 'GeoAlchemy2>=0.18.0', 'databases>=0.9.0', 'aiosqlite>=0.21.0', 'asyncpg>=0.30.0', 'cryptography>=38.0.1', 'psycopg[binary]>=3.2.9', 'psycopg2-binary>=2.9.11', 'PyMySQL>=0.9.0', 'aiomysql>=0.0.21', 'sqlalchemy-cockroachdb>=2.0.0', 'duckdb>=1.5.6', 'duckdb-engine>=0.17.0', 'wheel>=0.34.2', 'setuptools>=63.3.0', 'PyYAML>=5.3.1', 'pip>=22.0.4', 'update-checker>=0.18.0', 'semver>=3.0.2', 'pathspec>=0.9.0', 'python-dateutil>=2.7.5', 'requests>=2.32.5', 'certifi>=2024.8.30', 'idna>=3.10.0', 'binaryornot>=0.4.4', 'pyvim>=3.0.2', 'ptpython>=3.0.27', 'aiofiles>=0.6.0', 'packaging>=21.3.0', 'prompt-toolkit>=3.0.39', 'more-itertools>=8.7.0', 'virtualenv>=20.1.0', 'attrs>=24.2.0', 'uv>=0.2.11', 'pydantic>=2.11.7', 'annotated-types>=0.7.0', 'importlib-metadata>=4.12.0', 'pyproj>=3.7.1', 'geopandas>=1.0.1', 'shapely>=2.0.7', 'geoarrow-types>=0.3.0', 'pprintpp>=0.4.0', 'asciitree>=0.3.3', 'typing-extensions>=4.7.1', 'pygments>=2.21.0', 'colorama>=0.4.3', 'rich>=13.4.2', 'more-termcolor>=1.1.3', 'humanfriendly>=10.0.0', 'tabulate>=0.9.0', 'dash>=4.1.0', 'dash-bootstrap-components>=2.0.4', 'dash-ace>=0.2.1', 'dash-extensions>=2.0.5', 'a2wsgi>=1.10.0', 'dill>=0.4.0', 'python-daemon>=3.1.2', 'watchfiles>=1.1.0', 'psutil>=7.0.0']
extras: Dict[str, List[str]] = {'pandas': ['pandas>=3.0.0', 'pyarrow>=20.0.0'], 'polars': ['polars>=1.43.2'], 'geo': ['shapely>=2.0.7', 'pyproj>=3.7.1', 'geopandas>=1.0.1', 'geoarrow-types>=0.3.0'], 'sql': ['SQLAlchemy>=2.0.41', 'psycopg[binary]>=3.2.9', 'PyMySQL>=0.9.0'], 'sql-mssql': ['pyodbc>=4.0.30'], 'sql-oracle': ['oracledb>=2.5.0'], 'sql-duckdb': ['duckdb>=1.5.6', 'duckdb-engine>=0.17.0'], 'sql-cockroachdb': ['sqlalchemy-cockroachdb>=2.0.0'], 'api': ['fastapi>=0.128.0', 'uvicorn>=0.35.0', 'a2wsgi>=1.10.0', 'python-multipart>=0.0.20', 'PyJWT>=2.15.0', 'websockets>=15.0.1'], 'dash': ['dash>=4.1.0', 'pygments>=2.21.0', 'a2wsgi>=1.10.0', 'dash-bootstrap-components>=2.0.4', 'dash-ace>=0.2.1', 'dash-extensions>=2.0.5', 'fastapi>=0.128.0', 'uvicorn>=0.35.0', 'python-multipart>=0.0.20', 'PyJWT>=2.15.0', 'websockets>=15.0.1', 'pandas>=3.0.0', 'pyarrow>=20.0.0'], 'shell': ['ptpython>=3.0.27'], 'cli-tools': ['pgcli>=3.1.0', 'mycli>=1.23.2', 'litecli>=1.5.0', 'gadwall>=0.2.0'], 'gui': ['pywebview>=3.6.3'], 'full': ['pandas>=3.0.0', 'pyarrow>=20.0.0', 'polars>=1.43.2', 'shapely>=2.0.7', 'pyproj>=3.7.1', 'geopandas>=1.0.1', 'geoarrow-types>=0.3.0', 'SQLAlchemy>=2.0.41', 'psycopg[binary]>=3.2.9', 'PyMySQL>=0.9.0', 'fastapi>=0.128.0', 'uvicorn>=0.35.0', 'a2wsgi>=1.10.0', 'python-multipart>=0.0.20', 'PyJWT>=2.15.0', 'websockets>=15.0.1', 'dash>=4.1.0', 'pygments>=2.21.0', 'dash-bootstrap-components>=2.0.4', 'dash-ace>=0.2.1', 'dash-extensions>=2.0.5', 'ptpython>=3.0.27']}