Python code to upload data to Wikispeedia

If you need an easy way to upload or delete some wikispeedia data, consider python.

This is some python code that might help. Try it, its easy to learn and fun.

link

———-make sure you indent it properly. Python needs that!——–

#!/usr/bin/python
# -*- coding: utf-8 -*-

import sqlite3 as lite
import sys
import urllib
import urllib.request
import datetime
from dateutil import parser

con = lite.connect(‘east’)

with con:

cur = con.cursor()
cur.execute(“SELECT * FROM tmp”)

rows = cur.fetchall()

i= len(rows)

for row in rows:
i=i-1
print (str(i))
pointLat =row[0];
pointLon =row[1];
swlat= pointLat-0.00001;
nelat= pointLat+0.00001;
swlng= pointLon-0.00001;
nelng= pointLon+0.00001;
cog=row[2];
mph=row[3];
deletedon=row[4];
submittedon=row[5];
kph=row[6];
sutc=row[7];
dutc=row[8];
tag=row[9];
tagg= urllib.parse.quote(tag);
mph_truck=row[10]
web_local=row[11]
sutcc = parser.parse(sutc)
dutcc=None
if dutc is not None:
dutcc= parser.parse(dutc)
dutccc= urllib.parse.quote(dutc)
if dutcc==None:
url = ‘http://www.wikispeedia.org/a/process_submit_bb3.php?name=all’+’&mlat=’+str(pointLat)+’&mlon=’+str(pointLon)+’&mmph=’+str(mph)+’&mkph=69&mtag=’+tagg+’&mcog=’+str(cog)
urllib.request.urlopen(url).read()
elif dutcc is not None:
url = ‘http://www.wikispeedia.org/a/delete_bb4a.php?nelat=’+str(nelat)+’&swlat=’+str(swlat)+’&nelng=’+str(nelng)+’&swlng=’+str(swlng)+’&mcog=’+str(cog)+’&delmail=’+’gpscruise@gmail.com’+’&mdutc=’+dutccc
urllib.request.urlopen(url).read()

0 Shares
No Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

cameras
Road Rage Reduction
Land of Lincoln

WTF, Illinois getting rid of 600 traffic cameras! We all hate these revenue generating Androids, creating road rage as we guess whether to run the yellow or not. Reading the article, it says it was a bipartison vote to remove the cameras. What the judge said is beautiful, I think …

Road Rage Reduction
Future

The Zebra has some interesting predictions on the future of transportation. The most interesting was the Flying Hotel Pods. I have envisioned this as a car, but I may have to rethink because there are too too many factors involved in cars. I can name 10 pretty quick. Legal: Cant …

Road Rage Reduction
Daylight savings time is to drivers as y2k was to pilots.

Céline Vetter, a circadian sleep scientist [hmmmm, circadiummmm…] at the University of Colorado, Boulder, and senior author of the study, says that this research data paints a clear picture on the very tangible dangers of daylight saving time. “The acute adverse effects of DST on fatal traffic accident risk are real …