def setUp(self,):
self.table_desc = {
'name': 'mytest',
'author': 'josuebrunel',
'apiKeyURL': 'http://josuebrunel.org/api',
'documentationURL': 'http://josuebrunel.org/doc.html',
'sampleQuery': ['SELECT * FROM mytable', 'SELECT name FROM mytable WHERE id="345"','DELETE FROM mytable WHERE id="345"'],
}
self.table = Table(**self.table_desc)
self.binder_desc = {
'name': 'select',
'itemPath': 'products.product',
'produces': 'xml'
}
self.binder = Binder(**self.binder_desc)
self.binder_insert = Binder('insert','products.product','json')
self.key_desc = {
'id': 'artist',
'type': 'xs:string',
'paramType': 'path'
}
self.key = InputKey(**self.key_desc)
self.key2 = InputKey(id='song', type='xs:string', paramType='path', required='true')
start= {'id': 'ItemPage', 'default': '1'}
pageSize= {'id':'Count' ,'max':'25'}
total= {'default': '10'}
self.paging = PagingPage(start, pageSize, total)
def test_create_table_with_two_binders(self,):
self.binder.addInput(self.key)
self.binder.addFunction('', from_file='tests_data/jscode.js')
self.table_desc['bindings'] = [self.binder, self.binder_insert]
table = Table(**self.table_desc)
logging.debug(self.xml_pretty_print(table.etree))
table.save(name='mytable', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/mytable.xml'),True)
logging.debug(self.xml_pretty_print(table.etree))
def test_create_table_with_two_binders(self, ):
self.binder.addInput(self.key)
self.binder.addFunction('', from_file='tests_data/jscode.js')
self.table_desc['bindings'] = [self.binder, self.binder_insert]
table = Table(**self.table_desc)
logging.debug(self.xml_pretty_print(table.etree))
table.save(name='mytable', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/mytable.xml'), True)
logging.debug(self.xml_pretty_print(table.etree))
def setUp(self,):
self.table_desc = {
'name': 'mytest',
'author': 'josuebrunel',
'apiKeyURL': 'http://josuebrunel.org/api',
'documentationURL': 'http://josuebrunel.org/doc.html',
'sampleQuery': ['SELECT * FROM mytable', 'SELECT name FROM mytable WHERE id="345"','DELETE FROM mytable WHERE id="345"'],
}
self.table = Table(**self.table_desc)
self.binder_desc = {
'name': 'select',
'itemPath': 'products.product',
'produces': 'xml'
}
self.binder = Binder(**self.binder_desc)
self.binder_insert = Binder('insert','products.product','json')
self.key_desc = {
'id': 'artist',
'type': 'xs:string',
'paramType': 'path'
}
self.key = InputKey(**self.key_desc)
self.key2 = InputKey(id='song', type='xs:string', paramType='path', required='true')
start= {'id': 'ItemPage', 'default': '1'}
pageSize= {'id':'Count' ,'max':'25'}
total= {'default': '10'}
self.paging = PagingPage(start, pageSize, total)
class TestTable(unittest.TestCase):
def setUp(self,):
self.table_desc = {
'name': 'mytest',
'author': 'josuebrunel',
'apiKeyURL': 'http://josuebrunel.org/api',
'documentationURL': 'http://josuebrunel.org/doc.html',
'sampleQuery': ['SELECT * FROM mytable', 'SELECT name FROM mytable WHERE id="345"','DELETE FROM mytable WHERE id="345"'],
}
self.table = Table(**self.table_desc)
self.binder_desc = {
'name': 'select',
'itemPath': 'products.product',
'produces': 'xml'
}
self.binder = Binder(**self.binder_desc)
self.binder_insert = Binder('insert','products.product','json')
self.key_desc = {
'id': 'artist',
'type': 'xs:string',
'paramType': 'path'
}
self.key = InputKey(**self.key_desc)
self.key2 = InputKey(id='song', type='xs:string', paramType='path', required='true')
start= {'id': 'ItemPage', 'default': '1'}
pageSize= {'id':'Count' ,'max':'25'}
total= {'default': '10'}
self.paging = PagingPage(start, pageSize, total)
def xml_pretty_print(self, data):
"""Pretty logging.debug xml data
"""
raw_string = xtree.tostring(data, 'utf-8')
parsed_string = minidom.parseString(raw_string)
return parsed_string.toprettyxml(indent='\t')
def test_add_binder(self,):
self.assertEqual(self.table.addBinder(self.binder),True)
logging.debug(self.xml_pretty_print(self.table.etree))
def test_remove_binder(self,):
self.binder.addInput(self.key)
self.binder_insert.addInput(self.key)
self.binder.addFunction('', from_file='tests_data/jscode.js')
self.binder_insert.addFunction("console.log('hello this is an insert function'); ")
self.table.addBinder(self.binder)
self.table.addBinder(self.binder_insert)
self.table.save(name='before', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/before.xml'),True)
self.table.removeBinder('select')
self.table.save(name='after', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/after.xml'),True)
def test_add_input_to_binder(self,):
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addInput(self.key),True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_remove_input(self,):
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addInput(self.key),True)
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addInput(self.key2),True)
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.removeInput(key_id='artist'),True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_add_function_from_file(self,):
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addFunction('', from_file='tests_data/jscode.js'),True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_remove_function(self,):
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addFunction('', from_file='tests_data/jscode.js'),True)
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.removeFunction(), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_add_paging(self,):
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addPaging(self.paging), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_create_binder_with_paging(self,):
start= {'id': 'ItemPage', 'default': '1'}
pageSize= {'id':'Count' ,'max':'25'}
total= {'default': '10'}
paging = PagingPage(start, pageSize, total)
logging.debug(self.xml_pretty_print(paging.etree))
self.binder_desc['paging']=paging
logging.debug(self.binder_desc)
binder = Binder(**self.binder_desc)
self.assertNotEqual(binder.paging,None)
logging.debug(self.xml_pretty_print(binder.etree))
def test_create_binder_with_offset_paging(self,):
start= {'id': 'ItemPage', 'default': '1'}
pageSize= {'id':'Count' ,'max':'25'}
total= {'default': '10'}
paging = PagingOffset(True, start, pageSize, total)
logging.debug(self.xml_pretty_print(paging.etree))
self.binder_desc['paging']=paging
logging.debug(self.binder_desc)
binder = Binder(**self.binder_desc)
self.assertNotEqual(binder.paging,None)
logging.debug(self.xml_pretty_print(binder.etree))
def test_create_binder_with_url_paging(self,):
nextpage = {'path': 'ysearchresponse.nextpage'}
paging = PagingUrl(nextpage)
logging.debug(self.xml_pretty_print(paging.etree))
self.binder_desc['paging']=paging
logging.debug(self.binder_desc)
binder = Binder(**self.binder_desc)
self.assertNotEqual(binder.paging,None)
logging.debug(self.xml_pretty_print(binder.etree))
def test_remove_paging(self,):
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addPaging(self.paging), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.removePaging(), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_create_binder_with_urls(self,):
url = 'http://josuebrunel.org/service/v1'
url2 = 'http://josuebrunel.org/service/v1/?name=lol'
self.binder_desc['urls'] = [url, url2]
binder = Binder(**self.binder_desc)
logging.debug(self.xml_pretty_print(binder.etree))
self.assertEqual(self.binder.addUrl(url), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_add_url(self,):
url = 'http://josuebrunel.org/service.js'
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addUrl(url), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_remove_url(self,):
url = 'http://josuebrunel.org/service.js'
url2 = 'http://google.com'
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addUrl(url), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addUrl(url2), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.removeUrl(url), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_save_file(self,):
self.table.save()
self.assertEqual(os.path.isfile('mytest.xml'),True)
def test_save_with_another_name(self):
name = "tests_data/toto"
self.table.save(name)
self.assertEqual(os.path.isfile(name+'.xml'),True)
def test_save_to_different_location(self,):
fname = "titi"
path = 'tests_data'
name = os.path.join(path,fname)
self.table.save(name=fname, path=path)
self.assertEqual(os.path.isfile(name+'.xml'),True)
def test_create_table(self,):
self.binder.addInput(self.key)
self.binder.addFunction('', from_file='tests_data/jscode.js')
logging.debug(self.xml_pretty_print(self.table.etree))
self.table.addBinder(self.binder)
self.table.save(name='mytable', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/mytable.xml'),True)
logging.debug(self.xml_pretty_print(self.table.etree))
def test_create_table_and_add_two_binders(self,):
self.binder.addInput(self.key)
self.binder_insert.addInput(self.key)
self.binder.addFunction('', from_file='tests_data/jscode.js')
self.binder_insert.addFunction("console.log('hello this is an insert function'); ")
logging.debug(self.xml_pretty_print(self.table.etree))
self.table.addBinder(self.binder)
logging.debug(self.xml_pretty_print(self.table.etree))
self.table.addBinder(self.binder_insert)
self.table.save(name='mytable', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/mytable.xml'),True)
logging.debug(self.xml_pretty_print(self.table.etree))
def test_create_table_with_binder(self,):
self.binder.addInput(self.key)
self.binder.addFunction('', from_file='tests_data/jscode.js')
self.table_desc['bindings'] = [self.binder]
table = Table(**self.table_desc)
logging.debug(self.xml_pretty_print(table.etree))
table.save(name='mytable', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/mytable.xml'),True)
logging.debug(self.xml_pretty_print(table.etree))
def test_create_table_with_two_binders(self,):
self.binder.addInput(self.key)
self.binder.addFunction('', from_file='tests_data/jscode.js')
self.table_desc['bindings'] = [self.binder, self.binder_insert]
table = Table(**self.table_desc)
logging.debug(self.xml_pretty_print(table.etree))
table.save(name='mytable', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/mytable.xml'),True)
logging.debug(self.xml_pretty_print(table.etree))
def test_add_function_table(self):
logging.debug(self.xml_pretty_print(self.table.etree))
bf = BinderFunction('concat', inputs=[self.key, self.key2])
bf.addFunction('', from_file='tests_data/jscode.js')
self.table.addBinder(bf)
#self.assertEqual(self.table.addFunction('', from_file='tests_data/jscode.js'),True)
logging.debug(self.xml_pretty_print(self.table.etree))
def test_create_function_with_func_code(self):
logging.debug(self.xml_pretty_print(self.table.etree))
bf = BinderFunction('concat', func_code='console.log("hello moron !!!")')
logging.debug(self.xml_pretty_print(bf.etree))
def test_create_function_with_func_file(self):
logging.debug(self.xml_pretty_print(self.table.etree))
bf = BinderFunction('concat', func_file='tests_data/jscode.js')
logging.debug(self.xml_pretty_print(bf.etree))
def test_remove_function_table(self,):
logging.debug(self.xml_pretty_print(self.table.etree))
self.assertEqual(self.table.addFunction('', from_file='tests_data/jscode.js'),True)
logging.debug(self.xml_pretty_print(self.table.etree))
self.assertEqual(self.table.removeFunction(),True)
logging.debug(self.xml_pretty_print(self.table.etree))
def test_baseinput_to_xml(self,):
i = BaseInput('key','name','xs:string', 'path', required=True, default='josh', private=True, maxBatchItems=10)
logging.debug(self.xml_pretty_print(i.etree))
def test_inputvalue(self,):
v = InputValue('content', 'xs:string', 'variable', required=True)
logging.debug(self.xml_pretty_print(v.etree))
def tearUp(self):
os.path.unlink('tests_data/mytest.xml')
os.path.unlink('tests_data/toto.xml')
class TestTable(unittest.TestCase):
def setUp(self, ):
self.table_desc = {
'name':
'mytest',
'author':
'josuebrunel',
'apiKeyURL':
'http://josuebrunel.org/api',
'documentationURL':
'http://josuebrunel.org/doc.html',
'sampleQuery': [
'SELECT * FROM mytable',
'SELECT name FROM mytable WHERE id="345"',
'DELETE FROM mytable WHERE id="345"'
],
}
self.table = Table(**self.table_desc)
self.binder_desc = {
'name': 'select',
'itemPath': 'products.product',
'produces': 'xml'
}
self.binder = Binder(**self.binder_desc)
self.binder_insert = Binder('insert', 'products.product', 'json')
self.key_desc = {
'id': 'artist',
'type': 'xs:string',
'paramType': 'path'
}
self.key = InputKey(**self.key_desc)
self.key2 = InputKey(id='song',
type='xs:string',
paramType='path',
required='true')
start = {'id': 'ItemPage', 'default': '1'}
pageSize = {'id': 'Count', 'max': '25'}
total = {'default': '10'}
self.paging = PagingPage(start, pageSize, total)
def xml_pretty_print(self, data):
"""Pretty logging.debug xml data
"""
raw_string = xtree.tostring(data, 'utf-8')
parsed_string = minidom.parseString(raw_string)
return parsed_string.toprettyxml(indent='\t')
def test_add_binder(self, ):
self.assertEqual(self.table.addBinder(self.binder), True)
logging.debug(self.xml_pretty_print(self.table.etree))
def test_remove_binder(self, ):
self.binder.addInput(self.key)
self.binder_insert.addInput(self.key)
self.binder.addFunction('', from_file='tests_data/jscode.js')
self.binder_insert.addFunction(
"console.log('hello this is an insert function'); ")
self.table.addBinder(self.binder)
self.table.addBinder(self.binder_insert)
self.table.save(name='before', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/before.xml'), True)
self.table.removeBinder('select')
self.table.save(name='after', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/after.xml'), True)
def test_add_input_to_binder(self, ):
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addInput(self.key), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_remove_input(self, ):
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addInput(self.key), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addInput(self.key2), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.removeInput(key_id='artist'), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_add_function_from_file(self, ):
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(
self.binder.addFunction('', from_file='tests_data/jscode.js'),
True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_remove_function(self, ):
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(
self.binder.addFunction('', from_file='tests_data/jscode.js'),
True)
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.removeFunction(), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_add_paging(self, ):
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addPaging(self.paging), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_create_binder_with_paging(self, ):
start = {'id': 'ItemPage', 'default': '1'}
pageSize = {'id': 'Count', 'max': '25'}
total = {'default': '10'}
paging = PagingPage(start, pageSize, total)
logging.debug(self.xml_pretty_print(paging.etree))
self.binder_desc['paging'] = paging
logging.debug(self.binder_desc)
binder = Binder(**self.binder_desc)
self.assertNotEqual(binder.paging, None)
logging.debug(self.xml_pretty_print(binder.etree))
def test_create_binder_with_offset_paging(self, ):
start = {'id': 'ItemPage', 'default': '1'}
pageSize = {'id': 'Count', 'max': '25'}
total = {'default': '10'}
paging = PagingOffset(True, start, pageSize, total)
logging.debug(self.xml_pretty_print(paging.etree))
self.binder_desc['paging'] = paging
logging.debug(self.binder_desc)
binder = Binder(**self.binder_desc)
self.assertNotEqual(binder.paging, None)
logging.debug(self.xml_pretty_print(binder.etree))
def test_create_binder_with_url_paging(self, ):
nextpage = {'path': 'ysearchresponse.nextpage'}
paging = PagingUrl(nextpage)
logging.debug(self.xml_pretty_print(paging.etree))
self.binder_desc['paging'] = paging
logging.debug(self.binder_desc)
binder = Binder(**self.binder_desc)
self.assertNotEqual(binder.paging, None)
logging.debug(self.xml_pretty_print(binder.etree))
def test_remove_paging(self, ):
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addPaging(self.paging), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.removePaging(), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_create_binder_with_urls(self, ):
url = 'http://josuebrunel.org/service/v1'
url2 = 'http://josuebrunel.org/service/v1/?name=lol'
self.binder_desc['urls'] = [url, url2]
binder = Binder(**self.binder_desc)
logging.debug(self.xml_pretty_print(binder.etree))
self.assertEqual(self.binder.addUrl(url), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_add_url(self, ):
url = 'http://josuebrunel.org/service.js'
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addUrl(url), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_remove_url(self, ):
url = 'http://josuebrunel.org/service.js'
url2 = 'http://google.com'
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addUrl(url), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.addUrl(url2), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
self.assertEqual(self.binder.removeUrl(url), True)
logging.debug(self.xml_pretty_print(self.binder.etree))
def test_save_file(self, ):
self.table.save()
self.assertEqual(os.path.isfile('mytest.xml'), True)
def test_save_with_another_name(self):
name = "tests_data/toto"
self.table.save(name)
self.assertEqual(os.path.isfile(name + '.xml'), True)
def test_save_to_different_location(self, ):
fname = "titi"
path = 'tests_data'
name = os.path.join(path, fname)
self.table.save(name=fname, path=path)
self.assertEqual(os.path.isfile(name + '.xml'), True)
def test_create_table(self, ):
self.binder.addInput(self.key)
self.binder.addFunction('', from_file='tests_data/jscode.js')
logging.debug(self.xml_pretty_print(self.table.etree))
self.table.addBinder(self.binder)
self.table.save(name='mytable', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/mytable.xml'), True)
logging.debug(self.xml_pretty_print(self.table.etree))
def test_create_table_and_add_two_binders(self, ):
self.binder.addInput(self.key)
self.binder_insert.addInput(self.key)
self.binder.addFunction('', from_file='tests_data/jscode.js')
self.binder_insert.addFunction(
"console.log('hello this is an insert function'); ")
logging.debug(self.xml_pretty_print(self.table.etree))
self.table.addBinder(self.binder)
logging.debug(self.xml_pretty_print(self.table.etree))
self.table.addBinder(self.binder_insert)
self.table.save(name='mytable', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/mytable.xml'), True)
logging.debug(self.xml_pretty_print(self.table.etree))
def test_create_table_with_binder(self, ):
self.binder.addInput(self.key)
self.binder.addFunction('', from_file='tests_data/jscode.js')
self.table_desc['bindings'] = [self.binder]
table = Table(**self.table_desc)
logging.debug(self.xml_pretty_print(table.etree))
table.save(name='mytable', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/mytable.xml'), True)
logging.debug(self.xml_pretty_print(table.etree))
def test_create_table_with_two_binders(self, ):
self.binder.addInput(self.key)
self.binder.addFunction('', from_file='tests_data/jscode.js')
self.table_desc['bindings'] = [self.binder, self.binder_insert]
table = Table(**self.table_desc)
logging.debug(self.xml_pretty_print(table.etree))
table.save(name='mytable', path='tests_data')
self.assertEqual(os.path.isfile('tests_data/mytable.xml'), True)
logging.debug(self.xml_pretty_print(table.etree))
def test_add_function_table(self):
logging.debug(self.xml_pretty_print(self.table.etree))
bf = BinderFunction('concat', inputs=[self.key, self.key2])
bf.addFunction('', from_file='tests_data/jscode.js')
self.table.addBinder(bf)
#self.assertEqual(self.table.addFunction('', from_file='tests_data/jscode.js'),True)
logging.debug(self.xml_pretty_print(self.table.etree))
def test_create_function_with_func_code(self):
logging.debug(self.xml_pretty_print(self.table.etree))
bf = BinderFunction('concat',
func_code='console.log("hello moron !!!")')
logging.debug(self.xml_pretty_print(bf.etree))
def test_create_function_with_func_file(self):
logging.debug(self.xml_pretty_print(self.table.etree))
bf = BinderFunction('concat', func_file='tests_data/jscode.js')
logging.debug(self.xml_pretty_print(bf.etree))
def test_remove_function_table(self, ):
logging.debug(self.xml_pretty_print(self.table.etree))
self.assertEqual(
self.table.addFunction('', from_file='tests_data/jscode.js'), True)
logging.debug(self.xml_pretty_print(self.table.etree))
self.assertEqual(self.table.removeFunction(), True)
logging.debug(self.xml_pretty_print(self.table.etree))
def test_baseinput_to_xml(self, ):
i = BaseInput('key',
'name',
'xs:string',
'path',
required=True,
default='josh',
private=True,
maxBatchItems=10)
logging.debug(self.xml_pretty_print(i.etree))
def test_inputvalue(self, ):
v = InputValue('content', 'xs:string', 'variable', required=True)
logging.debug(self.xml_pretty_print(v.etree))
def tearUp(self):
os.path.unlink('tests_data/mytest.xml')
os.path.unlink('tests_data/toto.xml')