<?php
class ExportController extends ApplicationController{
  var $models = 'member,item,order';

  function member(){
    $this->export( $this->Member );
  }
  function item(){
    $this->export( $this->Item );
  }
  function order(){
    $this->export( $this->Order );
  }

  function export($dao){
    $table = $dao->getTableName();
    $cols = array_keys( $dao->getAttributeNames() );
    $cols_csv = implode(",",$cols);
    $sql = array();
    $results = $dao->_executeSql("SELECT * FROM {$table}");
    while ($record = $results->FetchRow()) {
      $vals = array();
      foreach( $cols as $i=>$name ){
        $vals[$i] = "'{$record[$name]}'";
      }
      $vals_csv = implode( ",", $vals );
      array_push( $sql, "insert into {$table} ({$cols_csv}) values ({$vals_csv});" );
    }
    $this->sendData( implode("\n",$sql),
      array('filename'=>"{$table}.sql",'type'=>'text/plain;charset=UTF8') );
  }
}
?>

class ExportController < ApplicationController

  def member
    export Member
  end
  def item
    export Item
  end
  def order
    export Order
  end

  def export( dao )
    table = dao.table_name
    cols = dao.new.attribute_names
    cols_csv = cols.join(',')
    sql = []
    dao.connection.select_all("SELECT * FROM #{table}").each do |record|
      vals = []
      cols.each do |name|
        vals << "'#{record[name]}'"
      end
      vals_csv = vals.join(',')
      sql << "insert into #{table} (#{cols_csv}) values (#{vals_csv});"
    end
    send_data( sql.join("\n") ,  :filename=>"#{table}.sql", :type=>'text/plain;charset=UTF8')
  end

end