Find Jobs
Hire Freelancers

Use python to clean up mysql database

$30-250 USD

En cours
Publié il y a presque 10 ans

$30-250 USD

Payé lors de la livraison
I have a table in mysql database that I want to clean up regularly using python scripts scheduled by crontab. The table contains several fields, but the ones of interests is "comment" (text), "entry_datetime" (datetime), a duplicate count (int) and a time_elapsed count (seconds). The entry in the table is stored in chronicle order. Script 1. Remove duplicates Every hour (configurable with cron), the first script wakes up and looks at the comments entered in the last hour (configurable in the script). For each comment, it will be compared to all the table entry from the beginning of the table for a string comparison of the "comment" text. If it finds the first match, it will then use its entry_datetime minus the entry_datetime of the original comment, and store the difference in "time_elapsed", increase "duplicate" count by one and finally it will delete itself from the mysql database then move onto the next comment until all comments entered during the last hour are examined. Script 2. Remove old entry The second script will also run every hour (configurable with cron) that will simply remove entries that are older than 1 day (configurable in the script). That is, it will compare [login to view URL]() with entry_datetime and remove older entry from the mysql database.
N° de projet : 5866682

Concernant le projet

16 propositions
Projet à distance
Actif à il y a 10 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
16 freelances proposent en moyenne $217 USD pour ce travail
Avatar de l'utilisateur
Hello, I have over 9 years experience as an Linux admin and python developer. Please feel free to ask if you have any questions. Thank You
$157 USD en 1 jour
4,9 (471 commentaires)
7,6
7,6
Avatar de l'utilisateur
A proposal has not yet been provided
$100 USD en 2 jours
5,0 (372 commentaires)
7,2
7,2
Avatar de l'utilisateur
Hi, i have read your project description, i understand what you want, and i would like to offer you my services. I have excellent knowledge of Python and MySQL and related technologies, plenty of experience with them, most importantly including experience with various similar cron scripts and database cleaning scripts, so i can finish this project quickly and to your full satisfaction. Feel free to contact me by private message to discuss the details of this project. I'm looking forward to our cooperation.
$200 USD en 2 jours
5,0 (136 commentaires)
6,8
6,8
Avatar de l'utilisateur
I can deliver the script to work as per your specifications and requirements .
$210 USD en 3 jours
4,8 (123 commentaires)
7,2
7,2
Avatar de l'utilisateur
Hello. Are you sure you want to let the comments go into the database and then remove duplicates? Implementing a filter to avoid letting duplicates in would be a better approach, generally speaking. Anyway, I can provide both solutions if you reconsider it.
$263 USD en 10 jours
5,0 (12 commentaires)
6,2
6,2
Avatar de l'utilisateur
A proposal has not yet been provided
$147 USD en 3 jours
4,8 (81 commentaires)
6,2
6,2
Avatar de l'utilisateur
I am working on software development since 1992. I am expert on database migration. I can migrate any kind of relational databases with just few SQL sentences. I can solve problems about replacing or combining data related with plugins, modules, themes or components. I have a lot of linux server administrator skills. I have an strong knowledge of server side scripting.
$50 USD en 3 jours
5,0 (126 commentaires)
5,9
5,9
Avatar de l'utilisateur
Hi, I have a lot of experience with Python and databases, I can write both scripts for you. Will you provide some sample data along with database structures. Also how many records are there and do you have some performance requirements?
$77 USD en 3 jours
5,0 (21 commentaires)
5,5
5,5
Avatar de l'utilisateur
Hi I'm a python expert programmer. I can prove it to you with my activity and You can believe me. I contributed the deja-dup project in Ubuntu. and fix a error of IBus(Input method)'s panel(written by Python). If you touch me and send a example, we can discuss about the project. Best Regards - DuPingPing
$133 USD en 3 jours
4,6 (9 commentaires)
4,6
4,6
Avatar de l'utilisateur
La propuesta todavía no ha sido proveída
$111 USD en 3 jours
4,9 (6 commentaires)
3,5
3,5
Avatar de l'utilisateur
I have experience with writing some database code with python, and I am sure I can do this kind of thing.
$155 USD en 5 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
A proposal has not yet been provided
$188 USD en 3 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de UNITED STATES
Irvine, United States
5,0
22
Méthode de paiement vérifiée
Membre depuis sept. 16, 2013

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.