SQL Query Adding Complex Conditions from a Table

Question

I have a long list (or a table of 3 to 4 columns of data) which simultaneously needs to be satisfied in a query, like below:

A    B   C
x1   y1  z1
x2   y2   z2
x3   y3   z3
.
.
.
xn    yn   zn

Is there a way I can create an expression/function etc or separate list etc which I can have which can be called into the SQL Query (instead of explicitly writing it):

So assuming, I have this list as a matrix/list in a table X (local) and I can use

and I can use a sample SQL query something like

SELECT *
FROM TABLE B
WHERE CONDITION  IN  ROWS OF TABLE X

Just to add here, that I am using python driver to get data via database and the table X (I have it locally on my drive) which I have is which I created locally.

. . Don't call something a table unless it is in the database. Your question is unclear. — Gordon Linoff
– Gordon Linoff, Commented Oct 12, 2018 at 16:09
What I mean was that I have the table X as a file locally on my PC. Sorry for the confusion. — Stan
– Stan, Commented Oct 12, 2018 at 16:26
To clarify the question as pointed out by Gordan: No I was not asking for the python code. I asked how can I create a compact query filter with the WHERE clause where the condition is being from a local table. Say based on the table I provided if each of the conditions in each row are met like ( x1 & y1 & z1 or x2 & y2 & z2 or x3 & y3 & z3 ..) — Stan
– Stan, Commented Oct 12, 2018 at 21:05

Dave · Accepted Answer · 2018-10-12 16:20:49Z

0

I am assuming you are asking for python code.

Using a simple in-memory SQLite db you can achieve this. See how use Sqlite db with python here. How to work with sqlite3 and Python.

Considering your example where we have list of data.

import sqlite3
connection = sqlite3.connect("company.db")

cursor = connection.cursor()

staff_data = [ ("William", "Shakespeare", "m", "1961-10-25"),
               ("Frank", "Schiller", "m", "1955-08-17"),
               ("Jane", "Wall", "f", "1989-03-14") ]

for p in staff_data:
    format_str = """INSERT INTO employee (staff_number, fname, lname, gender, birth_date)
    VALUES (NULL, "{first}", "{last}", "{gender}", "{birthdate}");"""

    sql_command = format_str.format(first=p[0], last=p[1], gender=p[2], birthdate = p[3])
    cursor.execute(sql_command)

See more here.

.

answered Oct 12, 2018 at 16:20

Dave

2991 silver badge7 bronze badges

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

1 Comment

Stan Over a year ago

No I was not asking for the python code. I asked how can I create a compact query filter with the WHERE clause where the condition is being from a local table. Say based on the table I provided if each of the conditions in each row are met like ( x1 & y1 & z1 or x2 & y2 & z2 or x3 & y3 & z3 ..)

Collectives™ on Stack Overflow

SQL Query Adding Complex Conditions from a Table

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related