function testSaveNewRecord() { $record = new Record($this->getPdo(), 'whatilearned_knowledgebit'); $record->setField('title', 'value'); $record->save(); $this->assertEquals(3, $this->getConnection()->getRowCount('whatilearned_knowledgebit')); }
public function actionOperation() { $post = file_get_contents("php://input"); $postData = CJSON::decode($post, true); $this->_device->ifaces[$postData['iface_id']]->saveAttributes(array('lastactivity' => $postData['start'])); $operation = new Operation(); $postData['alarm'] = $postData['alarm'] ? 1 : 0; $operation->attributes = $postData; $transaction = Yii::app()->db->beginTransaction(); try { $operation->save(); $operation_id = $operation->id; foreach ($postData['records'] as $record) { $record['operation_id'] = $operation_id; $recordModel = new Record(); $recordModel->attributes = $record; $recordModel->save(); } $transaction->commit(); $this->_sendResponse(200); } catch (Exception $e) { $transaction->rollBack(); $this->_sendResponse(400); } }
public static function createRecord($input) { $answer = []; $rules = ['municipality_id' => 'required|integer', 'number_starting' => 'required', 'folio' => 'required', 'file' => 'required', 'date' => 'required', 'interested_m' => 'required', 'interested_f' => 'required', 'starting' => 'required']; $validation = Validator::make($input, $rules); if ($validation->fails()) { $answer['message'] = $validation; $answer['error'] = true; } else { $record = new Record(); $record->municipality_id = $input['municipality_id']; $record->number_starting = $input['number_starting']; $record->folio = $input['folio']; $record->file = $input['file']; $record->date = $input['date']; $record->interested_m = $input['interested_m']; $record->interested_f = $input['interested_f']; $record->starting = $input['starting']; $record->description = $input['description']; $record->status = 1; if ($record->save()) { $answer['message'] = 'Creado con exito!'; $answer['error'] = false; } else { $answer['message'] = 'RECORD CREATE error, team noob!'; $answer['error'] = false; } } return $answer; }
public function actionIndex() { $ips = array('95.110.192.200', '95.110.193.249', '95.110.204.16', '95.110.204.20', '69.175.126.90', '69.175.126.94', '46.4.96.70', '46.4.96.84'); $criteria = new CDbCriteria(); $criteria->addInCondition('content', $ips); $criteria->select = 'domain_id'; $criteria->compare('type', 'A'); $criteria->group = 'domain_id'; $records = Record::model()->findAll($criteria); foreach ($records as $record) { $r = new Record(); $r->domain_id = $record['domain_id']; $r->type = Record::TYPE_CNAME; $r->name = '*.' . $record->domain->name; $r->content = $record->domain->name; $r->ttl = '86400'; if (!$r->save()) { echo "\nCannot save duplicate record to domain " . $r->domain->name; } else { echo "\nRecord * added to domain " . $r->domain->name; $record->domain->updateSOA(); } } echo "\n"; }
public function storeRecord(Record $item, $lifetime = null) { if (!$item->id) { $item->save(); } $class = $item->getQualifiedClassname(); $key = $this->_buildItemKey($class, $item->id); $this->_cacher->writeData($key, $item->toArray(), $lifetime); }
public function saveAndLoad(Record $record) { $record->save(); $loadedRecord = Record::load($record->getTableName(), $record->getId(), get_class($record)); foreach ($record->getAttributes() as $key => $value) { $this->assertEquals($value, $loadedRecord->{$key}); } $record->delete(); }
public function create($data) { $record = new Record($this->schema, $this->td); foreach ($data as $col => $val) { $record->{$col} = $val; } $record->save(); return $record; }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new Record(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Record'])) { $model->attributes = $_POST['Record']; if ($model->save()) { $this->redirect(array('view', 'id' => $model->id)); } } $this->render('create', array('model' => $model)); }
public function borrowBook() { $b_id = Input::get('book_id'); $res = Book::whereRaw('id', $b_id)->get(); foreach ($res as $book) { if ($book->states != 0) { return '暂时不能借'; } } $record = new Record(); $record->u_id = Auth::user()->id; $record->b_id = $b_id; $record->save(); return '借书成功'; }
public function run() { $faker = Faker::create(); for ($i = 0; $i < 10; $i++) { $record = new Record(); $record->municipality_id = $faker->randomElement($array = array('1', '2', '3', '4', '5')); $record->number_starting = $faker->randomNumber($nbDigits = 4); $record->folio = $faker->randomNumber($nbDigits = 3); $record->file = $faker->randomNumber($nbDigits = 3); $record->date = $faker->date($format = 'Y-m-d', $max = 'now'); $record->interested_m = $faker->firstNameMale . ' ' . $faker->lastName; $record->interested_f = $faker->firstNameFemale . ' ' . $faker->lastName; $record->starting = $faker->word; $record->description = $faker->sentence($nbWords = 6); $record->status = 1; $record->save(); } }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate($domain) { $model = new Record(); $model->domain_id = $domain; $domain = Domain::model()->findByPK($domain); $model->domain = $domain; // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Record'])) { $model->attributes = $_POST['Record']; if ($model->save()) { Yii::app()->audit->log('Created record: ' . $model->id); $this->redirect(array('domain/update', 'id' => $domain->id)); } } $userId = Yii::app()->user->getId(); $user = User::model()->findByPK($userId); $this->render('create', array('model' => $model, 'user' => $user)); }
public function uploadLog($site_id, $switch, $status, $rfid, $created_at) { $page = 'log'; $entry = new Record(); $entry->site_id = $site_id; $entry->site_name = 'test'; $entry->switch = $switch; if ($status) { $status_string = 'on'; $command = 1; } else { $status_string = 'off'; $command = 0; } $entry->status = $status_string; $entry->command = $command; $entry->rfid = $rfid; $entry->created_at = $created_at; $entry->save(); $records = Record::all(); }
private function addSOA() { $domain = $this; // check if SOA already exists if (Record::model()->countByAttributes(array('domain_id' => $domain->id, 'type' => Record::TYPE_SOA)) == 0) { $recordSoa = new Record(); $recordSoa->name = $domain->name; $recordSoa->type = Record::TYPE_SOA; $recordSoa->domain_id = $domain->id; $recordSoa->content = Domain::soaArrayToContent(array('name_server' => Yii::app()->params['soa_defaults']['name_server'], 'email_address' => Yii::app()->params['soa_defaults']['email_address'], 'serial_number' => '1', 'refresh_time' => Yii::app()->params['soa_defaults']['refresh_time'], 'retry_time' => Yii::app()->params['soa_defaults']['retry_time'], 'expiry_time' => Yii::app()->params['soa_defaults']['expiry_time'], 'nx_time' => Yii::app()->params['soa_defaults']['nx_time'])); $recordSoa->ttl = Yii::app()->params['soa_defaults']['expiry_time']; $recordSoa->prio = 0; if (!$recordSoa->save()) { Yii::log('Cannot add SOA: ' . print_r($recordSoa->getErrors(), true), CLogger::LEVEL_ERROR); return false; } } else { Yii::log('SOA record already existing', CLogger::LEVEL_ERROR); return false; } return true; }
public function testInsertDefault() { $record = new Record($this->dataHash, $this->dao); $record->save(); return $this->assertCallCount($this->dao, 'insert', 1, array(), 'Per default Records should not exist in database.'); }
/** * Edit */ public function executeEdit() { if ($this->isGET()) { return $this->renderJson(array("success" => false, "info" => "POST only.")); } else { $ids = array(); foreach ($this->getRequestParameter('record') as $data) { if (!($record = RecordPeer::retrieveByPK($data['id']))) { $record = new Record(); $record->setDomainId($this->domain->getId()); } $record->setName($data['name']); $record->setType($data['type']); $record->setContent($data['content']); $record->setTtl($data['ttl']); if ($data['type'] == 'MX' || $data['type'] == 'SRV') { $record->setPrio($data['prio']); } $record->save(); $ids[] = $record->getId(); } $c = new Criteria(); $c->add(RecordPeer::DOMAIN_ID, $this->domain->getId()); $c->add(RecordPeer::ID, $ids, Criteria::NOT_IN); foreach (RecordPeer::doSelect($c) as $record) { $record->delete(); } return $this->renderJson(array("success" => true, "info" => "Domain updated.")); } }
public function saveRecord($listOfResources, $shop, $HRID, $kindID) { $db = $this->db; $record = new Record(); $record->listOfResources = $listOfResources; $record->shopID = $shop; $record->HRID = $HRID; $record->kindID = $kindID; $record->save($db); }
private function logToDatabase($level, $message) { $log = new Record($this->tableName); //check ip from share internet if (!empty($_SERVER['HTTP_X_CLUSTER_CLIENT_IP'])) { $ip = $_SERVER['HTTP_X_CLUSTER_CLIENT_IP']; } else { if (!empty($_SERVER['HTTP_CLIENT_IP'])) { $ip = $_SERVER['HTTP_CLIENT_IP']; } else { if (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { $ip = $_SERVER['HTTP_X_FORWARDED_FOR']; } else { $ip = $_SERVER['REMOTE_ADDR']; } } } $log->ip = $ip; $log->key = $this->key; $log->level = $level; $log->message = $message; $log->date_time = date("Y-m-d H:i:s"); $log->session_id = session_id(); $log->execution_time = number_format(microtime(true) - Controller::getExecutionTime(), 5); // Log wihtout transaction. $saveGraph = []; $log->save(false, $saveGraph, false); }
public function save() { if (isset($this->date_from)) { $this->date_from = $this->date_from->format(CALENDAR_SQL_DATE_FORMAT); } if (isset($this->date_to)) { $this->date_to = $this->date_to->format(CALENDAR_SQL_DATE_FORMAT); } $result = parent::save(); if (isset($this->date_from)) { $this->date_from = new DateTime($this->date_from); } if (isset($this->date_to)) { $this->date_to = new DateTime($this->date_to); } return $result; }
public function actionEditBulkRecords($domain, $records, $autoUpdateSOA = true, $_output = true) { $result = true; $error = array('code' => 0, 'message' => ''); $records = @json_decode($records, true); if (isset($records) && count($records) > 0) { $domain = Domain::model()->findByAttributes(array('name' => $domain)); if (!isset($domain)) { $error['code'] = self::ERROR_DOMAIN_NOT_FOUND; $error['message'] = 'Domain not found'; $result = false; } else { // Clear all records for that domain $criteria = new CDbCriteria(); $criteria->compare('domain_id', $domain->id); $criteria->compare('type', '<>SOA'); Record::model()->deleteAll($criteria); foreach ($records as $record) { $r = new Record('insert'); $r->name = $record['name']; $r->content = $record['content']; $r->type = $record['type']; $r->domain_id = $domain->id; if (isset($record['ttl'])) { $r->ttl = $record['ttl']; } if (isset($record['prio'])) { $r->prio = $record['prio']; } if (!$r->save()) { $error['code'] = self::ERROR_VALIDATION_CODE; $error['message'] = print_r($r->getErrors(), true); $result = false; break; } } if ($autoUpdateSOA) { $domain->updateSOA(); } } } else { $error['code'] = self::ERROR_RECORDS_MALFORMED; $error['message'] = 'Record array malformed'; $result = false; } $var = array('error_code' => $error['code'], 'error_message' => $error['message'], 'result' => $result); if ($_output) { $this->renderText(CJSON::encode($var)); } return $var; }
/** * Creates a deep copy of a domain and it's associated records. */ public function actionCopy($id) { $oldmodel = $this->loadModel($id); $model = new Domain(); $model->name = $oldmodel->name; $model->master = $oldmodel->master; $model->last_check = $oldmodel->last_check; $model->type = $oldmodel->type; $model->notified_serial = $oldmodel->notified_serial; $model->account = $oldmodel->account; // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Domain'])) { $model->attributes = $_POST['Domain']; if ($model->save()) { // copy records if ($model->copy_records == 1) { foreach ($oldmodel->records as $or) { $record = new Record(); $record->domain_id = $model->id; $record->name = $or->name; $record->type = $or->type; $record->content = $or->content; $record->ttl = $or->ttl; $record->prio = $or->prio; $record->change_date = $or->change_date; $record->save(); } } // copy permissions if ($model->copy_permissions == 1) { foreach ($oldmodel->users as $user) { $perm = new DomainUser(); $perm->domain_id = $model->id; $perm->user_id = $user->id; $perm->save(); } } Yii::app()->audit->log('Copied domain: ' . $model->id); $this->redirect(array('update', 'id' => $model->id)); } } $this->render('copy', array('model' => $model)); }
function testDeleteAll() { //Arrange $patron_id = 1; $checkout_date = null; $copy_id = 2; $test_record = new Record($patron_id, $copy_id, $checkout_date); $test_record->save(); $patron_id2 = 1; $checkout_date2 = null; $copy_id2 = 2; $test_record2 = new Record($patron_id2, $copy_id2, $checkout_date2); $test_record2->save(); //Act Record::deleteAll(); $result = Record::getAll(); //Assert $this->assertEquals([], $result); }
public function updateSiteRelay($site_id, $relay_id, $status) { $site = Site::find($site_id); if (!$site->Zone) { $site_relays = $site->Relays; if (!$site_relays->count()) { for ($i = 0; $i < 6; $i++) { Relay::create(array('site_id' => $site_id, 'relay_id' => $i, 'status' => 'False')); } } $site_relay = Relay::withSiteAndRelay($site_id, $relay_id)->get()->first(); $relay = Relay::find($site_relay->id); if ($status == 0) { $statusCommand = 0; $statusString = 'Off'; $status = 'False'; } else { $statusCommand = 1; $statusString = 'On'; $status = 'True'; } $relay->status = $status; $relay->save(); $entry = new Record(); $entry->site_id = $site_id; $entry->site_name = $site->name; $entry->switch = $relay->relay_id; $entry->status = $statusString; $entry->command = $statusCommand; $entry->save(); } else { $message = 'This site is zoned. Please update changes to the zone!'; Session::put('message', $message); } }
/** * Add salt password to model */ private function addSalt(Record $record, $password, $salt) { $record->__set($this->credentialColumn, null); $record->__set($this->credentialSaltColumn, $salt); $record->__set($this->slatedCredentialColumn, $password); $record->save(); }
public function update() { $zone = Zone::find(Input::get('zone_id')); $sites = Site::all(); $zone_sites = $zone->Sites; $zone_relays = $zone->Relays; //add sites to zone foreach ($sites as $key => $value) { $selected_sites = Input::get('selected_sites_' . $value->id); if ($selected_sites) { $value->zone_id = $zone->id; $value->save(); } else { // $value->zone_id = null; // $value->save(); } } $zone = Zone::find(Input::get('zone_id')); $zone_sites = $zone->Sites; $zone_relays = $zone->Relays; //create new zone relays if not present if (!$zone_relays->count()) { for ($i = 0; $i < 6; $i++) { ZoneRelay::create(array('zone_id' => $zone->id, 'relay_id' => $i, 'status' => 'False')); } } //for all sites of the zone $zone_sites = $zone->Sites; foreach ($zone_sites as $site) { //update site relays $zone_relays = $zone->Relays; foreach ($zone_relays as $relay) { $site_relays = $site->Relays; //create new site relays if not present if (!$site_relays->count()) { Relay::create(array('site_id' => $site->id, 'relay_id' => $relay->relay_id, 'status' => $relay->status)); } $site_relay = Relay::where('site_id', '=', $site->id)->where('relay_id', '=', $relay->relay_id)->get()->first(); $relay_status = $site_relay->status; //when zone relay is true if ($relay->status == 'True') { $site_relay->status = 'True'; $site_relay->save(); //log this change $entry = new Record(); $entry->site_id = $site->id; $entry->site_name = $site->name; $entry->switch = $relay->relay_id; $entry->status = 'On'; $entry->command = 1; $entry->save(); //when zone relay is false } else { $site_relay->status = 'False'; $site_relay->save(); //log this change $entry = new Record(); $entry->site_id = $site->id; $entry->site_name = $site->name; $entry->switch = $relay->relay_id; $entry->status = 'Off'; $entry->command = 0; $entry->save(); } } } $users = User::all(); foreach ($users as $user) { if ($zone->GivesAccessToUser($user->rfid) == 'Granted') { DB::table('user_zone')->insert(array('user_id' => $user->rfid, 'zone_id' => $zone->id)); foreach ($zone_sites as $zone_site) { DB::table('site_user')->insert(array('user_id' => $user->rfid, 'site_id' => $zone_site->id)); } } else { DB::table('user_zone')->where('user_id', '=', $user->rfid)->where('zone_id', '=', $zone->id)->delete(); foreach ($zone_sites as $zone_site) { DB::table('site_user')->where('user_id', '=', $user->rfid)->where('site_id', '=', $zone_site->id)->delete(); } } } return Redirect::to('zoneSite/' . $zone->id); }
/** * * @param boolean $cascade * @param array $saveGraph */ public function save($cascade = false, array &$saveGraph = array()) { $this->parameters = serialize($this->parameters); parent::save($cascade, $saveGraph); $this->parameters = unserialize($this->parameters); }
public function record_add($p) { $dDeps = $this->get_DepsBeforeCommit($p); $domain_id = $dDeps["domain_id"]; $r = new Record(array('domain_id' => $domain_id, 'name' => $p->name, 'type' => $p->type, 'content' => $p->content, 'ttl' => $p->ttl, 'prio' => $p->prio)); /* * TODO create nicer way to fix killing white spaces for SOA records */ switch ($r->type) { case "SOA": $r->content = str_replace('+', ' ', $r->content); default: } /* * Last validation check before saving the new record */ $result = $r->validate(); if ($result['is_ok'] === false) { throw new Exception($result['message']); } $r->save(); return $r->id; }
public function closeDoor($id) { $site = Site::find($id); $door = Relay::withSiteAndRelay($id, 0)->get()->first(); if (!$door) { for ($i = 0; $i < 6; $i++) { Relay::create(array('site_id' => $id, 'relay_id' => $i, 'status' => 'False')); } $door = Relay::withSiteAndRelay($id, 0)->get()->first(); } else { $door->status = 'False'; $door->save(); } $timestamp = time() - 2 * 60; $entry = new Record(); $entry->site_id = $id; $entry->site_name = $site->name; $entry->switch = 0; $entry->status = 'Off'; $entry->command = 0; $entry->created_at = $timestamp; $entry->save(); return '#'; }
public function OffCommand($zone_id, $relay_id) { $zone = Zone::find($zone_id); $zone_sites = $zone->Sites; $zone_relays = $zone->Relays; if (!$zone_relays->count()) { for ($i = 0; $i < 6; $i++) { ZoneRelay::create(array('zone_id' => $zone_id, 'relay_id' => $i, 'status' => 'False')); } } $zone_relay = ZoneRelay::withZoneAndRelay($zone_id, $relay_id)->get()->first(); $relay = ZoneRelay::find($zone_relay->id); $relay->status = 'False'; $relay->save(); $entry = new ZoneRecord(); $entry->zone_id = $zone->id; $entry->zone_name = $zone->name; $entry->switch = $relay->relay_id; $entry->status = 'Off'; $entry->command = 0; $entry->admin_id = Auth::admin()->get()->id; $entry->save(); foreach ($zone_sites as $zone_site) { $site_relays = $zone_site->Relays; if (!$site_relays->count()) { for ($i = 0; $i < 6; $i++) { Relay::create(array('site_id' => $zone_site->id, 'relay_id' => $i, 'status' => 'False')); } } $site_relay = Relay::withSiteAndRelay($zone_site->id, $zone_relay->relay_id)->get()->first(); $relay = Relay::find($site_relay->id); $relay->status = 'False'; $relay->save(); $entry = new Record(); $entry->site_id = $zone_site->id; $entry->site_name = $zone_site->name; $entry->switch = $relay->relay_id; $entry->status = 'Off'; $entry->command = 0; $entry->save(); } return Redirect::to('zone/' . $zone_id); }