/** * 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->aMovie !== null) { if ($this->aMovie->isModified() || $this->aMovie->getCulture() && $this->aMovie->getCurrentMovieI18n()->isModified() || $this->aMovie->isNew()) { $affectedRows += $this->aMovie->save($con); } $this->setMovie($this->aMovie); } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $pk = MovieI18nPeer::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 += MovieI18nPeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } $this->alreadyInSave = false; } return $affectedRows; }
public function post_save() { $movie = new Movie(); $movie->nombre = Input::get('nombre'); $movie->duracion = Input::get('duracion'); $movie->save(); return Redirect::to('movie'); }
private function beforeInsert() { $this->log_content = Callback::searchMovie($this->query); foreach ($this->getContent() as $movie_info) { if (!Movie::model()->with('attributes')->find('tmdb_id=:id', array(':id' => $movie_info['imdb_id']))) { $movie = new Movie(); $movie->setUrlKey($movie_info); $movie->tmdb_id = $movie_info['id']; $movie->imdb_id = $movie_info['imdb_id']; $movie->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->aMovie !== null) { if ($this->aMovie->isModified() || $this->aMovie->isNew()) { $affectedRows += $this->aMovie->save($con); } $this->setMovie($this->aMovie); } if ($this->aPerson !== null) { if ($this->aPerson->isModified() || $this->aPerson->isNew()) { $affectedRows += $this->aPerson->save($con); } $this->setPerson($this->aPerson); } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $criteria = $this->buildCriteria(); $pk = BasePeer::doInsert($criteria, $con); $affectedRows += 1; $this->setNew(false); } else { $affectedRows += MoviespersonsPeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } $this->alreadyInSave = false; } return $affectedRows; }
include 'database_connection.php'; include 'classes/MediaItem.php'; include 'classes/Game.php'; include 'classes/Book.php'; include 'classes/Music.php'; include 'classes/Movie.php'; $game = new Game(); $game->setTitle('Watch Dogs'); $game->setDesc('Crappy shit wannabe hacker game'); $game->setRating(1); $game->setTags(['dnt']); print '<p>' . ($game->save() ? "Saving successful" : "Saving unsuccessful") . '</p>'; $book = new Book(); $book->setTitle('Momo'); $book->setDesc('Dreamy and so on'); $book->setRating(4); $book->setTags(['tc']); print '<p>' . ($book->save() ? "Saving successful" : "Saving unsuccessful") . '</p>'; $movie = new Movie(); $movie->setTitle('The big short'); $movie->setDesc('Capitalism'); $movie->setRating(3); $movie->setTags(['tc', 'wtf']); print '<p>' . ($movie->save() ? "Saving successful" : "Saving unsuccessful") . '</p>'; $music = new Music(); $music->setTitle('Bravo Hits 666'); $music->setDesc('Diabolic Bullshit'); $music->setRating(1); $music->setTags(['dnt']); print '<p>' . ($music->save() ? "Saving successful" : "Saving unsuccessful") . '</p>';
public function testI18nWithRelations2() { MovieQuery::create()->deleteAll(); $count = MovieQuery::create()->count(); $this->assertEquals(0, $count, 'No movie before the test'); ToyQuery::create()->deleteAll(); $count = ToyQuery::create()->count(); $this->assertEquals(0, $count, 'No toy before the test'); ToyI18nQuery::create()->deleteAll(); $count = ToyI18nQuery::create()->count(); $this->assertEquals(0, $count, 'No i18n toys before the test'); MovieI18nQuery::create()->deleteAll(); $count = MovieI18nQuery::create()->count(); $this->assertEquals(0, $count, 'No i18n movies before the test'); $t = new Toy(); $t->setLocale('en'); $t->setName('My Name'); $t->setLocale('fr'); $t->setName('Mon Nom'); $t->setLocale('en'); $this->assertEquals('My Name', $t->getName()); $t->setLocale('fr'); $this->assertEquals('Mon Nom', $t->getName()); $m = new Movie(); $m->addToy($t); $m->save(); $count = MovieQuery::create()->count(); $this->assertEquals(1, $count, '1 movie'); $count = ToyQuery::create()->count(); $this->assertEquals(1, $count, '1 toy'); $count = ToyI18nQuery::create()->count(); $this->assertEquals(2, $count, '2 i18n toys'); $count = MovieI18nQuery::create()->count(); $this->assertEquals(0, $count, '0 i18n movies'); }
public function postAddMovie() { $movie = new Movie(); $movie->title = Input::get('title'); $movie->genre = Input::get('genre'); $movie->year = Input::get('year'); $movie->user_id = Auth::user()->id; # Try to add the user try { $movie->save(); } catch (Exception $e) { return Redirect::to('/add-movie')->with('flash_message', 'New movie failed to create; please try again.')->withInput(); } return Redirect::to('/browse-movies')->with('flash_message', 'New movie created successfully!'); }
$fecha = $datos[$i]['value']; break; case "embedUrl": $trailer = $datos[$i]['value']; break; } } //me inserta una nueva fila a la tabla Movie por asi decirlo. Esta tabla tiene los campos name, description.... //la variable $name_mov tiene el nombre de la pelicula que quiero guardar $nueva_movie = new Movie(); $nueva_movie->name = $name_mov; $nueva_movie->description = $description; $nueva_movie->director = $director; $nueva_movie->datePublished = $fecha; $nueva_movie->embedUrl = $trailer; $nueva_movie->save(); }); /* modificar una película en concreto */ $app->put('/movies/:id', function ($id) use($app) { //recoge los datos del body y me devuelve los datos en json //die($datos['template']['data]); $body = $app->request->getBody(); //Esto me lo decofica de JSON a PHP $template = json_decode($body, true); //obtiene una arrary con las lineas del data del JSON que nosotros le pasamos. $datos = $template['template']['data']; //$name_mov, $email, $description $longitud = count($datos); for ($i = 0; $i < $longitud; $i++) { switch ($datos[$i]['name']) { case "name":
break; case "datePublished": $datePublished = $arrayDatos['value']; break; case "embedUrl": $embedUrl = $arrayDatos['value']; break; } } $nueva_movies = new Movie(); $nueva_movies['name'] = $name; $nueva_movies['description'] = $description; $nueva_movies['director'] = $director; $nueva_movies['datePublished'] = $datePublished; $nueva_movies['embedUrl'] = $embedUrl; $nueva_movies->save(); }); /* PUT MOVIE */ $app->put('/movies/:id', function ($id) use($app) { // codigo para peticiones PUT (creacion de items) $template = json_decode($app->request->getBody(), true); $datos = $template['template']['data']; // for each para los datos de las pelis foreach ($datos as $arrayDatos) { switch ($arrayDatos['name']) { case "name": $name = $arrayDatos['value']; break; case "description": $description = $arrayDatos['value']; break;
function wp_movie_ratings_management_page() { # DATABASE -> ADD A NEW MOVIE # Get title of the movie and save its rating in the database if (isset($_POST["action"]) && substr(strtolower($_POST["action"]), 0, 3) == "add") { $url = isset($_POST["url"]) ? wp_movie_ratings_utf8_raw_url_decode($_POST["url"]) : null; $rating = isset($_POST["rating"]) ? $_POST["rating"] : null; $title = isset($_POST["title"]) ? wp_movie_ratings_utf8_raw_url_decode($_POST["title"]) : ""; $review = isset($_POST["review"]) ? wp_movie_ratings_utf8_raw_url_decode($_POST["review"]) : ""; $replacement_url = isset($_POST["replacement_url"]) ? wp_movie_ratings_utf8_raw_url_decode($_POST["replacement_url"]) : ""; $watched_on = isset($_POST["watched_on"]) ? wp_movie_ratings_utf8_raw_url_decode($_POST["watched_on"]) : null; $movie = new Movie($url, $rating, $review, $title, $replacement_url, $watched_on); $msg = $movie->parse_rating(); if (empty($msg)) { if (!empty($url)) { $msg = $movie->parse_imdb_url(); } # fetch title from imdb if (empty($msg) && empty($title) && !empty($url)) { $msg = $movie->get_title(); } # save new movie rating in the database if (empty($msg)) { $msg = $movie->save(); } } echo wp_movie_ratings_utf8_raw_url_decode($msg); $m = new Movie(); # new 'empty' movie object } # DATABASE -> DELETE MOVIE if (isset($_POST["action"]) && substr(strtolower($_POST["action"]), 0, 6) == "delete") { $mm = new Movie(); $movie = $mm->get_movie_by_id($_POST["id"]); if ($movie != null) { echo $movie->delete(); } else { echo '<div id="message" class="error fade"><p><strong>Error: no movie review to delete.</strong></p></div>'; } } # DATABASE -> UPDATE MOVIE DATA if (isset($_POST["action"]) && substr(strtolower($_POST["action"]), 0, 6) == "update") { $movie = new Movie(); $m = $movie->get_movie_by_id($_POST["id"]); if (isset($_POST["url"]) && isset($_POST["title"]) && isset($_POST["rating"]) && isset($_POST["review"]) && isset($_POST["replacement_url"]) && isset($_POST["watched_on"])) { echo $m->update_from_post(); } } # EDIT MOVIE if (isset($_POST["action"]) && $_POST["action"] == "edit" || isset($_GET["action"]) && $_GET["action"] == "edit" && !isset($_POST["action"])) { $movie = new Movie(); $id = isset($_POST["id"]) ? $_POST["id"] : (isset($_GET["id"]) ? $_GET["id"] : 0); $m = $movie->get_movie_by_id($id); $dialog_title = "Edit"; $action = "Update"; if ($m == null) { echo '<div id="message" class="error fade"><p><strong>Error: movie review not found.</strong></p></div>'; } } else { # ADD MOVIE $dialog_title = "Add a new"; $action = "Add a new"; $m = new Movie(null, 7); # new 'empty' movie object (7 is the default rating) } $dialog_title .= " movie rating"; ?> <div class="wrap"> <h2><?php echo $dialog_title; ?> </h2> <?php if ($m != null) { $m->show_add_edit_form($action); } wp_movie_ratings_show(20, array("text_ratings" => "yes", "include_review" => "no", "sidebar_mode" => "no")); ?> <p>If you'd like to edit earlier movie reviews you need to create a <a href="http://pawelgoscicki.com/projects/wp-movie-ratings/#installation">movie reviews page</a> and click (while being logged in) on the small 'e' link next to the movie title.</p> <?php wp_movie_ratings_show_statistics("detailed"); ?> <h2>Bookmarklet</h2> <p>Add the following link to your Bookmarklets folder so you can rate your movies without visiting Wordpress administration page. You must be <strong>logged in</strong> to your Wordpress blog for it to work, though.</p> <p><a href="javascript:(function(){open('<?php echo wp_movie_ratings_get_plugin_path("absolute"); ?> add_movie.html?url='+escape(location.href),'<?php echo basename(__FILE__, ".php"); ?> ','toolbar=no,width=432,height=335')})()" title="Add movie rating bookmarklet">Add movie rating bookmarklet</a></p> </div> <?php }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { $time = time(); $name = Input::get('name'); $year = Input::get('year'); $director = Input::get('director'); $writer = Input::get('writer'); $stars = Input::get('stars'); $outline = Input::get('outline'); $story = Input::get('story'); $genre = Input::get('genre'); $release = Input::get('release'); $rating = Input::get('rating'); $duration = Input::get('duration'); $country = Input::get('country'); $chars = preg_replace('/[^a-zA-Z0-9\\s]/', '', $name); // Removes special chars. $space = str_replace(' ', '', $chars); // Replaces all spaces $tags = $name . ', ' . $chars . ', ' . $space; $image_name = ''; if (Input::hasFile('image')) { $original = Input::file('image')->getClientOriginalName(); $image_name = $time . "_" . $original; $destinationPath = 'public/uploads/movie/' . $year . '/'; if (Input::file('image')->move($destinationPath, $image_name)) { } } $rev = new Movie(); $rev->fl_name = $name; $rev->fl_year = $year; $rev->fl_dir_ar_id = $director; $rev->fl_writer = $writer; $rev->fl_stars = $stars; $rev->fl_outline = $outline; $rev->fl_story = $story; $rev->fl_genre = $genre; $rev->fl_releasedate = $release; $rev->fl_rating = $rating; $rev->fl_tags = $tags; $rev->fl_duration = $duration; $rev->fl_country = $country; $rev->fl_status = '1'; $rev->fl_image = $image_name; $rev->save(); }
/** * Creates a new movie in database. * Used in /movie/actions/executeRefreshMovieCollection * * @param String $movie_title ex: Star Wars.mkv * @param String $movie_rel_filename ex: Star Wars.mkv */ public static function createMovie($movie_title, $movie_rel_filename, $user) { $movie_object = Doctrine::getTable('Movie')->findOneByTitle($movie_title); $settings = Doctrine_Core::getTable('Settings')->findOneByUserId($user); //if new let's create it if ($movie_object == NULL) { $movie_object = new Movie(); $movie_object->title = $movie_title; $movie_object->cover_index = 'NULL'; $movie_object->cover_show = 'NULL'; } $movie_object->file_abs = Util::makePath(array($settings['movies_root'], utf8_encode($movie_rel_filename))); $movie_object->file_rel = Util::changePathSeparators(Util::makeURLPath(array($settings['movies_root_rel'], utf8_encode($movie_rel_filename)))); $movie_object->save(); }