def handle_data():
Conn = Connection.getConnection()
cursor = Conn.cursor()
if request.form.get('type') == 'anon':
comment = request.form.get('comment')
author = "Anonymous"
query = (
"INSERT INTO posts (author, comment, date, time) VALUES (%(author)s, %(comment)s, %(date)s, %(time)s)"
)
today = datetime.now().date()
if len(str(datetime.now().minute)) == 1:
time = str(datetime.now().hour) + ":" + "0" + str(
datetime.now().minute) + ":" + str(datetime.now().second)
else:
time = str(datetime.now().hour) + ":" + str(
datetime.now().minute) + ":" + str(datetime.now().second)
data = {
'author': author,
'comment': comment,
'date': today,
'time': time
}
cursor.execute(query, data)
cursor.close()
Conn.close()
else:
user = request.form.get('user')
comment = request.form.get('comment')
query = (
"INSERT INTO posts (author, comment, date, time) VALUES (%(author)s, %(comment)s, %(date)s, %(time)s)"
)
today = datetime.now().date()
if len(str(datetime.now().minute)) == 1:
time = str(datetime.now().hour) + ":" + "0" + str(
datetime.now().minute) + ":" + str(datetime.now().second)
else:
time = str(datetime.now().hour) + ":" + str(
datetime.now().minute) + ":" + str(datetime.now().second)
data = {
'author': user,
'comment': comment,
'date': today,
'time': time
}
cursor.execute(query, data)
cursor.close()
Conn.close()
return redirect(url_for('share'))
def __init__(self, aAlgoConf, aDataDims):
"""
Construct
:return: None
"""
#instantiate class variables
self.oDB = Connection.getDB()
self.oAlgoConf = aAlgoConf
self.aDataDims = aDataDims
self.fLiveValue = 0
self.fCashValue = self.oAlgoConf["start_bal"]
self.fTradeComission= self.oAlgoConf["comission"]
self.oOpenPositions = {}
self.aTradeLog = []
self.oNewValues = {}
def share():
Conn = Connection.getConnection()
cursor = Conn.cursor()
query = ("SELECT * FROM posts ORDER BY exact DESC")
cursor.execute(query)
return render_template('share.html', posts=cursor)
def __init__(self):
self.Db_Client = Connection().Connect
Info("DB Clinet : {}".format(self.Db_Client))
def __init__(self):
"""
Construct
:return: None
"""
self.oDB = Connection.getDB()
