Mar-18-2021, 10:27 AM
You can use the csv package for CSV write, see: https://docs.python.org/3/library/csv.html
specifically: https://docs.python.org/3/library/csv.html#csv.writer
For SQL, you might want to consider using sqlalchemy: https://pypi.org/project/SQLAlchemy/
Once a model written, the sane code can be used with little or no change for any other DBMS.
queries are a snap.
There is a simple tutorial you can examine here: https://python-forum.io/Thread-SqlAlchem...-Data-Load
specifically: https://docs.python.org/3/library/csv.html#csv.writer
For SQL, you might want to consider using sqlalchemy: https://pypi.org/project/SQLAlchemy/
Once a model written, the sane code can be used with little or no change for any other DBMS.
queries are a snap.
There is a simple tutorial you can examine here: https://python-forum.io/Thread-SqlAlchem...-Data-Load
