public function generate() { $files = new \Extool\Helpers\FilePackage(); $install_file = new \Extool\Helpers\File(); $uninstall_file = new \Extool\Helpers\File(); foreach ($this->rep->tables as $table) { $table->createDefaultKey(); $mysql = new \Extool\Helpers\MySQL($table); $install_file->appendContents($mysql->generateCreate() . "\n\n"); $uninstall_file->appendContents($mysql->generateDrop() . "\n"); } $files->addFile('admin/install.mysql.sql', $install_file); $files->addFile('admin/uninstall.mysql.sql', $uninstall_file); return $files; }
private function generateMySQL() { $component = $this->rep->system_name; $install_file = new \Extool\Helpers\File(); $uninstall_file = new \Extool\Helpers\File(); foreach ($this->rep->tables as $table) { $table->createDefaultKey(); $mysql = new \Extool\Helpers\MySQL($table); if ($component == $table->system_name) { $mysql->setName('#__' . $table->system_name); } else { $mysql->setName('#__' . $component . '_' . $table->system_name); } $install_file->appendContents($mysql->generateCreate() . "\n\n"); $uninstall_file->appendContents($mysql->generateDrop() . "\n"); if (isset($this->rep->data_sets[$table->name])) { $mysql->addData($this->rep->data_sets[$table->name]); $install_file->appendContents($mysql->generateInsert() . "\n\n"); } } $this->files->addFile('admin/install.mysql.sql', $install_file); $this->files->addFile('admin/uninstall.mysql.sql', $uninstall_file); }