/*
 * MySQL Database Simulation - Raspberry Pi Pico W
 * Exercise 11 - VIT IoT Lab
 * Simple CREATE TABLE and INSERT operations
 */

// No special libraries needed for this simulation

// Setup Function - runs once
void setup() {
  Serial.begin(115200);
  delay(1000);
  
  Serial.println("\n================================================");
  Serial.println("   EXERCISE 11 - MySQL DATABASE SIMULATION");
  Serial.println("================================================\n");
  
  // OPERATION 1: CREATE TABLE
  Serial.println("[1] CREATING TABLE: student_records");
  Serial.println("-----------------------------------");
  Serial.println("Query: CREATE TABLE student_records (");
  Serial.println("        roll_no INT PRIMARY KEY,");
  Serial.println("        name VARCHAR(50),");
  Serial.println("        marks INT");
  Serial.println(");");
  Serial.println("RESULT: Table created successfully ✓");
  Serial.println("");
  
  // OPERATION 2: INSERT DATA
  Serial.println("[2] INSERTING DATA INTO TABLE");
  Serial.println("-----------------------------");
  Serial.println("Query: INSERT INTO student_records VALUES");
  Serial.println("        (23001, 'Rahul', 85),");
  Serial.println("        (23002, 'Priya', 92),");
  Serial.println("        (23003, 'Arjun', 78);");
  Serial.println("RESULT: 3 rows inserted successfully ✓");
  Serial.println("");
  
  // Display the inserted data
  Serial.println("DATA IN TABLE:");
  Serial.println("--------------");
  Serial.println("+---------+---------+-------+");
  Serial.println("| roll_no | name    | marks |");
  Serial.println("+---------+---------+-------+");
  Serial.println("| 23001   | Rahul   | 85    |");
  Serial.println("| 23002   | Priya   | 92    |");
  Serial.println("| 23003   | Arjun   | 78    |");
  Serial.println("+---------+---------+-------+");
  Serial.println("");
  
  Serial.println("================================================");
  Serial.println("EXERCISE 11 COMPLETED SUCCESSFULLY");
  Serial.println("================================================\n");
}

// Loop Function - runs repeatedly
void loop() {
  // Display status every 10 seconds
  static unsigned long lastDisplay = 0;
  if (millis() - lastDisplay > 10000) {
    lastDisplay = millis();
    Serial.println("MySQL running. Table: student_records has 3 records.");
  }
  
  delay(100);
}