gpsdate | Simple tool for fetching date

Maybe you need something like this:

As I understand your question, you want to generate a timestamp with time zone from a date and a time. You can do this with the + operator, and additional casting:

I think the value assignment should look like this, yes?: values = [line[0].split(",").strip() for line in file_content]

Your code does not delete the existing table and create a new table because it already exists with the same name. Try the following piece of code inside the function.

You can use concatination array method.

I guess gpsTime is not properly terminated, i.e. it's not a valid C string. This will cause undefined behavior.

If you expect it to be "083559" as shown, it cannot be char gpsTime[6] since that leaves no room for the terminator. It has to be char gpsTime[7] or more. This of course goes for all of the strings; a C string with n characters has to have n + 1 chars worth of space since the final one must be \0 to terminate the string.

I like what you're doing with the cars and the GPS's.. Is not so easy to debug this kind of thing without the working code in front of one to play with the variables but have some ideas as have used pymysql a lot and also got that error missing 1 required positional argument

Things to try:

1. Lose the brackets around cmd =("""INSERT INTO GPS (signature,latitude,longitude,gpstime,gpsdata,orientationNS,orientationEV,direction,speed,distance) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)""") and put it on one line for now even if that breaks PEP 8 rules. Have checked my code and there were no brackets around this string.

2. Try an extra set of brackets here like this : self.cursor.execute((cmd,data_tuple))

3. Try an extra set of brackets in your handle_read function: Database.dbinsert((data_tuple))

4. Add cursorclass=pymysql.cursors.DictCursor to the things in brackets here ('localhost','db_user','password','db' ) You might even want to fill those things out with the handles, host='localhost' etc to be safe.

Anyway, I hope one of these things works, just from my experience that error message comes up when there is something wrong with the brackets as these variables are a passed between your functions.