Bible Display App files -- take csv that maps the filename to the date, put contents into database, query to join (a) presentation titles file content and (b) Bible Display App filenames

[zipperer]

40

made a csv that maps BDA filename to date.

Put this into a table in postgres.

Then, postgres has two tables. One table has columns

presentation_id | presentation_encoded_date | presentation_day | presentation_morning_or_night | presentation_date | title

Other table has columns bible_display_app_filename_id | bible_display_app_filename | bible_display_app_file_date

And we can join these two tables on presentation_date = bible_display_app_file_date

[zipperer]

See (file that records commands for psql and SQL)[https://github.com/zipperer/migrate_database_with_michael/blob/main/title_program_numbers_and_bible_verse_timestamp_files/bible_verse_timestamp_files/bible_verse_filename_date_into_postgres_and_query_for_presentation_id_and_filename.txt]