I have a script that starts with
import pandas as pd
from sqlalchemy import create_engine, text
hana_engine = create_engine(os.getenv('RCF_HANA_URI'), echo=False)
hana_conn = hana_engine.connect()
postgres_engine = create_engine(os.getenv('RCF_POSTGRES_URI'), echo=False)
I need to run it on my m1 macbook. I tried using conda to create an environment with all the necessary dependencies
conda create --name env pandas sqlalchemy psycopg2
conda activate env
after python script.py I was missing sqlalchemy-hana but conda install sqlalchemy-hana and pip install sqlalchemy-hana failed because they couldn't find a package with that name with noarch or arm64 for python 3.9.
I tried other python versions
conda create --name env pandas sqlalchemy psycopg2 python=3.5
this failed for arm64 for python 3.5-3.7. 3.8 worked.
conda create --name env2 pandas sqlalchemy psycopg2 python=3.8
conda activate env2
now pip install sqlalchemy-hana worked. I ran the script again and got
ModuleNotFoundError: No module named 'hdbcli'
So I tried to install it
pip install hdbcli
ERROR: Could not find a version that satisfies the requirement hdbcli (from versions: none)
ERROR: No matching distribution found for hdbcli
And this is where I am stuck. Is there a way to get hdbcli to work on an m1 mac?