Add comment to each sample indicating minimum version of cx_Oracle that is

anthony-tuininga · anthony-tuininga · commit 550d326c6820 · 2017-03-20T11:11:25.000-06:00
required in order to run it.
diff --git a/samples/AdvancedQueuing.py b/samples/AdvancedQueuing.py
@@ -11,6 +11,8 @@
 # AdvancedQueuing.py
 #   This script demonstrates how to use advanced queuing using cx_Oracle. It
 # creates a simple type and enqueues and dequeues a few objects.
+#
+# This script requires cx_Oracle 5.3 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/AppContext.py b/samples/AppContext.py
@@ -12,6 +12,8 @@
 #   This script demonstrates the use of application context. Application
 # context is available within logon triggers and can be retrieved by using the
 # function sys_context().
+#
+# This script requires cx_Oracle 5.3 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/DRCP.py b/samples/DRCP.py
@@ -24,6 +24,8 @@
 #
 # There is no difference in how a connection is used once it has been
 # established.
+#
+# This script requires cx_Oracle 5.0 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/DatabaseChangeNotification.py b/samples/DatabaseChangeNotification.py
@@ -13,6 +13,8 @@
 # feature that is available in Oracle 10g Release 2. Once this script is
 # running, use another session to insert, update or delete rows from the table
 # cx_Oracle.TestTempTable and you will see the notification of that change.
+#
+# This script requires cx_Oracle 5.3 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/DatabaseShutdown.py b/samples/DatabaseShutdown.py
@@ -12,6 +12,8 @@
 #   This script demonstrates shutting down a database using Python. It is only
 # possible in Oracle 10g Release 2 and higher. The connection used assumes that
 # the environment variable ORACLE_SID has been set.
+#
+# This script requires cx_Oracle 4.3 and higher.
 #------------------------------------------------------------------------------
 
 import cx_Oracle
diff --git a/samples/DatabaseStartup.py b/samples/DatabaseStartup.py
@@ -12,6 +12,8 @@
 #   This script demonstrates starting up a database using Python. It is only
 # possible in Oracle 10g Release 2 and higher. The connection used assumes that
 # the environment variable ORACLE_SID has been set.
+#
+# This script requires cx_Oracle 4.3 and higher.
 #------------------------------------------------------------------------------
 
 import cx_Oracle
diff --git a/samples/Editioning.py b/samples/Editioning.py
@@ -13,6 +13,8 @@
 # Database 11.2 and higher. See the Oracle documentation on the subject for
 # additional information. Adjust the contants at the top of the script for
 # your own database as needed.
+#
+# This script requires cx_Oracle 5.3 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/ImplicitResults.py b/samples/ImplicitResults.py
@@ -12,6 +12,8 @@
 #   This script demonstrates the use of the 12.1 feature that allows PL/SQL
 # procedures to return result sets implicitly, without having to explicitly
 # define them.
+#
+# This script requires cx_Oracle 5.3 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/InsertGeometry.py b/samples/InsertGeometry.py
@@ -11,6 +11,8 @@
 # InsertGeometry.py
 #   This script demonstrates the ability to create Oracle objects (this example
 # uses SDO_GEOMETRY) and insert them into a table.
+#
+# This script requires cx_Oracle 5.3 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/QueryChangeNotification.py b/samples/QueryChangeNotification.py
@@ -13,6 +13,8 @@
 # feature that is available in Oracle 11g. Once this script is running, use
 # another session to insert, update or delete rows from the table
 # cx_Oracle.TestTempTable and you will see the notification of that change.
+#
+# This script requires cx_Oracle 5.3 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/ReturnLongs.py b/samples/ReturnLongs.py
@@ -13,6 +13,8 @@
 # is only useful if the lengths of the CLOB and BLOB values are well known but
 # it can improve performance because there is no need to return to the database
 # to get the actual values.
+#
+# This script requires cx_Oracle 5.0 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/ReturnUnicode.py b/samples/ReturnUnicode.py
@@ -11,6 +11,8 @@
 # ReturnUnicode.py
 #   Returns all strings as unicode. This also demonstrates the use of an output
 # type handler to change the way in which data is returned from a cursor.
+#
+# This script requires cx_Oracle 5.0 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/RowsAsInstance.py b/samples/RowsAsInstance.py
@@ -12,6 +12,8 @@
 #   Returns rows as instances instead of tuples. See the ceDatabase.Row class
 # in the cx_PyGenLib project (http://cx-pygenlib.sourceforge.net) for a more
 # advanced example.
+#
+# This script requires cx_Oracle 4.3 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/ScrollableCursors.py b/samples/ScrollableCursors.py
@@ -12,6 +12,8 @@
 #   This script demonstrates how to use scrollable cursors. These allow moving
 # forward and backward in the result set but incur additional overhead on the
 # server to retain this information.
+#
+# This script requires cx_Oracle 5.3 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/TransactionGuard.py b/samples/TransactionGuard.py
@@ -30,6 +30,7 @@
 #     end;
 #     /
 #
+# This script requires cx_Oracle 5.3 and higher.
 #------------------------------------------------------------------------------
 
 from __future__ import print_function
diff --git a/samples/TypeHandlers.py b/samples/TypeHandlers.py
@@ -13,6 +13,8 @@
 # as variable input and output converters. These methods can be used to extend
 # cx_Oracle in many ways. This script demonstrates the binding and querying of
 # SQL objects as Python objects.
+#
+# This script requires cx_Oracle 5.0 and higher.
 #------------------------------------------------------------------------------
 
 

Original file line number	Diff line number	Diff line change
`@@ -24,6 +24,8 @@`
`24`	`24`	`#`
`25`	`25`	`# There is no difference in how a connection is used once it has been`
`26`	`26`	`# established.`
	`27`	`+#`
	`28`	`+# This script requires cx_Oracle 5.0 and higher.`
`27`	`29`	`#------------------------------------------------------------------------------`
`28`	`30`
`29`	`31`	`from __future__ import print_function`