Allow bind parameters to be specified without a leading colon. Also allow them to be specified as a symbol.

2 files changed, 13 insertions, 2 deletions

diff --git a/lib/sqlite3/statement.rb b/lib/sqlite3/statement.rb
index af26d42..0de27f1 100644
--- a/lib/sqlite3/statement.rb
+++ b/lib/sqlite3/statement.rb
@@ -129,8 +129,9 @@ module SQLite3
             @driver.bind_text( @handle, param, value )
         end
       else
-        index = @driver.bind_parameter_index(
-          @handle, param.to_s )
+        param = param.to_s
+        param = ":#{param}" unless param[0] == ?:
+        index = @driver.bind_parameter_index( @handle, param )
         raise Exception, "no such bind parameter '#{param}'" if index == 0
         bind_param index, value
       end
diff --git a/test/tc_integration.rb b/test/tc_integration.rb
index 664d216..70458b9 100644
--- a/test/tc_integration.rb
+++ b/test/tc_integration.rb
@@ -709,6 +709,16 @@ module Integration
         assert_equal 1, @stmt.execute!.length
       end
 
+      define_method( "test_bind_params_hash_without_colon" ) do
+        @stmt.bind_params "named" => 2
+        assert_equal 1, @stmt.execute!.length
+      end
+
+      define_method( "test_bind_params_hash_as_symbol" ) do
+        @stmt.bind_params :named => 2
+        assert_equal 1, @stmt.execute!.length
+      end
+
       define_method( "test_bind_params_mixed" ) do
         @stmt.bind_params( 1, ":named" => 2 )
         assert_equal 2, @stmt.execute!.length