Пример #1
0
def login():
    data = request.json

    if data:
        dataDict = json.loads(json.dumps(data))
        if 'user' in dataDict and 'pass' in dataDict:
            cnx, cur = helper.start()
            query = 'SELECT `id` FROM Client WHERE `username`=%s AND `password`=%s'
            cur.execute(query, (dataDict['user'], dataDict['pass']))
            theid = cur.fetchone()
            helper.stop(cnx, cur)

            if theid[0] > 0:
                if dataDict['booking']:
                    # deal with booking
                    cnx, cur = helper.start()
                    query = 'SELECT MAX(id) FROM Booking WHERE `client` = %s AND `start_time` >= %s'
                    cur.execute(query, (theid[0], datetime.datetime.now()))
                    ids = cur.fetchone()
                    helper.stop(cnx, cur)

                    return Response(json.dumps({'bookings': ids}),
                                    status=200,
                                    mimetype='application/json')
                else:
                    return Response(status=200)
            else:
                return helper.error()
        else:
            return helper.error()
    else:
        return helper.error()
Пример #2
0
def getNumLounger():
    con, cur = helper.start()

    cur.execute('SELECT COUNT(Lounger.id) ' 'FROM Lounger;')
    numOfLounger = cur.fetchall()

    helper.stop(cur, con)

    numOfLounger = list(numOfLounger[0])

    return numOfLounger[0]
Пример #3
0
def getLoungerInfo(id):
    con, cur = helper.start()
    chair_id = id

    cur.execute(
        'SELECT Lounger.name, Lounger.desc'
        ' FROM Lounger'
        ' WHERE Lounger.id = %s'
        ' LIMIT 1;', (chair_id, ))
    lounger_info = cur.fetchall()

    helper.stop(cur, con)

    return lounger_info[0]
def stop(logfile, errfile):
    helper.run([
        Command(
            "sudo /usr/local/nginx/sbin/nginx -s stop -c $TROOT/config/nginx.conf",
            True)
    ], logfile, errfile, os.environ['TROOT'])
    return helper.stop('unicorn', logfile, errfile)
Пример #5
0
def addCharge(booking, prices, quantities):
    con, cur = helper.start()

    #find the owner of the booking

    query = 'SELECT `Client`.`id` FROM `Client` INNER JOIN `Booking` ON `Client`.`id` = `Booking`.`client` WHERE `Booking`.`id` = %s'
    cur.execute(query, (booking, ))
    owner = cur.fetchone()[0]

    helper.stop(con, cur)

    #add the total of price[i] * quantities[i] to the owner's account
    total_charge = 0

    for i in range(0, len(prices)):
        total_charge = total_charge + (prices[i] * quantities[i])

    con, cur = helper.start()

    query = 'SELECT `spend` FROM `Client` WHERE id = %s'
    cur.execute(query, (owner, ))
    current_spend = cur.fetchone()[0]

    helper.stop(con, cur)

    total_charge = total_charge + current_spend

    con, cur = helper.start()

    query = 'UPDATE `Client` SET spend = %s WHERE `Client`.`id` = %s'
    cur.execute(query, (total_charge, owner))
    con.commit()
    helper.stop(con, cur)
Пример #6
0
def getBooked():
    con, cur = helper.start()
    current_dt = datetime.datetime.now()

    # Get Data
    cur.execute(
        'SELECT Lounger.id'
        ' FROM Booking'
        ' INNER JOIN Lounger ON Booking.lounger = Lounger.id'
        ' WHERE Booking.start_time < %s AND Booking.finish_time > %s;',
        (current_dt, current_dt))
    booking_result = cur.fetchall()

    # Close Down
    helper.stop(con, cur)

    # Turn tuple into array
    useful_results = [x for xs in booking_result for x in xs]

    print(useful_results)

    # Return array of integers
    return useful_results
Пример #7
0
def makeOrder(ids, quantities, booking):
    # Make the connection and cursor
    con, cur = helper.start()

    # Get the size of order table before the new order is added
    cur.execute('SELECT COUNT(Order.id) FROM password.Order;')

    number_before = cur.fetchone()
    number_before = number_before[0]

    helper.stop(con, cur)
    con, cur = helper.start()

    for i in range(0, len(ids)):
        query = 'INSERT INTO `Order` (booking, item, quantity) VALUES (%s, %s, %s)'
        cur.execute(query, (booking, ids[i], quantities[i]))
        con.commit()

    helper.stop(con, cur)
    con, cur = helper.start()

    # Get the size of order table after the new order is added
    cur.execute('SELECT COUNT(Order.id) FROM password.Order;')

    number_after = cur.fetchone()
    number_after = number_after[0]

    # Check th right number of orders have been added
    did_work = False
    if ((number_after - number_before) == len(ids)):
        did_work = True

    print(did_work)

    helper.stop(con, cur)

    return did_work
def stop(logfile, errfile):
  return helper.stop('trinidad', logfile, errfile)
def stop(logfile, errfile):
    return helper.stop('trinidad', logfile, errfile)
Пример #10
0
def stop(logfile, errfile):
  helper.run([Command("sudo /usr/local/nginx/sbin/nginx -s stop -c $TROOT/config/nginx.conf", True)], logfile, errfile, os.environ['TROOT'])
  return helper.stop('unicorn', logfile, errfile)
Пример #11
0
def stop(logfile, errfile):
    helper.run([Command('rm -rf tmp/*', True)], logfile, errfile,
               os.environ['TROOT'])
    return helper.stop('thin', logfile, errfile)
Пример #12
0
def stop(logfile, errfile):
    return helper.stop('puma', logfile, errfile)
Пример #13
0
def stop(logfile, errfile):
  return helper.stop('torqbox', logfile, errfile)
Пример #14
0
def stop(logfile, errfile):
    helper.run([Command("rm -rf tmp/*", True)], logfile, errfile, os.environ["TROOT"])
    return helper.stop("thin", logfile, errfile)
Пример #15
0
def stop(logfile, errfile):
    return helper.stop('torqbox', logfile, errfile)
Пример #16
0
def stop(logfile, errfile):
  helper.run([Command('rm -rf tmp/*', True)], logfile, errfile, os.environ['TROOT'])
  return helper.stop('thin', logfile, errfile)
Пример #17
0
def order():
    data = request.json

    if data:
        dataDict = json.loads(json.dumps(data))
        if 'order' in dataDict and 'booking' in dataDict:
            cnx, cur = helper.start()
            #query = 'SELECT `id` FROM Client WHERE `username`=%s AND `password`=%s'
            #cur.execute(query, (dataDict['user'], dataDict['pass']))
            #theid = cur.fetchone()
            #helper.stop(cnx, cur)

            ordered_items = []
            prices = []
            quantities = []
            for i in range(0, len(dataDict['order'])):
                query = 'SELECT `id` FROM Item WHERE `name`=%s;'
                cur.execute(query, (dataDict['order'][i]['name'], ))
                ordered_items.append(cur.fetchone()[0])

            print(ordered_items)

            helper.stop(cnx, cur)
            cnx, cur = helper.start()

            for i in range(0, len(dataDict['order'])):
                query = 'SELECT `price` FROM Item WHERE `id`=%s;'
                cur.execute(query, (ordered_items[i], ))
                prices.append(cur.fetchone()[0])

            print(prices)

            for i in range(0, len(dataDict['order'])):
                quantities.append(dataDict['order'][i]['quantity'])

            print(quantities)

            print(dataDict['booking'])

            did_work = makeOrder(ordered_items, quantities,
                                 dataDict['booking'])

            if (did_work == True):
                addCharge(dataDict['booking'], prices, quantities)
                return Response(status=200)
            else:
                return helper.error()

#           if theid[0] > 0:
#              if dataDict['booking']:
#                 # deal with booking
#                cnx, cur = helper.start()
#               query = 'SELECT MAX(id) FROM Booking WHERE `client` = %s AND `start_time` >= %s'
#              cur.execute(query, (theid[0], datetime.datetime.now()))
#             ids = cur.fetchone()
#            helper.stop(cnx, cur)

#           return Response(json.dumps({'bookings' : ids}), status=200, mimetype='application/json')
# else:
#     return Response(status=200)
#else:
#    return helper.error()
        else:
            return helper.error()
    else:
        return helper.error()
Пример #18
0
def stop(logfile, errfile):
  helper.run([Command('rm -rf tmp/*', True)], logfile, errfile, '.')  
  return helper.stop('thin', logfile, errfile)
Пример #19
0
def book():
    data = request.json

    if data:
        dataDict = json.loads(json.dumps(data))
        if 'lounger' in dataDict and 'start_time' in dataDict and 'finish_time' in dataDict and 'client' in dataDict:
            now = datetime.datetime.now()
            if datetime.datetime.strptime(
                    dataDict['start_time'],
                    "%Y-%m-%d %H:%M:%S") >= now and datetime.datetime.strptime(
                        dataDict['finish_time'],
                        "%Y-%m-%d %H:%M:%S") > datetime.datetime.strptime(
                            dataDict['start_time'], "%Y-%m-%d %H:%M:%S"):
                # Check client
                cnx, cur = helper.start()
                query = 'SELECT `id` FROM Client WHERE `id` = %s'
                cur.execute(query, (dataDict['client'], ))
                num = cur.rowcount
                cur.close()

                if num > 0:
                    # Times & Client are okay
                    # Check if the thing is free
                    cur = cnx.cursor()
                    query = 'SELECT `id` FROM Booking WHERE `start_time` <= %s AND `finish_time` >= %s'
                    cur.execute(
                        query,
                        (dataDict['start_time'], dataDict['finish_time']))
                    num = cur.rowcount
                    cur.close()

                    if num == 0 and dataDict['lounger'] > 0:
                        #Everything is good!
                        cur = cnx.cursor()
                        query = 'INSERT INTO Booking (`lounger`, `start_time`, `finish_time`, `client`) VALUES (%s, %s, %s, %s)'
                        cur.execute(
                            query,
                            (dataDict['lounger'], dataDict['start_time'],
                             dataDict['finish_time'], dataDict['client']))
                        cnx.commit()
                        cur.close()

                        # Now get the deails!
                        cur = cnx.cursor()
                        query = 'SELECT `id` FROM Booking WHERE `lounger` = %s AND `start_time` = %s AND `finish_time` = %s AND `client` = %s'
                        cur.execute(
                            query,
                            (dataDict['lounger'], dataDict['start_time'],
                             dataDict['finish_time'], dataDict['client']))
                        theid = cur.fetchone()
                        helper.stop(cnx, cur)

                        return Response(json.dumps({'booking': theid}),
                                        status=200,
                                        mimetype='application/json')
                    else:
                        print("1")
                        return helper.error()
                else:
                    print("2")
                    return helper.error()
            else:
                print("3")
                return helper.error()
        else:
            return helper.error()
    else:
        return helper.error()
Пример #20
0
def stop(logfile, errfile):
    helper.run([Command('rm -rf tmp/*', True)], logfile, errfile, '.')
    return helper.stop('thin', logfile, errfile)
Пример #21
0
def stop(logfile, errfile):
  command = Command("sudo /usr/local/nginx/sbin/nginx -c $TROOT/config/nginx.conf -s stop ", True)
  helper.run([command], logfile, errfile, '.')  
  return helper.stop('unicorn', logfile, errfile)
def stop(logfile, errfile):
  return helper.stop('puma', logfile, errfile)
def stop(logfile, errfile):
    return helper.stop("puma", logfile, errfile)