booksort_in, moviews_in, moviesort_in, gamesws_in, gamesort_in, force=False):

while True:

if not force:

if (local_in or (ip_in and username_in and key_in)) and file_in and level_in:

if (bookws_in and booksort_in) or (not booksort_in and not bookws_in):

if(gamesws_in and gamesort_in) or (not gamesort_in and not gamesws_in):

if(moviews_in and moviesort_in) or (not moviesort_in and not moviews_in):

return [file_path, local_in, ip_in, username_in, key_in, file_in, level_in, token_in,

bookws_in, booksort_in, moviews_in, moviesort_in, gamesws_in, gamesort_in]

print("Lets go through the settings")

print("Where would you like the spreadsheet, logs, and information files stored")

file_path_in = input("Enter the path to save files (C:\\Users\\Demo\\Desktop) [" + str(file_path_in) + "]: "

or file_path_in)

print("Local mode lets everything run on this machine, if false we need an IP address of server, username,"

" and key")

local_in = bool(input("Local mode? True or False [" + str(local_in) + "]: ") or local_in)

if not local_in:

print("Since we are not in local mode, we will need the IP address of the server (ex 192.168.1.1)")

ip_in = (input("Enter the servers IP address [" + str(ip_in) + "]: ") or ip_in)

print("We will need the username that can be used to ssh into the server")

username_in = (input("Enter the username [" + str(username_in) + "]: ") or username_in)

print("We only allow a keyfile to ssh in, please provide the full path to the key")

key_in = (input("Enter the path to the ssh key [" + str(key_in) + "]: ") or key_in)

if local_in:

print("If you would like, you can specify an IP address of a server in case "

"you want to switch out of local mode in the future")

ip_in = (input("Enter the servers IP address [" + str(ip_in) + "]: ") or ip_in)

print("We will need the username that can be used to ssh into the server")

username_in = (input("Enter the username [" + str(username_in) + "]: ") or username_in)

print("We only allow a keyfile to ssh in, please provide the full path to the key")

key_in = (input("Enter the path to the ssh key [" + str(key_in) + "]: ") or key_in)

print("We will also require the file name of the workbook, this is required even if uploading to"

" dropbox")

file_in = (input("Enter the excel workbook name [" + str(file_in) + "]: ") or file_in)

print("We also require the log level to be used, if you aren't sure, type in 'INFO'")

level_in = (input("Enter the log level [" + str(level_in) + "]: ") or level_in)

print("If this database stores books, we will require the name of the worksheet, if you are not storing books, "

"please leave blank")

bookws_in = (input("If you will be storing books, enter the name of the Book Worksheet or leave blank [" +

str(bookws_in) + "]: ") or bookws_in)

if bookws_in:

print("Since we will be storing books, enter how you would like to sort books in reverse sort order "

"(start with the least significant column)")

print("Possible columns are: Author, Title, Series, ISBN, Location, Condition, Borrowed By, Date Borrowed")

if booksort_in:

booksort_in = (input("Enter the sort order in a comma separated list in reverse order [" +

','.join(map(str, booksort_in)) + "]: ") or ','.join(map(str, booksort_in)))

else:

booksort_in = (input("Enter the sort order in a comma separated list in reverse order "

"[Author,Series,Title]: ") or "Author,Series,Title")

moviews_in = (input("If you will be storing movies, enter the name of the Movie Worksheet or leave blank [" +

str(moviews_in) + "]: ") or moviews_in)

if moviews_in:

print("Since we will be storing movies, enter how you would like to sort movies in reverse sort order "

"(start with the least significant column)")

print("Possible columns are: Title, Series, UPC, Format, Borrowed By, Date Borrowed")

if moviesort_in:

moviesort_in = (input("Enter the sort order in a comma separated list in reverse order [" +

','.join(map(str, moviesort_in)) + "]: ") or ','.join(map(str, moviesort_in)))

else:

moviesort_in = (input("Enter the sort order in a comma separated list in reverse order "

"[Title]: ") or "Title")

gamesws_in = (input("If you will be storing games, enter the name of the Game Worksheet or leave blank [" +

str(gamesws_in) + "]: ") or gamesws_in)

if gamesws_in:

print("Since we will be storing games, enter how you would like to sort games in reverse sort order "

"(start with the least significant column)")

print("Possible columns are: Title, Platform, UPC, Borrowed By, Date Borrowed")

if gamesort_in:

gamesort_in = (input("Enter the sort order in a comma separated list in reverse order [" +

','.join(map(str, gamesort_in)) + "]: ") or ','.join(map(str, gamesort_in)))

else:

gamesort_in = (input("Enter the sort order in a comma separated list in reverse order "

"[Title,Format]: ") or "Title,Format")

print("If you would like to upload the file to dropbox you will need to provide an access token, this is"

" optional")

token_in = (input("Enter the dropbox token [" + str(token_in) + "]: ") or token_in)

settings_in = open("db.conf", "w")

logging.info("Writing path = %s to db.conf", file_path_in)

settings_in.write("path = " + str(file_path_in) + '\n')

if file_path_in is not "":

settings_in.close()

settings_in = open(file_path+"db.conf", 'w')

logging.info("Writing local = %s to db.conf", local_in)

settings_in.write("local = " + str(local_in) + '\n')

if bookws_in and booksort_in:

logging.info("Writing bookWS = %s bookSort = %s to db.conf", bookws_in, ','.join(map(str, booksort_in)))

settings_in.write("bookWS = " + bookws_in + '\n')

settings_in.write("bookSort = " + booksort_in + '\n')

if moviews_in and moviesort_in:

logging.info("Writing movieWS = %s movieSort = %s to db.conf", moviews_in, ','.join(map(str, moviesort_in)))

settings_in.write("movieWS = " + moviews_in + '\n')

settings_in.write("movieSort = " + moviesort_in + '\n')

if gamesws_in and gamesort_in:

logging.info("Writing gameWS = %s gameSort = %s to db.conf", gamesws_in, ','.join(map(str, gamesort_in)))

settings_in.write("gameWS = " + gamesws_in + '\n')

settings_in.write("gameSort = " + gamesort_in + '\n')

if ip_in:

logging.info("Writing ip = %s to db.conf", ip_in)

settings_in.write("ip = " + ip_in + '\n')

if username_in:

logging.info("Writing user = %s to db.conf", username_in)

settings_in.write("user = " + username_in + '\n')

if key_in:

logging.info("Writing key = %s to db.conf", key_in)

settings_in.write("key = " + key_in + '\n')

if file_in:

logging.info("Writing file = %s to db.conf", file_in)

settings_in.write("file = " + file_in + '\n')

if level_in:

logging.info("Writing logLevel = %s to db.conf", level_in)

settings_in.write("logLevel = " + level_in + '\n')

if token_in:

logging.info("Writing dropboxToken = %s to db.conf", token_in)

settings_in.write("dropboxToken = " + token_in + '\n')

settings_in.close()

active_worksheet = mt_wb.ws

my_logging = logging.getLogger("ThreadManager")

my_logging.info("Thread Manager has started")

blank = False

# Used to track running sub threads

running = []

result = []

previous = None

# noinspection PyBroadException

try:

while True:

my_logging.debug("Thread Manager is listening")

# Blocking call for the next input

entry = upc_queue.get()

my_logging.debug("Received input %s", entry)

# If the input is numeric assume it's a upc and do a search

if entry.isnumeric():

my_logging.info("Searching for %s", entry)

# spawn a new thread to add book to database

running.append(

future.ThreadPoolExecutor(thread_name_prefix='lookup ' + entry).submit(

active_worksheet.add_entry, ssh_client, entry))

# if the input is the word exit then close all threads and exit

elif entry == "exit":

my_logging.debug("Waiting on metadata to finish")

# wait on all threads in running to finish

for j, x in enumerate(running):

while len(result) - 1 < j:

result.append(None)

result[j] = x.result()

my_logging.debug("Checking for blanks before exiting")

if active_worksheet.incomplete(result, previous):

blank = True

my_logging.debug("Thread Manager is Exiting")

return blank

# After every new input check if the length of running is > 9 if it is

if len(running) > 9:

# save workbook before adding new threads

my_logging.debug("Background Saving")

for j, x in enumerate(running):

while len(result) - 1 < j:

result.append(None)

result[j] = x.result()

my_logging.debug("Checking for blanks before continuing")

if active_worksheet.ws.incomplete(result, previous):

blank = True

previous = result[len(result) - 1]

active_worksheet.save()

running = []

result = []

except Exception as exc_inst:

# Sanity check, manage Thread should never reach here

my_logging.critical("manageThread left while loop, error is %s", exc_inst)

print("Critical Error, manager has failed\nError is:\a", exc_inst)

my_logging.critical("Traceback is %s", traceback.format_exc())