Sedang Disiapkan

Python Script for creating and fill a table from JSON


Necesitamos crear un script en python que sea capaz de crear una tabla en Mysql a partir de un array de jsons en string, se ha de crear una clase que sea capaz de:

1. Recibir una serie de jsons en string.

2. Recibir el nombre de la tabla.

3. Desde un array de jsons recibidos, recoger todos campos keys diferentes, analizar el value y crear una tabla en Mysql. La primary key será identificada con un ID.

4. Desde un array de json, hacer un upsert en la tabla Mysql a partir de los campos ID.

Se pasará al desarrollador los siguientes elementos:

1. Una clase que conectará con Mysql y ejecutará la query [esto no debe de desarrollarse, NO ES EL OBJETIVO del trabajo]

2. Una clase que enviará los JSONs que se desea utilizar.

La clase sería:

-class json_ingest

-método "create_table(self, table_name, json_array)" -> Creará la tabla a partir de los jsons pasados.

-método "upsert_jsons(self, table_name, json_array)" -> Hará un upsert de los jsons dentro de la tabla.

No debe de tener en cuenta las excepciones, prefiero que suban para contralarlas en el flujo de trabajo superior. Así que si falla no debes de controlarlo, deja que suban.

Se ha de utilizar Python 2.7. Si utiliza alguna librería, por favor pregunta antes, hay que analizar posibles problemas de incompatibilidades.

El desarrollador que acepte el trabajo no puede tomar más de tres días en hacer este trabajo.


We need to create a script in python that is able to create a table in Mysql from an array of jsons in string, we must create a class that is able to:

1. Receive a string of jsons.

2. Receive the name of the table.

3. From an array of received jsons, collect all different key fields, parse the value and create a table in Mysql. The primary key will be identified with an ID.

4. From an array of json, make an upsert in the Mysql table from the ID fields.

The following elements will be passed to the developer:

1. A class that will connect to Mysql and execute the query [this should not be developed]

2. A class that will send the JSONs to be used.

The class would be:

-class json_ingest

-method "create_table (self, table_name, json_array)" -> Create the table from the jsons passed.

- method "upsert_jsons (self, table_name, json_array)" -> It will upstate the jsons inside the table.

You do not have to take into account the exceptions, I prefer that they go up to contrarl them in the superior workflow. So if you fail you should not control it, let them go up.

Python 2.7 must be used. If you use a library, please ask before, you have to analyze possible problems of incompatibilities.

The developer who accepts the job can not take more than three days to do this job.

Kemahiran: MySQL, Python

Lihat lagi: html table expand script jobs, script python html, creating screenshots python, mysql, python, php table dump script, phplist table creation script, football league table php script, creating script alert mail outlook, script python extract html tags, creating websites python, csv mysql table php script, restaurant table booking script, amazon creating script soap, table reservation script, football table php script, reservation table restaurant script

Tentang Majikan:
( 6 ulasan ) Estepona, Spain

ID Projek: #14056566

30 pekerja bebas membida secara purata $122 untuk pekerjaan ini


Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following skills Lagi

$200 USD dalam 3 hari
(58 Ulasan)

Hi.. :) I am very interested in your project, because I have much experience in such projects. I have good skills with the program language including C/C++, C#, java, php,, python, VB.NET. So I have expert a Lagi

$155 USD dalam 3 hari
(63 Ulasan)

I understand about your requirements. I have done some project like ur project. I think I can do your work perfectly. If you choose me, I will finish it in time and do my best. I will provide you one month bug free Lagi

$160 USD dalam 3 hari
(36 Ulasan)
$250 USD dalam 3 hari
(79 Ulasan)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Lagi

$180 USD dalam 3 hari
(34 Ulasan)

A proposal has not yet been provided

$150 USD dalam 3 hari
(60 Ulasan)

I have good knowledge in below mentioned skills by you. I also have some certifications in Java python. I can share some of demos with you if you want for better understanding. Currently I'm working on a banking projec Lagi

$100 USD dalam 3 hari
(18 Ulasan)

we have a smart profile . we have done many projects here . look at [login to view URL] which we are currently developing for a local client. [login to view URL] is our domain. all of them in web development in softwa Lagi

$83 USD dalam 7 hari
(7 Ulasan)

hello I have read your requirement. I can help you to finish this work. Can you provide more information about this project? Thank you

$150 USD dalam 3 hari
(19 Ulasan)

Hello! My name is Mehnaz Bashir. I am writing in response to your Project. After carefully reviewing the experience requirements and skills required for the job, I feel that I am a suitable match for the job. I have Lagi

$30 USD dalam 3 hari
(14 Ulasan)
$155 USD dalam 3 hari
(6 Ulasan)
$155 USD dalam 3 hari
(8 Ulasan)

Hi. I have been developing applications in Python and MySQL so I know basically how to do the ask you have asked for. I am free and ready to start working anytime. This project won't take much time either. So I am look Lagi

$83 USD dalam 3 hari
(4 Ulasan)

I can do this by Monday. If you want to see any reference of my work then please see these links. Have a look at this link. I have uploaded one of my web scrapping work as video. [login to view URL] A Lagi

$200 USD dalam 5 hari
(1 Ulasan)
$30 USD dalam 3 hari
(6 Ulasan)

Saludos, su proyecto es simple, yo poseo los conocimientos y experticia necesarios (Python y Mysql); también tengo un poco de experiencia administrando servidores Linux. La librería a emplear sería json, que facilit Lagi

$50 USD dalam 2 hari
(5 Ulasan)
$155 USD dalam 3 hari
(1 Ulasan)
$35 USD dalam sehari
(2 Ulasan)

Hello, My name is ishtiyaq, I am certified python expert I have 6 years+ experience in python language and I have completed 100+ projects using python .. Expertise : Python, Django, Django-Rest- Framework and many pyth Lagi

$30 USD dalam 5 hari
(1 Ulasan)
$155 USD dalam 3 hari
(2 Ulasan)