Sqllite python select query

Question

If for example I had this database:

id  result
__________
1     55
2     67

And a function isPrime(number) which returns a boolean true or false if the number is prime,

Is there anyway for me to select numbers based on if isPrime = true;

something like this..

"SELECT * FROM DB WHERE result.isPrime()"

Thanks for any help

if isPrime() is a Python function, then no, you cannot call that function inside your query because the query is executed inside the database, and there is not Python interpreter or python data types inside the database. — Ralf
– Ralf, Commented Mar 7, 2019 at 11:46
IIRC, the python sqlite bindings let you write user defined functions in Python that can be called from SQL statements. — Shawn
– Shawn, Commented Mar 7, 2019 at 12:18
The python sqlite documentation: docs.python.org/3/library/sqlite3.html — Shawn
– Shawn, Commented Mar 7, 2019 at 12:27

Shawn · Accepted Answer · 2019-03-07 12:25:01Z

2

Assuming conn is a sqlite connection object, something like:

conn.create_function("isprime", 1, isPrime)

should let you call the function in SQL statements executed by that connection.

conn.execute("SELECT * FROM db WHERE isprime(result)")

answered Mar 7, 2019 at 12:25

Shawn

53.9k3 gold badges29 silver badges74 bronze badges

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

1 Answer 1