Changes between Version 5 and Version 6 of UseCaseModel/evaluation

Timestamp:

05/08/25 16:18:32 (5 days ago)

Author:

175012

Comment:

--

UseCaseModel/evaluation

@@ -86 +86 @@
 }}}
 
+3. Формат на табели за колата
+
+{{{#!sql
+        CREATE OR REPLACE FUNCTION validate_license_plate() 
+        RETURNS TRIGGER AS $$
+        BEGIN
+            -- Check if the license plate matches the expected format (XX-1234-XX)
+            IF NEW.license_plate !~ '^[A-Z]{2}-\d{4}-[A-Z]{2}$' THEN
+                RAISE EXCEPTION 'Invalid license plate format: %', NEW.license_plate;
+            END IF;
+            RETURN NEW;
+        END;
+        $$ LANGUAGE plpgsql;
+
+
+CREATE TRIGGER trigger_validate_license_plate
+BEFORE INSERT OR UPDATE ON vehicles
+FOR EACH ROW
+EXECUTE FUNCTION validate_license_plate_format();
+}}}
+
 
 == Погледи