transaction_sector table is missing?

[odscjames]

Seems to never be set up locally?

Live definition is:

ocdsdata=# \d transaction_sector 
             Table "public.transaction_sector"
      Column       | Type | Collation | Nullable | Default 
-------------------+------+-----------+----------+---------
 prefix            | text |           |          | 
 _link             | text |           |          | 
 _link_activity    | text |           |          | 
 _link_transaction | text |           |          | 
 iatiidentifier    | text |           |          | 
 reportingorg_ref  | text |           |          | 
 vocabulary        | text |           |          | 
 vocabularyname    | text |           |          | 
 vocabularyuri     | text |           |          | 
 code              | text |           |          | 
 codename          | text |           |          | 
 narrative         | text |           |          | 

[odscjames]

If I comment out the 2 function calls in sql_process() it will run:

 def sql_process():
-    augment_transaction()
-    transaction_breakdown()
+    pass
+    #augment_transaction()
+    #transaction_breakdown()

[odscjames]

(Other tables seem to be missing too, comparing the table list on live and local? But we'll start with this one and see if the solution helps the other ones)

[odscjames]

I've got past this. I was running it with sample=1 and I guess I got no data with transaction_sector info so the table was never made - tables seem to be created dynamically? If I run with sample=10 I get the table.

Should document this maybe?