Suoritettu

Python SQLAlchemy Core, change functions from static Class Table Names to Dynamic

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

Taidot: Tietokantaohjelmointi, MySQL, Python, tietojärjestelmäarkkitehtuuri

Näytä lisää: flask sqlalchemy relationship, sqlalchemy query dynamic column, dynamic table creation in python, flask sqlalchemy tutorial, flask sqlalchemy reflect, flask sqlalchemy table name, flask sqlalchemy automap, sqlalchemy orm dynamic

Tietoa työnantajasta:
( 9 arvostelua ) Swanley, United Kingdom

Projektin tunnus: #19679608

Myönnetty käyttäjälle:

BestService222

Hi,How are you? I am available to do your project. Your required task actually map on my skill sets. I can say that I can do it perfectly I would love to do this with full dedication and hopefully won't make you f Lisää

£150 GBP 3 päivässä
(17 Arvostelua)
4.7

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

mingxiao2008

Hello, Dear How are you? My name is Sundong. I have read your project description and am ready for discussing with you about project. I have experienced in developing Database Programming, MySQL, Python, Software Lisää

£200 GBP 3 päivässä
(79 arvostelua)
7.7
fattahaabdul

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.

£250 GBP 7 päivässä
(63 arvostelua)
7.4
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Lisää

£250 GBP 7 päivässä
(62 arvostelua)
6.4
alexwmsoft

Hi, there. I am an experienced full stack developer and I have 6+ years' experience in developing websites. I read your job description, and I am interested in your project. And I think it is not matter to perfor Lisää

£150 GBP 3 päivässä
(17 arvostelua)
5.5
xinglong717

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.

£250 GBP 7 päivässä
(47 arvostelua)
5.6
guptaabhinav

Expert developer with experience of over 7 years. I think I understand your problem to an extent, drop is a heavy cost function, alternate to this could be truncate. I think I need to talk to you to better understand t Lisää

£166 GBP 2 päivässä
(32 arvostelua)
5.4
jk901

Dear As I am a senior software developer, have rich experience with various application development using C#, VC, VB.Net, NodeJS, Matlab, and python If you are interested with my proposal, please let me know it. Lisää

£250 GBP 3 päivässä
(13 arvostelua)
4.9
alkajain2906

Hi, I have 5+years Experience in Website/Software Design & Website Development. I'm an Expert in: -Frontend & Backend Development -Python -Data Science -Machine Learning -JVM technologies -Jquery, PHP -Ion Lisää

£150 GBP 3 päivässä
(6 arvostelua)
3.8
toshazed

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.

£100 GBP 3 päivässä
(9 arvostelua)
3.6
WangJinStar

✫✫✫ Dear Hiring Manager ✫✫✫ Wish you a very good day!!! After reviewing your post, I am very interested in that due to my experience. I’d like to be considered for your project position. I am an expert Web develop Lisää

£200 GBP 3 päivässä
(1 arvostelu)
1.5
maha304

i have diploma and pre master in statistical i'm using python and spss so i can do what you want to do

£150 GBP 4 päivässä
(0 arvostelua)
0.0
yelanyu

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.

£20 GBP 3 päivässä
(0 arvostelua)
0.0
ayonpal547

Hi, I can help you do this job. I have experience in python and mysql. In SqlAlchemy all your table data is stored in metadata you can gather table names from there or use an inspector to gather names. If you still Lisää

£23 GBP 1 päivässä
(0 arvostelua)
0.4