You need something like : query = "select Item1,Item2,Item3, count(*) from %s where Item55 in (%s) *group by Item1,Item2,Item3*"
JG On 12 May 2012 10:24, philherna <[email protected]> wrote: > > Hi, > > > I am using sqlite commands in my python script to output data from a sqlite > database. My problem is however a Sqlite coding one. > > I can open, and select simple elements from the database easily but I have > trouble for one specific issue. > For example, to select the content of the rows Item1 , Item2 and Item3 for > which Item55 is equal to 888, I type: > > query = "select Item1,Item2,Item3, count(*) from %s where Item55 in (%s)" % > (Database,888) > c.execute(query) > results = c.fetchone() > > If I type in Python: > >> print results # I get a the unique object which satisfies Item55=888. > (0.2, 0.5, 0.9, 1) > in which the 3 first elements are the values for Item1 , Item2 and Item3, > and the last element tells me that I have done "oneobject matching the > query", i.e. the selected columns for which Item55=888. > However, i am not quite sure that I really well understand why I am > returned > this last element... > > And for instance, > >> print results[1] # gives > 0.5 # as expected > > Now, if I want to select to more objects contained in an array, I can do: > Array = [888,999] > query = "select Item1,Item2,Item3, count(*) from %s where Item55 in (%s)" % > (Database,Array) > c.execute(query) > results = c.fetchall() > > The fetchall command is supposed to return all the rows, as far as I > understand Sqlite... My problem is that i don't understand the query > results > in this case. Indeed, > >> print results # gives > (0.2, 0.5, 0.9, 2) > in which the last element tells me (again, as far as I understand ...) that > I have submitted "2 queries", i.e. selected rows for which Item55=888 and > 999. I would have expected a result to be a matrix with 2 rows, not a 1D > array... > >> print results[1][0] # gives > IndexError: list index out of range > > > Does anyone has an idea of what I am doing wrong here? > Thanks in advance ! > -- > View this message in context: > http://old.nabble.com/don%27t-understand-what-%22query%22-returns...-tp33796190p33796190.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
