def mysql_db_context(request, input_dict, output_dict, widget):
con = input_dict['connection']
find_con = input_dict['find_connections'] == 'true'
initial_context = DBContext(con, find_connections=find_con)
initial_target_cols = initial_context.cols[initial_context.target_table]
cols_dump = json.dumps(initial_context.cols)
return render(
request, 'interactions/db_context.html', {
'widget': widget,
'context': initial_context,
'connections': dict(initial_context.connected),
'target_cols': initial_target_cols,
'cols': cols_dump
})
def mysql_db_context_finished(postdata, input_dict, output_dict):
con = input_dict['connection']
find_con = input_dict['find_connections'] == 'true'
context = DBContext(con, find_connections=find_con)
context.update(postdata)
return {'context': context}
def dataset(self):
'''
Returns the db context as a list of interpretations, i.e., a list of
facts true for each example.
'''
target = self.db.target_table
db_examples = self.db.rows(target,
[self.db.target_att, self.db.pkeys[target]])
examples = []
for cls, pk in sorted(db_examples, key=lambda ex: ex[0]):
facts = self._facts(pk,
self.db.pkeys[target],
target,
visited=set())
examples.append('%s %s' % (cls, ', '.join(facts)))
return '\n'.join(examples)
def default_template(self):
return '[%s]' % (', '.join(self._template))
if __name__ == '__main__':
from context import DBConnection, DBContext
context = DBContext(DBConnection('ilp', 'ilp123', 'ged.ijs.si', 'muta_42'))
context.target_table = 'drugs'
context.target_att = 'active'
conv = Aleph_Converter(context)
def database_db_context_finished(postdata, input_dict, output_dict):
con = input_dict['connection']
find_con = input_dict['find_connections'] == 'true'
context = DBContext(con, find_connections=find_con)
_update_context(context, postdata)
return {'context' : context}
