Sqllite python select queryCalling an external command in PythonWhat are metaclasses in Python?Finding the index of an item given a list containing it in PythonDifference between append vs. extend list methods in PythonHow can I safely create a nested directory in Python?Does Python have a ternary conditional operator?How to get the current time in Python“Least Astonishment” and the Mutable Default ArgumentImprove INSERT-per-second performance of SQLite?Does Python have a string 'contains' substring method?
Print name if parameter passed to function
Is it okay / does it make sense for another player to join a running game of Munchkin?
Products and sum of cubes in Fibonacci
Why Were Madagascar and New Zealand Discovered So Late?
What would be the benefits of having both a state and local currencies?
Go Pregnant or Go Home
Applicability of Single Responsibility Principle
Where in the Bible does the greeting ("Dominus Vobiscum") used at Mass come from?
Why is delta-v is the most useful quantity for planning space travel?
There is only s̶i̶x̶t̶y one place he can be
Is expanding the research of a group into machine learning as a PhD student risky?
Ways to speed up user implemented RK4
Can a monster with multiattack use this ability if they are missing a limb?
Is exact Kanji stroke length important?
The baby cries all morning
Are there any comparative studies done between Ashtavakra Gita and Buddhim?
How will losing mobility of one hand affect my career as a programmer?
Is there an Impartial Brexit Deal comparison site?
Bash method for viewing beginning and end of file
voltage of sounds of mp3files
Can somebody explain Brexit in a few child-proof sentences?
Your magic is very sketchy
Personal Teleportation as a Weapon
Teaching indefinite integrals that require special-casing
Sqllite python select query
Calling an external command in PythonWhat are metaclasses in Python?Finding the index of an item given a list containing it in PythonDifference between append vs. extend list methods in PythonHow can I safely create a nested directory in Python?Does Python have a ternary conditional operator?How to get the current time in Python“Least Astonishment” and the Mutable Default ArgumentImprove INSERT-per-second performance of SQLite?Does Python have a string 'contains' substring method?
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
python database sqlite
asked Mar 7 at 11:43
AlexAlex
137
add a comment |
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
python database sqlite
asked Mar 7 at 11:43
AlexAlex
137
ifisPrime()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
Mar 7 at 11:46
IIRC, the python sqlite bindings let you write user defined functions in Python that can be called from SQL statements.
– Shawn
Mar 7 at 12:18
@Shawn do you know where get documentation on this?
– Alex
Mar 7 at 12:25
The python sqlite documentation: docs.python.org/3/library/sqlite3.html
– Shawn
Mar 7 at 12:27
add a comment |
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
python database sqlite
asked Mar 7 at 11:43
AlexAlex
137
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
python database sqlite
python database sqlite
asked Mar 7 at 11:43
AlexAlex
137
asked Mar 7 at 11:43
AlexAlex
137
asked Mar 7 at 11:43
AlexAlex
137
asked Mar 7 at 11:43
AlexAlex
137
asked Mar 7 at 11:43
AlexAlex
137
137
ifisPrime()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
Mar 7 at 11:46
IIRC, the python sqlite bindings let you write user defined functions in Python that can be called from SQL statements.
– Shawn
Mar 7 at 12:18
@Shawn do you know where get documentation on this?
– Alex
Mar 7 at 12:25
The python sqlite documentation: docs.python.org/3/library/sqlite3.html
– Shawn
Mar 7 at 12:27
add a comment |
ifisPrime()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
Mar 7 at 11:46
IIRC, the python sqlite bindings let you write user defined functions in Python that can be called from SQL statements.
– Shawn
Mar 7 at 12:18
@Shawn do you know where get documentation on this?
– Alex
Mar 7 at 12:25
The python sqlite documentation: docs.python.org/3/library/sqlite3.html
– Shawn
Mar 7 at 12:27
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
Mar 7 at 11:46
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
Mar 7 at 11:46
IIRC, the python sqlite bindings let you write user defined functions in Python that can be called from SQL statements.
– Shawn
Mar 7 at 12:18
IIRC, the python sqlite bindings let you write user defined functions in Python that can be called from SQL statements.
– Shawn
Mar 7 at 12:18
@Shawn do you know where get documentation on this?
– Alex
Mar 7 at 12:25
@Shawn do you know where get documentation on this?
– Alex
Mar 7 at 12:25
The python sqlite documentation: docs.python.org/3/library/sqlite3.html
– Shawn
Mar 7 at 12:27
The python sqlite documentation: docs.python.org/3/library/sqlite3.html
– Shawn
Mar 7 at 12:27
add a comment |
1 Answer
1
active
oldest
votes
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 at 12:25
ShawnShawn
4,8572614
thank you! this is just what i'm looking for
– Alex
Mar 7 at 13:53
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55042976%2fsqllite-python-select-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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 at 12:25
ShawnShawn
4,8572614
thank you! this is just what i'm looking for
– Alex
Mar 7 at 13:53
add a comment |
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 at 12:25
ShawnShawn
4,8572614
thank you! this is just what i'm looking for
– Alex
Mar 7 at 13:53
add a comment |
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 at 12:25
ShawnShawn
4,8572614
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 at 12:25
ShawnShawn
4,8572614
answered Mar 7 at 12:25
ShawnShawn
4,8572614
answered Mar 7 at 12:25
ShawnShawn
4,8572614
answered Mar 7 at 12:25
ShawnShawn
4,8572614
4,8572614
thank you! this is just what i'm looking for
– Alex
Mar 7 at 13:53
add a comment |
thank you! this is just what i'm looking for
– Alex
Mar 7 at 13:53
thank you! this is just what i'm looking for
– Alex
Mar 7 at 13:53
thank you! this is just what i'm looking for
– Alex
Mar 7 at 13:53
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55042976%2fsqllite-python-select-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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
Mar 7 at 11:46
IIRC, the python sqlite bindings let you write user defined functions in Python that can be called from SQL statements.
– Shawn
Mar 7 at 12:18
@Shawn do you know where get documentation on this?
– Alex
Mar 7 at 12:25
The python sqlite documentation: docs.python.org/3/library/sqlite3.html
– Shawn
Mar 7 at 12:27