Extracting random data from sqlite database

Python
1

There is a table named filmler in the database. I want to draw a random line from this table and print it on the screen.

import sqlite3
con = sqlite3.connect("filmler.db")
cursor= con.cursor()

def veri_cek():
    cursor.execute("select * from filmler order by RANDOM() LIMIT 1")
veri_cek=cursor.fetchall()

print(veri_cek)
con.close()

" " comes out when I write this code

where did i go wrong can you help me?

2

@def2easy SQLite RANDOM() function returns a pseudo-random integer between -9223372036854775808 and +9223372036854775807.
You will have to use the Python random modules on a list.
By the way, LIMIT 1 will give you one item in the list.

import random

veri_cek = cursor.fetchall()
print(random.choice(veri_cek))