Added an uppercase in sql for venue and concert duplicate check

Added test to create duplicate concert with varied cases in string

1 files changed, 22 insertions, 0 deletions

diff --git a/tests/ConcertTest.php b/tests/ConcertTest.php
index 82bdc9a..6d14b68 100644
--- a/tests/ConcertTest.php
+++ b/tests/ConcertTest.php
@@ -46,4 +46,26 @@ final class ConcertTest extends WP_UnitTestCase
 
         $this->assertNull($new);
     }
+
+    public function testCreateExistingConcertVariableCase() : void
+    {
+        $venue = GiglogAdmin_Venue::create("a venue");
+        $today = date("Y-m-d");
+
+        GiglogAdmin_Concert::create(
+            "a concert123",
+            $venue->id(),
+            $today,
+            "https://example.com/tickets/42",
+            "https://example.com/events/93");
+
+        $new = GiglogAdmin_Concert::create(
+            "a CoNceRt123",
+            $venue->id(),
+            $today,
+            "https://example.com/tickets/42",
+            "https://example.com/events/93");
+
+        $this->assertNull($new);
+    }
 }