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

£20-250 GBP

Completed

Posted

almost 5 years ago

£20-250 GBP

Paid on delivery

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

Database Programming

MySQL

Python

Software Architecture

Project ID: 19679608

About the project

13 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 feel lost time. I work hard for you and you will surely get the result in a promised time. As I am a professional developer, I can do your job perfectly ASAP and I want to work with you Thanks From Xun C.

£150 GBP in 3 days

4.7

(37 reviews)

5.6

13 freelancers are bidding on average £162 GBP for this job

@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 in 7 days

5.0

(87 reviews)

7.7

@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 Architecture. I will work very hard and best for you. Best Regards

£200 GBP in 3 days

5.0

(84 reviews)

7.8

@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 perform your project, and I can satisfy you by completing your project with high quality in deadline. I have deep knowledge about React, Angular.js 2,4,5,6,7 and node.js express and serveral frameworks. I can make any directive, service, pipe, any CRUD in angular and nodejs or other backend frame. As a dedicated full stack developer, I am always available for daily communication and ready for your full response. I am free now, I can start to work in your project immediately. I would love to have an opportunity to discuss with you for further details. Regards

£150 GBP in 3 days

5.0

(30 reviews)

6.3

@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. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

£250 GBP in 7 days

4.8

(77 reviews)

6.5

@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. I hope to work with you on this project. Thanks.

£250 GBP in 3 days

5.0

(23 reviews)

5.6

@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 in 7 days

4.8

(52 reviews)

5.7

@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 the problem. Contact me to discuss this further. Thanks. Let's chat

£166 GBP in 2 days

4.9

(34 reviews)

5.4

@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 -Ionic - Hybrid Mobile Applications -Angular, Node.js -Ruby on Rails -C++ Who Knows the value of time. Very hard working and always delivers the work on time. I will finish your tasks in a timely and efficient manner, I aspire to help others reach their goals through the use of my knowledge and experience, I am available 24 hours support. I am available for the weekend also. If you are looking for website design and development I am the right person for you. 

£150 GBP in 3 days

4.9

(15 reviews)

4.4

@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 in 3 days

4.8

(14 reviews)

3.9

@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 have confusion or need support contact me. Thank you.

£23 GBP in 1 day

5.0

(1 review)

1.1

@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 in 4 days

0.0

(0 reviews)

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 in 3 days