fukamachi / mito / 287

72%

master: 72%

Pull #53

travis-ci

Free query resources after use

Introduce a macro WITH-PREPARED-QUERY. Given a connection and sql statement, it
prepares a statement, binds it to desired name, executes the body, and then
cleans up the query with an UNWIND-PROTECT.

Replaced all calls to DBI:PREPARE with the equivalent WITH-PREPARED-BODY.

This helps prevent unused resources from piling up. As an example, cl-sqlite
finalizes all queries when the database connection is closed. In a program that
connects, performs millions of queries, and then disconnects, the disconnect
will take a ridiculous amount of time to perform if the resources are not freed
immediately after use.

209 of 209 new or added lines in 5 files covered. (100.0%)

1679 of 2345 relevant lines covered (71.6%)

0.72 hits per line