def loadRelations(self, indexFirst=False):
self.log_statement('loadRelations')
cursor = self._db.cursor()
cursor.execute("""
insert into %s
select distinct subject, subject_term, predicate, predicate_term,
object, object_term, context, context_term
from triples where predicate != %s and object_term != 'L'""" %
(self.binaryRelations,
str(normalizeNode(RDF.type, self.useSignedInts))))
def loadRelations(self, indexFirst=False):
self.log_statement('loadRelations')
cursor = self._db.cursor()
cursor.execute("""
insert into %s
select distinct subject, subject_term, predicate, predicate_term,
object, object_term, context, context_term
from triples where predicate != %s and object_term != 'L'""" %
(self.binaryRelations,
str(normalizeNode(RDF.type, self.useSignedInts))))
def loadAssociativeBox(self, indexFirst=False):
self.log_statement('loadAssociativeBox')
cursor = self._db.cursor()
cursor.execute("""
insert into %s
select distinct subject as member, subject_term as member_term,
object as class, object_term as class_term,
context, context_term
from triples where predicate = %s and predicate_term = 'U'""" %
(self.aboxAssertions,
str(normalizeNode(RDF.type, self.useSignedInts))))
def loadAssociativeBox(self, indexFirst=False):
self.log_statement('loadAssociativeBox')
cursor = self._db.cursor()
cursor.execute("""
insert into %s
select distinct subject as member, subject_term as member_term,
object as class, object_term as class_term,
context, context_term
from triples where predicate = %s and predicate_term = 'U'""" %
(self.aboxAssertions,
str(normalizeNode(RDF.type, self.useSignedInts))))
def loadRelations(self, indexFirst=False):
self._loadTable(self.binaryRelations)
return
cursor = self._db.cursor()
sql = """
insert into %s
select subject, subject_term, predicate, predicate_term,
object, object_term, context, context_term
from triples
where predicate != %s and object_term != 'L'
group by subject, predicate, object, context
""" % (self.binaryRelations,
str(normalizeNode(RDF.type, self.useSignedInts)))
log.debug(sql)
cursor.execute(sql)
def loadRelations(self, indexFirst=False):
self._loadTable(self.binaryRelations)
return
cursor = self._db.cursor()
sql = """
insert into %s
select subject, subject_term, predicate, predicate_term,
object, object_term, context, context_term
from triples
where predicate != %s and object_term != 'L'
group by subject, predicate, object, context
""" % (self.binaryRelations,
str(normalizeNode(RDF.type, self.useSignedInts)))
print >> sys.stderr, sql
cursor.execute(sql)
def loadAssociativeBox(self, indexFirst=False):
self._loadTable(self.aboxAssertions)
return
cursor = self._db.cursor()
sql = """
insert into %s
select subject as member, subject_term as member_term,
object as class, object_term as class_term,
context, context_term
from triples
where predicate = %s and predicate_term = 'U'
group by subject, object, context
""" % (self.aboxAssertions,
str(normalizeNode(RDF.type, self.useSignedInts)))
log.debug(sql)
cursor.execute(sql)
def loadAssociativeBox(self, indexFirst=False):
self._loadTable(self.aboxAssertions)
return
cursor = self._db.cursor()
sql = """
insert into %s
select subject as member, subject_term as member_term,
object as class, object_term as class_term,
context, context_term
from triples
where predicate = %s and predicate_term = 'U'
group by subject, object, context
""" % (self.aboxAssertions,
str(normalizeNode(RDF.type, self.useSignedInts)))
print >> sys.stderr, sql
cursor.execute(sql)