public function addtrackAction() { $form = new App_Form_NewTrack(); if (!empty($_POST) && $form->isValid($_POST)) { $artists = new App_Table_Artist(); //-------------------------------- // Check the file info, and save //-------------------------------- $track = new Track(); $track->title = $form->getValue('title'); $track->artistId = $this->_artist->id; $track->releaseId = $form->getValue('releaseId'); $track->single = true; $track->publishDate = $form->getValue('publishDate'); $track->save(); $this->_flash->addMessage('Your track info has been saved.'); $file = new TrackFile(); $file->trackId = $track->id; $file->fileName = $form->audioFile->getFileName(); $file->mimeType = mime_content_type($file->fileName); $file->save(); $track->originalFileId = $file->id; $track->save(); $this->_flash->addMessage('The audio file for your track has been scheduled for injestion. Once the file has been injested, it will be available on the site.'); $form = new App_Form_NewTrack(); } $form->setDefault('releaseId', $this->_request->getParam('releaseId')); $form->setMethod('post'); $form->setAction('/dashboard/catalog/addtrack'); $this->view->form = $form; }
/** * store in db action * * @return array */ protected function track($action, $model, $id) { $track = new Track(); $track->auth_id = Auth::user()->id; $track->date = new Datetime(); $track->action = $action; $track->trackable_id = $id; $track->trackable_type = $model; return $track->save(); }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { $latitud = Input::get('latitud', 0); $longitud = Input::get('longitud', 0); // DB::table('tracks')->insert( array( // 'latitud' => $latitud, // 'longitud' => $longitud // )); $track = new Track(); $track->latitud = $latitud; $track->longitud = $longitud; $track->save(); $respuesta = array("state" => "ok", "message" => "todo ok"); // $personas = Persona::all(); return json_encode($respuesta); }
/** * Performs the work of inserting or updating the row in the database. * * If the object is new, it inserts it; otherwise an update is performed. * All related objects are also updated in this method. * * @param PropelPDO $con * @return int The number of rows affected by this insert/update and any referring fk objects' save() operations. * @throws PropelException * @see save() */ protected function doSave(PropelPDO $con) { $affectedRows = 0; // initialize var to track total num of affected rows if (!$this->alreadyInSave) { $this->alreadyInSave = true; // We call the save method on the following object(s) if they // were passed to this object by their coresponding set // method. This object relates to these object(s) by a // foreign key reference. if ($this->aTrack !== null) { if ($this->aTrack->isModified() || $this->aTrack->isNew()) { $affectedRows += $this->aTrack->save($con); } $this->setTrack($this->aTrack); } if ($this->isNew()) { $this->modifiedColumns[] = FilePeer::ID; } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $pk = FilePeer::doInsert($this, $con); $affectedRows += 1; // we are assuming that there is only 1 row per doInsert() which // should always be true here (even though technically // BasePeer::doInsert() can insert multiple rows). $this->setId($pk); //[IMV] update autoincrement primary key $this->setNew(false); } else { $affectedRows += FilePeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } if ($this->collCollectionFiles !== null) { foreach ($this->collCollectionFiles as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collFeaturevectors !== null) { foreach ($this->collFeaturevectors as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collFeaturevectorsegments !== null) { foreach ($this->collFeaturevectorsegments as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } $this->alreadyInSave = false; } return $affectedRows; }
$start += $size; $log->save(TRUE); // SAVE TO DABATASE $ok = 0; $error = 0; $log->add("saving {$xmlName} content to database..."); $result = $doc->getElementsByTagName("item"); // cada item corresponde a un album (o bundle en lenguaje netm) if ($result->length > 0) { // si tengo albums para recorrer foreach ($result as $itemNumber => $xmlTrack) { $xmlItem = $result->item($itemNumber); if ($xmlItem->hasAttributes()) { $track = new Track("brasil"); $track->setFromXML($xmlItem); $saved = $track->save($dbc, "temas"); if ($saved === TRUE) { // ************************* // OBTENGO DATOS DEL TRACK $log->add("getting track id..."); $trackId = $track->getId(); // ************************* // ************************* // OBTENGO DATOS DEL ARTISTA $log->add("getting artist id..."); if ($trackId != NULL) { $artist = new Artist(); $log->add("searching db for artist=" . $track->getArtistName()); $artist->loadFromName($dbc, $track->getArtistName()); if ($artist->getMaches() == "1") { $artistId = $artist->getId();
return Response::error('500'); } }); Route::filter('auth', function () { if (Auth::guest()) { return Redirect::to('/'); } }); Route::filter('Sentry_auth', function () { if (Sentry::guest()) { return Redirect::to('/'); } }); Route::filter('ip', function () { // Create the Eloquent object Visit $visit = new Track(); $browser = new Browser(); $visit->location = Locate::get('city') . ', ' . Locate::get('state') . ', ' . Locate::get('country'); $visit->ip_address = Request::ip(); $visit->request = URI::current(); if (Auth::check()) { $visit->user_id = Auth::user()->id; } // Browser stats $visit->browser = $browser->getBrowser(); $visit->browser_version = $browser->getVersion(); $visit->platform = $browser->getPlatform(); $visit->mobile = $browser->isMobile(); $visit->robot = $browser->isRobot(); $visit->save(); });
/** * Performs the work of inserting or updating the row in the database. * * If the object is new, it inserts it; otherwise an update is performed. * All related objects are also updated in this method. * * @param PropelPDO $con * @return int The number of rows affected by this insert/update and any referring fk objects' save() operations. * @throws PropelException * @see save() */ protected function doSave(PropelPDO $con) { $affectedRows = 0; // initialize var to track total num of affected rows if (!$this->alreadyInSave) { $this->alreadyInSave = true; // We call the save method on the following object(s) if they // were passed to this object by their coresponding set // method. This object relates to these object(s) by a // foreign key reference. if ($this->aTrack !== null) { if ($this->aTrack->isModified() || $this->aTrack->isNew()) { $affectedRows += $this->aTrack->save($con); } $this->setTrack($this->aTrack); } if ($this->aFeaturevectortype !== null) { if ($this->aFeaturevectortype->isModified() || $this->aFeaturevectortype->isNew()) { $affectedRows += $this->aFeaturevectortype->save($con); } $this->setFeaturevectortype($this->aFeaturevectortype); } if ($this->aFile !== null) { if ($this->aFile->isModified() || $this->aFile->isNew()) { $affectedRows += $this->aFile->save($con); } $this->setFile($this->aFile); } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $pk = FeaturevectorPeer::doInsert($this, $con); $affectedRows += 1; // we are assuming that there is only 1 row per doInsert() which // should always be true here (even though technically // BasePeer::doInsert() can insert multiple rows). $this->setNew(false); } else { $affectedRows += FeaturevectorPeer::doUpdate($this, $con); } // Rewind the data LOB column, since PDO does not rewind after inserting value. if ($this->data !== null && is_resource($this->data)) { rewind($this->data); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } if ($this->collDistancesRelatedByTrackAId !== null) { foreach ($this->collDistancesRelatedByTrackAId as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collDistancesRelatedByTrackBId !== null) { foreach ($this->collDistancesRelatedByTrackBId as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collDistancejobs !== null) { foreach ($this->collDistancejobs as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } if ($this->collFeaturevectorsegments !== null) { foreach ($this->collFeaturevectorsegments as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } $this->alreadyInSave = false; } return $affectedRows; }
/** * Creates or updates the track in database getting data from file. * Used in /album/actions/executeRefreshAlbum * * @param Cd $cd_object ex: CD(Cd 1) * @param Array $track_info[] ex: [3, Beat it, MICHAEL JACKSON, 4:32, 128 kbps, 3,4 MB] * @return Track */ public static function createTrack($cd_object, $track_info) { //looking for this episode in db $track_object = NULL; foreach ($cd_object['Tracks'] as $track) { if ($track->title == $track_info['title']) { $track_object = $track; } } //if there is no episode if ($track_object == NULL) { $track_object = new Track(); $track_object->title = $track_info['title']; } $track_object->num_track = $track_info['num_track']; $track_object->duration = $track_info['duration']; $track_object->bitrate = $track_info['bitrate']; $track_object->filesize = $track_info['filesize']; $track_object->rating = $track_info['rating']; $track_object->lyrics = $track_info['lyrics']; $track_object->file_rel = $track_info['file_rel']; /********************************* YEAR *********************************/ if ($track_info['year'] == "") { $track_object->Year = NULL; } else { $year_object = Doctrine::getTable('Year')->findOneByName($track_info['year']); if ($year_object == NULL) { $year_object = Util::createYear($track_info['year']); } $track_object->Year = $year_object; } /********************************* GENRE *********************************/ if ($track_info['genre'] == "") { $track_object->Genre = NULL; } else { $genre_object = Doctrine::getTable('Genre')->findOneByName($track_info['genre']); if ($genre_object == NULL) { $genre_object = Util::createGenre($track_info['genre']); } $track_object->Genre = $genre_object; } /********************************* SINGER *********************************/ if ($track_info['artist'] == "") { $track_object->Singer = NULL; } else { $singer_object = Doctrine::getTable('Singer')->findOneByName(Util::formatName($track_info['artist'])); if ($singer_object == NULL) { $singer_object = Util::createSinger(Util::formatName($track_info['artist'])); } $track_object->Singer = $singer_object; } $track_object->save(); $cd_object->Tracks[] = $track_object; $cd_object->save(); return $track_object; }