I've an application that imports .DBF file data to SQL using SQL Alchemy Core, currently it imports the data to a static table name, runs a function to generate data then drops the table and repeats.
This is inefficient as the same source data will repeat many times over, so I want to know how I can create Classes and Tables dynamically as to not need to drop tables?
For example at the moment -
I have a class and table called HistDob
HISDOB = 20181019
The function imports data for 20181019 to the HistDob table, generates data on this and then drops the table,
Then HISTDOB changes to 20181020 and repeats, drops table.
I would like class name and table name to be dynamic so we don't need to drop the table?
For example in the SQLAlchemy database there would now be 2 tables I could query HistDob_20181019 and HistDob_20181020
14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
I can change class name to dynamic. I assure you that i will give 100% quality work. Let us discuss and proceed further in chat. I am online. Please reply.
Python, MySQL. I have many experiences. I can complete your project successfully. I'm software engineer and algorithm expert. I'm fullstack website developer and database manager. Thanks.
I am Ring. I am about 18+ years experienced in GNU/Linux based system, server installation and customization, develop, deploy, security and support. I may help you in this regard.
I have plenty of python programming experience and I know SQL. I am just not very sure about the specific task to be honest, but I will have a good try anyway.