Robot at 16:49, 9 June 2024

2024-06-09T16:49:46Z

Robot: Created page with "Return back to project page: Door camera - Jakub Vojtek Python code for the Database Reader: impo..."

2024-06-09T16:48:19Z

Created page with "Return back to project page: Door camera - Jakub Vojtek Python code for the Database Reader: <syntaxhighlight lang=python> impo..."

New page

Return back to project page: [[Spike Prime - Door camera - Jakub Vojtek| Door camera - Jakub Vojtek]]

Python code for the Database Reader:
<syntaxhighlight lang=python>
import sqlite3

# Connect to the SQLite database
conn = sqlite3.connect('database/face_images.db')
c = conn.cursor()

def print_data():
c.execute('SELECT * FROM images')
rows = c.fetchall()
for row in rows:
print(row)

def delete_data_with_no_faces():
c.execute('DELETE FROM images WHERE detected_faces = 0')

conn.close()

</syntaxhighlight>

@@ Line 4: / Line 4: @@
 <syntaxhighlight lang=python>
 import sqlite3
 def print_data():
-     c.execute('SELECT * FROM images')
+     with sqlite3.connect('database/face_images.db') as conn:
-    rows = c.fetchall()
+        c = conn.cursor()
-    for row in rows:
+        c.execute('SELECT * FROM images')
-        print(row)
+        rows = c.fetchall()
+        for row in rows:
 def delete_data_with_no_faces():
-     c.execute('DELETE FROM images WHERE detected_faces = 0')
+     with sqlite3.connect('database/face_images.db') as conn:
 </syntaxhighlight>

Database Reader - Code - Revision history

Robot at 16:49, 9 June 2024

Robot: Created page with "Return back to project page: Door camera - Jakub Vojtek Python code for the Database Reader: impo..."