def commit_houses():
trimmed_house_list = load_listing('data/trimmed_houses_alliances.json')
for house in trimmed_house_list:
house_model = House(**house)
database.session.add(house_model)
database.session.commit()
print("House data loaded")
def commit_books():
trimmed_book_list = load_listing('data/trimmed_books.json')
for book in trimmed_book_list:
# book.pop('id')
book_model = Book(**book)
database.session.add(book_model)
database.session.commit()
print("Book Data loaded.")
def commit_alliances():
trimmed_alliance_list = load_listing('data/trimmed_alliances.json')
for alliance in trimmed_alliance_list:
# alliance.pop('id')
alliance_model = Alliance(**alliance)
database.session.add(alliance_model)
database.session.commit()
print("Alliance data loaded")
def commit_charactes():
trimmed_character_list = load_listing('data/trimmed_characters.json')
char_id_set = set()
for char in trimmed_character_list:
char_id_set.add(char['id'])
# char.pop('id')
char_model = Character(**char)
# print(str(char_model.toJSON()))
database.session.add(char_model)
database.session.commit()
print("Character Data Loaded")
import json
from app.views import load_listing
trimmed_character_list = load_listing('data/trimmed_characters.json')
for char in trimmed_character_list:
if char['povBooks'] is not []:
result = []
for book in char['povBooks']:
val = int(book.split('/')[5])
result.append(val)
char['povBooks'] = result
if char['allegiances'] is not []:
result = []
for allegiance in char['allegiances']:
val = int(allegiance.split('/')[5])
result.append(val)
char['allegiances'] = result
print(str(json.dumps(trimmed_character_list)))
import urllib.request
from app.views import load_listing
char_list = load_listing('data/api_got_show/characters.json')
def getFileName(imageURl):
fileName = imageURl.split('/')[4]
return fileName
for char in char_list:
if 'imageLink' in char.keys():
# print("the characters name is: " + char['name'])
baseURl = 'https://api.got.show'
imageURl = char['imageLink']
fileName = getFileName(imageURl)
url = baseURl + imageURl
print("the url is : " + url)
urllib.request.urlretrieve(url, 'app/static/img/chars/' + fileName)
