示例#1
0
def module_test():
    """Run the module test"""
    try:
        # Assume office PC and just try and connect to db
        database = BarDatabase("servcinf-sql", 3306)
        through_tunnel = False
    except MySQLdb.OperationalError:
        # If not, try and create a tunnel
        from ssh_tunnel import create_tunnel, close_tunnel
        create_tunnel()
        time.sleep(1)
        database = BarDatabase("127.0.0.1", 9000)
        through_tunnel = True


    #DATABASE.insert_user(1234567890128,"test2")

    username, id_ = database.get_user('test')
    print "For barcode 'test' fetch name '{}' and id '{}'".format(username, id_)

    print "For id {} fetch sum {}".format(id_, database.sum_log(id_))

    database.cursor.execute('select * from fridays_items')
    for line in database.cursor.fetchall():
        print line

    if through_tunnel:
        close_tunnel()
        time.sleep(1)
示例#2
0
def module_test():
    """Run the module test"""
    try:
        # Assume office PC and just try and connect to db
        database = BarDatabase("servcinf-sql", 3306)
        through_tunnel = False
    except MySQLdb.OperationalError:
        # If not, try and create a tunnel
        from ssh_tunnel import create_tunnel, close_tunnel
        create_tunnel()
        time.sleep(1)
        database = BarDatabase("127.0.0.1", 9000)
        through_tunnel = True

    #DATABASE.insert_user(1234567890128,"test2")

    username, id_ = database.get_user('test')
    print "For barcode 'test' fetch name '{}' and id '{}'".format(
        username, id_)

    print "For id {} fetch sum {}".format(id_, database.sum_log(id_))

    database.cursor.execute('select * from fridays_items')
    for line in database.cursor.fetchall():
        print line

    if through_tunnel:
        close_tunnel()
        time.sleep(1)
示例#3
0
    def start_up(self):
        """Starting up initials"""
        self.picaso.clear_screen()

        # Testing demon connection
        attempt_number = 0
        while not test_demon_connection():
            self.picaso.move_cursor(2, 0)
            attempt_number += 1
            status_string = "Demon connection attempt {} failed".format(
                attempt_number)
            self.picaso.put_string(status_string)
            time.sleep(1)

        # Demon connection successful
        self.picaso.clear_screen()
        self.picaso.move_cursor(2, 0)
        status_string = "Demon connection attempt succeeded".format(
            attempt_number)
        self.picaso.put_string(status_string)

        # Create ssh tunnel
        self.picaso.move_cursor(3, 0)
        if create_tunnel():
            self.picaso.put_string('Created SSH tunnel')
        else:
            self.picaso.put_string('Unable to create SSH tunnel. Quitting!')
            time.sleep(5)
            raise SystemExit('Unable to create ssh tunnel')

        # Print network interface and ip address
        interface, ip_address = get_ip_address()
        self.picaso.move_cursor(5, 0)
        interface_string = "Interface: {}".format(interface)
        self.picaso.put_string(interface_string)
        self.picaso.move_cursor(6, 0)
        ip_address_string = "Ip address: {}".format(ip_address)
        self.picaso.put_string(ip_address_string)

        # Start the database backend
        time.sleep(1)
        for _ in range(10):
            try:
                self.bar_database = BarDatabase('127.0.0.1', 9000)
                break
            except OperationalError:
                time.sleep(1)
        self.picaso.move_cursor(7, 0)
        self.picaso.put_string('Connection to database')

        # Start barcode scanner
        dev_ = detect_barcode_device()
        print dev_
        self.tbs = ThreadedBarcodeReader(dev_)
        self.tbs.start()
        time.sleep(1)
示例#4
0
    def start_up(self):
        """Starting up initials"""
        self.picaso.clear_screen()

        # Testing demon connection
        attempt_number = 0
        while not test_demon_connection():
            self.picaso.move_cursor(2, 0)
            attempt_number += 1
            status_string = "Demon connection attempt {} failed".format(attempt_number)
            self.picaso.put_string(status_string)
            time.sleep(1)

        # Demon connection successful
        self.picaso.clear_screen()
        self.picaso.move_cursor(2, 0)
        status_string = "Demon connection attempt succeeded".format(attempt_number)
        self.picaso.put_string(status_string)

        # Create ssh tunnel
        self.picaso.move_cursor(3, 0)
        if create_tunnel():
            self.picaso.put_string('Created SSH tunnel')
        else:
            self.picaso.put_string('Unable to create SSH tunnel. Quitting!')
            time.sleep(5)
            raise SystemExit('Unable to create ssh tunnel')

        # Print network interface and ip address
        interface, ip_address = get_ip_address()
        self.picaso.move_cursor(5, 0)
        interface_string = "Interface: {}".format(interface)
        self.picaso.put_string(interface_string)
        self.picaso.move_cursor(6, 0)
        ip_address_string = "Ip address: {}".format(ip_address)
        self.picaso.put_string(ip_address_string)

        # Start the database backend
        time.sleep(1)
        for _ in range(10):
            try:
                self.bar_database = BarDatabase('127.0.0.1', 9000)
                break
            except OperationalError:
                time.sleep(1)
        self.picaso.move_cursor(7, 0)
        self.picaso.put_string('Connection to database')

        # Start barcode scanner
        dev_ = detect_barcode_device()
        print dev_
        self.tbs = ThreadedBarcodeReader(dev_)
        self.tbs.start()
        time.sleep(1)