def setUp(self): main.app.config["TESTING"] = True main.connect_db() self.app = main.app.test_client() self.app.post('/createModel', data = json.dumps({"model_name": "test_model1", "model_type": "OnlineLinearRegression", "retrain_counter": 1}))
def setUp(self): main.app.config["TESTING"] = True main.connect_db() self.app = main.app.test_client() self.app.post('/createModel', data=json.dumps({ "model_name": "test_model1", "model_type": "LinearRegression", "retrain_counter": 10 }))
def setUp(self): print "starting setup" main.app.config["TESTING"] = True main.connect_db() self.app = main.app.test_client() try: rv = self.app.get('/models/test_model1') except: self.app.post('/createModel', data = json.dumps({"model_name": "test_model1", "model_type": "OnlineLinearRegression", "retrain_counter": 1})) print "finished setup"
def setUp(self): print "starting setup" main.app.config["TESTING"] = True main.connect_db() self.app = main.app.test_client() try: rv = self.app.get('/models/test_model1') except: self.app.post('/createModel', data=json.dumps({ "model_name": "test_model1", "model_type": "OnlineLinearRegression", "retrain_counter": 1 })) print "finished setup"
def setUp(self): main.app.config['TESTING'] = True main.app.logger.setLevel('DEBUG') self.app = main.app.test_client() main.init_db() self.db = main.connect_db() self.service = Service(self.db)
def add_profile(): db = connect_db() #cursor = db.cursor() user_id = request.cookies.get('user_id') color = request.form['color'] skill = request.form['skill'] if len(skill) > 2 or int(skill) > 12: return jsonify({'error': 'skill can be a number from 1 to 12 '}) if not check_cookies(): return jsonify({'error': 'in cookies'}) skills = replace_skills(skill) skill = request.form['skill'] abilities = Matrix.get_skill_matrix(skill) res = App.add_profile(user_id, skills, color, abilities) if res: return jsonify({'success': True}) else: return jsonify({ 'error': 'profile not added(a profile with this id already exists)' })
def result(): conn = connect_db() cur = conn.cursor() sql_str = "SELECT * FROM t_persons" cur.execute(sql_str) content = cur.fetchall() sql_str = "SHOW FIELDS FROM t_persons" cur.execute(sql_str) labels = cur.fetchall() labels = [l[0] for l in labels] return render_template('result.html', labels=labels, content=content)
def display_customer(self): for i in range(1, 11, 2): self.tick = Label(root, text="|") self.tick.grid(row=1, column=i) self.array_cursor_top.append(self.tick) self.customer_id = Label(root, text='N°client') self.money = Label(root, text='Cagnotte') self.last_name = Label(root, text='Nom') self.first_name = Label(root, text='Prénom') self.contact = Label(root, text='Contact') self.customer_id.grid(row=1, column=0) self.money.grid(row=1, column=2) self.last_name.grid(row=1, column=4) self.first_name.grid(row=1, column=6) self.contact.grid(row=1, column=8) connection, cursor = connect_db('db.db') cursor.execute("SELECT *FROM Customer") row = cursor.fetchall() i = 2 self.array_cursor = [] self.array_data = [] for customer in row: j = 0 k = 1 for data in customer: self.data_label = Label(root, text=data) self.data_label.grid(row=i, column=j) self.array_data.append(self.data_label) self.tick = Label(root, text="|") self.tick.grid(row=i, column=k) self.array_cursor.append(self.tick) j += 2 k += 2 i += 1 connection.close()
#import main import main main.connect_db() print( main.push( "sc", 1, "#### 完美解码V.20201225 已发布 \n #### 下载地址: http://www.wmzhe.com/soft-13163.html" ))
import sqlite3 as db from main import connect_db from datetime import date, datetime, timedelta print('Releasing assets for ' + str(date.today())) conn = connect_db() curs = conn.cursor() #curs.execute('update asset set releasedate = (?) where isreserved = 1', [str(date.today())]) curs.execute('update asset set isreserved = 0 where isreserved = 1 AND releasedate = (?)', [str(date.today())]) conn.commit()
#! python3 # coming_soon.py - PART2 Task2: Parses coming_soon.json to movies.db import sys, os, json, uuid from main import Movie as Movie from main import get_movie as get_movie from main import connect_db as connect_db from main import create_movie_table as create_movie_table pyPath = os.path.abspath(os.path.dirname(sys.argv[0])) jsonSrc = os.path.join(pyPath, 'coming_soon.json') if __name__ == '__main__': conn, cursor = connect_db('movies.db') create_movie_table(conn, cursor) #if not exists if os.path.exists(jsonSrc): with open(jsonSrc) as jsonFile: jsonData = json.load(jsonFile) for amovie in jsonData['results']: newmovie = Movie(str(uuid.uuid1()), amovie['rating'], amovie.get('release_date', "Now Showing"), str(amovie['cast']), amovie['synopsis'], amovie['movie_title'], amovie['image_url'], amovie['id'], None) if newmovie.check_movie_exists(conn, cursor): print( str(newmovie) + " already exists in our database. Updating release date instead."
for p in profits: share = main.shared_money(p['money']) if fee + share > app.config['REDPACK_MAX']: sys_pay = _share(p['agent_openid'], fee, p['user_pay_id']) if sys_pay['state'] == SUCCESS: save_shares(profits_in_one_share, sys_pay['id']) total += fee profits_in_one_share = [] fee = 0 fee += share profits_in_one_share.append(p) if fee > app.config['REDPACK_MIN']: sys_pay = _share(p['agent_openid'], fee, p['user_pay_id']) if sys_pay['state'] == SUCCESS: save_shares(profits_in_one_share, sys_pay['id']) total += fee app.logger.info('share %d points to user: %d', total, agent) if __name__ == '__main__': app.logger.info('share profilt run') service = Service(main.connect_db()) weixin.ssl_cert_file = './apiclient_cert.pem' weixin.ssl_key_file = './apiclient_key.pem' profit = service.find_unshared_profit() for k, g in groupby(profit, lambda x: x['agent']): settlement(k, g)
def setUp(self): main.app.config["TESTING"] = True main.connect_db() self.app = main.app.test_client()