changeset 1845:a185f432d94c

improve Sql
author Franklin Schmidt <fschmidt@gmail.com>
date Tue, 04 Feb 2025 20:55:21 -0700
parents 9147ce7f5b72
children 695a73e060a4
files src/luan/modules/sql/Sql.luan
diffstat 1 files changed, 9 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/src/luan/modules/sql/Sql.luan	Sun Feb 02 04:55:02 2025 -0700
+++ b/src/luan/modules/sql/Sql.luan	Tue Feb 04 20:55:21 2025 -0700
@@ -30,6 +30,7 @@
 	database.is_closed = java_database.con.isClosed
 	database.update = java_database.update
 	database.set = java_database.set
+	database.commit = java_database.con.commit;
 
 	function database.query(sql,...)
 		local rs = java_database.query(sql,...)
@@ -66,6 +67,14 @@
 		return query
 	end
 
+	function database.run(fn)
+		try
+			return fn()
+		finally
+			database.close()
+		end
+	end
+
 	return database
 end