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.


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

# -*- 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:
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;
tagg= urllib.parse.quote(tag);
sutcc = parser.parse(sutc)
if dutc is not None:
dutcc= parser.parse(dutc)
dutccc= urllib.parse.quote(dutc)
if dutcc==None:
url = ‘’+’&mlat=’+str(pointLat)+’&mlon=’+str(pointLon)+’&mmph=’+str(mph)+’&mkph=69&mtag=’+tagg+’&mcog=’+str(cog)
elif dutcc is not None:
url = ‘’+str(nelat)+’&swlat=’+str(swlat)+’&nelng=’+str(nelng)+’&swlng=’+str(swlng)+’&mcog=’+str(cog)+’&delmail=’+’’+’&mdutc=’+dutccc

Road Rage Reduction
Buying Service Hours

You can buy anything, we know that. When you think of service hours, you think of going to a nursing home and adjusting a pillow or two. Something with a human touch. Forcing you to connect to other humans in ways we avoid. Most high schools require service hours. So …

Speed Limit News
Lombard street look out.

Good boy. Who gets a mapping? You do! Lombard Street will get one more mapping for sure.   Who in the world would expect a new mapping company to arise. Today, started hiring uber drivers to make maps. Imagine that. On their off time, they get $3 /mile to drone …

Road Rage Reduction
How I survived Road Rage and the 6 second horn.

We have all heard the 6 second horn. I sure did. But whats important is how I survived this. First tip to get ahead of road rage is this. Turn all your mirrors away so you can’t see who is behind you. That way you won’t see tailgators. They will …