python 3.7 on windows using flask and flask-sqlalchemy. - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: Web Scraping & Web Development (https://python-forum.io/forum-13.html) +--- Thread: python 3.7 on windows using flask and flask-sqlalchemy. (/thread-28558.html) |
python 3.7 on windows using flask and flask-sqlalchemy. - Alpy - Jul-23-2020 [url=https://github.com/celiao/tmdbsimple/]API used[/url] #I can't extract data from an API arrow and add it to my database @blueprintRote.route('/', methods =['GET','POST']) def post_movies(): #POST if request.method == 'POST': def search(title): search = tmdb.Search() response = search.movie(query=title) info = json.dumps(search.results) record = [] for infos in info: record.append((infos['title'], infos['release_date'], infos['popularity'])) return record m = search('The Bourne') new_user = Movies(title=m['title'], release_date=m['release_date'],popularity=m['popularity']) db.session.add(new_user) db.session.commit() return render_template('myMovies.htm')
RE: python 3.7 on windows using flask and flask-sqlalchemy. - mlieqo - Jul-23-2020 with this line: info = json.dumps(search.results)you serialize search.results to JSON formatted string and then later here:record.append((infos['title'], infos['release_date'], infos['popularity']))you try to access it's keys like it's dictionary, which causes the error shown RE: python 3.7 on windows using flask and flask-sqlalchemy. - Alpy - Aug-12-2020 def search(title): search = tmdb.Search() response = search.movie(query=title) record = [] for info in search.results: record.append(info['title']) record.append(info['release_date']) record.append(info['popularity']) return record |