Calculation using a sqlite db in python

Question

i've generated a database file running sqlite3 inside a python script. now i'm trying to make some calculation with the data inside the db but i'm having trouble running a loop that get a name from a txt file to help in the data range selection. anyone can help me with this please or indicate what would be the best way to make calculations with the database data.

This is what i have in the text file and i want to use the name "Candy" and Cannon's Roar as a filter for the data selection
GPB, Candy, 14 4.333 GPB, Cannon's Roar, 5

and here is what i'm trying to run

import sqlite3
import re
import sqlite3

conn = sqlite3.connect('raceinfo.db')
cursor = conn.cursor()
base = open("base/dognames.txt").read()
nome = re.findall(re.compile('(.+?), (.+?), (.+?)'),base)

for n in name:
  cursor.execute("SELECT AVG(FINALPLACE) from BASEINICIAL WHERE name =('"+str(n[1]+"')")
  print cursor.fetchone()[0]

many thanks

The select funtion doesnt work when i try the look using the ('"+str(n[1]+"')") — user3319895
– user3319895, Commented Apr 27, 2014 at 12:57
it doesnt read the above as a valid syntax. this is the error that i get — user3319895
– user3319895, Commented Apr 27, 2014 at 15:43
Traceback (most recent call last): File "<stdin>", line 1, in <module> File "upt.py", line 10 print cursor.fetchone()[0] ^ SyntaxError: invalid syntax — user3319895
– user3319895, Commented Apr 27, 2014 at 15:44

CL. · Accepted Answer · 2014-04-27 15:52:44Z

1

You forgot a closing parenthesis after n[1]:

cursor.execute("... WHERE name =('"+str(n[1])+"')")

To avoid formatting problems like this, and escaping problems when there is a name containing a quote, better use parameters:

cursor.execute("... WHERE name = ?", (n[1],))

answered Apr 27, 2014 at 15:52

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Calculation using a sqlite db in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related