Issue Converting to MySQL

[lmarchesi]

New all sky user here. I'm setting up on my RPi 5 and want to use MySQL database. I think I have that setup properly (I can login as the all sky owner in MySQL and I can see the tables in the indi_allsky database). However when I run the conversion script I encounter this problem. Any ideas?

(indi-allsky) pi@raspberrysky:~/indi-allsky $ ./misc/convert_db.py
/home/pi/indi-allsky/./misc/convert_db.py:31: MovedIn20Warning: The ``declarative_base()`` function is now available as sqlalchemy.orm.declarative_base(). (deprecated since: 2.0) (Background on SQLAlchemy 2.0 at: https://sqlalche.me/e/b8d9)
  src_Base = declarative_base(SRC_ENGINE)
Traceback (most recent call last):
  File "/home/pi/indi-allsky/./misc/convert_db.py", line 31, in <module>
    src_Base = declarative_base(SRC_ENGINE)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in declarative_base
  File "/home/pi/indi-allsky/virtualenv/indi-allsky/lib/python3.11/site-packages/sqlalchemy/util/deprecations.py", line 386, in warned
    return fn(*args, **kwargs)  # type: ignore[no-any-return]
           ^^^^^^^^^^^^^^^^^^^
  File "/home/pi/indi-allsky/virtualenv/indi-allsky/lib/python3.11/site-packages/sqlalchemy/ext/declarative/__init__.py", line 27, in declarative_base
    return _declarative_base(*arg, **kw)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
TypeError: declarative_base() takes 0 positional arguments but 1 was given

[aaronwmorris]

I am trying to figure out how to convert this to sqlalchemy 2.0

[aaronwmorris]

Merged #1385 to update the syntax to SQLAlchemy 2.0. I needed to do an update to this script with some additional tables to be migrated anyway.

[aaronwmorris]

Note, you will need to drop the mysql database you created and recreate. Make sure you delete the new migrations before initializing the database with flask.

rm /var/lib/indi-allsky/migrations_mysql/versions/*.py

[lmarchesi]

Wow thanks for the quick turnaround! Seems to be working now 👍