Small script to demonstrate sqlite3 serialize/deserialize interface in python (>3.11rc1)

sqlite_deserialize.py

# requires python > 3.11rc1 for sqlite3.{serialize, deserialize}
import sqlite3

def serialize():
  con = sqlite3.connect(":memory:")
  cur = con.cursor()
  cur.execute("CREATE TABLE movie(title, year, score)")
  cur.execute("""
    INSERT INTO movie VALUES
         ('Monty Python and the Holy Grail', 1975, 8.2),
         ('And Now for Something Completely Different', 1971, 7.5)
  """)
  con.commit()
  res = cur.execute("SELECT score FROM movie")
  print(res.fetchall())
  bytes = con.serialize()
  f = open("sample.db", "wb")
  f.write(bytes)
  f.close()

  f = open("sample.db", "rb")
  b2 = f.read()
  f.close

  cur.execute("DROP table movie")
  con.commit()

  con.deserialize(b2)

  res = cur.execute("SELECT score FROM movie")
  print(res.fetchall())

serialize()