Python Forum
python 3.7 on windows using flask and flask-sqlalchemy.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
python 3.7 on windows using flask and flask-sqlalchemy.
#1
[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')
Error:
File "c:\users\alefg\projects\mytop100movies\venv\lib\site-packages\flask\app.py", line 1936, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "C:\Users\alefg\projects\MyTop100Movies\src\blueprint\blueprintsRoutes.py", line 21, in post_movies m = search('The Bourne') File "C:\Users\alefg\projects\MyTop100Movies\src\blueprint\blueprintsRoutes.py", line 18, in search record.append((infos['title'], infos['release_date'], infos['popularity'])) TypeError: string indices must be integers
Reply
#2
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
Reply
#3
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Flask_table module compatibility issue: cannot import name 'Markup' from 'flask' venkateshbalagiri 1 177 Mar-22-2024, 05:07 AM
Last Post: venkateshbalagiri
Shocked FLASK confuse LennyKiz 1 482 Nov-05-2023, 04:23 PM
Last Post: Axel_Erfurt
  Flask - use bootstrap styles in HTML Krayna 1 1,004 Aug-29-2023, 02:33 PM
Last Post: menator01
  Flask CORS not functioning michaelnicol 1 1,313 Jul-02-2023, 05:04 PM
Last Post: michaelnicol
  Flask & Files Gilush 1 1,662 Apr-07-2023, 08:23 AM
Last Post: SpongeB0B
  Flask: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked pythonpaul32 1 2,029 Apr-04-2023, 07:44 AM
Last Post: Larz60+
  Flask error sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint pythonpaul32 2 3,492 Feb-21-2023, 03:13 AM
Last Post: noisefloor
  flask.cli.NoAppException: Could not import 'app' kazu755 4 4,599 Feb-19-2023, 01:50 PM
Last Post: Larz60+
  Flask and SQLAlchemy question: Database is being created but tables aren't adding pythonpaul32 3 4,414 Feb-07-2023, 10:48 AM
Last Post: pythonpaul32
  REST API using flask - limit connection? korenron 1 1,210 Feb-05-2023, 06:48 PM
Last Post: noisefloor

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020