#ifndef EXECUTE_SQL_FILE_H
#define EXECUTE_SQL_FILE_H

#include <QDebug>
#include <QFile>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QTextStream>

class ExecuteSqlFile {
private:
  QSqlDatabase &db_; // Reference to the database handler

  // Tracks if the parser is inside a trigger block
  bool insideTrigger_ = false;

  // Delimiter for SQL statements
  QString delimiter_;

public:
  // Constructor to initialize the database handler
  explicit ExecuteSqlFile(QSqlDatabase &db);

  // Executes the SQL commands from the given file
  bool operator()(const QString &filePath);

private:
  // Executes a single SQL statement
  bool executeStatement(const QString &statement) const;

  // Filter out comments and empty lines
  bool filterLine(QString &line);

  // Processes the DELIMITER command
  bool processDelimiterChange(QString &line);

  // Processes a single line of SQL and updates the current state
  bool processLine(QString &line, QString &currentStatement);

  // Processes a block of SQL statements, handling triggers separately
  bool processStatements(QStringList &statements);
};

#endif // EXECUTE_SQL_FILE_H