=== DATABASE TESTING WITH TRANSACTION (NO COMMIT) ===

✅ Transaction started

1. Testing INSERT operation:
----------------------------
✅ Test user inserted: test9758
✅ Insert verified - User found in database
   - Username: test9758
   - UserGroupID: 1

2. Testing UPDATE operation:
----------------------------
✅ Test user updated
✅ Update verified - Password changed

3. Testing COMPLEX QUERY:
-------------------------
✅ Complex query executed
   Found 1 test users

4. Testing LOCATION DATA ACCESS:
--------------------------------
✅ Location data accessed
   Latest 5 locations:
   - N.A. at 2036-02-06 06:28:15.000
   - D 8314 FA at 2030-03-08 05:01:21.000
   - K 1451 TD at 2026-08-16 10:13:02.000
   - BG 8252 JF at 2026-08-16 10:13:02.000
   - D 8191 CS at 2026-08-16 10:12:58.000

=== ROLLBACK TRANSACTION ===
✅ All changes rolled back - database unchanged

5. Verifying ROLLBACK:
----------------------
✅ Rollback verified - Test user not found (as expected)

=== TEST COMPLETED - NO DATA CHANGED ===