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 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)
