Missing join tables in db.tables
Created by: brad-decker
So, to give a high level overview of our table structure. We have main tables that are capitalized. 'Users' and 'Lifestyles' among others. We also have join tables such as 'userLifestyles'. Some, but not all of, the join tables are missing when we run massive. So if we were to do:
db.userLifestyles
we get undefined. We can query that table just fine without using the massive helper. Also if I loop through the values of db.table and console.log the path all of the tables that are camelCase (join tables) appear twice. Note in the clip below i'm toLowerCase()'ing to group like items.
db.tables
.filter(t => t.schema === 'public')
.map(t => t.path.toLowerCase())
.sort()
.forEach(t => console.log(t));
agentproperties
agentproperties
businessdeveloperproperties
businessdeveloperproperties
[...]
Overall there are three tables missing from massive. What would cause this to happen? Tagging the engineer on our team who originally discovered the issue which lead to this discover @arilfrankel