sql2nosql
Migrate data from SQL to NoSQL easily.
Installation ?
pip install sql2nosql --upgrade
Dependencies ?
For the package to work, it first needs "clients", which are other packages that are in charge of managing the data in the database. Most of them work very similar, as in the case of 'mysql-connector' and 'pymysql' for MySQL databases, and 'PyMongo' for MongoDB databases.
For example, the parameter 'sql_client' of the Migrator() class, receives by parameter a string where it is indicated which is the "client" to use, for example:
from sql2nosql import Migrator
Migrator(sql_client="mysql.connector")
For this case, you will need to manually install 'mysql.connector', as it is not a 'native package' of Python, therefore, the installation you need to do is as follows: pip install mysql-connector-python
In case you want to use 'pymysql', then first install it: pip install pymysql
And then pass it as a parameter in the form of a string:
from sql2nosql import Migrator
Migrator(sql_client="pymysql")
SQL2NoSQL takes care of the rest.
⚠️ Attention:
It is not yet implemented with PostgreSQL, SQLite3 and SQLServer, but will be tested with those databases soon. For the moment, it works with MySQL and MariaDB.
How to use ?
Basic usage
You indicate the SQL and NoSQL database connection data in a dictionary, and the "client"/"engine" you normally use for this conversion (I recommend PyMongo for MongoDB).
from sql2nosql import Migrator
host = "0.0.0.0"
sql_config = {
"host": host,
"port": 33060,
"username": "root",
"password": "1234",
"database": "classicmodels",
}
nosql_config = {
"host": host,
"port": 27018,
"username": "sql2nosql",
"password": "1234",
}
migrator = Migrator(
sql_config=sql_config,
nosql_config=nosql_config,
sql_client="mysql.connector",
nosql_client="pymongo",
)
migrator.migrate_data(tables=["customers", "employees", "offices"])
