def test_str_subclass(self):
class StrSubClass(str):
pass
x = StrSubClass('test')
csub = convert(x)
cstr = convert('test')
self.assertEqual(csub, cstr)
def test_str_subclass(self):
class StrSubClass(str):
pass
x = StrSubClass('test')
csub = convert(x)
cstr = convert('test')
self.assertEqual(csub, cstr)
def execute(self, operation, parameters=None):
"""Prepare and execute a database operation (query or
command). Parameters may be provided as mapping and
will be bound to variables in the operation.
"""
if not self.connection:
self.__exception_handler(ProgrammingError, "cursor is closed")
# clear message history
self.messages = []
# convert to utf-8
operation = unicode(operation).encode('utf-8')
# set the number of rows to fetch
if self.arraysize != self.connection.replysize:
self.connection.set_replysize(self.arraysize)
if operation == self.operation:
#same operation, DBAPI mentioned something about reuse
# but monetdb doesn't support this
pass
else:
self.operation = operation
query = ""
if parameters:
if isinstance(parameters, dict):
query = operation % dict([(k, monetize.convert(v))
for (k, v) in parameters.items()])
elif type(parameters) == list or type(parameters) == tuple:
query = operation % tuple([monetize.convert(item) for item
in parameters])
elif isinstance(parameters, str):
query = operation % monetize.convert(parameters)
else:
msg = "Parameters should be None, dict or list, now it is %s"
self.__exception_handler(ValueError, msg % type(parameters))
else:
query = operation
block = self.connection.execute(query)
self.__store_result(block)
self.rownumber = 0
self.__executed = operation
return self.rowcount
def execute(self, operation, parameters=None):
"""Prepare and execute a database operation (query or
command). Parameters may be provided as mapping and
will be bound to variables in the operation.
"""
if not self.connection:
self.__exception_handler(ProgrammingError, "cursor is closed")
# clear message history
self.messages = []
# convert to utf-8
operation = unicode(operation).encode('utf-8')
# set the number of rows to fetch
if self.arraysize != self.connection.replysize:
self.connection.set_replysize(self.arraysize)
if operation == self.operation:
#same operation, DBAPI mentioned something about reuse
# but monetdb doesn't support this
pass
else:
self.operation = operation
query = ""
if parameters:
if isinstance(parameters, dict):
query = operation % dict([(k, monetize.convert(v))
for (k, v) in parameters.items()])
elif type(parameters) == list or type(parameters) == tuple:
query = operation % tuple(
[monetize.convert(item) for item in parameters])
elif isinstance(parameters, str):
query = operation % monetize.convert(parameters)
else:
msg = "Parameters should be None, dict or list, now it is %s"
self.__exception_handler(ValueError, msg % type(parameters))
else:
query = operation
block = self.connection.execute(query)
self.__store_result(block)
self.rownumber = 0
self.__executed = operation
return self.rowcount
def task():
# clear message history
self.messages = []
# set the number of rows to fetch
if self.arraysize != self.connection.replysize:
self.connection.set_replysize(self.arraysize)
if operation == self.operation:
#same operation, DBAPI mentioned something about reuse
# but monetdb doesn't support this
pass
else:
self.operation = operation
query = ""
if parameters:
if isinstance(parameters, dict):
query = operation % dict([(k, monetize.convert(v))
for (k, v) in parameters.items()
])
elif type(parameters) == list or type(parameters) == tuple:
query = operation % tuple(
[monetize.convert(item) for item in parameters])
elif isinstance(parameters, str):
query = operation % monetize.convert(parameters)
else:
msg = "Parameters should be None, dict or list, now it is %s"
self.__exception_handler(ValueError,
msg % type(parameters))
else:
query = operation
block = self.connection.execute(query)
self.__store_result(block)
self.rownumber = 0
self.__executed = operation
return self.rowcount
def task():
# clear message history
self.messages = []
# set the number of rows to fetch
if self.arraysize != self.connection.replysize:
self.connection.set_replysize(self.arraysize)
if operation == self.operation:
#same operation, DBAPI mentioned something about reuse
# but monetdb doesn't support this
pass
else:
self.operation = operation
query = ""
if parameters:
if isinstance(parameters, dict):
query = operation % dict([(k, monetize.convert(v))
for (k, v) in parameters.items()])
elif type(parameters) == list or type(parameters) == tuple:
query = operation % tuple([monetize.convert(item) for item
in parameters])
elif isinstance(parameters, str):
query = operation % monetize.convert(parameters)
else:
msg = "Parameters should be None, dict or list, now it is %s"
self.__exception_handler(ValueError, msg % type(parameters))
else:
query = operation
block = self.connection.execute(query)
self.__store_result(block)
self.rownumber = 0
self.__executed = operation
return self.rowcount
def convert(self, data):
"""
"""
return monetize.convert(data)
def convert(self, data):
"""
"""
return monetize.convert(data)
