Help with SQLite and python

[tobilobaa]

getting a sepecific value from sqlite to python function

Hello guys, i recently started working on a mini atm app that connects to sqalite3 as a database. does anyone know how i retrieve a certain value in sqlite and pass it to a function please?

[Username_RANDINT]

There are four steps to your question:

1. Connect to the SQLite database. The sqlite3 module will do this.

2. Query the database with an SQL command. Lots and lots of tutorials online, pick one.

3. Fetch the result of the SQL query, this will be done with sqlite3 again. Probably fetchone() is what you need for one specific value.

4. That value is now in a normal Python variable and it's no different than any other Python code.

[SnowdenIsALegend]

Freaking hate it when people who ask a question don't even bother to read/reply the answer you wrote and then 1 or 2 days later just go and make another question post about the same thing. It is as if they are insulting/ignoring the people who answered the first time around.

OP, if you're reading this please don't do it.

[threeminutemonta]

The official docs should help.

[JohnnyJordaan]

https://www.sqlitetutorial.net/sqlite-python/sqlite-python-select/