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

$70.00

Budget

Details

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:
year/month/day/hour/min/second

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: http://i.imgur.com/Q6Phb.png

EventId needs to be taken from the Events table based on time. Events table: http://i.imgur.com/LToLW.png

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.


update:

Hi,

Now the script count.py can be run like this:
./count.py video.fennoturvapalvelut.com/131/9735377/*

which runs it on all files given as the argument.

It outputs: video.fennoturvapalvelut.com/131/9737455/018-capture.jpg   0

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

Skills Required:

Client Activity on this Job

Last Viewed: 2 years ago

Proposals: 9

Hired: 1

Other open jobs by this client ({{ jobsCount }})


About the Client

(4.26) 51 reviews

Estonia
Tallinn 05:31 AM

123 Jobs Posted
67% Hire Rate, 1 Open Job

Over $10,000 Total Spent
98 Hires, 4 Active

$15.88/hr Avg Hourly Rate Paid
321 Hours

Member Since Nov 15, 2011