title: Insert Values from dictionary into sqlite database
body: <p>I cannot get my head around it.
  I want to insert the values of a dictionary into a sqlite databse.</p>
  
  <pre><code>url = "https://api.flickr.com/services/rest/?method=flickr.photos.search&amp;api_key=5f...1b&amp;per_page=250&amp;accuracy=1&amp;has_geo=1&amp;extras=geo,tags,views,description"
  soup = BeautifulSoup(urlopen(url)) #soup it up
  for data in soup.find_all('photo'): #parsing the data
      dict = { #filter the data, find_all creats dictionary KEY:VALUE
          "id_p": data.get('id'),
          "title_p": data.get('title'),
          "tags_p": data.get('tags'),
          "latitude_p": data.get('latitude'),
          "longitude_p": data.get('longitude'),
      }
      #print (dict)
      connector.execute("insert into DATAGERMANY values (?,?,?,?,?)", );
      connector.commit()
  
  connector.close
  </code></pre>
  
  <p>My keys are <code>id_p</code>, <code>title_p</code> etc. and the values I retrieve through <code>data.get</code>.</p>
  
  <p>However, I cannot insert them. 
  When I try to write <code>id, title, tags, latitude, longitude</code> behind <code>...DATAGERMANY values (?,?,?,?,?)", );</code> I get 
  <code>NameError: name 'title' is not defined</code>. </p>
  
  <p>I tried it with <code>dict.values</code> and <code>dict</code> but then its saying <code>table DATAGERMANY has 6 columns but 5 values were supplied</code>. </p>
  
  <p>Adding another <code>?</code> gives me the error (with `dict.values): ValueError: parameters are of unsupported type</p>
  
  <p>This is how I created the db and table.</p>
  
  <pre><code>#creating SQLite Database and Table
  connector = sqlite3.connect("GERMANY.db") #create Database and Table, check if NOT NULL is a good idea
  connector.execute('''CREATE TABLE DATAGERMANY
          (id_db INTEGER PRIMARY KEY AUTOINCREMENT,
          id_photo INTEGER NOT NULL,
          title TEXT,
          tags TEXT,
          latitude NUMERIC NOT NULL, 
          longitude NUMERIC NOT NULL);''')
  </code></pre>
  
  <p>The method should work even if there is no <code>value</code>to fill in into the database... That can happen as well.</p>