def test_t46():
args = {
'connection_info': {
"type": "mysql",
"host": "localhost",
"namespace": "testtest",
"user": "******",
"password": "******",
"port": 3306
},
"tablename":
"test_all_datatypes",
"select_fields": ["id", "name"],
"limit":
"5",
"offset":
"20",
"order_by":
"id",
"filter": [{
"operand": "id",
"operator": ">",
"value": 10
}, {
"operand": "is_active",
"operator": "=",
"value": True
}]
}
datastorex.select(args)
def test_t64():
args = {
'connection_info': {
"type": "mysql",
"host": "localhost",
"namespace": "testtest",
"user": "******",
"password": "******",
"port": 3306
},
"tablename":
"test_all_datatypes",
"select_fields": ["id", "name", "dob"],
"limit":
"5",
"offset":
"20",
"order_by":
"id",
"filter": [{
"operand": "dob",
"operator": "not in",
"value": ["2016-02-01", "2016-02-09 23:59:59"]
}]
}
datastorex.select(args)
def test_t36():
args = {
'connection_info': {
"type": "mysql",
"host": "localhost",
"namespace": "testtest",
"user": "******",
"password": "******",
"port": 3306
},
"tablename":
"test_all_datatypes",
"select_fields": ["id", "name"],
"limit":
"5",
"offset":
"20",
"order_by":
"id",
"filter": [{
"operand": "height",
"operator": "not in",
"value": [10.23, 11, 12.45, 1, -89]
}]
}
datastorex.select(args)
def test_t7():
with pytest.raises(Exception) as e:
args = {
'connection_info': {
"type": "mysql",
"host": "localhost",
"namespace": "freedata",
"user": "******",
"password": "******",
"port": "1234"
}
}
datastorex.select(args)
def test_t11():
args = {
'connection_info': {
"type": "mysql",
"host": "localhost",
"namespace": "testtest",
"user": "******",
"password": "******",
"port": 3306
},
"tablename": "yoooo"
}
datastorex.select(args)
def test_t9():
with pytest.raises(Exception) as e:
args = {
'connection_info': {
"type": "sqlite",
"host": "localhost",
"namespace": "freedata",
"user": "******",
"password": "******",
"port": "1234"
},
"tablename": "ohhlala"
}
datastorex.select(args)
def test_t10():
with pytest.raises(Exception) as e:
args = {
'connection_info': {
"type": "mysql",
"host": "localhost",
"namespace": "testtest",
"user": "******",
"password": "******",
"port": 3306
},
"tablename": "ohhlala"
}
datastorex.select(args)
def test_t19():
args = {
'connection_info': {
"type": "mysql",
"host": "localhost",
"namespace": "testtest",
"user": "******",
"password": "******",
"port": 3306
},
"tablename": "test_all_datatypes",
"select_fields": ["dob_tz"],
"limit": "10"
}
datastorex.select(args)
def test_t15():
args = {
'connection_info': {
"type": "mysql",
"host": "localhost",
"namespace": "testtest",
"user": "******",
"password": "******",
"port": 3306
},
"tablename": "yoooo",
"select_fields": ["aTTr9", "Attr1"],
"limit": "2"
}
datastorex.select(args)
def test_t16():
with pytest.raises(Exception) as e:
args = {
'connection_info': {
"type": "mysql",
"host": "localhost",
"namespace": "testtest",
"user": "******",
"password": "******",
"port": 3306
},
"tablename": "test_all_datatypes",
"select_fields": ["", ""],
"limit": "2"
}
datastorex.select(args)
def test_t65():
args = {
'order_by': '',
'connection_info': {
'namespace': 'testtest',
'host': 'localhost',
'user': '******',
'password': '******',
'type': 'mysql',
'port': '3306'
},
'tablename': 'category',
'filter': [],
'limit': '',
'offset': '',
'select_fields': []
}
datastorex.select(args)
def test_t22():
args = {
'connection_info': {
"type": "mysql",
"host": "localhost",
"namespace": "testtest",
"user": "******",
"password": "******",
"port": 3306
},
"tablename": "test_all_datatypes",
"select_fields":
["id", "name", "height", "is_active", "dob", "dob_tz"],
"limit": "5",
"offset": "20",
"order_by": "id desc"
}
datastorex.select(args)
def test_t2():
with pytest.raises(Exception) as e:
args = ''
datastorex.select(args)
def test_t4():
with pytest.raises(Exception) as e:
args = {'connection_info': {}}
datastorex.select(args)
def test_t6():
with pytest.raises(Exception) as e:
args = {'connection_info': {"type": "mysql"}}
datastorex.select(args)
def test_t5():
with pytest.raises(Exception) as e:
args = {'connection_info': {"tablename": "yoooo"}}
datastorex.select(args)
def test_t1():
with pytest.raises(Exception) as e:
datastorex.select()
