Spaces:
Sleeping
Sleeping
File size: 3,199 Bytes
fc9a733 ec4d503 fc9a733 ec4d503 fc9a733 ec4d503 fc9a733 ec4d503 fc9a733 ec4d503 fc9a733 ec4d503 fc9a733 ec4d503 fc9a733 ec4d503 fc9a733 ec4d503 fc9a733 ec4d503 fc9a733 ec4d503 fc9a733 ec4d503 fc9a733 ec4d503 fc9a733 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 |
// package com.cs102.attendance.controller;
// import com.cs102.attendance.entity.TestConnection;
// import com.cs102.attendance.repository.TestConnectionRepository;
// import org.springframework.beans.factory.annotation.Autowired;
// import org.springframework.http.ResponseEntity;
// import org.springframework.web.bind.annotation.*;
// import java.util.HashMap;
// import java.util.List;
// import java.util.Map;
// @RestController
// @RequestMapping("/api/test")
// public class TestController {
// @Autowired
// private TestConnectionRepository testConnectionRepository;
// @GetMapping("/database-operations")
// public ResponseEntity<Map<String, Object>> testDatabaseOperations() {
// Map<String, Object> response = new HashMap<>();
// try {
// // Test 1: Simple query
// Integer queryResult = testConnectionRepository.testQuery();
// response.put("simpleQuery", queryResult == 1 ? "PASS" : "FAIL");
// // Test 2: Insert operation
// TestConnection testEntity = new TestConnection("Connection test from Spring Boot");
// TestConnection saved = testConnectionRepository.save(testEntity);
// response.put("insertOperation", saved.getId() != null ? "PASS" : "FAIL");
// // Test 3: Read operation
// List<TestConnection> allRecords = testConnectionRepository.findAll();
// response.put("readOperation", !allRecords.isEmpty() ? "PASS" : "FAIL");
// response.put("recordCount", allRecords.size());
// // Test 4: Delete operation
// testConnectionRepository.deleteById(saved.getId());
// response.put("deleteOperation", "PASS");
// response.put("overallStatus", "SUCCESS");
// response.put("message", "All database operations completed successfully");
// return ResponseEntity.ok(response);
// } catch (Exception e) {
// response.put("overallStatus", "FAILED");
// response.put("error", e.getMessage());
// response.put("errorClass", e.getClass().getSimpleName());
// return ResponseEntity.status(500).body(response);
// }
// }
// @PostMapping("/insert-test-data")
// public ResponseEntity<TestConnection> insertTestData(@RequestParam(defaultValue = "Test message") String message) {
// try {
// TestConnection testEntity = new TestConnection(message);
// TestConnection saved = testConnectionRepository.save(testEntity);
// return ResponseEntity.ok(saved);
// } catch (Exception e) {
// return ResponseEntity.status(500).build();
// }
// }
// @GetMapping("/all-test-data")
// public ResponseEntity<List<TestConnection>> getAllTestData() {
// try {
// List<TestConnection> allRecords = testConnectionRepository.findAll();
// return ResponseEntity.ok(allRecords);
// } catch (Exception e) {
// return ResponseEntity.status(500).build();
// }
// }
// } |