def buildTripleSQLCommand(self, subject, predicate, obj, context, storeId, quoted):
"""
Builds an insert command for regular triple table
"""
stmt_table = quoted and "%s_quoted_statements" % storeId or "%s_asserted_statements" % storeId
triplePattern = statement2TermCombination(subject, predicate, obj, context)
if quoted:
command = "INSERT INTO %s" % stmt_table +" (subject,predicate,object,context,termComb,objLanguage,objDatatype) VALUES (%s, %s, %s, %s, %s,%s,%s)"
params = [
self.normalizeTerm(subject),
self.normalizeTerm(predicate),
self.normalizeTerm(obj),
self.normalizeTerm(context.identifier),
triplePattern,
isinstance(obj, Literal) and obj.language or 'NULL',
isinstance(obj, Literal) and obj.datatype or 'NULL']
else:
command = "INSERT INTO %s" % stmt_table + " (subject,predicate,object,context,termComb) VALUES (%s, %s, %s, %s, %s)"
params = [
self.normalizeTerm(subject),
self.normalizeTerm(predicate),
self.normalizeTerm(obj),
self.normalizeTerm(context.identifier),
triplePattern]
return command,params
def buildLiteralTripleSQLCommand(self, subject, predicate, obj, context, storeId):
"""
Builds an insert command for literal triples (statements where the
object is a Literal)
"""
triplePattern = int(statement2TermCombination(subject, predicate, obj, context))
literal_table = "%s_literal_statements" % storeId
command = "INSERT INTO %s " % literal_table +" (subject,predicate,object,context,termComb,objLanguage,objDatatype) VALUES (%s, %s, %s, %s, %s,%s,%s)"
return command, [
self.normalizeTerm(subject),
self.normalizeTerm(predicate),
self.normalizeTerm(obj),
self.normalizeTerm(context.identifier),
triplePattern,
isinstance(obj, Literal) and obj.language or 'NULL',
isinstance(obj, Literal) and obj.datatype or 'NULL']
