Skip to content

Instantly share code, notes, and snippets.

View peerax's full-sized avatar

peerathai puapan peerax

View GitHub Profile
@peerax
peerax / dht.py
Created August 27, 2014 09:56
DHT11,22,2302 in python from https://github.com/adafruit
import sys
import dhtreader
DHT11 = 11
DHT22 = 22
AM2302 = 22
dhtreader.init()
@peerax
peerax / conCSVtoSQlite.py
Created August 26, 2014 07:35
python import txt,csv to sqlite
import csv, sqlite3
conn = sqlite3.connect("converting2.sqlite")
curs = conn.cursor()
curs.execute("CREATE TABLE document (col1 TEXT, col2 TEXT, col3 TEXT, col4 TEXT,col5 TEXT);")
reader = csv.reader(open('Calendar.txt', 'rU'), delimiter=' ')
for row in reader:
to_db = [unicode(row[0], "utf8"), unicode(row[1], "utf8"), unicode(row[2], "utf8"), unicode(row[3], "utf8"), unicode(row[4], "utf8")]
curs.execute("INSERT INTO document VALUES (?, ?, ?,?,?);", to_db)
conn.commit()