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