Index

_

__init__() (pir_pipeline.dashboard.CustomSessionInterface method) (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method) (pir_pipeline.linking.PIRLinker.PIRLinker method) (pir_pipeline.models.pir_models.ProgramModel method) (pir_pipeline.models.pir_models.QuestionModel method) (pir_pipeline.models.pir_models.QuestionModelOptional method) (pir_pipeline.models.pir_models.ResponseModel method) (pir_pipeline.utils.dashboard_utils.QuestionLinker method) (pir_pipeline.utils.MockData.MockData method) (pir_pipeline.utils.sql_alchemy_view.CreateView method) (pir_pipeline.utils.sql_alchemy_view.DropView method) (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method)

A

against() (pir_pipeline.utils.sql_alchemy_view.CreateView method) (pir_pipeline.utils.sql_alchemy_view.DropView method)

append_sections() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method)

C

clean_name() (in module pir_pipeline.utils.utils) clean_pir_data() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method) close_connection() (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method) close_db() (in module pir_pipeline.dashboard.db) close_excel_files() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method) close_logger() (in module pir_pipeline.utils.utils) compare() (pir_pipeline.utils.sql_alchemy_view.CreateView method) (pir_pipeline.utils.sql_alchemy_view.DropView method) compile() (pir_pipeline.utils.sql_alchemy_view.CreateView method) (pir_pipeline.utils.sql_alchemy_view.DropView method)

confirm() (pir_pipeline.utils.dashboard_utils.QuestionLinker method) consolidate_uqids() (pir_pipeline.linking.PIRLinker.PIRLinker method) copy() (pir_pipeline.models.pir_models.ProgramModel method) (pir_pipeline.models.pir_models.QuestionModel method) (pir_pipeline.models.pir_models.QuestionModelOptional method) (pir_pipeline.models.pir_models.ResponseModel method) create_app() (in module pir_pipeline.dashboard) create_db() (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method) CreateView (class in pir_pipeline.utils.sql_alchemy_view) CustomSessionInterface (class in pir_pipeline.dashboard)

D

data (pir_pipeline.utils.MockData.MockData property) data() (in module pir_pipeline.dashboard.review) (in module pir_pipeline.dashboard.search) data_specifications() (pir_pipeline.utils.MockData.MockData method) database (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils property)

DB_CONFIG (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils property) digest_method() (pir_pipeline.dashboard.CustomSessionInterface static method) direct_link() (pir_pipeline.linking.PIRLinker.PIRLinker method) drop_db() (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method) DropView (class in pir_pipeline.utils.sql_alchemy_view) duplicated_question_error() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method)

E

engine (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils property) error_thrower() (in module pir_pipeline.utils.utils) execute_if() (pir_pipeline.utils.sql_alchemy_view.CreateView method) (pir_pipeline.utils.sql_alchemy_view.DropView method)

execution_options() (pir_pipeline.utils.sql_alchemy_view.CreateView method) (pir_pipeline.utils.sql_alchemy_view.DropView method) export() (pir_pipeline.utils.MockData.MockData method) extract_sheets() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method)

F

flashcard() (in module pir_pipeline.dashboard.review)

fuzzy_link() (pir_pipeline.linking.PIRLinker.PIRLinker method)

G

gen_engine() (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method) gen_uqid() (pir_pipeline.linking.PIRLinker.PIRLinker method) generate_data() (pir_pipeline.utils.MockData.MockData method) generate_rows() (pir_pipeline.utils.MockData.MockData method) get_children() (pir_pipeline.utils.sql_alchemy_view.CreateView method) (pir_pipeline.utils.sql_alchemy_view.DropView method) get_columns() (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method) get_cookie_domain() (pir_pipeline.dashboard.CustomSessionInterface method) get_cookie_httponly() (pir_pipeline.dashboard.CustomSessionInterface method) get_cookie_name() (pir_pipeline.dashboard.CustomSessionInterface method) get_cookie_partitioned() (pir_pipeline.dashboard.CustomSessionInterface method) get_cookie_path() (pir_pipeline.dashboard.CustomSessionInterface method) get_cookie_samesite() (pir_pipeline.dashboard.CustomSessionInterface method) get_cookie_secure() (pir_pipeline.dashboard.CustomSessionInterface method) get_db() (in module pir_pipeline.dashboard.db)

get_execution_options() (pir_pipeline.utils.sql_alchemy_view.CreateView method) (pir_pipeline.utils.sql_alchemy_view.DropView method) get_expiration_time() (pir_pipeline.dashboard.CustomSessionInterface method) get_flashcard_question() (in module pir_pipeline.dashboard.review) (in module pir_pipeline.dashboard.search) get_ids() (pir_pipeline.utils.dashboard_utils.QuestionLinker method) get_logger() (in module pir_pipeline.utils.utils) get_matches() (in module pir_pipeline.utils.dashboard_utils) get_question_data() (pir_pipeline.linking.PIRLinker.PIRLinker method) get_records() (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method) get_review_question() (in module pir_pipeline.utils.dashboard_utils) get_scalar() (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method) get_search_results() (in module pir_pipeline.utils.dashboard_utils) get_searchable_columns() (in module pir_pipeline.utils.utils) get_section() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method) get_year_range() (in module pir_pipeline.utils.dashboard_utils)

H

hash_columns() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method)

I

index() (in module pir_pipeline.dashboard.index) (in module pir_pipeline.dashboard.review) ingest() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method) inherit_cache (pir_pipeline.utils.sql_alchemy_view.CreateView attribute) (pir_pipeline.utils.sql_alchemy_view.DropView attribute)

init_app() (in module pir_pipeline.dashboard.db) insert_data() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method) insert_records() (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method) is_null_session() (pir_pipeline.dashboard.CustomSessionInterface method)

J

join_on_type_and_section() (pir_pipeline.linking.PIRLinker.PIRLinker method)

K

key_derivation (pir_pipeline.dashboard.CustomSessionInterface attribute)

L

link() (in module pir_pipeline.dashboard.review) (pir_pipeline.linking.PIRLinker.PIRLinker method) (pir_pipeline.utils.dashboard_utils.QuestionLinker method)

load_data() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method)

M

make_connection() (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method) make_fields_optional() (in module pir_pipeline.models.pir_models) make_null_session() (pir_pipeline.dashboard.CustomSessionInterface method) make_snake_name() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method) merge_response_question() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method) MockData (class in pir_pipeline.utils.MockData) model_config (pir_pipeline.models.pir_models.ProgramModel attribute) (pir_pipeline.models.pir_models.QuestionModel attribute) (pir_pipeline.models.pir_models.QuestionModelOptional attribute) (pir_pipeline.models.pir_models.ResponseModel attribute) model_construct() (pir_pipeline.models.pir_models.ProgramModel class method) (pir_pipeline.models.pir_models.QuestionModel class method) (pir_pipeline.models.pir_models.QuestionModelOptional class method) (pir_pipeline.models.pir_models.ResponseModel class method) model_copy() (pir_pipeline.models.pir_models.ProgramModel method) (pir_pipeline.models.pir_models.QuestionModel method) (pir_pipeline.models.pir_models.QuestionModelOptional method) (pir_pipeline.models.pir_models.ResponseModel method) model_dump() (pir_pipeline.models.pir_models.ProgramModel method) (pir_pipeline.models.pir_models.QuestionModel method) (pir_pipeline.models.pir_models.QuestionModelOptional method) (pir_pipeline.models.pir_models.ResponseModel method) model_dump_json() (pir_pipeline.models.pir_models.ProgramModel method) (pir_pipeline.models.pir_models.QuestionModel method) (pir_pipeline.models.pir_models.QuestionModelOptional method) (pir_pipeline.models.pir_models.ResponseModel method) model_extra (pir_pipeline.models.pir_models.ProgramModel property) (pir_pipeline.models.pir_models.QuestionModel property) (pir_pipeline.models.pir_models.QuestionModelOptional property) (pir_pipeline.models.pir_models.ResponseModel property) model_fields_set (pir_pipeline.models.pir_models.ProgramModel property) (pir_pipeline.models.pir_models.QuestionModel property) (pir_pipeline.models.pir_models.QuestionModelOptional property) (pir_pipeline.models.pir_models.ResponseModel property) model_json_schema() (pir_pipeline.models.pir_models.ProgramModel class method) (pir_pipeline.models.pir_models.QuestionModel class method) (pir_pipeline.models.pir_models.QuestionModelOptional class method) (pir_pipeline.models.pir_models.ResponseModel class method) model_parametrized_name() (pir_pipeline.models.pir_models.ProgramModel class method) (pir_pipeline.models.pir_models.QuestionModel class method) (pir_pipeline.models.pir_models.QuestionModelOptional class method) (pir_pipeline.models.pir_models.ResponseModel class method)

model_post_init() (pir_pipeline.models.pir_models.ProgramModel method) (pir_pipeline.models.pir_models.QuestionModel method) (pir_pipeline.models.pir_models.QuestionModelOptional method) (pir_pipeline.models.pir_models.ResponseModel method) model_rebuild() (pir_pipeline.models.pir_models.ProgramModel class method) (pir_pipeline.models.pir_models.QuestionModel class method) (pir_pipeline.models.pir_models.QuestionModelOptional class method) (pir_pipeline.models.pir_models.ResponseModel class method) model_validate() (pir_pipeline.models.pir_models.ProgramModel class method) (pir_pipeline.models.pir_models.QuestionModel class method) (pir_pipeline.models.pir_models.QuestionModelOptional class method) (pir_pipeline.models.pir_models.ResponseModel class method) model_validate_json() (pir_pipeline.models.pir_models.ProgramModel class method) (pir_pipeline.models.pir_models.QuestionModel class method) (pir_pipeline.models.pir_models.QuestionModelOptional class method) (pir_pipeline.models.pir_models.ResponseModel class method) model_validate_strings() (pir_pipeline.models.pir_models.ProgramModel class method) (pir_pipeline.models.pir_models.QuestionModel class method) (pir_pipeline.models.pir_models.QuestionModelOptional class method) (pir_pipeline.models.pir_models.ResponseModel class method) module pir_pipeline pir_pipeline.config pir_pipeline.dashboard pir_pipeline.dashboard.db pir_pipeline.dashboard.index pir_pipeline.dashboard.review pir_pipeline.dashboard.search pir_pipeline.ingestion pir_pipeline.ingestion.PIRIngestor pir_pipeline.linking pir_pipeline.linking.PIRLinker pir_pipeline.models pir_pipeline.models.pir_models pir_pipeline.models.pir_sql_models pir_pipeline.utils pir_pipeline.utils.dashboard_utils pir_pipeline.utils.MockData pir_pipeline.utils.paths pir_pipeline.utils.sql_alchemy_view pir_pipeline.utils.SQLAlchemyUtils pir_pipeline.utils.SQLUtils pir_pipeline.utils.utils

N

null_session_class (pir_pipeline.dashboard.CustomSessionInterface attribute)

O

open_session() (pir_pipeline.dashboard.CustomSessionInterface method)

options() (pir_pipeline.utils.sql_alchemy_view.CreateView method) (pir_pipeline.utils.sql_alchemy_view.DropView method)

P

params() (pir_pipeline.utils.sql_alchemy_view.CreateView method) (pir_pipeline.utils.sql_alchemy_view.DropView method) pickle_based (pir_pipeline.dashboard.CustomSessionInterface attribute) pir_pipeline module pir_pipeline.config module pir_pipeline.dashboard module pir_pipeline.dashboard.db module pir_pipeline.dashboard.index module pir_pipeline.dashboard.review module pir_pipeline.dashboard.search module pir_pipeline.ingestion module pir_pipeline.ingestion.PIRIngestor module pir_pipeline.linking module pir_pipeline.linking.PIRLinker module

pir_pipeline.models module pir_pipeline.models.pir_models module pir_pipeline.models.pir_sql_models module pir_pipeline.utils module pir_pipeline.utils.dashboard_utils module pir_pipeline.utils.MockData module pir_pipeline.utils.paths module pir_pipeline.utils.sql_alchemy_view module pir_pipeline.utils.SQLAlchemyUtils module pir_pipeline.utils.SQLUtils module pir_pipeline.utils.utils module PIRIngestor (class in pir_pipeline.ingestion.PIRIngestor) PIRLinker (class in pir_pipeline.linking.PIRLinker) prepare_for_insertion() (pir_pipeline.linking.PIRLinker.PIRLinker method) ProgramModel (class in pir_pipeline.models.pir_models)

Q

question_data_check() (pir_pipeline.linking.PIRLinker.PIRLinker method) QuestionLinker (class in pir_pipeline.utils.dashboard_utils)

QuestionModel (class in pir_pipeline.models.pir_models) QuestionModelOptional (class in pir_pipeline.models.pir_models)

R

ResponseModel (class in pir_pipeline.models.pir_models)

S

salt (pir_pipeline.dashboard.CustomSessionInterface attribute) save_session() (pir_pipeline.dashboard.CustomSessionInterface method) search() (in module pir_pipeline.dashboard.search) search_matches() (in module pir_pipeline.utils.dashboard_utils) self_group() (pir_pipeline.utils.sql_alchemy_view.CreateView method) (pir_pipeline.utils.sql_alchemy_view.DropView method)

serializer (pir_pipeline.dashboard.CustomSessionInterface attribute) session_class (pir_pipeline.dashboard.CustomSessionInterface attribute) sheets (pir_pipeline.utils.MockData.MockData property) should_set_cookie() (pir_pipeline.dashboard.CustomSessionInterface method) SQLAlchemyUtils (class in pir_pipeline.utils.SQLAlchemyUtils) stringify() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method)

T

tables (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils property)

to_dict() (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method)

U

unique_params() (pir_pipeline.utils.sql_alchemy_view.CreateView method) (pir_pipeline.utils.sql_alchemy_view.DropView method) unlink() (pir_pipeline.utils.dashboard_utils.QuestionLinker method)

update_links() (pir_pipeline.utils.dashboard_utils.QuestionLinker method) update_records() (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method) update_unlinked() (pir_pipeline.linking.PIRLinker.PIRLinker method)

V

validate_data() (pir_pipeline.ingestion.PIRIngestor.PIRIngestor method) validate_table() (pir_pipeline.utils.SQLAlchemyUtils.SQLAlchemyUtils method)

view() (in module pir_pipeline.utils.sql_alchemy_view) view_doesnt_exist() (in module pir_pipeline.utils.sql_alchemy_view) view_exists() (in module pir_pipeline.utils.sql_alchemy_view)

W

workbooks (pir_pipeline.utils.MockData.MockData property)

Y

year (pir_pipeline.utils.MockData.MockData property)