Open zipperer opened 5 months ago
See email thread with subject 'another little project' from Jan 22.
Pieces:
For the pieces, see Dropbox links from Michael.
Phases:
convert to csvs
For 'Title Text file': see title_program_numbers_and_bible_verse_timestamp_files/title_program_numbers_into_db
space-separated to pipe-separated
pipe-separated to pipe-separated with additional columns -- additional columns for the components of the decoded date
For 'BDA ... .txt' files: see title_program_numbers_and_bible_verse_timestamp_files/bible_verse_timestamp_files/bible_display_app_file_entries/bible_display_app_files_to_csvs.py
for each .txt file, make one or two .csv files. Make two files when the input .txt file contains entries for both morning session and night session.
for use of script see use of bible_display_app_files_to_csvs.py in title_program_numbers_and_bible_verse_timestamp_files/bible_verse_timestamp_files/bible_display_app_file_entries/shell_interactions_use_script_to_make_csvs_and_copy_csv_into_database.txt
bible_display_app_files_to_csvs.py
import csvs into db
For 'Title Text file': see the 'docker*' files in title_program_numbers_and_bible_verse_timestamp_files/title_program_numbers_into_db
docker cp file into container
docker cp
make table
\copy into table
\copy
For 'BDA ... .txt' files: see
COPY
query tables and join
See email thread with subject 'another little project' from Jan 22.
Pieces:
For the pieces, see Dropbox links from Michael.
Phases:
convert to csvs
For 'Title Text file': see title_program_numbers_and_bible_verse_timestamp_files/title_program_numbers_into_db
space-separated to pipe-separated
pipe-separated to pipe-separated with additional columns -- additional columns for the components of the decoded date
For 'BDA ... .txt' files: see title_program_numbers_and_bible_verse_timestamp_files/bible_verse_timestamp_files/bible_display_app_file_entries/bible_display_app_files_to_csvs.py
for each .txt file, make one or two .csv files. Make two files when the input .txt file contains entries for both morning session and night session.
for use of script see use of
bible_display_app_files_to_csvs.py
in title_program_numbers_and_bible_verse_timestamp_files/bible_verse_timestamp_files/bible_display_app_file_entries/shell_interactions_use_script_to_make_csvs_and_copy_csv_into_database.txtimport csvs into db
For 'Title Text file': see the 'docker*' files in title_program_numbers_and_bible_verse_timestamp_files/title_program_numbers_into_db
docker cp
file into containermake table
\copy
into tableFor 'BDA ... .txt' files: see
COPY
each csv into table title_program_numbers_and_bible_verse_timestamp_files/bible_verse_timestamp_files/bible_display_app_file_entries/copy_output_csvs_into_table.pyquery tables and join