jrf0110 / dirac

A Node Postgres DB layer built with MoSQL
http://dirac.j0.hn
6 stars 2 forks source link

Database.getCreateTableAndViewList() returns views out of order #67

Open jrf0110 opened 7 years ago

jrf0110 commented 7 years ago
  1. Views need to have their queries inspected to figure out dependencies
  2. A view isn't exactly like a reference dependency (there isn't a table.col->table.col link)
  3. A view should be able to depend on multiple tables, those tables should get created first, then the view, if another table references the view, then that table should be created last