Add check constraint on MetaPackage name

[cheatdb.git] / app / models.py

diff --git a/app/models.py b/app/models.py
index 4102049ce240e6f43237464a4d84913e916771be..0db7ca4999a84dad7d163375bfec350410be3420 100644 (file)
--- 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