From 4bd9411d870d0402ddf83d0c84591f7c8ce32daf Mon Sep 17 00:00:00 2001
From: rubenwardy <rw@rubenwardy.com>
Date: Sun, 12 Jul 2020 02:43:48 +0100
Subject: Add check constraint on MetaPackage name

---
 app/models.py | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'app')

diff --git a/app/models.py b/app/models.py
index 4102049..0db7ca4 100644
--- a/app/models.py
+++ b/app/models.py
@@ -758,6 +758,8 @@ class MetaPackage(db.Model):
 	name         = db.Column(db.String(100), unique=True, nullable=False)
 	dependencies = db.relationship("Dependency", backref="meta_package", lazy="dynamic")
 
+	mp_name_valid = db.CheckConstraint("name ~* '^[a-z0-9_]+$'")
+
 	def __init__(self, name=None):
 		self.name = name
 
-- 
cgit v1.2.3