CRUDE-ASP

CRUDE-ASP copied to clipboard

These custom actions should be available per each dataview-

• [ ] validate dataview (makes sure the metadata defined in crude matches actual database schema, and outputs any discrepancies such as missing fields, mismatching data types or max length, missing procedure parameters, etc.)
• [ ] Auto complete crude metadata using database schema. Parameters:
  • create missing fields ( #125 )
  • change primary key column if different
• [ ] Update database schema based on crude metadata ( #56 ). Parameters:
  • create missing fields
  • update data types for existing fields
• [ ] generate source/modification/deletion procedure (creates a basic stored procedure based on current crude schema). Parameters:
  • procedure name
  • overwrite existing