Modify python script to insert results in mysql db

Web, Mobile & Software Dev Scripts & Utilities Posted 2 years ago

Fixed Price

Delivery by January 3, 2013




I have a python script that generates results based on jpg-files it analyzes.

These jpgs are in structured directories and subdirectories based on time in the following format:

This job is to modify the python script so that it runs on all subdirectories given as argument and outputs the results by UPDATING the 'Faces' column in 'Frames' table in a mysql database. Frames table:

EventId needs to be taken from the Events table based on time. Events table:

The FrameId is gotten from the jpg name:
001-capture.jpg  002-capture.jpg  003-capture.jpg
-The numbers are the FrameId's before capture.jpg

So some sql queries are required to get the right row to update but otherwise is a relatively simple job.

Full access to the Ubuntu server will be provided.
Documentation of all changes are extremely important.



Now the script can be run like this:

which runs it on all files given as the argument.

It outputs:   0

where the last '0' is the number to be inserted in the Faces column, but of course its not always a 0.

  • Other Skills:

Client Activity on this Job

Last Viewed: 2 years ago

Proposals: 9

Hired: 1

About the Client

(4.39) 54 reviews

Tallinn 01:41 PM

126 Jobs Posted
67% Hire Rate, 1 Open Job

Over $10,000 Total Spent
101 Hires, 1 Active

$16.01/hr Avg Hourly Rate Paid
328 Hours

Member Since Nov 15, 2011