added select examples

OsBlaineOra · OsBlaineOra · commit c349a58826fb · 2017-07-20T15:54:47.000-06:00
diff --git a/ruby/CRUD-examples/select/bind_variables.rb b/ruby/CRUD-examples/select/bind_variables.rb
@@ -0,0 +1,18 @@
+# Code Sample from the tutorial at https://learncodeshare.net/2016/09/09/select-crud-using-ruby-oci8/
+#  section titled "Select specific rows"
+# Using the base template, the example code executes a simple query using named bind variables,
+#  uses fetchall to retrieve the data and displays the results.
+
+require 'oci8'
+connectString = ENV['DB_CONNECT'] # The environment variable for the connect string: DB_CONNECT=user/password@database
+con = OCI8.new(connectString)
+
+# Query for Kim
+person_name = 'Kim'
+statement = 'select id, name, age, notes from lcs_people where name=:name'
+cursor = con.parse(statement)
+cursor.bind_param('name', person_name)
+cursor.exec
+cursor.fetch do |row|
+  printf "Id: %d, Name: %s, Age: %d, Notes: %s\n", row[0], row[1], row[2], row[3]
+end
diff --git a/ruby/CRUD-examples/select/extra_fun_1.rb b/ruby/CRUD-examples/select/extra_fun_1.rb
@@ -0,0 +1,15 @@
+# Code Sample from the tutorial at https://learncodeshare.net/2016/09/09/select-crud-using-ruby-oci8/
+#  section titled "Extra Fun 1"
+# Using the base template, the example code executes a simple query, uses fetchall to retrieve the data
+#  and displays the results.
+
+require 'oci8'
+connectString = ENV['DB_CONNECT'] # The environment variable for the connect string: DB_CONNECT=user/password@database
+con = OCI8.new(connectString)
+
+statement = 'select id, name, age, notes from lcs_people order by age'
+cursor = con.parse(statement)
+cursor.exec
+cursor.fetch do |row|
+  printf "Id: %d, Name: %s, Age: %d, Notes: %s\n", row[0], row[1], row[2], row[3]
+end
diff --git a/ruby/CRUD-examples/select/extra_fun_2.rb b/ruby/CRUD-examples/select/extra_fun_2.rb
@@ -0,0 +1,16 @@
+# Code Sample from the tutorial at https://learncodeshare.net/2016/09/09/select-crud-using-ruby-oci8/
+#  section titled "Extra Fun 2"
+# Using the base template, the example code executes a simple query using named bind variables,
+#  uses fetchall to retrieve the data and displays the results.
+
+require 'oci8'
+connectString = ENV['DB_CONNECT'] # The environment variable for the connect string: DB_CONNECT=user/password@database
+con = OCI8.new(connectString)
+
+statement = 'select id, name, age, notes from lcs_people where age > :age'
+cursor = con.parse(statement)
+cursor.bind_param('age', 30)
+cursor.exec
+cursor.fetch do |row|
+  printf "Id: %d, Name: %s, Age: %d, Notes: %s\n", row[0], row[1], row[2], row[3]
+end
diff --git a/ruby/CRUD-examples/select/simple.rb b/ruby/CRUD-examples/select/simple.rb
@@ -0,0 +1,17 @@
+# Code Sample from the tutorial at https://learncodeshare.net/2016/09/09/select-crud-using-ruby-oci8/
+#  section titled "Simple query"
+# Using the base template, the example code executes a simple query, uses fetchall to retrieve the data
+#  and displays the results.
+
+require 'oci8'
+connectString = ENV['DB_CONNECT'] # The environment variable for the connect string: DB_CONNECT=user/password@database
+con = OCI8.new(connectString)
+
+# Query all rows
+con = OCI8.new(connectString)
+statement = 'select id, name, age, notes from lcs_people'
+cursor = con.parse(statement)
+cursor.exec
+cursor.fetch do |row|
+  print row
+end
diff --git a/ruby/CRUD-examples/select/template.rb b/ruby/CRUD-examples/select/template.rb
@@ -0,0 +1,8 @@
+# Code Sample from the tutorial at https://learncodeshare.net/2016/09/09/select-crud-using-ruby-oci8/
+# The following code is used as the base template for the other examples.
+
+require 'oci8'
+connectString = ENV['DB_CONNECT'] # The environment variable for the connect string: DB_CONNECT=user/password@database
+con = OCI8.new(connectString)
+
+# Your code here
