// API Routes สำหรับระบบฐานข้อมูล SEA Games 2025
// เป็นตัวอย่าง endpoints ที่จะใช้ในการพัฒนา web application
 
/**
 * เส้นทาง API สำหรับข้อมูลนักกีฬา (Athletes)
 */
// GET /api/athletes - ดึงข้อมูลนักกีฬาทั้งหมด
app.get('/api/athletes', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [athletes] = await connection.query('SELECT * FROM Athlete');
    connection.release();
    res.json(athletes);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
// GET /api/athletes/:id - ดึงข้อมูลนักกีฬารายคน
app.get('/api/athletes/:id', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [athlete] = await connection.query('SELECT * FROM Athlete WHERE athlete_id = ?', [req.params.id]);
    connection.release();
 
    if (athlete.length === 0) {
      return res.status(404).json({ message: 'ไม่พบข้อมูลนักกีฬา' });
    }
 
    res.json(athlete[0]);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
// POST /api/athletes - เพิ่มข้อมูลนักกีฬาใหม่
app.post('/api/athletes', async (req, res) => {
  const { athlete_name, birth_date, country, gender } = req.body;
 
  try {
    const connection = await pool.getConnection();
    const [result] = await connection.query(
      'INSERT INTO Athlete (athlete_name, birth_date, country, gender) VALUES (?, ?, ?, ?)',
      [athlete_name, birth_date, country, gender]
    );
    connection.release();
 
    res.status(201).json({ 
      message: 'สร้างข้อมูลนักกีฬาสำเร็จ', 
      athlete_id: result.insertId 
    });
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
/**
 * เส้นทาง API สำหรับข้อมูลกีฬา (Sports)
 */
// GET /api/sports - ดึงข้อมูลกีฬาทั้งหมด
app.get('/api/sports', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [sports] = await connection.query('SELECT * FROM Sport');
    connection.release();
    res.json(sports);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
// GET /api/sports/:id/events - ดึงข้อมูลการแข่งขันในกีฬาที่กำหนด
app.get('/api/sports/:id/events', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [events] = await connection.query(
      'SELECT e.*, v.venue_name FROM Event e JOIN Venue v ON e.venue_id = v.venue_id WHERE e.sport_id = ?',
      [req.params.id]
    );
    connection.release();
    res.json(events);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
/**
 * เส้นทาง API สำหรับข้อมูลการแข่งขัน (Events)
 */
// GET /api/events - ดึงข้อมูลการแข่งขันทั้งหมด
app.get('/api/events', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [events] = await connection.query(`
      SELECT e.*, s.sport_name, v.venue_name 
      FROM Event e 
      JOIN Sport s ON e.sport_id = s.sport_id 
      JOIN Venue v ON e.venue_id = v.venue_id
    `);
    connection.release();
    res.json(events);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
// GET /api/events/:id/participants - ดึงรายชื่อนักกีฬาที่เข้าร่วมการแข่งขัน
app.get('/api/events/:id/participants', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [participants] = await connection.query(`
      SELECT a.* 
      FROM Participation p 
      JOIN Athlete a ON p.athlete_id = a.athlete_id 
      WHERE p.event_id = ?
    `, [req.params.id]);
    connection.release();
    res.json(participants);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
/**
 * เส้นทาง API สำหรับข้อมูลเหรียญรางวัล (Medals)
 */
// GET /api/medals - ดึงข้อมูลเหรียญรางวัลทั้งหมด
app.get('/api/medals', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [medals] = await connection.query(`
      SELECT m.*, a.athlete_name, e.event_name, s.sport_name
      FROM Medal m
      JOIN Athlete a ON m.athlete_id = a.athlete_id
      JOIN Event e ON m.event_id = e.event_id
      JOIN Sport s ON e.sport_id = s.sport_id
    `);
    connection.release();
    res.json(medals);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
// GET /api/medals/tally - ดึงข้อมูลตารางเหรียญรางวัลตามประเทศ
app.get('/api/medals/tally', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [tally] = await connection.query('SELECT * FROM MedalTally ORDER BY gold_count DESC, silver_count DESC, bronze_count DESC');
    connection.release();
    res.json(tally);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
// POST /api/medals - เพิ่มข้อมูลเหรียญรางวัลใหม่
app.post('/api/medals', async (req, res) => {
  const { medal_type, athlete_id, event_id, country } = req.body;
 
  try {
    const connection = await pool.getConnection();
    const [result] = await connection.query(
      'INSERT INTO Medal (medal_type, athlete_id, event_id, country) VALUES (?, ?, ?, ?)',
      [medal_type, athlete_id, event_id, country]
    );
    connection.release();
 
    res.status(201).json({ 
      message: 'บันทึกข้อมูลเหรียญรางวัลสำเร็จ', 
      medal_id: result.insertId 
    });
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
/**
 * เส้นทาง API สำหรับข้อมูลสถิติการแข่งขัน (Records)
 */
// GET /api/records - ดึงข้อมูลสถิติการแข่งขันทั้งหมด
app.get('/api/records', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [records] = await connection.query(`
      SELECT r.*, s.sport_name, e.event_name
      FROM Record r
      JOIN Sport s ON r.sport_id = s.sport_id
      JOIN Event e ON r.event_id = e.event_id
    `);
    connection.release();
    res.json(records);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
/**
 * เส้นทาง API สำหรับข้อมูลสถานที่แข่งขัน (Venues)
 */
// GET /api/venues - ดึงข้อมูลสถานที่แข่งขันทั้งหมด
app.get('/api/venues', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [venues] = await connection.query('SELECT * FROM Venue');
    connection.release();
    res.json(venues);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
// GET /api/venues/:id/events - ดึงข้อมูลการแข่งขันในสถานที่ที่กำหนด
app.get('/api/venues/:id/events', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [events] = await connection.query(`
      SELECT e.*, s.sport_name 
      FROM Event e 
      JOIN Sport s ON e.sport_id = s.sport_id 
      WHERE e.venue_id = ?
    `, [req.params.id]);
    connection.release();
    res.json(events);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
/**
 * เส้นทาง API สำหรับข้อมูลข่าวสาร (News)
 */
// GET /api/news - ดึงข้อมูลข่าวสารทั้งหมด
app.get('/api/news', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [news] = await connection.query('SELECT * FROM News ORDER BY publish_date DESC');
    connection.release();
    res.json(news);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});
 
// GET /api/news/featured - ดึงข่าวสารที่แนะนำ
app.get('/api/news/featured', async (req, res) => {
  try {
    const connection = await pool.getConnection();
    const [news] = await connection.query('SELECT * FROM News WHERE is_featured = 1 ORDER BY publish_date DESC');
    connection.release();
    res.json(news);
  } catch (error) {
    res.status(500).json({ error: error.message });
  }
});

Ly8gQVBJIFJvdXRlcyDguKrguLPguKvguKPguLHguJrguKPguLDguJrguJrguJDguLLguJnguILguYnguK3guKHguLnguKUgU0VBIEdhbWVzIDIwMjUKLy8g4LmA4Lib4LmH4LiZ4LiV4Lix4Lin4Lit4Lii4LmI4Liy4LiHIGVuZHBvaW50cyDguJfguLXguYjguIjguLDguYPguIrguYnguYPguJnguIHguLLguKPguJ7guLHguJLguJnguLIgd2ViIGFwcGxpY2F0aW9uCgovKioKICog4LmA4Liq4LmJ4LiZ4LiX4Liy4LiHIEFQSSDguKrguLPguKvguKPguLHguJrguILguYnguK3guKHguLnguKXguJnguLHguIHguIHguLXguKzguLIgKEF0aGxldGVzKQogKi8KLy8gR0VUIC9hcGkvYXRobGV0ZXMgLSDguJTguLbguIfguILguYnguK3guKHguLnguKXguJnguLHguIHguIHguLXguKzguLLguJfguLHguYnguIfguKvguKHguJQKYXBwLmdldCgnL2FwaS9hdGhsZXRlcycsIGFzeW5jIChyZXEsIHJlcykgPT4gewogIHRyeSB7CiAgICBjb25zdCBjb25uZWN0aW9uID0gYXdhaXQgcG9vbC5nZXRDb25uZWN0aW9uKCk7CiAgICBjb25zdCBbYXRobGV0ZXNdID0gYXdhaXQgY29ubmVjdGlvbi5xdWVyeSgnU0VMRUNUICogRlJPTSBBdGhsZXRlJyk7CiAgICBjb25uZWN0aW9uLnJlbGVhc2UoKTsKICAgIHJlcy5qc29uKGF0aGxldGVzKTsKICB9IGNhdGNoIChlcnJvcikgewogICAgcmVzLnN0YXR1cyg1MDApLmpzb24oeyBlcnJvcjogZXJyb3IubWVzc2FnZSB9KTsKICB9Cn0pOwoKLy8gR0VUIC9hcGkvYXRobGV0ZXMvOmlkIC0g4LiU4Li24LiH4LiC4LmJ4Lit4Lih4Li54Lil4LiZ4Lix4LiB4LiB4Li14Lis4Liy4Lij4Liy4Lii4LiE4LiZCmFwcC5nZXQoJy9hcGkvYXRobGV0ZXMvOmlkJywgYXN5bmMgKHJlcSwgcmVzKSA9PiB7CiAgdHJ5IHsKICAgIGNvbnN0IGNvbm5lY3Rpb24gPSBhd2FpdCBwb29sLmdldENvbm5lY3Rpb24oKTsKICAgIGNvbnN0IFthdGhsZXRlXSA9IGF3YWl0IGNvbm5lY3Rpb24ucXVlcnkoJ1NFTEVDVCAqIEZST00gQXRobGV0ZSBXSEVSRSBhdGhsZXRlX2lkID0gPycsIFtyZXEucGFyYW1zLmlkXSk7CiAgICBjb25uZWN0aW9uLnJlbGVhc2UoKTsKICAgIAogICAgaWYgKGF0aGxldGUubGVuZ3RoID09PSAwKSB7CiAgICAgIHJldHVybiByZXMuc3RhdHVzKDQwNCkuanNvbih7IG1lc3NhZ2U6ICfguYTguKHguYjguJ7guJrguILguYnguK3guKHguLnguKXguJnguLHguIHguIHguLXguKzguLInIH0pOwogICAgfQogICAgCiAgICByZXMuanNvbihhdGhsZXRlWzBdKTsKICB9IGNhdGNoIChlcnJvcikgewogICAgcmVzLnN0YXR1cyg1MDApLmpzb24oeyBlcnJvcjogZXJyb3IubWVzc2FnZSB9KTsKICB9Cn0pOwoKLy8gUE9TVCAvYXBpL2F0aGxldGVzIC0g4LmA4Lie4Li04LmI4Lih4LiC4LmJ4Lit4Lih4Li54Lil4LiZ4Lix4LiB4LiB4Li14Lis4Liy4LmD4Lir4Lih4LmICmFwcC5wb3N0KCcvYXBpL2F0aGxldGVzJywgYXN5bmMgKHJlcSwgcmVzKSA9PiB7CiAgY29uc3QgeyBhdGhsZXRlX25hbWUsIGJpcnRoX2RhdGUsIGNvdW50cnksIGdlbmRlciB9ID0gcmVxLmJvZHk7CiAgCiAgdHJ5IHsKICAgIGNvbnN0IGNvbm5lY3Rpb24gPSBhd2FpdCBwb29sLmdldENvbm5lY3Rpb24oKTsKICAgIGNvbnN0IFtyZXN1bHRdID0gYXdhaXQgY29ubmVjdGlvbi5xdWVyeSgKICAgICAgJ0lOU0VSVCBJTlRPIEF0aGxldGUgKGF0aGxldGVfbmFtZSwgYmlydGhfZGF0ZSwgY291bnRyeSwgZ2VuZGVyKSBWQUxVRVMgKD8sID8sID8sID8pJywKICAgICAgW2F0aGxldGVfbmFtZSwgYmlydGhfZGF0ZSwgY291bnRyeSwgZ2VuZGVyXQogICAgKTsKICAgIGNvbm5lY3Rpb24ucmVsZWFzZSgpOwogICAgCiAgICByZXMuc3RhdHVzKDIwMSkuanNvbih7IAogICAgICBtZXNzYWdlOiAn4Liq4Lij4LmJ4Liy4LiH4LiC4LmJ4Lit4Lih4Li54Lil4LiZ4Lix4LiB4LiB4Li14Lis4Liy4Liq4Liz4LmA4Lij4LmH4LiIJywgCiAgICAgIGF0aGxldGVfaWQ6IHJlc3VsdC5pbnNlcnRJZCAKICAgIH0pOwogIH0gY2F0Y2ggKGVycm9yKSB7CiAgICByZXMuc3RhdHVzKDUwMCkuanNvbih7IGVycm9yOiBlcnJvci5tZXNzYWdlIH0pOwogIH0KfSk7CgovKioKICog4LmA4Liq4LmJ4LiZ4LiX4Liy4LiHIEFQSSDguKrguLPguKvguKPguLHguJrguILguYnguK3guKHguLnguKXguIHguLXguKzguLIgKFNwb3J0cykKICovCi8vIEdFVCAvYXBpL3Nwb3J0cyAtIOC4lOC4tuC4h+C4guC5ieC4reC4oeC4ueC4peC4geC4teC4rOC4suC4l+C4seC5ieC4h+C4q+C4oeC4lAphcHAuZ2V0KCcvYXBpL3Nwb3J0cycsIGFzeW5jIChyZXEsIHJlcykgPT4gewogIHRyeSB7CiAgICBjb25zdCBjb25uZWN0aW9uID0gYXdhaXQgcG9vbC5nZXRDb25uZWN0aW9uKCk7CiAgICBjb25zdCBbc3BvcnRzXSA9IGF3YWl0IGNvbm5lY3Rpb24ucXVlcnkoJ1NFTEVDVCAqIEZST00gU3BvcnQnKTsKICAgIGNvbm5lY3Rpb24ucmVsZWFzZSgpOwogICAgcmVzLmpzb24oc3BvcnRzKTsKICB9IGNhdGNoIChlcnJvcikgewogICAgcmVzLnN0YXR1cyg1MDApLmpzb24oeyBlcnJvcjogZXJyb3IubWVzc2FnZSB9KTsKICB9Cn0pOwoKLy8gR0VUIC9hcGkvc3BvcnRzLzppZC9ldmVudHMgLSDguJTguLbguIfguILguYnguK3guKHguLnguKXguIHguLLguKPguYHguILguYjguIfguILguLHguJnguYPguJnguIHguLXguKzguLLguJfguLXguYjguIHguLPguKvguJnguJQKYXBwLmdldCgnL2FwaS9zcG9ydHMvOmlkL2V2ZW50cycsIGFzeW5jIChyZXEsIHJlcykgPT4gewogIHRyeSB7CiAgICBjb25zdCBjb25uZWN0aW9uID0gYXdhaXQgcG9vbC5nZXRDb25uZWN0aW9uKCk7CiAgICBjb25zdCBbZXZlbnRzXSA9IGF3YWl0IGNvbm5lY3Rpb24ucXVlcnkoCiAgICAgICdTRUxFQ1QgZS4qLCB2LnZlbnVlX25hbWUgRlJPTSBFdmVudCBlIEpPSU4gVmVudWUgdiBPTiBlLnZlbnVlX2lkID0gdi52ZW51ZV9pZCBXSEVSRSBlLnNwb3J0X2lkID0gPycsCiAgICAgIFtyZXEucGFyYW1zLmlkXQogICAgKTsKICAgIGNvbm5lY3Rpb24ucmVsZWFzZSgpOwogICAgcmVzLmpzb24oZXZlbnRzKTsKICB9IGNhdGNoIChlcnJvcikgewogICAgcmVzLnN0YXR1cyg1MDApLmpzb24oeyBlcnJvcjogZXJyb3IubWVzc2FnZSB9KTsKICB9Cn0pOwoKLyoqCiAqIOC5gOC4quC5ieC4meC4l+C4suC4hyBBUEkg4Liq4Liz4Lir4Lij4Lix4Lia4LiC4LmJ4Lit4Lih4Li54Lil4LiB4Liy4Lij4LmB4LiC4LmI4LiH4LiC4Lix4LiZIChFdmVudHMpCiAqLwovLyBHRVQgL2FwaS9ldmVudHMgLSDguJTguLbguIfguILguYnguK3guKHguLnguKXguIHguLLguKPguYHguILguYjguIfguILguLHguJnguJfguLHguYnguIfguKvguKHguJQKYXBwLmdldCgnL2FwaS9ldmVudHMnLCBhc3luYyAocmVxLCByZXMpID0+IHsKICB0cnkgewogICAgY29uc3QgY29ubmVjdGlvbiA9IGF3YWl0IHBvb2wuZ2V0Q29ubmVjdGlvbigpOwogICAgY29uc3QgW2V2ZW50c10gPSBhd2FpdCBjb25uZWN0aW9uLnF1ZXJ5KGAKICAgICAgU0VMRUNUIGUuKiwgcy5zcG9ydF9uYW1lLCB2LnZlbnVlX25hbWUgCiAgICAgIEZST00gRXZlbnQgZSAKICAgICAgSk9JTiBTcG9ydCBzIE9OIGUuc3BvcnRfaWQgPSBzLnNwb3J0X2lkIAogICAgICBKT0lOIFZlbnVlIHYgT04gZS52ZW51ZV9pZCA9IHYudmVudWVfaWQKICAgIGApOwogICAgY29ubmVjdGlvbi5yZWxlYXNlKCk7CiAgICByZXMuanNvbihldmVudHMpOwogIH0gY2F0Y2ggKGVycm9yKSB7CiAgICByZXMuc3RhdHVzKDUwMCkuanNvbih7IGVycm9yOiBlcnJvci5tZXNzYWdlIH0pOwogIH0KfSk7CgovLyBHRVQgL2FwaS9ldmVudHMvOmlkL3BhcnRpY2lwYW50cyAtIOC4lOC4tuC4h+C4o+C4suC4ouC4iuC4t+C5iOC4reC4meC4seC4geC4geC4teC4rOC4suC4l+C4teC5iOC5gOC4guC5ieC4suC4o+C5iOC4p+C4oeC4geC4suC4o+C5geC4guC5iOC4h+C4guC4seC4mQphcHAuZ2V0KCcvYXBpL2V2ZW50cy86aWQvcGFydGljaXBhbnRzJywgYXN5bmMgKHJlcSwgcmVzKSA9PiB7CiAgdHJ5IHsKICAgIGNvbnN0IGNvbm5lY3Rpb24gPSBhd2FpdCBwb29sLmdldENvbm5lY3Rpb24oKTsKICAgIGNvbnN0IFtwYXJ0aWNpcGFudHNdID0gYXdhaXQgY29ubmVjdGlvbi5xdWVyeShgCiAgICAgIFNFTEVDVCBhLiogCiAgICAgIEZST00gUGFydGljaXBhdGlvbiBwIAogICAgICBKT0lOIEF0aGxldGUgYSBPTiBwLmF0aGxldGVfaWQgPSBhLmF0aGxldGVfaWQgCiAgICAgIFdIRVJFIHAuZXZlbnRfaWQgPSA/CiAgICBgLCBbcmVxLnBhcmFtcy5pZF0pOwogICAgY29ubmVjdGlvbi5yZWxlYXNlKCk7CiAgICByZXMuanNvbihwYXJ0aWNpcGFudHMpOwogIH0gY2F0Y2ggKGVycm9yKSB7CiAgICByZXMuc3RhdHVzKDUwMCkuanNvbih7IGVycm9yOiBlcnJvci5tZXNzYWdlIH0pOwogIH0KfSk7CgovKioKICog4LmA4Liq4LmJ4LiZ4LiX4Liy4LiHIEFQSSDguKrguLPguKvguKPguLHguJrguILguYnguK3guKHguLnguKXguYDguKvguKPguLXguKLguI3guKPguLLguIfguKfguLHguKUgKE1lZGFscykKICovCi8vIEdFVCAvYXBpL21lZGFscyAtIOC4lOC4tuC4h+C4guC5ieC4reC4oeC4ueC4peC5gOC4q+C4o+C4teC4ouC4jeC4o+C4suC4h+C4p+C4seC4peC4l+C4seC5ieC4h+C4q+C4oeC4lAphcHAuZ2V0KCcvYXBpL21lZGFscycsIGFzeW5jIChyZXEsIHJlcykgPT4gewogIHRyeSB7CiAgICBjb25zdCBjb25uZWN0aW9uID0gYXdhaXQgcG9vbC5nZXRDb25uZWN0aW9uKCk7CiAgICBjb25zdCBbbWVkYWxzXSA9IGF3YWl0IGNvbm5lY3Rpb24ucXVlcnkoYAogICAgICBTRUxFQ1QgbS4qLCBhLmF0aGxldGVfbmFtZSwgZS5ldmVudF9uYW1lLCBzLnNwb3J0X25hbWUKICAgICAgRlJPTSBNZWRhbCBtCiAgICAgIEpPSU4gQXRobGV0ZSBhIE9OIG0uYXRobGV0ZV9pZCA9IGEuYXRobGV0ZV9pZAogICAgICBKT0lOIEV2ZW50IGUgT04gbS5ldmVudF9pZCA9IGUuZXZlbnRfaWQKICAgICAgSk9JTiBTcG9ydCBzIE9OIGUuc3BvcnRfaWQgPSBzLnNwb3J0X2lkCiAgICBgKTsKICAgIGNvbm5lY3Rpb24ucmVsZWFzZSgpOwogICAgcmVzLmpzb24obWVkYWxzKTsKICB9IGNhdGNoIChlcnJvcikgewogICAgcmVzLnN0YXR1cyg1MDApLmpzb24oeyBlcnJvcjogZXJyb3IubWVzc2FnZSB9KTsKICB9Cn0pOwoKLy8gR0VUIC9hcGkvbWVkYWxzL3RhbGx5IC0g4LiU4Li24LiH4LiC4LmJ4Lit4Lih4Li54Lil4LiV4Liy4Lij4Liy4LiH4LmA4Lir4Lij4Li14Lii4LiN4Lij4Liy4LiH4Lin4Lix4Lil4LiV4Liy4Lih4Lib4Lij4Liw4LmA4LiX4LioCmFwcC5nZXQoJy9hcGkvbWVkYWxzL3RhbGx5JywgYXN5bmMgKHJlcSwgcmVzKSA9PiB7CiAgdHJ5IHsKICAgIGNvbnN0IGNvbm5lY3Rpb24gPSBhd2FpdCBwb29sLmdldENvbm5lY3Rpb24oKTsKICAgIGNvbnN0IFt0YWxseV0gPSBhd2FpdCBjb25uZWN0aW9uLnF1ZXJ5KCdTRUxFQ1QgKiBGUk9NIE1lZGFsVGFsbHkgT1JERVIgQlkgZ29sZF9jb3VudCBERVNDLCBzaWx2ZXJfY291bnQgREVTQywgYnJvbnplX2NvdW50IERFU0MnKTsKICAgIGNvbm5lY3Rpb24ucmVsZWFzZSgpOwogICAgcmVzLmpzb24odGFsbHkpOwogIH0gY2F0Y2ggKGVycm9yKSB7CiAgICByZXMuc3RhdHVzKDUwMCkuanNvbih7IGVycm9yOiBlcnJvci5tZXNzYWdlIH0pOwogIH0KfSk7CgovLyBQT1NUIC9hcGkvbWVkYWxzIC0g4LmA4Lie4Li04LmI4Lih4LiC4LmJ4Lit4Lih4Li54Lil4LmA4Lir4Lij4Li14Lii4LiN4Lij4Liy4LiH4Lin4Lix4Lil4LmD4Lir4Lih4LmICmFwcC5wb3N0KCcvYXBpL21lZGFscycsIGFzeW5jIChyZXEsIHJlcykgPT4gewogIGNvbnN0IHsgbWVkYWxfdHlwZSwgYXRobGV0ZV9pZCwgZXZlbnRfaWQsIGNvdW50cnkgfSA9IHJlcS5ib2R5OwogIAogIHRyeSB7CiAgICBjb25zdCBjb25uZWN0aW9uID0gYXdhaXQgcG9vbC5nZXRDb25uZWN0aW9uKCk7CiAgICBjb25zdCBbcmVzdWx0XSA9IGF3YWl0IGNvbm5lY3Rpb24ucXVlcnkoCiAgICAgICdJTlNFUlQgSU5UTyBNZWRhbCAobWVkYWxfdHlwZSwgYXRobGV0ZV9pZCwgZXZlbnRfaWQsIGNvdW50cnkpIFZBTFVFUyAoPywgPywgPywgPyknLAogICAgICBbbWVkYWxfdHlwZSwgYXRobGV0ZV9pZCwgZXZlbnRfaWQsIGNvdW50cnldCiAgICApOwogICAgY29ubmVjdGlvbi5yZWxlYXNlKCk7CiAgICAKICAgIHJlcy5zdGF0dXMoMjAxKS5qc29uKHsgCiAgICAgIG1lc3NhZ2U6ICfguJrguLHguJnguJfguLbguIHguILguYnguK3guKHguLnguKXguYDguKvguKPguLXguKLguI3guKPguLLguIfguKfguLHguKXguKrguLPguYDguKPguYfguIgnLCAKICAgICAgbWVkYWxfaWQ6IHJlc3VsdC5pbnNlcnRJZCAKICAgIH0pOwogIH0gY2F0Y2ggKGVycm9yKSB7CiAgICByZXMuc3RhdHVzKDUwMCkuanNvbih7IGVycm9yOiBlcnJvci5tZXNzYWdlIH0pOwogIH0KfSk7CgovKioKICog4LmA4Liq4LmJ4LiZ4LiX4Liy4LiHIEFQSSDguKrguLPguKvguKPguLHguJrguILguYnguK3guKHguLnguKXguKrguJbguLTguJXguLTguIHguLLguKPguYHguILguYjguIfguILguLHguJkgKFJlY29yZHMpCiAqLwovLyBHRVQgL2FwaS9yZWNvcmRzIC0g4LiU4Li24LiH4LiC4LmJ4Lit4Lih4Li54Lil4Liq4LiW4Li04LiV4Li04LiB4Liy4Lij4LmB4LiC4LmI4LiH4LiC4Lix4LiZ4LiX4Lix4LmJ4LiH4Lir4Lih4LiUCmFwcC5nZXQoJy9hcGkvcmVjb3JkcycsIGFzeW5jIChyZXEsIHJlcykgPT4gewogIHRyeSB7CiAgICBjb25zdCBjb25uZWN0aW9uID0gYXdhaXQgcG9vbC5nZXRDb25uZWN0aW9uKCk7CiAgICBjb25zdCBbcmVjb3Jkc10gPSBhd2FpdCBjb25uZWN0aW9uLnF1ZXJ5KGAKICAgICAgU0VMRUNUIHIuKiwgcy5zcG9ydF9uYW1lLCBlLmV2ZW50X25hbWUKICAgICAgRlJPTSBSZWNvcmQgcgogICAgICBKT0lOIFNwb3J0IHMgT04gci5zcG9ydF9pZCA9IHMuc3BvcnRfaWQKICAgICAgSk9JTiBFdmVudCBlIE9OIHIuZXZlbnRfaWQgPSBlLmV2ZW50X2lkCiAgICBgKTsKICAgIGNvbm5lY3Rpb24ucmVsZWFzZSgpOwogICAgcmVzLmpzb24ocmVjb3Jkcyk7CiAgfSBjYXRjaCAoZXJyb3IpIHsKICAgIHJlcy5zdGF0dXMoNTAwKS5qc29uKHsgZXJyb3I6IGVycm9yLm1lc3NhZ2UgfSk7CiAgfQp9KTsKCi8qKgogKiDguYDguKrguYnguJnguJfguLLguIcgQVBJIOC4quC4s+C4q+C4o+C4seC4muC4guC5ieC4reC4oeC4ueC4peC4quC4luC4suC4meC4l+C4teC5iOC5geC4guC5iOC4h+C4guC4seC4mSAoVmVudWVzKQogKi8KLy8gR0VUIC9hcGkvdmVudWVzIC0g4LiU4Li24LiH4LiC4LmJ4Lit4Lih4Li54Lil4Liq4LiW4Liy4LiZ4LiX4Li14LmI4LmB4LiC4LmI4LiH4LiC4Lix4LiZ4LiX4Lix4LmJ4LiH4Lir4Lih4LiUCmFwcC5nZXQoJy9hcGkvdmVudWVzJywgYXN5bmMgKHJlcSwgcmVzKSA9PiB7CiAgdHJ5IHsKICAgIGNvbnN0IGNvbm5lY3Rpb24gPSBhd2FpdCBwb29sLmdldENvbm5lY3Rpb24oKTsKICAgIGNvbnN0IFt2ZW51ZXNdID0gYXdhaXQgY29ubmVjdGlvbi5xdWVyeSgnU0VMRUNUICogRlJPTSBWZW51ZScpOwogICAgY29ubmVjdGlvbi5yZWxlYXNlKCk7CiAgICByZXMuanNvbih2ZW51ZXMpOwogIH0gY2F0Y2ggKGVycm9yKSB7CiAgICByZXMuc3RhdHVzKDUwMCkuanNvbih7IGVycm9yOiBlcnJvci5tZXNzYWdlIH0pOwogIH0KfSk7CgovLyBHRVQgL2FwaS92ZW51ZXMvOmlkL2V2ZW50cyAtIOC4lOC4tuC4h+C4guC5ieC4reC4oeC4ueC4peC4geC4suC4o+C5geC4guC5iOC4h+C4guC4seC4meC5g+C4meC4quC4luC4suC4meC4l+C4teC5iOC4l+C4teC5iOC4geC4s+C4q+C4meC4lAphcHAuZ2V0KCcvYXBpL3ZlbnVlcy86aWQvZXZlbnRzJywgYXN5bmMgKHJlcSwgcmVzKSA9PiB7CiAgdHJ5IHsKICAgIGNvbnN0IGNvbm5lY3Rpb24gPSBhd2FpdCBwb29sLmdldENvbm5lY3Rpb24oKTsKICAgIGNvbnN0IFtldmVudHNdID0gYXdhaXQgY29ubmVjdGlvbi5xdWVyeShgCiAgICAgIFNFTEVDVCBlLiosIHMuc3BvcnRfbmFtZSAKICAgICAgRlJPTSBFdmVudCBlIAogICAgICBKT0lOIFNwb3J0IHMgT04gZS5zcG9ydF9pZCA9IHMuc3BvcnRfaWQgCiAgICAgIFdIRVJFIGUudmVudWVfaWQgPSA/CiAgICBgLCBbcmVxLnBhcmFtcy5pZF0pOwogICAgY29ubmVjdGlvbi5yZWxlYXNlKCk7CiAgICByZXMuanNvbihldmVudHMpOwogIH0gY2F0Y2ggKGVycm9yKSB7CiAgICByZXMuc3RhdHVzKDUwMCkuanNvbih7IGVycm9yOiBlcnJvci5tZXNzYWdlIH0pOwogIH0KfSk7CgovKioKICog4LmA4Liq4LmJ4LiZ4LiX4Liy4LiHIEFQSSDguKrguLPguKvguKPguLHguJrguILguYnguK3guKHguLnguKXguILguYjguLLguKfguKrguLLguKMgKE5ld3MpCiAqLwovLyBHRVQgL2FwaS9uZXdzIC0g4LiU4Li24LiH4LiC4LmJ4Lit4Lih4Li54Lil4LiC4LmI4Liy4Lin4Liq4Liy4Lij4LiX4Lix4LmJ4LiH4Lir4Lih4LiUCmFwcC5nZXQoJy9hcGkvbmV3cycsIGFzeW5jIChyZXEsIHJlcykgPT4gewogIHRyeSB7CiAgICBjb25zdCBjb25uZWN0aW9uID0gYXdhaXQgcG9vbC5nZXRDb25uZWN0aW9uKCk7CiAgICBjb25zdCBbbmV3c10gPSBhd2FpdCBjb25uZWN0aW9uLnF1ZXJ5KCdTRUxFQ1QgKiBGUk9NIE5ld3MgT1JERVIgQlkgcHVibGlzaF9kYXRlIERFU0MnKTsKICAgIGNvbm5lY3Rpb24ucmVsZWFzZSgpOwogICAgcmVzLmpzb24obmV3cyk7CiAgfSBjYXRjaCAoZXJyb3IpIHsKICAgIHJlcy5zdGF0dXMoNTAwKS5qc29uKHsgZXJyb3I6IGVycm9yLm1lc3NhZ2UgfSk7CiAgfQp9KTsKCi8vIEdFVCAvYXBpL25ld3MvZmVhdHVyZWQgLSDguJTguLbguIfguILguYjguLLguKfguKrguLLguKPguJfguLXguYjguYHguJnguLDguJnguLMKYXBwLmdldCgnL2FwaS9uZXdzL2ZlYXR1cmVkJywgYXN5bmMgKHJlcSwgcmVzKSA9PiB7CiAgdHJ5IHsKICAgIGNvbnN0IGNvbm5lY3Rpb24gPSBhd2FpdCBwb29sLmdldENvbm5lY3Rpb24oKTsKICAgIGNvbnN0IFtuZXdzXSA9IGF3YWl0IGNvbm5lY3Rpb24ucXVlcnkoJ1NFTEVDVCAqIEZST00gTmV3cyBXSEVSRSBpc19mZWF0dXJlZCA9IDEgT1JERVIgQlkgcHVibGlzaF9kYXRlIERFU0MnKTsKICAgIGNvbm5lY3Rpb24ucmVsZWFzZSgpOwogICAgcmVzLmpzb24obmV3cyk7CiAgfSBjYXRjaCAoZXJyb3IpIHsKICAgIHJlcy5zdGF0dXMoNTAwKS5qc29uKHsgZXJyb3I6IGVycm9yLm1lc3NhZ2UgfSk7CiAgfQp9KTs=