def event_callback(event_type, event_mention_str, actor_str, location_str):
event = EventT1(event_type=event_type,
event_mention_str=event_mention_str,
actor_str=actor_str,
location_str=location_str)
event.save()
def query_location_cnt_in_event():
print("#### Location cnt in event")
for i in EventT1.select(EventT1.location_str,fn.COUNT(EventT1.location_str).alias("count")).where(EventT1.location_str != "").group_by(EventT1.location_str).order_by(SQL("count").desc()).limit(20):
print("{}\t{}".format(i.location_str,i.count))
print("#### End Location cnt in event")
def given_event_str_and_location_output_count_of_actors(event_str,location):
print("#### Actor counts given event string: {} and location: {}".format(event_str,location))
for i in EventT1.select(EventT1.actor_str,fn.COUNT(EventT1.actor_str).alias("count")).where((EventT1.event_mention_str.contains(event_str)) & (EventT1.location_str.contains(location)) & (EventT1.actor_str != "")).group_by(EventT1.actor_str).order_by(SQL("count").desc()).limit(20):
print("{}\t{}".format(i.actor_str,i.count))
print("#### End Actor counts given event string: {} and location: {}".format(event_str,location))
def query_anchor_string_cnt():
print("#### Event anchor string count")
for i in EventT1.select(EventT1.event_mention_str,fn.COUNT(EventT1.event_mention_str).alias("count")).where((EventT1.actor_str == "") & (EventT1.location_str == "")).group_by(EventT1.event_mention_str).order_by(SQL("count").desc()).limit(20):
print("{}\t{}".format(i.event_mention_str,i.count))
print("#### End Event anchor and string count")