Find Jobs
Hire Freelancers

Python Script to Create a SQL Script

$30-250 USD

Completato
Pubblicato circa 5 anni fa

$30-250 USD

Pagato al completamento
I just need a Python Script that will input a file record containing column headers and then build a SQL SELECT Script file. Basically, you are building dynamic SQL Select builder script. The input file will be a CSV text file containing one record with text columns like this: Lutron, C:\My Documents, A-MFG_PART_NUMBER, B-MFG_PART_NUMBER, A-Supplier_ID, B-Supplier_ID, A-Eco_10, S-Eco_10, A-Eco_12, S-Eco_12,..... The input record is dynamic and will have different labels and different number of labels with the exception of the first four columns. Column 1 = File Name (ex.,Lutron) Column 2 = File Path (ex., C:\My Documents) Column 3 = A-MFG_PART_NUMBER, Column 4 = B-MFG_PART_NUMBER All other columns will be dynamic and can have different labels. Again, the first four columns will be as defined above and the rest dynamic. This script will read in this record and produce an XML SQL script file that looks like this: <BusinessRule Name="File Name from Column 1" Id="File Name from Column 1" Description="" PassPolity="NoRowsReturned" PrimaryTable="">SELECT A-MFG_PART_NUMBER, B-MFG_PART_NUMBER, A-Supplier_ID, B-Supplier_ID, A-Eco_10, S-Eco_10, A-Eco_12, S-Eco_12 FROM [STEP] as S INNER JOIN [ACDC] A ON S.[MFG_PART_NUMBER] = A.[MFG_PART_NUMBER] WHERE ( (S.[S-Supplier_ID] is NULL and A.[A-Supplier_ID] is not NULL) or ( S.[S-Eco_10] is NULL and A.[A-Eco_10] is not NULL) or ( S.[S-Eco_12] is NULL and A.[A-Eco_12] is not NULL) ..... ) </BusinessRule> To save the file you will take the file name from column A and the file path from column B. The output file needs to have a ".br" extension. For example; Lutron.br. The path to save file will always be in the second column. For example; C:\My Documents
Rif. progetto: 18546123

Info sul progetto

18 proposte
Progetto a distanza
Attivo 5 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
Hi, Well I have done many python project and a file reading projects that creates the sql select statement will be no different. You don't need to overpay high amounts to anyone. I will create this is one day. Do look at my past projects.
$30 USD in 1 giorno
5,0 (13 valutazioni)
3,8
3,8
18 freelance hanno fatto un'offerta media di $194 USD
Avatar dell'utente
Hello I'm experienced Python developer with strong expertise and I'm interested with your task. Let's discuss it in detail over the chat. Regards, Alex.
$250 USD in 3 giorni
5,0 (20 valutazioni)
5,7
5,7
Avatar dell'utente
I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Python. Please ping me for more discussion.
$250 USD in 4 giorni
4,9 (30 valutazioni)
5,8
5,8
Avatar dell'utente
Hello? How are you? I have good experiences in "Python Script to Create a SQL Script" as you can see my profile for these (Python). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
$155 USD in 3 giorni
4,9 (26 valutazioni)
5,0
5,0
Avatar dell'utente
Hi there Roaya is a startup based in Egypt and we are Odoo official partner. We are ready to start working on your project. Please let us discuss the details Regards Mohammad Alaa
$1.000 USD in 10 giorni
4,9 (20 valutazioni)
5,0
5,0
Avatar dell'utente
Hi I am a data engineer with 4+ years of industry experience. I have worked in automation of scripts generation in sql, scala, java, shell using python, groovy and java.i can do this work for you Relevant Skills and Experience I have expertise in 1. Python 2. SQL(Redshift, teradata, db2) 3. Automation in shell, jenkins groovy etc Looking forward to hearing from you
$150 USD in 3 giorni
5,0 (19 valutazioni)
5,0
5,0
Avatar dell'utente
Hey there I'm a System Engineer with coding skills. I'm checking the project description now. I can help. Regards.
$155 USD in 3 giorni
5,0 (12 valutazioni)
4,5
4,5
Avatar dell'utente
Hi There I've excellent programming and development skills and knowledge. I can provide an efficient, perfect, well documented development of your Programming and Computer project according to 100% accuracy and requirements, with dedicated support. Thanks Farah Saif
$155 USD in 3 giorni
4,9 (20 valutazioni)
4,3
4,3
Avatar dell'utente
I can help to build the script. Do you have any preference for Python version (2/3)? And looks like you need it to run on Windows rather than Linux.. Either way it won't affect much, but better to know so I can test it properly.
$222 USD in 3 giorni
5,0 (4 valutazioni)
3,1
3,1
Avatar dell'utente
I can do it in 3 days at max. (before Monday morning). If you want, I can put 10% as guarantee money as I'm sure of completing this work quickly and with quality. I'll also be providing you support after the project, so if in case you ever need some fix of addition of functionality, I'll be there to help. Try me anytime (as I've freelance on mobile phone as well) and I'm sure I'll become your preferred freelancer after this project.
$110 USD in 3 giorni
5,0 (4 valutazioni)
2,5
2,5
Avatar dell'utente
Hi! I am a Linux expert and Python developer. I can help you with your 'SQL Select builder script'. Thank you!
$30 USD in 1 giorno
5,0 (4 valutazioni)
2,4
2,4
Avatar dell'utente
Hello I have experience in this domain. Let me know your requirements. I will provide you high quality work. Ping me if you are interested. Thanks
$30 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
I am python developer with 3+ years of practical experience in data domain. Should be able to deliver the prod-ready code to you within 3 days.
$155 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hi there! We have experience with scripts for mssql. I’ understood your requirement and this is easy to accomplish for us. Please ping me to start working with you. Best regards!
$220 USD in 5 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
Powder Springs, United States
5,0
58
Metodo di pagamento verificato
Membro dal feb 2, 2010

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.