How to load an sql dump using symfony

Question

I'm trying to make a user friendly way of testing via lime in symfony 1. I want to load a specific sql dump for each test I write (if required). The problem I face is that I don't know how to make dump loading independent of database type. Currently I'm using the shell exec() command. Here is the code :

  public function loadSql()
  {
    $this->diag("Loading dump...");
    if ($this->_sql_is_set)
    {
      if (file_exists($this->_getSqlPath()))
      {
        $this->_emptyDataBase();
        $options   = $this->_connection_manager->connection()->getOptions();
        $dsn_parts = $this->_connection_manager->parsePdoDsn($options['dsn']);
        exec("mysql -u{$options['username']} -p{$options['password']} {$dsn_parts['dbname']} < {$this->_getSqlPath()}");
        return $this;
      }
      else
      {
        $this->error("Nothing to load : sql file was not found in ".$this->_getDataDir());
        exit;
      }
    }
    else
    {
      $this->error("Nothing to load : sql dump was not set");
      exit;
    }
  }

$this->_connection_manager is an instance of Doctrine_Manager. Any help will with that?

waldek_h · Accepted Answer · 2013-11-30 11:01:07Z

1

Try with something like that:

public function loadSqlFiles(sfEvent $event)
{
    $task = $event->getSubject();
    $taskName = $task->getName();
    if ($taskName == 'insert-sql') {
        $conn = Doctrine_Manager::connection();
        $filesPath = sfConfig::get('sf_data_dir') . '/sql/full-data';

        // get all files
        $files = sfFinder::type('file')->sort_by_name()->name('*.sql')->in($filesPath);
        foreach ($files as $file) {
            $task->logSection('custom-sql', sprintf('Inserting custom sql file (%s)', $file));
            $res = $conn->getDbh()->exec(file_get_contents($file));
        }
    }
}

answered Nov 30, 2013 at 11:01

waldek_h

9309 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Vit Kos Over a year ago

Where did you get the getDbh() method ? looked through the code in Doctrine_Manager class and there is no such method. Also ran this code and getting this error Call to undefined method Doctrine_Manager::getDbh()

Vit Kos Over a year ago

Oh well, made a little research, and to have access to getDbh method we need to call getCurrentConnection() first. Thx for hinting that anyway.

waldek_h Over a year ago

Yes You need to have current connection to get access to getDbh thats why $conn = Doctrine_Manager::connection();

Collectives™ on Stack Overflow

How to load an sql dump using symfony

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related