orchestrator-core icon indicating copy to clipboard operation
orchestrator-core copied to clipboard

[Improvement]: Restrict Text fields in DB Models, save empty subscription note as NULL

Open Mark90 opened this issue 3 months ago • 0 comments

Check the DB models for unrestricted Text fields which allow storing an unlimited amount of text. Decide a sensible upper limit on case by case basis.

For SubscriptionTable.note:

  • Explicitly make the Text column a nullable String
  • On save of the model, check if the note is empty - in that case save it as NULL
  • Create migration to update the note field of existing subscriptions, if note contains string of 0 length then store NULL

Mark90 avatar Sep 15 '25 10:09 Mark90