From: Alexis Laferrière <alexis.laf@xymus.net>
Date: Thu, 24 Jul 2014 00:40:03 +0000 (-0400)
Subject: lib/sqlite3: add the service `String::to_sql_string`
X-Git-Tag: v0.6.7~8^2~8
X-Git-Url: http://nitlanguage.org

lib/sqlite3: add the service `String::to_sql_string`

Signed-off-by: Alexis Laferrière <alexis.laf@xymus.net>
---

diff --git a/lib/sqlite3/sqlite3.nit b/lib/sqlite3/sqlite3.nit
index d194362..6856d9d 100644
--- a/lib/sqlite3/sqlite3.nit
+++ b/lib/sqlite3/sqlite3.nit
@@ -290,7 +290,17 @@ interface Sqlite3Data end
 
 redef universal Int super Sqlite3Data end
 redef universal Float super Sqlite3Data end
-redef class String super Sqlite3Data end
+redef class String
+	super Sqlite3Data
+
+	# Return `self` between `'`s and escaping any extra `'`
+	#
+	#     assert "'; DROP TABLE students".to_sql_string == "'''; DROP TABLE students'"
+	fun to_sql_string: String
+	do
+		return "'{self.replace('\'', "''")}'"
+	end
+end
 
 # A Sqlite3 blob
 class Blob