Using SQlalchemy i need a sample template/pseudo code on how we can and perform database checks/ create functions to 1) load multiple tables from MYSQL database into a pandas Df to perfrom activites by creating a function for each of these 2) the missing values from all the columns and if any, shown give details of that record 3) see if few specific formatted table names have same number of rows if not throw an error showing the table name 4) if each of the columns have the correct data types within them if not throw an error or display the particular value with column name and table name
I am new to SQlalchemy so I need a starting point on how can i define a function which can iterate over all the tables(110) in the database. These tables doesn't have any primary key or secondary key or related to each other. We have created this db to perform analytics on this monthly data tables. Kindly I need the community support to dive deep into this. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
