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 )