# For example, if I were using django, I would say:
# import adodbapi as Database
# Database.adodbapi.paramstyle = 'format'
# ------- other module level defaults --------
defaultIsolationLevel = adc.adXactReadCommitted
# Set defaultIsolationLevel on module level before creating the connection.
# For example:
# import adodbapi, ado_consts
# adodbapi.adodbapi.defaultIsolationLevel=ado_consts.adXactBrowse"
#
# Set defaultCursorLocation on module level before creating the connection.
# It may be one of the "adUse..." consts.
defaultCursorLocation = adc.adUseClient # changed from adUseServer as of v 2.3.0
dateconverter = api.pythonDateTimeConverter() # default
def format_parameters(ADOparameters, show_value=False):
"""Format a collection of ADO Command Parameters.
Used by error reporting in _execute_command.
"""
try:
if show_value:
desc = [
"Name: %s, Dir.: %s, Type: %s, Size: %s, Value: \"%s\", Precision: %s, NumericScale: %s" %\
(p.Name, adc.directions[p.Direction], adc.adTypeNames.get(p.Type, str(p.Type)+' (unknown type)'), p.Size, p.Value, p.Precision, p.NumericScale)
for p in ADOparameters ]
else:
desc = [
# For example, if I were using django, I would say:
# import adodbapi as Database
# Database.adodbapi.paramstyle = 'format'
# ------- other module level defaults --------
defaultIsolationLevel = adc.adXactReadCommitted
# Set defaultIsolationLevel on module level before creating the connection.
# For example:
# import adodbapi, ado_consts
# adodbapi.adodbapi.defaultIsolationLevel=ado_consts.adXactBrowse"
#
# Set defaultCursorLocation on module level before creating the connection.
# It may be one of the "adUse..." consts.
defaultCursorLocation = adc.adUseClient # changed from adUseServer as of v 2.3.0
dateconverter = api.pythonDateTimeConverter() # default
def format_parameters(ADOparameters, show_value=False):
"""Format a collection of ADO Command Parameters.
Used by error reporting in _execute_command.
"""
try:
if show_value:
desc = [
"Name: %s, Dir.: %s, Type: %s, Size: %s, Value: \"%s\", Precision: %s, NumericScale: %s" %\
(p.Name, adc.directions[p.Direction], adc.adTypeNames.get(p.Type, str(p.Type)+' (unknown type)'), p.Size, p.Value, p.Precision, p.NumericScale)
for p in ADOparameters ]
else:
desc = [
"Name: %s, Dir.: %s, Type: %s, Size: %s, Precision: %s, NumericScale: %s" %\