import random
from pymongo import MongoClient

mc = MongoClient("mongodb://localhost:27017")
db = mc['starwars']
collections = db.list_collection_names()

episode = input("What episode do you care about? (I-to-IX) ")
chars = list(db.c.find({'episodes':episode}, {'name':1, '_id':0}))

print(f"Here are the characters in episode {episode}:")
for i,char in enumerate(chars, start=1):
    print(f"{i}) {char['name']}")
char_num = int(input("Which character are you interested in? "))

char_name = chars[char_num - 1]['name']

print(f"Oh, I just love {char_name} too!")

char = db.c.find_one({'name':char_name}, {'_id':0})
if 'demeanor' in char:
    print(f"{char['name']} is a {char['demeanor']} {char['race']}.")
elif 'race' in char:
    print(f"{char['name']} is a {char['race']}.")
else:
    print(f"{char['name']} is somebody special.")

gabe = char.keys() - {'name','race','demeanor','episodes'}
rproperty = random.choice(list(gabe))
rproperty = "relations"
rvalue = char[rproperty]
print(f"Fun fact about {char['name']}: their {rproperty} is {rvalue}.")