test(sqlite): use context managers for sqlite connections to avoid ResourceWarning in python 3.13

test(sqlite): use context managers for sqlite connections to avoid ResourceWarning in python 3.13 #1054