remove formatting from sqlite query

Question

In Python when i'm making a query to select everything from set row in sqlite, It works fine but the string that i append into a array look rather odd.

This is my array when I append the same data into my array but from at text file:

ORC
TROLL
WORGEN
DWARF

but if I try to do the same from the data i appended from my sqlite table i get this:

('ORC',)
('TROLL',)
('WORGEN',)
('DWARF',)

races = []

races = dbaction.execute("SELECT races FROM racetable;").fetchall()
for item in racetable:
  print(item)

How do I turn the print from sqlite into looking the same as the one from the text file? the problem is probably pretty simple, but i'm missing the keywords to google the answer i believe, because most posts are talking about unicode and utf-8

Vlad · Accepted Answer · 2017-06-28 09:27:00Z

1

Item is array-like, try print(item[0])

answered Jun 28, 2017 at 9:27

Vlad

6092 gold badges5 silver badges16 bronze badges

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

2 Comments

BIGFATTOBY Over a year ago

cheers that worked, what does it mean when something is array like?

Vlad Over a year ago

It means you get not a single value as a response on your request but a set of values (in each item of races array, some sort of array of arrays), so you need to address to some specific value with the index. For example you could make the SQL request like SELECT races, pilots FROM racetable and get two values in each races item. Although you requested only one value, the result is anyway an array - with one element. So, you need to address to it using index.

Bert Peters · Accepted Answer · 2017-06-28 09:28:31Z

1

SQLite returnsa tuple for every row, which makes sense when your query can return multiple columns. So to create your array, you could use:

races = [race[0] for race in dbaction.execute("SELECT races FROM racetable;").fetchall()]

using list comprehension or similar.

answered Jun 28, 2017 at 9:28

Bert Peters

1,55114 silver badges30 bronze badges

Comments

Arunesh Singh · Accepted Answer · 2017-06-28 09:26:28Z

0

Result-set from database is two-dimensional tuple. The item is tuple, so give an index for accessing any particular element.

for item in racetable:
  print (item[0])

answered Jun 28, 2017 at 9:26

Arunesh Singh

3,53521 silver badges26 bronze badges

Collectives™ on Stack Overflow

remove formatting from sqlite query

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related