python SQLite custom function

sqlite_custom_function.py

import sqlite3
from netaddr import IPNetwork

def is_private_ip(value):    
    return IPNetwork(value).is_private()


connection = sqlite3.connect(':memory:')
cur = connection.cursor()
cur.execute("""
CREATE TABLE ip_prefix
( id INTEGER PRIMARY KEY AUTOINCREMENT,
  prefix VARCHAR NOT NULL,
  description VARCHAR
);
""")
cur.execute('INSERT INTO ip_prefix VALUES(1,"8.8.8.8/24", "ip1")')
cur.execute('INSERT INTO ip_prefix VALUES(2,"192.168.1.1/24", "ip2")')

connection.create_function("is_private_ip", 1, is_private_ip)

if __name__ == '__main__':
    print(cur.execute('SELECT * FROM ip_prefix').fetchall())
    print(cur.execute('SELECT *, is_private_ip(prefix) FROM ip_prefix').fetchall())