|
|
|
validate_option(option,
lower=True)
Strips and checks that there are no newlines, tabs, spaces, or
semi-colons in the given option. |
source code
|
|
|
del_rows_from_table(connection,
del_table,
del_table_id,
join_conditions,
del_filters=None,
save_filters=None,
verbose=False)
Deletes triggers from any specified table in the del_table option. |
source code
|
|
|
get_tables_in_database(connection)
Gets the names of tables that are in the database. |
source code
|
|
|
vacuum_database(connection,
vacuum=None,
verbose=None)
Remove empty space and defragment the database. |
source code
|
|
|
get_column_names_from_table(connection,
table_name)
Gets the column names from a table and returns them as a list. |
source code
|
|
|
|
|
convert_duration(duration,
convert_to)
Converts durations stored in the experiment_summary_table from seconds
to other units of time. |
source code
|
|
|
get_next_id(connection,
table,
id_column)
Gets the next available id in the specified id_column in the
specified table. |
source code
|
|
|
increment_id(last_id,
nsteps=1)
Increments the given id by nsteps. |
source code
|
|
|
|
|
get_col_type(table_name,
col_name,
default='lstring')
Attempts to get column type from lsctables.py for the given table
name and column name. |
source code
|
|
|
|
|
clean_metadata(connection,
key_tables,
verbose=False)
Cleans metadata from tables that don't have process_ids in any of the tables
listed in the key_tables list. |
source code
|
|
|
clean_metadata_using_end_time(connection,
key_table,
key_column,
verbose=False)
An alternate to clean_metadata, this cleans metadata from tables
who's start/end_times don't encompass the end_times in the given
table. |
source code
|
|
|
get_process_info(connection,
verbose=False,
debug=False)
Create a map between process_ids so duplicate entries in numerous
ligolw_xml tables can be removed without a loss of information. |
source code
|
|
|
get_pids_to_update(cursor,
programs)
Make a tuple of the process_ids from the temp table '_pidmap_' that
need to be updated for a given list of programs. |
source code
|
|
|
simplify_summ_tbls(connection,
verbose=False,
debug=False)
Delete duplicate information in summary tables according to the
process_ids. |
source code
|
|
|
|
|
|
|
|
|
|
|
clean_experiment_tables(connection,
verbose=False)
Removes entries from the experiment, experiment_summary, and
time_slide tables that have no events in them, i.e., that have no
mapping to any coinc_event_ids via the experiment_map table. |
source code
|
|
|
simplify_expr_tbl(connection,
verbose=False,
debug=False)
Cleaning up the experiment table by removing duplicate rows and
remapping events to the appropriate experiment. |
source code
|
|
|
simplify_exprsumm_tbl(connection,
verbose=False,
debug=False)
Cleaning up the experiment_summary and the experiment_map tables by
removing duplicate rows and remapping events to the appropriate
experiment. |
source code
|
|
|
|
|
clean_using_coinc_table(connection,
table_name,
verbose=False,
clean_experiment_map=True,
clean_coinc_event_table=True,
clean_coinc_definer=True,
clean_coinc_event_map=True,
clean_mapped_tables=True,
selected_tables=[])
Clears experiment_map, coinc_event, coinc_event_map, and all tables
pointing to the coinc_event_map of triggers that are no longer in the
specified table. |
source code
|
|
|
apply_inclusion_rules_to_coinc_table(connection,
coinc_table,
exclude_coincs=None,
include_coincs=None,
param_filters=None,
verbose=False)
Clears the given table of coinc triggers falling outside of the
desired ranges, as specified by parse_param_ranges and parse_coinc_opts. |
source code
|
|
|
|
|
get_map_labels(connection)
Retrieves values in the description column of the coinc_definer
table. |
source code
|
|
|
|
|
delete_map(connection,
map_label)
Deletes all mappings that have the given map_label in the description
column of the coinc_definer table. |
source code
|
|
|
simplify_coincdef_tbl(connection,
verbose=False,
debug=False)
Remove duplicate entries in the coinc_definer table and update the
coinc_event table with new coinc_def_ids. |
source code
|
|
|
delete_coinc_type(connection,
map_label,
coincTables)
Deletes all mappings that have the given coinc type. |
source code
|
|
|
add_coinc_event_entries(connection,
process_id,
coinc_def_id,
time_slide_id,
num_new_entries=1)
Writes N new entries in the coinc_event table, where N is given by
num_new_entries. |
source code
|
|
|
update_coinctab_nevents(connection)
Updates the nevents column based on what's in the coinc_event_map
table. |
source code
|
|
|
get_cem_table_names(connection)
Retrieves the all of the table names present in the coinc_event_map
table. |
source code
|
|
|
|
|
create_mapped_tables_func(connection,
nargs=1)
Creates a function in the database called get_mapped_tables that
allows one to quickly get all the mapped tables to a coinc_event_id. |
source code
|
|
|
clean_mapped_event_tables(connection,
tableList,
raise_err_on_missing_evid=False,
verbose=False)
Cleans tables given in tableList of events whose event_ids aren't in
the coinc_event_map table. |
source code
|
|
|
|
|
apply_inclusion_rules_to_coinc_inspiral(connection,
exclude_coincs=None,
include_coincs=None,
param_filters=None,
verbose=False)
Clears coinc_inspiral table of coinc triggers falling outside of the
desired ranges, as specified by parse_param_ranges and
parse_coinc_opts. |
source code
|
|
|
clean_inspiral_tables(connection,
verbose=False)
Clears experiment_map, coinc_event, coinc_event_map, and all tables
pointing to the coinc_event_map of triggers that are no longer in the
coinc_inspiral table. |
source code
|
|
|
create_sim_rec_map_table(connection,
simulation_table,
recovery_table,
map_label,
ranking_stat=None)
Creates a temporary table in the sqlite database called sim_rec_map. |
source code
|
|
|
simplify_sim_tbls(connection,
verbose=False,
debug=False)
Remove duplicates from simulation tables (sim_inspiral &
sim_ringdown) if those tables exist in the database. |
source code
|
|
|
simplify_segments_tbls(connection,
verbose=False,
debug=False)
Removing duplicate row in the segment, segment_definer and
segment_summary tables as well as the associated entries in the
process & process_params tables |
source code
|
|
|
get_zero_lag_time_slide_ids(connection)
Gets zero-lag time_slide_id's from the time_slide_table. |
source code
|
|
|
get_zero_lag_instrument_sets(connection)
Gets instrument sets from time slide table by using the ids of the
zero-lag time-slides (Assumption is there is a zero-lag row in the
time-slide table). |
source code
|
|
|
|
|
simplify_timeslide_tbl(connection,
verbose=False,
debug=False)
Remove duplicate entries in the time_slide table and update entries
in the the time_slide_id column of both the experiment_summary and
coinc_event tables. |
source code
|
|
|
simplify_vetodef_tbl(connection,
verbose=False,
debug=False)
Cleaning up the veto_definer table as well as the associated entries
in the process & process_params tables |
source code
|
|