How to convert sql query to list?

Question

I am trying to convert my sql query output into a list to look a certain way.

Here is my code:

def get_sf_metadata():

    import sqlite3
    #Tables I want to be dynamically created
    table_names=['AcceptedEventRelation','Asset', 'Book']

    #SQLIte Connection
    conn = sqlite3.connect('aaa_test.db')
    c = conn.cursor()

    #select the metadata table records
    c.execute("select  name, type from sf_field_metadata1  limit 10 ")
    print(list(c))


get_sf_metadata()

Here is my output:

[('Id', 'id'), ('RelationId', 'reference'), ('EventId', 'reference')]

Is there any way to make the output looks like this:

[Id id, RelationId reference, EventId  reference]

Leo Arad · Accepted Answer · 2020-04-20 04:19:09Z

1

You can try

print(["{} {}".format(i[0], i[1]) for i in list(c)])

That will print you

['Id id', 'RelationId reference', 'EventId reference']

answered Apr 20, 2020 at 4:19

Leo Arad

4,4822 gold badges8 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to convert sql query to list?

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