An API for Python To MySQL with some addons.
- Google Sheet
- Make sure you have MySQL Server running in your system, if not, download it here:
https://dev.mysql.com/downloads/windows/installer/8.0.html make sure that you remember your USERNAME and PASSWORD. You'll need it later
- Install MySQL Connector
pip install mysql-connector-python- Install Google Modules (Optional)
pip install --upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlib- You can use this code to test if everything is working propertly
from PySQL import * # changer the placeholder with your own values pysql = PySQL("USERNAME", "PASSWORD") pysql.createDatabase("TestDatabase00") pysql.useDatabase("TestDatabase00") pysql.createTable("TestTable00",["SOME_ID int PRIMARY KEY", "SOME_DATA VARCHAR(255)"]) # Print all the table inside the current database print(pysql.getTables()); from PySql import * # Read and Write Access # You can refer here: https://developers.google.com/sheets/api/guides/authorizing SCOPES = ['https://www.googleapis.com/auth/spreadsheets'] # The Name of the Sheet (not the file) RANGE_VALUE = "Sheet1" # You can see in your URL # Example: https://docs.google.com/spreadsheets/d/SPREADSHEETID/edit#gid=0 SHEET_ID = "spreadsheetId" # replace with placeholder TOKEN_PATH = "token.json"; # changer the placeholder with your own values pysql = PySql("USERNAME","PASSWORD") # Initialize the Google Sheet pysql.initGoogleSheet(SCOPES,TOKEN_PATH); # Change the placeholder pysql.useDatabase("DATABASE_NAME"); # Export the whole TABLE_NAME data in the google sheet pysql.exportToGoogleSheet("TABLE_NAME", RANGE_VALUE,SHEET_ID)