Implement table `file_timestamped_entry_book_chapter_verse` and make process to populate it

[zipperer]

See this comment.

Copied below:

-- Table from content of files in directory of files ‘Bible Display App CSV txt files’ after 
--  (a) split days with two sessions into two files and 
--  (b) convert to csv.
-- tablename: timestamped_entry_book_chapter_verse

filename                  | filename_date | morning_or_night | entry_timestamp     | book     | chapter | verse
BDA 2014 1 05_morning.txt | 2014-01-05    | morning          | 2014-01-05 00:01:49 | Romans   | 8       | 29
BDA 2014 1 05_night.txt   | 2014-01-05    | night            | 2014-01-05 00:04:45 | 1Timothy | 4       | 1

To get a table like this I propose:

• start with directory of files 'BDA YYYY MM DD.txt'
• make new directory of files that can have form
  • 'BDA YYYY MM DD.txt' or
  • 'BDA YYYY MM DD_morning.txt' or
  • 'BDA YYYY MM DD_night.txt'
  • where file has the first form when the entries in the file start from 12am and only go up in time and
  • file has second form or third form when the entries in the file start from 12am and go up and then go back down afterward
  • second form for the entries from 12am to up before go back down
  • third form for entries from 12am to up after first batch of entries
  • from new directory of files make third directory of files that can have form
  • 'BDA YYYY MM DD.csv' or
  • 'BDA YYYY MM DD_morning.csv' or
  • 'BDA YYYY MM DD_night.csv'
  • make script that iterates through this directory of csvs and uses psycopg2 to copy content from file into the target table

[zipperer]

At first I will go directly from

• directory of files 'BDA YYYY MM DD.txt'
• new directory of files make third directory of files that can have form
  • 'BDA YYYY MM DD.csv' or
  • 'BDA YYYY MM DD_morning.csv' or
  • 'BDA YYYY MM DD_night.csv'

So, in the case where there is no restart at 12am, will still write new file b/c will write as csv.

[zipperer]

Note on filename_date:

Current version uses entry_timestamp to determine this date rather than extracting the date from the filename. Better name for that column, given how current version determines it, is entry_date.

[zipperer]

postgres=# CREATE TABLE bible_display_app_file_entries_with_morning_or_night (
postgres(#   filename VARCHAR NOT NULL,
postgres(#   entry_date DATE NOT NULL,
postgres(#   morning_or_night VARCHAR NOT NULL,
postgres(#   entry_timestamp TIMESTAMP NOT NULL,
postgres(#   book VARCHAR NOT NULL,
postgres(#   chapter VARCHAR NOT NULL,
postgres(#   verse VARCHAR NOT NULL);

[zipperer]

I perform initial experiment and tests with this commit