public static function findKeysFor($provider_code) { if (empty(self::$__keys[$provider_code])) { $key = new self(); $provider = new Api_Model_Provider(); $provider->find($provider_code, 'code'); if (!$provider->getId()) { return $keys; } foreach ($provider->getKeys() as $tmp_key) { $key->addData($tmp_key->getKey(), $tmp_key->getValue()); } self::$__keys[$provider_code] = $key; } return self::$__keys[$provider_code]; }
<?php $this->query("\n CREATE TABLE `api_provider` (\n `provider_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `code` varchar(30) NOT NULL,\n `name` varchar(60) NOT NULL,\n `icon` varchar(50) NULL DEFAULT NULL,\n `created_at` datetime NOT NULL,\n `updated_at` datetime NOT NULL,\n PRIMARY KEY (`provider_id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\n CREATE TABLE `api_key` (\n `key_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `provider_id` int(11) unsigned NOT NULL,\n `key` varchar(30) NULL DEFAULT NULL,\n `value` varchar(255) NULL DEFAULT NULL,\n `created_at` datetime NOT NULL,\n `updated_at` datetime NOT NULL,\n PRIMARY KEY (`key_id`),\n KEY `KEY_PROVIDER_ID` (`provider_id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n"); $this->query("\n CREATE TABLE `api_user` (\n `user_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\n `username` varchar(50) NOT NULL,\n `firstname` varchar(50) NULL DEFAULT NULL,\n `lastname` varchar(50) NULL DEFAULT NULL,\n `password` varchar(100) NOT NULL,\n `created_at` datetime NOT NULL,\n `updated_at` datetime NOT NULL,\n PRIMARY KEY (`user_id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n"); $this->query("\n ALTER TABLE `api_key`\n ADD FOREIGN KEY `FK_PROVIDER_ID` (`provider_id`) REFERENCES `api_provider` (`provider_id`) ON DELETE CASCADE ON UPDATE CASCADE;\n"); $apis = array(array("code" => "instagram", "icon" => "fa-instagram", "keys" => array("token", "client_id")), array("code" => "facebook", "icon" => "fa-facebook-square", "keys" => array("app_id", "secret_key")), array("code" => "youtube", "icon" => "fa-youtube", "keys" => array("api_key")), array("code" => "soundcloud", "icon" => "fa-soundcloud", "keys" => array("client_id", "secret_id"))); foreach ($apis as $provider_data) { $provider_name = ucfirst($provider_data["code"]); $provider = new Api_Model_Provider(); $provider->setData(array("code" => $provider_data["code"], "name" => $provider_name, "icon" => $provider_data["icon"]))->save(); foreach ($provider_data["keys"] as $key) { $data = array('provider_id' => $provider->getId(), 'key' => $key); $key = new Api_Model_Key(); $key->setData($data)->save(); } }
<?php $this->query("ALTER TABLE `api_provider` ADD `icon` varchar(50) NULL DEFAULT NULL AFTER `name`;"); $provider_codes = array("instagram" => "fa-instagram", "facebook" => "fa-facebook-square", "youtube" => "fa-youtube"); foreach ($provider_codes as $provider_code => $icon_name) { $provider = new Api_Model_Provider(); $provider->find($provider_code, "code"); if ($provider->getId()) { $provider->setIcon($icon_name)->save(); } }