def add_date(calendar, date, event): with orm.db_session: Date(calendar, date, event) response.status = 201 return {}
def create_date(**form_kwargs): new_date = Date(**form_kwargs) db.session.add(new_date) db.session.commit() print(f'{new_date} successfully created!🌈') # DELETE
def post_new_curve(): body = request.get_json() yyyymmdd = body.get('date') currency = body.get('ccy') ccy = Currency.query.filter_by(ccy=currency).one_or_none() if ccy is None: abort(404, f"There is no currency {currency}") date_datetime = to_datetime(yyyymmdd) date = Date.query.filter_by(date=date_datetime).one_or_none() if date is None: date = Date(date_datetime) date.insert() yield_dict = get_markit_yiled(yyyymmdd, currency)[1] curve = Curve(date.id, ccy.id) try: curve.insert() except: abort(409, "Curve already exist") tenors = Tenor.query.all() for tenor in tenors: Spread(tenor.id, curve.id, yield_dict[tenor.tenor]).insert() tenor_5y = Tenor.query.filter_by(tenor='5Y').one() try: spread = Spread.query.filter_by(curve_id=curve.id, tenor_id=tenor_5y.id).one() except: abort(422, "Unable to query 5y spread for posted curve.") return jsonify({ 'success': True, 'status_code': 200, 'curve': { 'date_id': curve.date_id, 'ccy_id': curve.ccy_id }, 'spread': spread.spread, }), 200
def add_date(response, calendar, date, event): with orm.db_session: if Calendar.get(id=calendar): calendar = Calendar.get(id=calendar) logger.warning("201") date = Date(calendar=calendar, date=date, event=event) response.status = HTTP_201 else: logger.warning("404") response.status = HTTP_404 return {}
def add_log(given_date): requested_date = format_date(given_date) existing_date = Date.query.filter_by(date=requested_date).first() if not existing_date: new_date = Date(date=requested_date, public_id=str(uuid.uuid4()), user=current_user) db.session.add(new_date) db.session.commit() else: flash("This date already exists.")
def save_data(grubber_date): date = Date(date=grubber_date) session.add(date) session.commit() music_data = grub_data_from_url(grubber_date) for item in music_data: music_track = MusicTrack() music_track.artist = item[0] music_track.song = item[1] music_track.date_id = date.id session.add(music_track) session.commit() print("Data has been loaded successfully")
def alter_time(): date = request.form['date'] month = request.form['month'] year = request.form['year'] date_full = db.session.query(Date).first() if date_full == None or date_full == '': date = Date(date=date, month=month, year=year) db.session.add(date) db.session.commit() return render_template('final-date.html', date=date) else: if date == None or date == '': date = date_full.date if month == None or month == '': month = date_full.month if year == None or year == '': year = date_full.year db.session.query(Date).filter_by(dateTime=date_full.dateTime).delete() date = Date(date=date, month=month, year=year) db.session.add(date) db.session.commit() return render_template('final-date.html', date=date)
def save_events(request): data = json.loads(request.body) data_success = {} for event in data['events']: event_id = event['id'] if event_id == '': event_id = 0 try: dateObject = Date.objects.get(date=data['date_event']) single_event = Event.objects.get(id=event_id) except Date.DoesNotExist: new_date = Date(date=data['date_event']) new_date.save() new_event = Event(event=event['event'], event_date=new_date) new_event.save() except Event.DoesNotExist: new_event = Event(event=event['event'], event_date=dateObject) new_event.save() else: single_event.event = event['event'] single_event.save() data_success['Status'] = 'Success' return JsonResponse(data_success, safe=False)
def date(): form = DateForm() if request.method == 'POST': if form.validate() == False: return render_template('date.html', form=form) else: newdate = Date(request.form['firstname'], request.form['lastname'], request.form['email'], request.form['hobbies']) #newpost = Post(form.title.data, form.post.data) db.session.add(newdate) db.session.commit() return redirect(url_for('dateview')) elif request.method == 'GET': return render_template('date.html', form=form)
def connect_match_data_season_1617(): df = pd.read_csv("./data/season_files/season1617.csv").drop(["Unnamed: 0"], axis=1) n_rels = 0 n_nodes = 0 for _, row in df.iterrows(): # NODES # Hometeam ht = Team.nodes.get(name=row["Home/Neutral"]) # Visitor vt = Team.nodes.get(name=row["Visitor/Neutral"]) # HomeScore hs = Score(score=row["PTS.1"]).save() # VisitorScore vs = Score(score=row["PTS"]).save() # Arena a = ht.arena.get() # Season s = Season.get_or_create({"name": "2016/2017"})[0] # Date d = Date.get_or_create({ "datetime": datetime.strptime(row["Date"] + " " + row["Start (ET)"], "%Y-%m-%d %I:%M %p") })[0] # Game g = Game(game_name=row["game_name"], game_type=row["game_type"], ot=row["OT"]).save() n_nodes += 1 # RELATIONSHIPS # Team -> Score ht.scored.connect(hs) vt.scored.connect(vs) # Score -> Game hs.in_game.connect(g) vs.in_game.connect(g) # Game -> Season g.season.connect(s) # Game -> Date g.date.connect(d) # Game -> Arena g.arena.connect(a) n_rels += 7 print("created (approx:) {} nodes and {} relationships".format( n_nodes, n_rels))
def wrapper(self): commit_tenors() commit_ccy() currency = 'USD' yyyymmdd = '20201231' date_datetime = to_datetime(yyyymmdd) Date(date_datetime).insert() commit_curve(yyyymmdd=yyyymmdd, CCY=currency) try: func(self) except: delete_data() raise delete_data()
def last_news(last=Date('28 апр в 17:25')): posts = get_last_posts(last) titles = [] for post in posts: date = get_date(post) title = get_title(post) links = get_links(post) translators = get_vk_names(post) language = get_language(post) titles.append({ 'date': date, 'title': title, 'links': links, 'translators': translators, 'language': language }) return titles
def run(self): """ This function doing something depending on users' choice. """ i = 0 while i != 8: i = self.view.user_input(self.view.menu_function) if i == 1: for operation in self.session.query(Operation).all(): print(operation) elif i == 2: new_operation = self.view.get_new_operation_data() new_operation['date'] = self.session.query(Date).filter_by(date=new_operation['date']).first() or \ Date(date=new_operation['date']) self.session.add(Operation(**new_operation)) self.session.commit() elif i == 3: for operation in self.session.query(Operation).filter_by( money=float( self.view.user_input( self.view.get_money_function))).all(): print(operation) elif i == 4: for operation in self.session.query(Operation).filter_by( description=self.view.get_description_function()).all( ): print(operation) elif i == 5: for operation in self.session.query(Operation).filter_by( date=self.session.query(Date).filter_by( date=self.view.get_datetime()).first()).all(): print(operation) elif i == 6: print("Balance = %.2f" % Operation.get_balance(self.session)) elif i == 7: for operation in self.session.query(Operation).all(): self.session.delete(operation) self.session.commit() elif i != 8: print("Wrong choice, try again")
def reset_calendars(): """ This function, used only for testing purposes, resets the calendars list to its initial states. :return: a simple status """ # Removing all calendars and dates: with orm.db_session: # Deleting all dates and calendars Date.select().delete(bulk=True) Calendar.select().delete(bulk=True) # Creating sample calendars and dates Calendar(id=0, title="Empty calendar") c2 = Calendar(id=1, title="Sport and activities") Date(id=0, calendar=c2, date="2018-01-01", event="Go fishing") Date(id=1, calendar=c2, date="2018-01-11", event="Go surfing") Date(id=2, calendar=c2, date="2018-02-12", event="Go skying") Date(id=3, calendar=c2, date="2018-03-09", event="Go swimming") return dict(status="done")
def get_last_date(): if len(sys.argv) == 1: date = get_date(get_last_posts()[0]) else: date = Date(sys.argv[1]) return date
def import_dates(modeladmin, request, queryset): with open('D:/Users/mcpherro/PycharmProjects/Sites/dates.csv', 'rb') as f: reader = csv.reader(f) for row in reader: d = Date(id=row[0], site_id=row[1], layer=row[2], industry=row[3], industry_2=row[4], industry_3=row[5], cat_no=row[6], sample=row[10], technique=row[11], hominid_remains=row[15], bibliography=row[16], period=row[17], notes=row[18]) if row[7] != 'NA': d.date = row[7] if row[8] != 'NA': d.sd_plus = row[8] if row[9] != 'NA': d.sd_minus = row[9] if row[19] != 'NA': d.intcal09_max = row[19] if row[20] != 'NA': d.intcal09_min = row[20] if row[12] != 'NA': d.corrected_date_BP = row[12] if row[13] != 'NA': d.plus = row[13] if row[14] != 'NA': d.minus = row[14] d.save() return None # Return None to display the change list page again.
def get_date(post): return Date(post.find_all('span', class_='wi_date')[0].text)