교리 2: 실제 예를 사용하여 원시 SQL 쿼리를 실행하는 방법은 무엇입니까?

<code class="php">public function truncateAndInitializeTables()
{
    // Get the entity manager
    $em = $this->getDoctrine()->getManager();

    // Open a connection to the database
    $conn = $em->getConnection();

    // Execute raw SQL queries to truncate tables
    $conn->executeUpdate('TRUNCATE TABLE table_one');
    $conn->executeUpdate('TRUNCATE TABLE table_two');

    // Execute raw SQL queries to insert default test data
    $query = "INSERT INTO table_one (column_one, column_two) VALUES ('value1', 'value2')";
    $conn->executeUpdate($query);
    $query = "INSERT INTO table_two (column_one, column_two) VALUES ('value3', 'value4')";
    $conn->executeUpdate($query);
}</code>