Find All Tables in a SQL query with a Python Script

Question

Another way to say this is "find all substrings within a string"; while there's a bunch of these posts on stackoverflow already, none I've found quite get the job done.

#query variable
query = "select * from table1 a join table2 b on a.id = b.id left join table3 c on b.id = c.id where x = 5;"
query_list = query.split()

#find the adjacent word in a list
def find_adjacents(some_value, some_list):
    i = some_list.index(some_value)
    return some_list[i:i+2]

print('from tables:', find_adjacents("from", query_list)[1])
print('join tables:', find_adjacents("join", query_list)[1])

>>>from tables: table1
>>>join tables: table2

There should be one more join tables: table3. How do I get this to print All instances of the adjacent substring "join"?

DeveloperLV · Accepted Answer · 2020-11-13 18:35:39Z

3

Is this what you're after?

# Query variable
query = "select * from table1 a join table2 b on a.id = b.id left join table3 c on b.id = c.id where x = 5;"
query_list = query.split()

def find_adjacents(some_value, some_list):
    val = [index for index, value in enumerate(some_list) if value == some_value]

    allVal = []
    for x in val:
        allVal.append(some_list[x+1])
    return allVal

>>> print('from tables:', find_adjacents("from", query_list))
from tables: ['table1']

>>> print('join tables:', find_adjacents("join", query_list))
join tables: ['table2', 'table3']

edited Nov 13, 2020 at 18:35

answered Nov 13, 2020 at 18:23

DeveloperLV

1,8013 gold badges20 silver badges49 bronze badges

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

1 Comment

max Over a year ago

Yes sir brother (or woman!) - that's exactly what i was looking for. thank you

Collectives™ on Stack Overflow

Find All Tables in a SQL query with a Python Script

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related