def test_dbquery(self):
from ptrdf.triples.db import DBTriples
dbname = 'new03.db'
dbwrite(dbname,'''v1 = a
v2 = b
v3 = c
v4 = d
v5 = e
ia = 1
ib = 2
ic = 3
id = 4
ie = 5
l = 5
t1,2,3 = 1
t1,2,4 = 1
t1,5,3 = 1
o1,2 = 3+4
o1,5 = 3
s2,3 = 1
s2,4 = 1
s5,3 = 1
''')
t = DBTriples(dbname,'r')
self.assertEqual(t.test('a','b','c'), True, 'simple test')
self.assertEqual(t.test('a','b','d'), True, 'simple test')
self.assertEqual(t.test('a','b','a'), False, 'test no, resource exists')
self.assertEqual(t.test('x','b','c'), False, 'test no, subject unknown')
self.assertEqual(t.test('a','y','c'), False, 'test no, predicate unknown')
self.assertEqual(t.test('a','b','z'), False, 'test no, object unknown')
self.assertEqual(qt(t.all_query('a','b',None)), 'c;d', 'query sp?')
self.assertEqual(qt(t.all_query('a',None,'c')), 'b;e', 'query s?p')
self.assertEqual(qt(t.all_query('a',None,None)), 'b,c;b,d;e,c', 'query s??')
self.assertEqual(qt(t.all_query(None,'b','c')), 'a', 'query ?po')
self.assertEqual(qt(t.all_query(None,'b',None)), 'a,c;a,d', 'query ?p?')
self.assertEqual(qt(t.all_query(None,None,'d')), 'a,b', 'query ??o')
self.assertEqual(qt(t.all_query(None,None,None)), 'a,b,c;a,b,d;a,e,c', 'query ???')
self.assertEqual(j(t.all_sp2o('a','b')), 'c,d', 'sp2o')
self.assertEqual(j(t.sp2o('a','y')), '', 'sp2o no match')
self.assertEqual(t.sp2o('a','b') in ('c','d'), True, 'sp2o scalar')
self.assertEqual(j(t.all_po2s('b','d')), 'a', 'po2s')
self.assertEqual(j(t.po2s('b','d')), 'a', 'po2s scalar')
self.assertEqual(j(t.all_po2s('b','z')), '', 'po2s no match')
self.assertEqual(j(t.all_s2p('a')), 'b,e', 's2p')
self.assertEqual(j(t.all_s2p('c')), '', 's2p no match')
