def data_to_breadth_x_db(self, start_date, x): if x == '30': breadth = 'thirty' digit = 7 add = '.00' elif x == '40': breadth = 'forty' digit = 6 add = '0.00' elif x == '50': breadth = 'fifty' digit = 5 add = '00.00' else: breadth = 'sixty' digit = 4 add = '000.00' count_dictionary = self.create_full_breadth_x_dictionary(x) for question in util.get_all_the_questions(): for row in self.pull_all_non_breadth_data(question, start_date): soc = str(row[1]) soc = soc[:digit] + add try: count_dictionary[question][soc]['numerator_count'] = row[2] count_dictionary[question][soc]['bailed_20'] = row[3] count_dictionary[question][soc]['saw_20'] = row[4] count_dictionary[question][soc]['saw_my_payscale'] = row[5] count_dictionary[question][soc]['total_shown'] = row[6] except KeyError: continue print "Inserting data into breadth " + breadth + " database..." conn = sqlite3.connect(self.database_path + "breadth_" + breadth + ".db") c = conn.cursor() for question in count_dictionary: for soc in count_dictionary[question]: answers = count_dictionary[question][soc] numerator = answers['numerator_count'] bail = answers['bailed_20'] saw = answers['saw_20'] my_payscale = answers['saw_my_payscale'] total = answers['total_shown'] question_alt = question.replace("/", "_").replace(" ", "_").replace( "-", "_") c.execute( 'INSERT INTO ' + question_alt + ' VALUES(?,?,?,?,?,?,?)', (start_date, soc, numerator, bail, saw, my_payscale, total)) conn.commit() conn.close()
def data_to_breadth_x_db(self, start_date, x): if x == "30": breadth = "thirty" digit = 7 add = ".00" elif x == "40": breadth = "forty" digit = 6 add = "0.00" elif x == "50": breadth = "fifty" digit = 5 add = "00.00" else: breadth = "sixty" digit = 4 add = "000.00" count_dictionary = self.create_full_breadth_x_dictionary(x) for question in util.get_all_the_questions(): for row in self.pull_all_non_breadth_data(question, start_date): soc = str(row[1]) soc = soc[:digit] + add try: count_dictionary[question][soc]["numerator_count"] = row[2] count_dictionary[question][soc]["bailed_20"] = row[3] count_dictionary[question][soc]["saw_20"] = row[4] count_dictionary[question][soc]["saw_my_payscale"] = row[5] count_dictionary[question][soc]["total_shown"] = row[6] except KeyError: continue print "Inserting data into breadth " + breadth + " database..." conn = sqlite3.connect(self.database_path + "breadth_" + breadth + ".db") c = conn.cursor() for question in count_dictionary: for soc in count_dictionary[question]: answers = count_dictionary[question][soc] numerator = answers["numerator_count"] bail = answers["bailed_20"] saw = answers["saw_20"] my_payscale = answers["saw_my_payscale"] total = answers["total_shown"] question_alt = question.replace("/", "_").replace(" ", "_").replace("-", "_") c.execute( "INSERT INTO " + question_alt + " VALUES(?,?,?,?,?,?,?)", (start_date, soc, numerator, bail, saw, my_payscale, total), ) conn.commit() conn.close()
def create_full_breadth_x_num_dictionary(self, x): count_dictionary = {} for question in util.get_all_the_questions(): count_dictionary[question] = {} for soc in self.find_breadth_x_soc_codes(x): count_dictionary[question][soc] = 0 return count_dictionary
def create_full_breadth_x_dictionary(self, x): count_dictionary = {} for question in util.get_all_the_questions(): count_dictionary[question] = {} for soc in self.find_breadth_x_soc_codes(x): count_dictionary[question][soc] = {} for answer in ["numerator_count", "bailed_20", "saw_20", "saw_my_payscale", "total_shown"]: count_dictionary[question][soc][answer] = 0 return count_dictionary
def create_full_breadth_x_dictionary(self, x): count_dictionary = {} for question in util.get_all_the_questions(): count_dictionary[question] = {} for soc in self.find_breadth_x_soc_codes(x): count_dictionary[question][soc] = {} for answer in [ 'numerator_count', 'bailed_20', 'saw_20', 'saw_my_payscale', 'total_shown' ]: count_dictionary[question][soc][answer] = 0 return count_dictionary
def check_for_data(self): conn = sqlite3.connect(self.database_path + "Question_Denominator.db") c = conn.cursor() for i, question in enumerate(util.get_all_the_questions()): if 1 < 10: query = "SELECT date FROM " + question.replace("/", "_").replace(" ", "_").replace("-", "_") for row in c.execute(str(query)): print row else: break conn.close()
def check_for_data(self): conn = sqlite3.connect(self.database_path + "Question_Denominator.db") c = conn.cursor() for i, question in enumerate(util.get_all_the_questions()): if 1 < 10: query = "SELECT date FROM " + question.replace( "/", "_").replace(" ", "_").replace("-", "_") for row in c.execute(str(query)): print row else: break conn.close()