def from_db(a_concept_id, a_cursor=None):
a_concept = on.corpora.ontology.concept(None, a_cursor)
a_concept.id = a_concept_id
# lets fill the concept attributes first
a_cursor.execute(
"""select * from concept_pool_type where id = '%s'""" %
(a_concept_id))
concept_pool_type_rows = a_cursor.fetchall()
for a_concept_pool_type_row in concept_pool_type_rows:
a_concept.spid = a_concept_pool_type_row["spid"]
a_concept.fid = a_concept_pool_type_row["spid"]
a_concept.name = a_concept_pool_type_row["name"]
a_concept.commentaries.append(
a_concept_pool_type_row["commentary"])
a_cursor.execute(
"""select * from concept_pool_parent where id = '%s'""" %
(a_concept_id))
parent_id_rows = a_cursor.fetchall()
for a_parent_id_row in parent_id_rows:
status("adding %s as parent" % (a_parent_id_row["parent_id"]))
a_concept.parent_ids.append(a_parent_id_row["parent_id"])
a_cursor.execute(
"""select * from concept_pool_relation where id = '%s'""" %
(a_concept_id))
relation_id_rows = a_cursor.fetchall()
for a_relation_id_row in relation_id_rows:
status("adding %s as being related" %
(a_relation_id_row["relation_id"]))
a_concept.relation_ids.append(a_relation_id_row["relation_id"])
a_cursor.execute(
"""select * from concept_pool_feature where id = '%s'""" %
(a_concept_id))
feature_id_rows = a_cursor.fetchall()
for a_feature_id_row in feature_id_rows:
status("adding %s as a feature with %s modifier" %
(a_feature_id_row["feature_type"],
a_feature_id_row["feature_modifier"]))
a_feature = on.corpora.ontology.feature(
"%s%s" % (a_feature_id_row["feature_modifier"],
a_feature_id_row["feature_type"]))
a_concept.features.append(a_feature)
return a_concept
def from_db(a_concept_id, a_cursor=None):
a_concept = on.corpora.ontology.concept(None, a_cursor)
a_concept.id = a_concept_id
# lets fill the concept attributes first
a_cursor.execute("""select * from concept_pool_type where id = '%s'""" % (a_concept_id))
concept_pool_type_rows = a_cursor.fetchall()
for a_concept_pool_type_row in concept_pool_type_rows:
a_concept.spid = a_concept_pool_type_row["spid"]
a_concept.fid = a_concept_pool_type_row["spid"]
a_concept.name = a_concept_pool_type_row["name"]
a_concept.commentaries.append(a_concept_pool_type_row["commentary"])
a_cursor.execute("""select * from concept_pool_parent where id = '%s'""" % (a_concept_id))
parent_id_rows = a_cursor.fetchall()
for a_parent_id_row in parent_id_rows:
status("adding %s as parent" % (a_parent_id_row["parent_id"]))
a_concept.parent_ids.append(a_parent_id_row["parent_id"])
a_cursor.execute("""select * from concept_pool_relation where id = '%s'""" % (a_concept_id))
relation_id_rows = a_cursor.fetchall()
for a_relation_id_row in relation_id_rows:
status("adding %s as being related" % (a_relation_id_row["relation_id"]))
a_concept.relation_ids.append(a_relation_id_row["relation_id"])
a_cursor.execute("""select * from concept_pool_feature where id = '%s'""" % (a_concept_id))
feature_id_rows = a_cursor.fetchall()
for a_feature_id_row in feature_id_rows:
status("adding %s as a feature with %s modifier" % (a_feature_id_row["feature_type"], a_feature_id_row["feature_modifier"]))
a_feature = on.corpora.ontology.feature("%s%s" % (a_feature_id_row["feature_modifier"], a_feature_id_row["feature_type"]))
a_concept.features.append(a_feature)
return a_concept
def from_db(a_sense_pool_id, a_cursor):
a_sense_pool = on.corpora.ontology.sense_pool(a_sense_pool_id, None, a_cursor)
a_sense_pool.id = a_sense_pool_id
# lets fill the concept attributes first
a_cursor.execute("""select * from concept_pool_type where id = '%s'""" % (a_sense_pool_id))
sense_pool_type_rows = a_cursor.fetchall()
for a_sense_pool_type_row in sense_pool_type_rows:
a_sense_pool.spid = a_sense_pool_type_row["spid"]
a_sense_pool.fid = a_sense_pool_type_row["spid"]
a_sense_pool.name = a_sense_pool_type_row["name"]
a_sense_pool.commentary = a_sense_pool_type_row["commentary"]
a_cursor.execute("""select * from concept_pool_parent where id = '%s' and type = 'concept'""" % (a_sense_pool_id))
parent_concept_id_rows = a_cursor.fetchall()
for a_parent_concept_id_row in parent_concept_id_rows:
status("adding %s as parent concept" % (a_parent_concept_id_row["parent_id"]))
a_sense_pool.parent_concepts_list.append(a_parent_concept_id_row["parent_id"])
a_cursor.execute("""select * from concept_pool_parent where id = '%s' and type = 'pool'""" % (a_sense_pool_id))
parent_pool_id_rows = a_cursor.fetchall()
for a_parent_pool_id_row in parent_pool_id_rows:
status("adding %s as parent pool" % (a_parent_pool_id_row["parent_id"]))
a_sense_pool.parent_pools_list.append(a_parent_pool_id_row["parent_id"])
a_cursor.execute("""select * from concept_pool_relation where id = '%s' and relation_type='concept'""" % (a_sense_pool_id))
relation_concept_id_rows = a_cursor.fetchall()
for a_relation_concept_id_row in relation_concept_id_rows:
status("adding %s as being related concept" % (a_relation_pool_id_row["relation_id"]))
a_sense_pool.related_concepts_list.append(a_relation_pool_id_row["relation_id"])
a_cursor.execute("""select * from concept_pool_relation where id = '%s' and relation_type='pool'""" % (a_sense_pool_id))
relation_pool_id_rows = a_cursor.fetchall()
for a_relation_pool_id_row in relation_pool_id_rows:
status("adding %s as being related pool" % (a_relation_pool_id_row["relation_id"]))
a_sense_pool.related_pools_list.append(a_relation_pool_id_row["relation_id"])
a_cursor.execute("""select * from pool_sense where id = '%s'""" % (a_sense_pool_id))
sense_id_rows = a_cursor.fetchall()
for a_sense_id_row in sense_id_rows:
a_sense_id = a_sense_id_row["sense_id"]
status("adding %s as a sense in this pool" % (a_sense_id))
a_sense_pool.sense_list.append(a_sense_id)
return a_sense_pool
def make_sense_pools(sp_dir):
status("Loading sense pools ...")
return on.corpora.ontology.sense_pool_collection(
"sense_pool_collection@ontology@on", sp_dir)
def make_upper_model(um_fname):
status("Loading upper model ...")
with codecs.open(um_fname, "r", "utf8") as um_inf:
return on.corpora.ontology.upper_model(
"upper_model@ontology@on", um_inf.read())
def from_db(a_sense_pool_id, a_cursor):
a_sense_pool = on.corpora.ontology.sense_pool(a_sense_pool_id, None, a_cursor)
a_sense_pool.id = a_sense_pool_id
# lets fill the concept attributes first
a_cursor.execute("""select * from concept_pool_type where id = '%s'""" % (a_sense_pool_id))
sense_pool_type_rows = a_cursor.fetchall()
for a_sense_pool_type_row in sense_pool_type_rows:
a_sense_pool.spid = a_sense_pool_type_row["spid"]
a_sense_pool.fid = a_sense_pool_type_row["spid"]
a_sense_pool.name = a_sense_pool_type_row["name"]
a_sense_pool.commentary = a_sense_pool_type_row["commentary"]
a_cursor.execute("""select * from concept_pool_parent where id = '%s' and type = 'concept'""" % (a_sense_pool_id))
parent_concept_id_rows = a_cursor.fetchall()
for a_parent_concept_id_row in parent_concept_id_rows:
status("adding %s as parent concept" % (a_parent_concept_id_row["parent_id"]))
a_sense_pool.parent_concepts_list.append(a_parent_concept_id_row["parent_id"])
a_cursor.execute("""select * from concept_pool_parent where id = '%s' and type = 'pool'""" % (a_sense_pool_id))
parent_pool_id_rows = a_cursor.fetchall()
for a_parent_pool_id_row in parent_pool_id_rows:
status("adding %s as parent pool" % (a_parent_pool_id_row["parent_id"]))
a_sense_pool.parent_pools_list.append(a_parent_pool_id_row["parent_id"])
a_cursor.execute("""select * from concept_pool_relation where id = '%s' and relation_type='concept'""" % (a_sense_pool_id))
relation_concept_id_rows = a_cursor.fetchall()
for a_relation_concept_id_row in relation_concept_id_rows:
status("adding %s as being related concept" % (a_relation_pool_id_row["relation_id"]))
a_sense_pool.related_concepts_list.append(a_relation_pool_id_row["relation_id"])
a_cursor.execute("""select * from concept_pool_relation where id = '%s' and relation_type='pool'""" % (a_sense_pool_id))
relation_pool_id_rows = a_cursor.fetchall()
for a_relation_pool_id_row in relation_pool_id_rows:
status("adding %s as being related pool" % (a_relation_pool_id_row["relation_id"]))
a_sense_pool.related_pools_list.append(a_relation_pool_id_row["relation_id"])
a_cursor.execute("""select * from pool_sense where id = '%s'""" % (a_sense_pool_id))
sense_id_rows = a_cursor.fetchall()
for a_sense_id_row in sense_id_rows:
a_sense_id = a_sense_id_row["sense_id"]
status("adding %s as a sense in this pool" % (a_sense_id))
a_sense_pool.sense_list.append(a_sense_id)
return a_sense_pool
def make_sense_pools(sp_dir):
status("Loading sense pools ...")
return on.corpora.ontology.sense_pool_collection(
"sense_pool_collection@ontology@on", sp_dir)
def make_upper_model(um_fname):
status("Loading upper model ...")
with codecs.open(um_fname, "r", "utf8") as um_inf:
return on.corpora.ontology.upper_model(
"upper_model@ontology@on", um_inf.read())
