from mysql import database
import globals
import sys
import os
#global variables
tempunit = "C"
count = 0
humidity = 0.0
temperature = 0.0
disconnectflag = 0
tempc = 0.0
tempf = 0.0
mydb = database()
#main class
class Ui_MainWindow(object):
#Function to get values from DHT22
def sensor(self):
global disconnectflag
global humidity, temperature, tempc, tempf
DHT_SENSOR = Adafruit_DHT.DHT22
DHT_PIN = 4
for i in range(1, 5):
humidity, temperature = Adafruit_DHT.read(DHT_SENSOR, DHT_PIN)
if humidity is not None and temperature is not None:
'''
index_convertor = lambda a: (int(a[0:-2]), int(a[-2:]))
type_convertor = lambda num: 'type%s' % (num)
lis = lis[1:] #get rid of header
result = []
for row in lis:
id, val = row[0], row[1:]
serial_no, question_no = index_convertor(id)
types = option_convert(val)
key = ['serial_no', 'question_no']
key_type = map(type_convertor, types)
key += key_type
value = [serial_no, question_no] + [
1,
] * len(types)
value = map(str, value)
atom = (key, value)
result.append(atom)
return result
filename = '/Users/Zhe/Desktop/grammer/bank_trial.csv'
input_data = readcsv(filename)
data = process_input_data(input_data)
mydb = database('test')
mydb.simple_insert('grammer_bank', data)
#!/usr/bin/python
#coding: utf-8
from mysql import database
from config import DB_NAME
database = database()
cur = database.cur()
print "Opened database %s successfully" % DB_NAME
cur.query('''CREATE TABLE proxys
(id INTEGER PRIMARY KEY AUTO_INCREMENT,
ip CHAR(20) NOT NULL,
port CHAR(10) NOT NULL,
type INT NOT NULL,
protocol CHAR(20) NOT NULL
);''')
print "Table created ok"
questions = questions.split(',')
name = '\"%s\"'%name
date = '\"%s\"'%date
quesitons = map(str,map(int,questions)) #reduce to most simple int format
for question in questions:
result.append([name,date,serial_no,question])
return result
filename = '/Users/Zhe/Desktop/grammer/record_trial.csv'
input_data = readcsv(filename)
#print input_data
data = process_input_data(input_data)
print data
mydb = database('test')
cols = ['student_name','record_date', 'serial_no', 'question_no']
mydb.simple_insert('grammer_record',cols, data )