    <?php
    /*********************************************************************************
     * Zurmo is a customer relationship management program developed by
     * Zurmo, Inc. Copyright (C) 2017 Zurmo Inc.
     *
     * Zurmo is free software; you can redistribute it and/or modify it under
     * the terms of the GNU Affero General Public License version 3 as published by the
     * Free Software Foundation with the addition of the following permission added
     * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
     * IN WHICH THE COPYRIGHT IS OWNED BY ZURMO, ZURMO DISCLAIMS THE WARRANTY
     * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
     *
     * Zurmo is distributed in the hope that it will be useful, but WITHOUT
     * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
     * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
     * details.
     *
     * You should have received a copy of the GNU Affero General Public License along with
     * this program; if not, see http://www.gnu.org/licenses or write to the Free
     * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
     * 02110-1301 USA.
     *
     * You can contact Zurmo, Inc. with a mailing address at 27 North Wacker Drive
     * Suite 370 Chicago, IL 60606. or at email address contact@zurmo.com.
     *
     * The interactive user interfaces in original and modified versions
     * of this program must display Appropriate Legal Notices, as required under
     * Section 5 of the GNU Affero General Public License version 3.
     *
     * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
     * these Appropriate Legal Notices must retain the display of the Zurmo
     * logo and Zurmo copyright notice. If the display of the logo is not reasonably
     * feasible for technical reasons, the Appropriate Legal Notices must display the words
     * "Copyright Zurmo Inc. 2017. All rights reserved".
     ********************************************************************************/

    /**
     * UpdateSchemaCommand allows the schema to be updated.  This is useful if you are developing
     * and make changes to metadata that affects the database schema.
     */
    class UpdateSchemaCommand extends CConsoleCommand
    {
        public function getHelp()
        {
            return <<<EOD
    USAGE
      zurmoc updateSchema <username> <overwriteExistingReadTables>

    DESCRIPTION
      This command runs an update on the database schema. It calls the
      InstallUtil::runAutoBuildFromUpdateSchemaCommand.

    PARAMETERS
     * username: username to log in as and run the import processes. Typically 'super'.
                  This user must be a super administrator.
     * overwriteExistingReadTables: If set to 1 all read tables would be regenerated, which could be a time consuming process.
                                    If not set, or set to 0, any existing read tables would be skipped.
                                    Defaults to 0.
EOD;
    }

        /**
         * Execute the action.
         * @param array command line parameters specific for this command
         */
        public function run($args)
        {
            set_time_limit('1800');
            if (!isset($args[0]))
            {
                $this->usageError('A username must be specified.');
            }
            try
            {
                Yii::app()->user->userModel = User::getByUsername($args[0]);
            }
            catch (NotFoundException $e)
            {
                $this->usageError('The specified username does not exist.');
            }
            $group = Group::getByName(Group::SUPER_ADMINISTRATORS_GROUP_NAME);
            if (!$group->users->contains(Yii::app()->user->userModel))
            {
                $this->usageError('The specified user is not a super administrator.');
            }

            $overwriteExistingReadTables = false;
            $overwriteReadTablesMessage = Zurmo::t('Commands', 'Skipping existing read Tables.');
            if (isset($args[1]) && $args[1] == 1)
            {
                $overwriteExistingReadTables = true;
                $overwriteReadTablesMessage = Zurmo::t('Commands', 'Overwriting any existing read Tables.');
            }

            $startTime = microtime(true);
            $template        = "{message}\n";
            $messageStreamer = new MessageStreamer($template);
            $messageStreamer->setExtraRenderBytes(0);
            $messageStreamer->add(Zurmo::t('Commands', 'Starting schema update process.'));
            $messageLogger = new MessageLogger($messageStreamer);
            $messageLogger->logDateTimeStamp = false;
            InstallUtil::runAutoBuildFromUpdateSchemaCommand($messageLogger);
            $messageStreamer->add(Zurmo::t('Commands', 'Autobuild complete, rebuilding read permissions.'));
            if (SHOW_QUERY_DATA)
            {
                $messageStreamer->add(FooterView::getTotalAndDuplicateQueryCountContent());
            }
            $messageStreamer->add($overwriteReadTablesMessage);
            AllPermissionsOptimizationUtil::rebuild($overwriteExistingReadTables, false, $messageStreamer);
            $messageStreamer->add(Zurmo::t('Commands', 'Rebuild read permissions complete.'));
            $endTime = microtime(true);
            $messageStreamer->add(Zurmo::t('Commands', 'Schema update complete.'));
            $messageStreamer->add(Zurmo::t('Commands', 'Total run time: {formattedTime} seconds.',
                                         array('{formattedTime}' => number_format(($endTime - $startTime), 3))));
            if (SHOW_QUERY_DATA)
            {
                $messageStreamer->add(FooterView::getTotalAndDuplicateQueryCountContent());
            }
        }
    }
?>