def create_database(appKey, cityId):
print('create database')
db.drop_all()
db.create_all()
cinemas = getCinema(appKey, cityId)
for cinema in cinemas:
c = Cinema()
c.id = int(cinema['id'])
c.cityName = cinema['cityName']
c.cinemaName = cinema['cinemaName']
c.address = cinema['address']
c.telephone = cinema['telephone']
c.latitude = float(cinema['latitude'])
c.longitude = float(cinema['longitude'])
c.trafficRoutes = cinema['trafficRoutes']
result = getMovieByCinema(appKey, cinema['id'])
lists = result['lists']
for item in lists:
# some problem there with the api
# the item's movieId sometimes is None
m = Movie.query.get(int(item['movieId']))
if m is None:
movieId = int(item['movieId'])
movie = getMovieDetails(appKey, movieId)
# api doesn't have details of the movie
if movie == False:
m = Movie()
m.id = int(item['movieId'])
m.title = item['movieName']
m.poster = item['pic_url']
# api has the details of the movie
else:
m = Movie()
m.id = int(movie['movieid'])
m.actors = movie['actors']
m.also_known_as = movie['also_known_as']
m.country = movie['country']
m.directors = movie['directors']
m.film_locations = movie['film_locations']
m.genres = movie['genres']
m.language = movie['language']
m.plot_simple = movie['plot_simple']
m.poster = item['pic_url']
m.rating = movie['rating']
m.rating_count = movie['rating_count']
m.release_date = movie['release_date']
m.runtime = movie['runtime']
m.title = movie['title']
m.type = movie['type']
m.writers = movie['writers']
m.year = movie['year']
r = Release()
broadcasts_list = item['broadcast']
for broadcast_item in broadcasts_list:
b = Broadcast()
b.hall = broadcast_item['hall']
b.price = broadcast_item['price']
b.time = broadcast_item['time']
r.broadcasts.append(b)
db.session.add(b)
r.movie = m
c.movies.append(r)
db.session.add(r)
db.session.add(m)
db.session.add(c)
db.session.commit()
print('database create success!')
return '<h1>database update success!</h1>'
