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 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']
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' ]