search

thanethomson / MLAlchemy

Python library to convert YAML/JSON into SQLAlchemy SELECT queries
MIT License
42 stars 5 forks source link

Love this project, and wanted to ask about some things related... #2

Open jeremy-donson opened 6 years ago

jeremy-donson commented 6 years ago

Hello Sir!

What I like about this project is that it uses sqlalchemy as a means to stay dbms-agnostic.

What I was looking for instead was a tool to generate schemas (tables and relationships), and perhaps some random sample data, from a yaml file.

Note that php 👎 supports this through doctrine, http://doctrine.readthedocs.io/en/latest/en/manual/yaml-schema-files.html

And pypi has pyrseas https://pythonhosted.org/Pyrseas/ but this is only postgres specific.

I see no reason to avoid leveraging the power of sqlalchemy instead. Thoughts?

thanethomson commented 6 years ago

I originally wrote MLAlchemy to be a reusable component within Statik, which does pretty much what you're asking (and more), except that it uses SQLAlchemy with an in-memory SQLite database.

Perhaps with a bit of tweaking one could repurpose Statik to use any SQLAlchemy-supported backend? 😀