def get_results(search_terms): connection = ds.establish_connection(ds.TEAM_CREDENTIALS) data_source = ds.DataSource(connection) results = None order_by = search_terms.get('order') # Protect from unexpected query terms search_terms = { field: value for field, value in search_terms.items() if is_valid_field(field) } for search_term in search_terms.items(): field_results = get_field_results(data_source, search_term) if field_results is None: continue # If multiple search terms, get intersection if results is None: results = field_results else: results = [result for result in results if result in field_results] connection.close() if results is None: return [] elif order_by is not None: sort_results_by_field(results, order_by) return results
def main(): global app # sys.argv.extend(['-platform', 'eglfs']) # Qt Charts uses Qt Graphics View Framework for drawing, therefore QApplication must be used. app = QApplication(sys.argv) viewer = QQuickView() # The following are needed to make examples run without having to install the module # in desktop environments. extraImportPath = QGuiApplication.applicationDirPath() if sys.platform == 'win32': extraImportPath += "/../../../../qml" else: extraImportPath += "/../../../qml" viewer.engine().addImportPath(extraImportPath) viewer.engine().quit.connect(app.quit) viewer.setTitle("QML Oscilloscope") dataSource = datasource.DataSource(viewer) viewer.rootContext().setContextProperty("dataSource", dataSource) main_qml = path.dirname(__file__) + "/qml/qmloscilloscope/main.qml" viewer.setSource(QUrl(main_qml)) viewer.setResizeMode(QQuickView.SizeRootObjectToView) viewer.setColor(QColor("#404040")) viewer.show() return app.exec_()
def get_all_unique_values(): connection = ds.establish_connection(ds.TEAM_CREDENTIALS) data_source = ds.DataSource(connection) unique_values = { field: data_source.get_unique_values(field) for field in ds.DB_ENTRY_FIELDS } connection.close() return unique_values
def respond(): data = datasource.DataSource() data.update_data() # pprint.pprint(data.data) with open('data.json', 'w') as outfile: for article in data.data: article['wordchoice'] = [ x.__dict__['string'] for x in article['wordchoice'] ] json.dump(data.data, outfile) return 'blah'
def result(): if request.method == 'POST': inputCategory = request.form['Category'] inputTime = request.form['Time'] inputAge = request.form['Minimum Age'] inputNumPlayer = request.form['No. of Players'] info = datasource.DataSource(inputNumPlayer, inputAge, inputCategory, inputTime) query = info.search() if query == "Sorry! No games found": return render_template('noResults.html') else: return render_template("results.html",result = query)
def renderResultTimeUsageRange(): result = datasource.DataSource("diiannic", "corn972corn") state = request.args.get("state") activity = request.args.get("activity") start = request.args.get("start") end = request.args.get("end") if ((start == "---") and (end == "---")): stateMins = result.getActivityMinsByState(state, activity) start = 2014 end = 2018 year_message = "from " + str(start) + " to " + str(end) peopleSurveyed = result.getNumberOfPeopleSurveyedByStateAverage( state, start, end) elif (end == "---"): start = int(start) end = start year_message = "in " + str(start) stateMins = result.getActivityAverageMinsByYearAndState( start, state, activity) peopleSurveyed = result.getNumberOfPeopleSurveyedByStateAndYear( state, start) elif (start == "---"): end = int(end) start = end year_message = "in " + str(end) stateMins = result.getActivityAverageMinsByYearAndState( end, state, activity) peopleSurveyed = result.getNumberOfPeopleSurveyedByStateAndYear( state, end) else: start = int(start) end = int(end) if (start > end): temp = start start = end end = temp if start == end: year_message = "in " + str(start) else: year_message = "from " + str(start) + " to " + str(end) stateMins = result.getActivityMinsByStateRange(state, activity, start, end) peopleSurveyed = result.getNumberOfPeopleSurveyedByStateAverage( state, start, end) plt.clf() createPlot(start, end, stateMins) return render_template('sample_results.html', peopleSurveyed=peopleSurveyed, type=activity + " Time Usage", state=state, year=year_message)
async def ftp_handler(reader, writer): session = ftpsession.FtpSession( HOST, reader, writer, datasource.DataSource(HTTP_SESSION) ) try: try: await session.dispatch() finally: await session.close() except ftpsession.DropSession: pass except BrokenPipeError: pass except ConnectionResetError: pass
def tableComparison(): if request.method == 'POST': field1 = request.form["DV1"] field2 = request.form["DV2"] spotlight = request.form["SL"] staffpick = request.form["SP"] ds = datasource.DataSource() ds.connect('beckerr2', 'barn787sign') if (field1 == "Backer Count" and field2 == "Pledged Amount" and spotlight == "IDC" and staffpick == "IDC"): table = [] table = ds.getBackersAndPledged() newTable = [] i = 0 for row in table: currency = row[2] pledged = ds.convertCurrency(row[1], currency) rowX = [row[0], pledged] newTable.append(rowX) i = i + 1 bestTable = [] for row in table: for index in row: bestTable.append(index) newtable_json = json.dumps(newTable) return render_template('datapage_table.html', table=table, field1=field1, field2=field2, newTable=newtable_json) return render_template('datapage_table.html')
def __init__(self): '''Has several methods to return HTML code for printing in index.py''' self.data = datasource.DataSource() self.form = cgi.FieldStorage()
def get_results(): ''' Gets fields of submitted query and calls DB API with the query params. Returns: -results.html page formatted with comments ''' comments = [] errors = [] ds = datasource.DataSource() #initializes booleans for filtering purposes badSentBool = False goodSentBool = False maxScoreBool = False minScoreBool = False if request.method == 'POST': print(request.form) # get keywords, other comment specs from submitted form #A series of try commands that conditionally execute queries based on user input try: keywords = request.form['keywords'] if keywords != "": queryResult = ds.KeywordSearch(keywords) for comment in queryResult: if comment in comments: pass else: comments.append(comment) keywordBool = True except: pass try: goodSentiment = request.form['goodSentiment'] goodSentBool = True except: pass try: badSentiment = request.form['badSentiment'] badSentBool = True except: pass #returns everything if both good and bad sentiment are selected if badSentBool and goodSentBool: badSentBool = False goodSentBool = False elif badSentBool and not goodSentBool: queryResult = ds.getSentimentBad() for comment in queryResult: if comment in comments: pass else: comments.append(comment) elif goodSentBool and not badSentBool: queryResult = ds.getSentimentGood() for comment in queryResult: if comment in comments: pass else: comments.append(comment) #sets filtering booleans for a score query try: scoreLow = request.form['scoreLow'] if scoreLow != '': minScoreBool = True except: pass try: scoreHigh = request.form['scoreHigh'] if scoreHigh != '': maxScoreBool = True except: pass #begins appending the queries into a comment array if minScoreBool and maxScoreBool: queryResult = ds.getScoreInRange(scoreLow, scoreHigh) for comment in queryResult: if comment in comments: pass else: comments.append(comment) if minScoreBool and not maxScoreBool: queryResult = ds.getScoreAbove(scoreLow) for comment in queryResult: if comment in comments: pass else: comments.append(comment) if maxScoreBool and not minScoreBool: queryResult = ds.getScoreBelow(scoreHigh) for comment in queryResult: if comment in comments: pass else: comments.append(comment) try: edited = request.form['edited'] queryResult = ds.getEdited('TRUE') for comment in queryResult: if comment in comments: pass else: comments.append(comment) editedBool = True except: pass try: gilded = request.form['gilded'] queryResult = ds.getGuilded() for comment in queryResult: if comment in comments: pass else: comments.append(comment) gildedBool = True except: pass try: controversial = request.form['controversial'] queryResult = ds.getControversial() for comment in queryResult: if comment in comments: pass else: comments.append(comment) controvBool = True except: pass #removes comments that dont fit the query conditions Results = filterResults(comments, request.form) #comment array is pushed to be rendered return render_template('resultsTemplate.html', comments=Results)
def defaultComparison(): if request.method == 'POST': field1 = request.form["DV1"] field2 = request.form["DV2"] spotlight = request.form["SL"] staffpick = request.form["SP"] ds = datasource.DataSource() ds.connect('beckerr2', 'barn787sign') if (spotlight == "True"): spot = "t" elif (spotlight == "False"): spot = "f" else: spot = "" if (staffpick == "True"): staff = "t" elif (staffpick == "False"): staff = "f" else: staff = "" if (field1 == "Backer Count" and field2 == "Pledged Amount"): table = [] table = ds.getBackersAndPledged(spot, staff) newTable = [] i = 0 for row in table: currency = row[2] pledged = ds.convertCurrency(row[1], currency) rowX = [row[0], pledged] newTable.append(rowX) i = i + 1 newtable_json = json.dumps(newTable) return render_template('datapage.html', table=table, field1=field1, field2=field2, newTable=newtable_json, spotlight=spotlight, staffpick=staffpick) elif (field1 == "Pledged Amount" and field2 == "Backer Count"): table = [] table = ds.getBackersAndPledged(spot, staff) newTable = [] i = 0 for row in table: currency = row[2] pledged = ds.convertCurrency(row[1], currency) rowX = [pledged, row[0]] newTable.append(rowX) i = i + 1 newtable_json = json.dumps(newTable) return render_template('datapage.html', table=table, field1=field2, field2=field1, newTable=newtable_json, spotlight=spotlight, staffpick=staffpick) elif (field1 == "Backer Count" and field2 == "Goal"): table = [] table = ds.getBackersAndGoal(spot, staff) newTable = [] i = 0 for row in table: currency = row[2] goal = ds.convertCurrency(row[1], currency) rowX = [row[0], goal] newTable.append(rowX) i = i + 1 newtable_json = json.dumps(newTable) return render_template('datapage.html', table=table, field1=field1, field2=field2, newTable=newtable_json, spotlight=spotlight, staffpick=staffpick) elif (field1 == "Goal" and field2 == "BackerCount"): table = [] table = ds.getBackersAndGoal(spot, staff) newTable = [] i = 0 for row in table: currency = row[2] goal = ds.convertCurrency(row[1], currency) rowX = [goal, row[0]] newTable.append(rowX) i = i + 1 newtable_json = json.dumps(newTable) return render_template('datapage.html', table=table, field1=field2, field2=field1, newTable=newtable_json, spotlight=spotlight, staffpick=staffpick) elif (field1 == "Pledged Amount" and field2 == "Goal"): table = [] table = ds.getPledgedAndGoal(spot, staff) newTable = [] i = 0 for row in table: currency = row[2] pledged = ds.convertCurrency(row[0], currency) goal = ds.convertCurrency(row[1], currency) rowX = [pledged, goal] newTable.append(rowX) i = i + 1 newtable_json = json.dumps(newTable) return render_template('datapage.html', table=table, field1=field1, field2=field2, newTable=newtable_json, spotlight=spotlight, staffpick=staffpick) elif (field1 == "Goal" and field2 == "Pledged Amount"): table = [] table = ds.getPledgedAndGoal(spot, staff) newTable = [] i = 0 for row in table: currency = row[2] pledged = ds.convertCurrency(row[0], currency) goal = ds.convertCurrency(row[1], currency) rowX = [goal, pledged] newTable.append(rowX) i = i + 1 newtable_json = json.dumps(newTable) return render_template('datapage.html', table=table, field1=field2, field2=field1, newTable=newtable_json, spotlight=spotlight, staffpick=staffpick) return render_template('datapage.html')
def chartComparison(): ###TO_DO### if request.method == 'POST': #Casting Data from User ds = datasource.DataSource() ds.connect('beckerr2', 'barn787sign') minBackers = int(request.form["backers_min"]) maxBackers = int(request.form["backers_max"]) minPledged = int(request.form["pledged_min"]) maxPledged = int(request.form["pledged_max"]) minGoal = int(request.form["goal_min"]) maxGoal = int(request.form["goal_max"]) displayVariable = request.form["DV"] chartData = [] if (displayVariable == "Spotlight"): isSpotlightedCount = 0 isNotSpotlightedCount = 0 ###WORKINGHERE### if ((not (minBackers == 0 and maxBackers == 0)) and (not (minPledged == 0 and maxPledged == 0)) and (not (minGoal == 0 and maxGoal == 0))): chartData = ds.getFilterByAll(minBackers, maxBackers, minPledged, maxPledged, minGoal, maxGoal) for row in chartData: if (row[10] == "T"): isSpotlightedCount = isSpotlightedCount + 1 elif (row[10] == "F"): isNotSpotlightedCount = isNotSpotlightedCount + 1 newTable = [] row1 = ["Spotlighted", isSpotlightedCount] newTable.append(row1) row2 = ["Not Spotlighted", isNotSpotlightedCount] newTable.append(row2) newtable_json = json.dumps(newTable) params = "All" return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((not (minBackers == 0 and maxBackers == 0)) and (not (minPledged == 0 and maxPledged == 0)) and (minGoal == 0 and maxGoal == 0)): chartData = ds.getFilterByBackersPledged( minBackers, maxBackers, minPledged, maxPledged) params = "BP" for row in chartData: if (row[10] == "T"): isSpotlightedCount = isSpotlightedCount + 1 elif (row[10] == "F"): isNotSpotlightedCount = isNotSpotlightedCount + 1 newTable = [] row1 = ["Spotlighted", isSpotlightedCount] newTable.append(row1) row2 = ["Not Spotlighted", isNotSpotlightedCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((not (minBackers == 0 and maxBackers == 0)) and (minPledged == 0 and maxPledged == 0) and (not (minGoal == 0 and maxGoal == 0))): chartData = ds.getFilterByBackersGoal(minBackers, maxBackers, minGoal, maxGoal) params = "BG" for row in chartData: if (row[10] == "T"): isSpotlightedCount = isSpotlightedCount + 1 elif (row[10] == "F"): isNotSpotlightedCount = isNotSpotlightedCount + 1 newTable = [] row1 = ["Spotlighted", isSpotlightedCount] newTable.append(row1) row2 = ["Not Spotlighted", isNotSpotlightedCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((minBackers == 0 and maxBackers == 0) and (not (minPledged == 0 and maxPledged == 0)) and (not (minGoal == 0 and maxGoal == 0))): chartData = ds.getFilterByPledgedGoal(minPledged, maxPledged, minGoal, maxGoal) params = "PG" a = 1 i = 10000000000 ^ 10000000000000000000000000000000000000000000000000000000000000000000000000000000000 breakYouGodDamnFool = i * 3.1415926 while True: a = a + 1 print("yaaaaaaaaaaas") for row in chartData: if (row[10] == "T"): isSpotlightedCount = isSpotlightedCount + 1 elif (row[10] == "F"): isNotSpotlightedCount = isNotSpotlightedCount + 1 newTable = [] row1 = ["Spotlighted", isSpotlightedCount] newTable.append(row1) row2 = ["Not Spotlighted", isNotSpotlightedCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((not (minBackers == 0 and maxBackers == 0)) and (minPledged == 0 and maxPledged == 0) and (minGoal == 0 and maxGoal == 0)): chartData = ds.getFilterByBackers(minBackers, maxBackers) params = "B" for row in chartData: if (row[10] == "T"): isSpotlightedCount = isSpotlightedCount + 1 elif (row[10] == "F"): isNotSpotlightedCount = isNotSpotlightedCount + 1 newTable = [] row1 = ["Spotlighted", isSpotlightedCount] newTable.append(row1) row2 = ["Not Spotlighted", isNotSpotlightedCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((minBackers == 0 and maxBackers == 0) and (not (minPledged == 0 and maxPledged == 0)) and (minGoal == 0 and maxGoal == 0)): chartData = ds.getFilterByPledged(minPledged, maxPledged) params = "P" for row in chartData: if (row[10] == "T"): isSpotlightedCount = isSpotlightedCount + 1 elif (row[10] == "F"): isNotSpotlightedCount = isNotSpotlightedCount + 1 newTable = [] row1 = ["Spotlighted", isSpotlightedCount] newTable.append(row1) row2 = ["Not Spotlighted", isNotSpotlightedCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((minBackers == 0 and maxBackers == 0) and (minPledged == 0 and maxPledged == 0) and (not (minGoal == 0 and maxGoal == 0))): chartData = ds.getFilterByGoal(minGoal, maxGoal) params = "G" for row in chartData: if (row[10] == "T"): isSpotlightedCount = isSpotlightedCount + 1 elif (row[10] == "F"): isNotSpotlightedCount = isNotSpotlightedCount + 1 newTable = [] row1 = ["Spotlighted", isSpotlightedCount] newTable.append(row1) row2 = ["Not Spotlighted", isNotSpotlightedCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((minBackers == 0 and maxBackers == 0) and (minPledged == 0 and maxPledged == 0) and (minGoal == 0 and maxGoal == 0)): chartData = ds.getFilterByNone() params = "None" for row in chartData: if (row[10] == "T"): isSpotlightedCount = isSpotlightedCount + 1 elif (row[10] == "F"): isNotSpotlightedCount = isNotSpotlightedCount + 1 newTable = [] row1 = ["Spotlighted", isSpotlightedCount] newTable.append(row1) row2 = ["Not Spotlighted", isNotSpotlightedCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) else: print("We f****d up") if (displayVariable == "Staffpick"): # all staffpick sorts: isStaffpickCount = 0 isNotStaffpickCount = 0 if ((not (minBackers == 0 and maxBackers == 0)) and (not (minPledged == 0 and maxPledged == 0)) and (not (minGoal == 0 and maxGoal == 0))): chartData = ds.getFilterByAll(minBackers, maxBackers, minPledged, maxPledged, minGoal, maxGoal) params = "All" for row in chartData: if (row[11] == "T"): isStaffpickCount = isStaffpickCount + 1 elif (row[11] == "F"): isNotStaffpickCount = isNotStaffpickCount + 1 newTable = [] row1 = ["Staff-Picked", isStaffpickCount] newTable.append(row1) row2 = ["Not Staff-Picked", isNotStaffpickCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((not (minBackers == 0 and maxBackers == 0)) and (not (minPledged == 0 and maxPledged == 0)) and (minGoal == 0 and maxGoal == 0)): chartData = ds.getFilterByBackersPledged( minBackers, maxBackers, minPledged, maxPledged) params = "BP" for row in chartData: if (row[11] == "T"): isStaffpickCount = isStaffpickCount + 1 elif (row[11] == "F"): isNotStaffpickCount = isNotStaffpickCount + 1 newTable = [] row1 = ["Staff-Picked", isStaffpickCount] newTable.append(row1) row2 = ["Not Staff-Picked", isNotStaffpickCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((not (minBackers == 0 and maxBackers == 0)) and (minPledged == 0 and maxPledged == 0) and (not (minGoal == 0 and maxGoal == 0))): chartData = ds.getFilterByBackersGoal(minBackers, maxBackers, minGoal, maxGoal) params = "BG" for row in chartData: if (row[11] == "T"): isStaffpickCount = isStaffpickCount + 1 elif (row[11] == "F"): isNotStaffpickCount = isNotStaffpickCount + 1 newTable = [] row1 = ["Staff-Picked", isStaffpickCount] newTable.append(row1) row2 = ["Not Staff-Picked", isNotStaffpickCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((minBackers == 0 and maxBackers == 0) and (not (minPledged == 0 and maxPledged == 0)) and (not (minGoal == 0 and maxGoal == 0))): chartData = ds.getFilterByPledgedGoal(minPledged, maxPledged, minGoal, maxGoal) params = "PG" for row in chartData: if (row[11] == "T"): isStaffpickCount = isStaffpickCount + 1 elif (row[11] == "F"): isNotStaffpickCount = isNotStaffpickCount + 1 newTable = [] row1 = ["Staff-Picked", isStaffpickCount] newTable.append(row1) row2 = ["Not Staff-Picked", isNotStaffpickCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((not (minBackers == 0 and maxBackers == 0)) and (minPledged == 0 and maxPledged == 0) and (minGoal == 0 and maxGoal == 0)): chartData = ds.getFilterByBackers(minBackers, maxBackers) params = "B" for row in chartData: if (row[11] == "T"): isStaffpickCount = isStaffpickCount + 1 elif (row[11] == "F"): isNotStaffpickCount = isNotStaffpickCount + 1 newTable = [] row1 = ["Staff-Picked", isStaffpickCount] newTable.append(row1) row2 = ["Not Staff-Picked", isNotStaffpickCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((minBackers == 0 and maxBackers == 0) and (not (minPledged == 0 and maxPledged == 0)) and (minGoal == 0 and maxGoal == 0)): chartData = ds.getFilterByPledged(minPledged, maxPledged) params = "P" for row in chartData: if (row[11] == "T"): isStaffpickCount = isStaffpickCount + 1 elif (row[11] == "F"): isNotStaffpickCount = isNotStaffpickCount + 1 newTable = [] row1 = ["Staff-Picked", isStaffpickCount] newTable.append(row1) row2 = ["Not Staff-Picked", isNotStaffpickCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((minBackers == 0 and maxBackers == 0) and (minPledged == 0 and maxPledged == 0) and (not (minGoal == 0 and maxGoal == 0))): chartData = ds.getFilterByGoal(minGoal, maxGoal) params = "G" for row in chartData: if (row[11] == "T"): isStaffpickCount = isStaffpickCount + 1 elif (row[11] == "F"): isNotStaffpickCount = isNotStaffpickCount + 1 newTable = [] row1 = ["Staff-Picked", isStaffpickCount] newTable.append(row1) row2 = ["Not Staff-Picked", isNotStaffpickCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((minBackers == 0 and maxBackers == 0) and (minPledged == 0 and maxPledged == 0) and (minGoal == 0 and maxGoal == 0)): chartData = ds.getFilterByNone() params = "None" for row in chartData: if (row[11] == "T"): isStaffpickCount = isStaffpickCount + 1 elif (row[11] == "F"): isNotStaffpickCount = isNotStaffpickCount + 1 newTable = [] row1 = ["Staff-Picked", isStaffpickCount] newTable.append(row1) row2 = ["Not Staff-Picked", isNotStaffpickCount] newTable.append(row2) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) else: print("We f****d up") if (displayVariable == "Status"): #all status sorts statusSuccess = 0 statusFailed = 0 statusCancelled = 0 statusSuspended = 0 statusLive = 0 if ((not (minBackers == 0 and maxBackers == 0)) and (not (minPledged == 0 and maxPledged == 0)) and (not (minGoal == 0 and maxGoal == 0))): chartData = ds.getFilterByAll(minBackers, maxBackers, minPledged, maxPledged, minGoal, maxGoal) params = "All" for row in chartData: if (row[12] == "S"): statusSuccess = statusSuccess + 1 elif (row[12] == "F"): statusFailed = statusFailed + 1 elif (row[12] == "C"): statusCancelled = statusCancelled + 1 elif (row[12] == "X"): statusSuspended = statusSuspended + 1 elif (row[12] == "L"): statusLive = statusLive + 1 newTable = [] row1 = ["Succesful", statusSuccess] newTable.append(row1) row2 = ["Failed", statusFailed] newTable.append(row2) row3 = ["Cancelled", statusCancelled] newTable.append(row3) row4 = ["Suspended", statusSuspended] newTable.append(row4) row5 = ["Live", statusLive] newTable.append(row5) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((not (minBackers == 0 and maxBackers == 0)) and (not (minPledged == 0 and maxPledged == 0)) and (minGoal == 0 and maxGoal == 0)): chartData = ds.getFilterByBackersPledged( minBackers, maxBackers, minPledged, maxPledged) params = "BP" for row in chartData: if (row[12] == "S"): statusSuccess = statusSuccess + 1 elif (row[12] == "F"): statusFailed = statusFailed + 1 elif (row[12] == "C"): statusCancelled = statusCancelled + 1 elif (row[12] == "X"): statusSuspended = statusSuspended + 1 elif (row[12] == "L"): statusLive = statusLive + 1 newTable = [] row1 = ["Succesful", statusSuccess] newTable.append(row1) row2 = ["Failed", statusFailed] newTable.append(row2) row3 = ["Cancelled", statusCancelled] newTable.append(row3) row4 = ["Suspended", statusSuspended] newTable.append(row4) row5 = ["Live", statusLive] newTable.append(row5) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((not (minBackers == 0 and maxBackers == 0)) and (minPledged == 0 and maxPledged == 0) and (not (minGoal == 0 and maxGoal == 0))): chartData = ds.getFilterByBackersGoal(minBackers, maxBackers, minGoal, maxGoal) params = "BG" for row in chartData: if (row[12] == "S"): statusSuccess = statusSuccess + 1 elif (row[12] == "F"): statusFailed = statusFailed + 1 elif (row[12] == "C"): statusCancelled = statusCancelled + 1 elif (row[12] == "X"): statusSuspended = statusSuspended + 1 elif (row[12] == "L"): statusLive = statusLive + 1 newTable = [] row1 = ["Succesful", statusSuccess] newTable.append(row1) row2 = ["Failed", statusFailed] newTable.append(row2) row3 = ["Cancelled", statusCancelled] newTable.append(row3) row4 = ["Suspended", statusSuspended] newTable.append(row4) row5 = ["Live", statusLive] newTable.append(row5) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((minBackers == 0 and maxBackers == 0) and (not (minPledged == 0 and maxPledged == 0)) and (not (minGoal == 0 and maxGoal == 0))): chartData = ds.getFilterByPledgedGoal(minPledged, maxPledged, minGoal, maxGoal) params = "PG" for row in chartData: if (row[12] == "S"): statusSuccess = statusSuccess + 1 elif (row[12] == "F"): statusFailed = statusFailed + 1 elif (row[12] == "C"): statusCancelled = statusCancelled + 1 elif (row[12] == "X"): statusSuspended = statusSuspended + 1 elif (row[12] == "L"): statusLive = statusLive + 1 newTable = [] row1 = ["Succesful", statusSuccess] newTable.append(row1) row2 = ["Failed", statusFailed] newTable.append(row2) row3 = ["Cancelled", statusCancelled] newTable.append(row3) row4 = ["Suspended", statusSuspended] newTable.append(row4) row5 = ["Live", statusLive] newTable.append(row5) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((not (minBackers == 0 and maxBackers == 0)) and (minPledged == 0 and maxPledged == 0) and (minGoal == 0 and maxGoal == 0)): chartData = ds.getFilterByBackers(minBackers, maxBackers) params = "B" for row in chartData: if (row[12] == "S"): statusSuccess = statusSuccess + 1 elif (row[12] == "F"): statusFailed = statusFailed + 1 elif (row[12] == "C"): statusCancelled = statusCancelled + 1 elif (row[12] == "X"): statusSuspended = statusSuspended + 1 elif (row[12] == "L"): statusLive = statusLive + 1 newTable = [] row1 = ["Succesful", statusSuccess] newTable.append(row1) row2 = ["Failed", statusFailed] newTable.append(row2) row3 = ["Cancelled", statusCancelled] newTable.append(row3) row4 = ["Suspended", statusSuspended] newTable.append(row4) row5 = ["Live", statusLive] newTable.append(row5) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((minBackers == 0 and maxBackers == 0) and (not (minPledged == 0 and maxPledged == 0)) and (minGoal == 0 and maxGoal == 0)): chartData = ds.getFilterByPledged(minPledged, maxPledged) params = "P" for row in chartData: if (row[12] == "S"): statusSuccess = statusSuccess + 1 elif (row[12] == "F"): statusFailed = statusFailed + 1 elif (row[12] == "C"): statusCancelled = statusCancelled + 1 elif (row[12] == "X"): statusSuspended = statusSuspended + 1 elif (row[12] == "L"): statusLive = statusLive + 1 newTable = [] row1 = ["Succesful", statusSuccess] newTable.append(row1) row2 = ["Failed", statusFailed] newTable.append(row2) row3 = ["Cancelled", statusCancelled] newTable.append(row3) row4 = ["Suspended", statusSuspended] newTable.append(row4) row5 = ["Live", statusLive] newTable.append(row5) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((minBackers == 0 and maxBackers == 0) and (minPledged == 0 and maxPledged == 0) and (not (minGoal == 0 and maxGoal == 0))): chartData = ds.getFilterByGoal(minGoal, maxGoal) params = "G" for row in chartData: if (row[12] == "S"): statusSuccess = statusSuccess + 1 elif (row[12] == "F"): statusFailed = statusFailed + 1 elif (row[12] == "C"): statusCancelled = statusCancelled + 1 elif (row[12] == "X"): statusSuspended = statusSuspended + 1 elif (row[12] == "L"): statusLive = statusLive + 1 newTable = [] row1 = ["Succesful", statusSuccess] newTable.append(row1) row2 = ["Failed", statusFailed] newTable.append(row2) row3 = ["Cancelled", statusCancelled] newTable.append(row3) row4 = ["Suspended", statusSuspended] newTable.append(row4) row5 = ["Live", statusLive] newTable.append(row5) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) elif ((minBackers == 0 and maxBackers == 0) and (minPledged == 0 and maxPledged == 0) and (minGoal == 0 and maxGoal == 0)): chartData = ds.getFilterByNone() params = "None" for row in chartData: if (row[12] == "S"): statusSuccess = statusSuccess + 1 elif (row[12] == "F"): statusFailed = statusFailed + 1 elif (row[12] == "C"): statusCancelled = statusCancelled + 1 elif (row[12] == "X"): statusSuspended = statusSuspended + 1 elif (row[12] == "L"): statusLive = statusLive + 1 newTable = [] row1 = ["Succesful", statusSuccess] newTable.append(row1) row2 = ["Failed", statusFailed] newTable.append(row2) row3 = ["Cancelled", statusCancelled] newTable.append(row3) row4 = ["Suspended", statusSuspended] newTable.append(row4) row5 = ["Live", statusLive] newTable.append(row5) newtable_json = json.dumps(newTable) return render_template('chartpage.html', displayVariable=displayVariable, newTable=newtable_json, params=params, minBackers=minBackers, maxBackers=maxBackers, minPledged=minPledged, maxPledged=maxPledged, minGoal=minGoal, maxGoal=maxGoal) else: print("We f****d up") return render_template('chartpage.html')
plt.show() print("mean squared bias: {:.4f}".format(avg_sqrd_bias)) print("mean variance: {:.4f}".format(avg_variance)) return avg_sqrd_bias, avg_variance def tune_experiment(num_trials, train_size, min_degree, max_degree, source): biases = [] variances = [] degrees = range(min_degree, max_degree) for degree in degrees: avg_sqrd_bias, avg_variance = bias_variance_experiment(num_trials, train_size, degree, source, display=False) biases.append(avg_sqrd_bias) variances.append(avg_variance) biases = np.array(biases) variances = np.array(variances) plt.plot(degrees, biases) plt.plot(degrees, variances) plt.plot(degrees, biases + variances) plt.legend(["mean sqrd bias", "variance", "sum"]) plt.show() if __name__ == "__main__": ds = datasource.DataSource() bias_variance_experiment(100, 30, 3, ds, True)
def random(): info = datasource.DataSource(5, 21, "Puzzel", 200) query = info.getRandomGame() return render_template('results.html', result = query)
def test_created_class_based_on_target(self, name, target, klass, data, datasize_lazy, datasize): s = datasource.DataSource(target) self.assertIsInstance(s, klass)