From e9d3f49aa12c3e098ccdcb105fb2cabd35ea984e Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 11 Apr 2025 22:45:39 +0000 Subject: [PATCH] Adjust conversion for tables dropped in the upstream MS Access db --- conversion/clean_names.sql | 79 -------------------------------- conversion/grant_permissions.sql | 7 +-- conversion/tidy.sql | 20 -------- 3 files changed, 1 insertion(+), 105 deletions(-) diff --git a/conversion/clean_names.sql b/conversion/clean_names.sql index de96dfa..251a212 100644 --- a/conversion/clean_names.sql +++ b/conversion/clean_names.sql @@ -294,41 +294,6 @@ ALTER TABLE community_membership_update_log RENAME "made by" TO made_by; -ALTER TABLE "ELO RANKS DAILY - FEMALES - old" RENAME TO ELO_RANKS_DAILY___FEMALES___old; -ALTER TABLE elo_ranks_daily___females___old - RENAME "Date" TO Date; -ALTER TABLE elo_ranks_daily___females___old - RENAME "Female" TO Female; -ALTER TABLE elo_ranks_daily___females___old - RENAME "EloStartingValue" TO EloStartingValue; -ALTER TABLE elo_ranks_daily___females___old - RENAME "Elo" TO Elo; -ALTER TABLE elo_ranks_daily___females___old - RENAME "Elo_mean" TO Elo_mean; -ALTER TABLE elo_ranks_daily___females___old - RENAME "Elo_sd" TO Elo_sd; -ALTER TABLE elo_ranks_daily___females___old - RENAME "Pre" TO Pre; -ALTER TABLE elo_ranks_daily___females___old - RENAME "EntryType" TO EntryType; -ALTER TABLE elo_ranks_daily___females___old - RENAME "MomPresence" TO MomPresence; -ALTER TABLE elo_ranks_daily___females___old - RENAME "EntryMom" TO EntryMom; -ALTER TABLE elo_ranks_daily___females___old - RENAME "EloOrdinal" TO EloOrdinal; -ALTER TABLE elo_ranks_daily___females___old - RENAME "EloOrdinal_max" TO EloOrdinal_max; -ALTER TABLE elo_ranks_daily___females___old - RENAME "PropDominated" TO PropDominated; -ALTER TABLE elo_ranks_daily___females___old - RENAME "PropDominatedThirds" TO PropDominatedThirds; -ALTER TABLE elo_ranks_daily___females___old - RENAME "NaturalCatsJenks3" TO NaturalCatsJenks3; -ALTER TABLE elo_ranks_daily___females___old - RENAME "CardinalRanksMathias" TO CardinalRanksMathias; - - ALTER TABLE "ELO RANKS DAILY - KK FEMALES" RENAME TO ELO_RANKS_DAILY___KK_FEMALES; ALTER TABLE elo_ranks_daily___kk_females @@ -368,23 +333,6 @@ ALTER TABLE elo_ranks_daily___kk_males RENAME "JenksEloCardinal" TO JenksEloCardinal; -ALTER TABLE "ELO RANKS DAILY - MALES - old" RENAME TO ELO_RANKS_DAILY___MALES___old; -ALTER TABLE elo_ranks_daily___males___old - RENAME "Date" TO Date; -ALTER TABLE elo_ranks_daily___males___old - RENAME "Individual" TO Individual; -ALTER TABLE elo_ranks_daily___males___old - RENAME "Elo" TO Elo; -ALTER TABLE elo_ranks_daily___males___old - RENAME "EloOrdinal" TO EloOrdinal; -ALTER TABLE elo_ranks_daily___males___old - RENAME "EloScaled" TO EloScaled; -ALTER TABLE elo_ranks_daily___males___old - RENAME "EloCardinal" TO EloCardinal; -ALTER TABLE elo_ranks_daily___males___old - RENAME "JenksEloCardinal" TO JenksEloCardinal; - - ALTER TABLE "ELO RANKS DAILY - MT FEMALES" RENAME TO ELO_RANKS_DAILY___MT_FEMALES; ALTER TABLE elo_ranks_daily___mt_females RENAME "Date" TO Date; @@ -576,11 +524,6 @@ ALTER TABLE follow_map_time RENAME "FMT_update" TO FMT_update; -ALTER TABLE "FOLLOW_MAP_TIME_PROBLEMS" RENAME TO FOLLOW_MAP_TIME_PROBLEMS; -ALTER TABLE follow_map_time_problems - RENAME "FMTP_Date" TO FMTP_Date; - - ALTER TABLE "FOOD_BOUT" RENAME TO FOOD_BOUT; ALTER TABLE food_bout RENAME "FB_FOL_date" TO FB_FOL_date; @@ -887,25 +830,3 @@ ALTER TABLE subadult_arrivals_log RENAME "SA_first_tiki_date" TO SA_first_tiki_date; ALTER TABLE subadult_arrivals_log RENAME "SA_notes" TO SA_notes; - - -ALTER TABLE "tbl_adjusted ages for alone arrivals" RENAME TO tbl_adjusted_ages_for_alone_arrivals; -ALTER TABLE tbl_adjusted_ages_for_alone_arrivals - RENAME "B_AnimID" TO B_AnimID; -ALTER TABLE tbl_adjusted_ages_for_alone_arrivals - RENAME "S_Date" TO S_Date; -ALTER TABLE tbl_adjusted_ages_for_alone_arrivals - RENAME "Year" TO Year; -ALTER TABLE tbl_adjusted_ages_for_alone_arrivals - RENAME "AgeCalc" TO AgeCalc; -ALTER TABLE tbl_adjusted_ages_for_alone_arrivals - RENAME "AgeAdj" TO AgeAdj; - - --- There is also "tlk_brecord_notes_codes", which does not need renaming. -ALTER TABLE tlk_brecord_notes_codes - RENAME "ID" TO ID; -ALTER TABLE tlk_brecord_notes_codes - RENAME "Abbreviation" TO Abbreviation; -ALTER TABLE tlk_brecord_notes_codes - RENAME "Meaning" TO Meaning; diff --git a/conversion/grant_permissions.sql b/conversion/grant_permissions.sql index 765f2f9..e3ddcbb 100644 --- a/conversion/grant_permissions.sql +++ b/conversion/grant_permissions.sql @@ -1,4 +1,4 @@ --- Copyright (C) 2023 The Meme Factory, Inc. http://www.karlpinc.com/ +-- Copyright (C) 2023, 2025 The Meme Factory, Inc. http://www.karlpinc.com/ -- -- This program is free software: you can redistribute it and/or modify -- it under the terms of the GNU Affero General Public License as @@ -28,10 +28,8 @@ GRANT SELECT ON "COLOBUS" TO reader, writer; GRANT SELECT ON "COMMUNITY_LOOKUP" TO reader, writer; GRANT SELECT ON "COMMUNITY_MEMBERSHIP" TO reader, writer; GRANT SELECT ON "COMMUNITY_MEMBERSHIP_UPDATE_LOG" TO reader, writer; -GRANT SELECT ON "ELO RANKS DAILY - FEMALES - old" TO reader, writer; GRANT SELECT ON "ELO RANKS DAILY - KK FEMALES" TO reader, writer; GRANT SELECT ON "ELO RANKS DAILY - KK MALES" TO reader, writer; -GRANT SELECT ON "ELO RANKS DAILY - MALES - old" TO reader, writer; GRANT SELECT ON "ELO RANKS DAILY - MT FEMALES" TO reader, writer; GRANT SELECT ON "FEMALE REPRODUCTIVE STATES" TO reader, writer; GRANT SELECT ON "FEMALE_REPRO_HISTORY" TO reader, writer; @@ -41,7 +39,6 @@ GRANT SELECT ON "FOLLOW_ARRIVAL" TO reader, writer; GRANT SELECT ON "FOLLOW_MAP_LOCATION" TO reader, writer; GRANT SELECT ON "FOLLOW_MAP_POSITION" TO reader, writer; GRANT SELECT ON "FOLLOW_MAP_TIME" TO reader, writer; -GRANT SELECT ON "FOLLOW_MAP_TIME_PROBLEMS" TO reader, writer; GRANT SELECT ON "FOOD_BOUT" TO reader, writer; GRANT SELECT ON "FOOD_LOOKUP" TO reader, writer; GRANT SELECT ON "FOOD_PART_LOOKUP" TO reader, writer; @@ -58,5 +55,3 @@ GRANT SELECT ON "PANTGRUNT_EVENT_LOG" TO reader, writer; GRANT SELECT ON "SIGHTINGS" TO reader, writer; GRANT SELECT ON "SIV_STATUS_BOUT" TO reader, writer; GRANT SELECT ON "SUBADULT_ARRIVALS_LOG" TO reader, writer; -GRANT SELECT ON "tbl_adjusted ages for alone arrivals" TO reader, writer; -GRANT SELECT ON "tlk_brecord_notes_codes" TO reader, writer; diff --git a/conversion/tidy.sql b/conversion/tidy.sql index 7d23f71..ec8ae28 100644 --- a/conversion/tidy.sql +++ b/conversion/tidy.sql @@ -90,10 +90,6 @@ SELECT checktime('COMMUNITY_MEMBERSHIP_UPDATE_LOG', 'date_of_update'); ALTER TABLE "COMMUNITY_MEMBERSHIP_UPDATE_LOG" ALTER date_of_update TYPE DATE; -SELECT checktime('ELO RANKS DAILY - FEMALES - old', 'Date'); -ALTER TABLE "ELO RANKS DAILY - FEMALES - old" - ALTER "Date" TYPE DATE; - SELECT checktime('ELO RANKS DAILY - KK FEMALES', 'Date'); ALTER TABLE "ELO RANKS DAILY - KK FEMALES" ALTER "Date" TYPE DATE; @@ -102,10 +98,6 @@ SELECT checktime('ELO RANKS DAILY - KK MALES', 'Date'); ALTER TABLE "ELO RANKS DAILY - KK MALES" ALTER "Date" TYPE DATE; -SELECT checktime('ELO RANKS DAILY - MALES - old', 'Date'); -ALTER TABLE "ELO RANKS DAILY - MALES - old" - ALTER "Date" TYPE DATE; - SELECT checktime('ELO RANKS DAILY - MT FEMALES', 'Date'); ALTER TABLE "ELO RANKS DAILY - MT FEMALES" ALTER "Date" TYPE DATE; @@ -166,12 +158,6 @@ ALTER TABLE "FOLLOW_MAP_TIME" ALTER "FMT_time" TYPE TIME WITHOUT TIME ZONE, ALTER "FMT_update" TYPE DATE; -SELECT checktime('FOLLOW_MAP_TIME_PROBLEMS', 'FMTP_Date'); -SELECT checkdate('FOLLOW_MAP_TIME_PROBLEMS', 'map_time'); -ALTER TABLE "FOLLOW_MAP_TIME_PROBLEMS" - ALTER "FMTP_Date" TYPE DATE, - ALTER map_time TYPE TIME WITHOUT TIME ZONE; - SELECT checktime('FOOD_BOUT', 'FB_FOL_date'); SELECT checkdate('FOOD_BOUT', 'FB_begin_feed_time'); SELECT checkdate('FOOD_BOUT', 'FB_end_feed_time'); @@ -255,9 +241,3 @@ ALTER TABLE "SIV_STATUS_BOUT" ALTER "SSB_last_test_date" TYPE DATE; -- ALTER TABLE "SUBADULT_ARRIVALS_LOG" RENAME TO SUBADULT_ARRIVALS_LOG; - -SELECT checktime('tbl_adjusted ages for alone arrivals', 'S_Date'); -ALTER TABLE "tbl_adjusted ages for alone arrivals" - ALTER "S_Date" TYPE DATE; - --- There is also "tlk_brecord_notes_codes", which does not need alteration. -- 2.34.1