/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
// posts data exported using phpMyAdmin
$posts_data = [['provider' => 'twitter', 'uri' => 'https://twitter.com/AvrilLavigne/status/676145834073923584', 'source_time' => '2015-12-13 21:05:03', 'text' => 'Happy 26th Birthday to the sweetest sweetheart taylorswift xoxoxo <a href="https://www.instagram.com/p/_PxZA1I4CD/" target="_blank" rel="nofollow">instagram.com/...p/_PxZA1I4CD/</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_VMOIoMxSM/', 'source_time' => '2015-12-15 23:35:41', 'text' => 'How is she so beautiful?♡♡♡
(I\'m going to Target now to buy wrapping paper)
#bambi #pastel #like4like #selenagomez #taylorswift #arianagrande #indie #pastel #pinkbambi #flowers #onedirection #mitam #madeintheam #littlemix #arianagrande #grande #ariana'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_VP2-akr-5/', 'source_time' => '2015-12-16 00:07:29', 'text' => '{ #KatyPerry } *me when someone bumps into me and says sorry
'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/CapitalOfficial/status/676729488315666436', 'source_time' => '2015-12-15 11:44:17', 'text' => '@katyperry has been nominated for Best Female in the '], ['provider' => 'twitter', 'uri' => 'https://twitter.com/taylornation13/status/675632059474317312', 'source_time' => '2015-12-12 11:03:30', 'text' => 'Long live... '], ['provider' => 'twitter', 'uri' => 'https://twitter.com/taylornation13/status/675259625554485248', 'source_time' => '2015-12-11 10:23:35', 'text' => 'Dancing, castles, heartbreak... All a part of THE DREAM that is life as a new romantic! ❤️ <a href="https://twitter.com/search?q=%231989TourMelbourne" target="_blank">#1989TourMelbourne</a> <a href="https://pbs.twimg.com/ext_tw_video_thumb/675259111848693760/pu/img/T2o5frXxqYhcjYO2.jpg" target="_blank">pic.twitter.c...om/J9VeBThru7</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_V9W_EuHen/', 'source_time' => '2015-12-16 06:45:04', 'text' => 'Shake it off '], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_WApP6AmaV/', 'source_time' => '2015-12-16 07:13:46', 'text' => '#wcw '], ['provider' => 'twitter', 'uri' => 'https://twitter.com/giphy/status/676562118724870144', 'source_time' => '2015-12-15 00:39:13', 'text' => 'The red carpet can be a little overwhelming for new, young stars like BB-8 <a href="https://twitter.com/search?q=%23ForceAwakens" target="_blank">#ForceAwakens</a> <a href="https://twitter.com/search?q=%23giphycam" target="_blank">#giphycam</a> <a href="http://twitter.com/giphy/status/676562118724870144/photo/1" target="_blank" rel="nofollow">pic.twitter.c...om/fNT9CkXSCE</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_WEx0ypyJT/', 'source_time' => '2015-12-16 07:49:54', 'text' => 'I am SO excited for Legends of Tomorrow '], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_WCDdVi1Hm/', 'source_time' => '2015-12-16 07:26:05', 'text' => 'Unnnnngghhhh this girl. #wcw #womancrushwednesday #willaholland #speedy #arrow'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_WD2ziRjZA/', 'source_time' => '2015-12-16 07:41:50', 'text' => '❤️ #victoriassecret #vsfashionshow #style #instastyle #fashionable #fashion #fashionblogger #styleblogger #love #loveit #hair #makeup #candiceswanepoel #angels #angel'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_V40ksFG6s/', 'source_time' => '2015-12-16 06:05:25', 'text' => 'Miranda at the vsfashionshow 2008 fittings, she\'s so lovely! '], ['provider' => 'twitter', 'uri' => 'https://twitter.com/VictoriasSecret/status/674434163894788096', 'source_time' => '2015-12-09 03:43:29', 'text' => 'You\'re up, <a href="https://twitter.com/angelcandice" target="_blank">@angelcandice</a>!! <a href="https://twitter.com/search?q=%23VSFashionShow" target="_blank">#VSFashionShow</a> <a href="https://pbs.twimg.com/media/CVwSSyHWcAA3A7u.jpg" target="_blank">pic.twitter.c...om/Uj8gbq5NBM</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_Vyaz1D2fA/', 'source_time' => '2015-12-16 05:09:28', 'text' => '#xmenapocalypse #xmen #sequeal #2016'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_XdHBaOn6y/', 'source_time' => '2015-12-16 20:41:45', 'text' => 'Today I\'m going to Melbourne! I stopped by the beach resort & Albury for two days '], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_XesJctYqn/', 'source_time' => '2015-12-16 20:55:33', 'text' => 'Gigi on Exotic Butterflies segment with a performance of Ellie Goulding. '], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_XgAv8NYtr/', 'source_time' => '2015-12-16 21:07:06', 'text' => 'Alessandra on Fireworks segment with a performance of The Weeknd. '], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_Xgv2aB21k/', 'source_time' => '2015-12-16 21:13:32', 'text' => 'We had, a beautiful magic love there, what a sad beautiful tragic love affair. #taylorswift #taylurking'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/ScreamQueens/status/676945628711231491', 'source_time' => '2015-12-16 02:03:09', 'text' => 'Going a bit insane without a new <a href="https://twitter.com/search?q=%23ScreamQueens" target="_blank">#ScreamQueens</a> today? Here\'s something to calm the madness: <a href="http://fox.tv/WatchScrmQns" target="_blank" rel="nofollow">fox.tv/WatchScrmQns</a> <a href="http://twitter.com/ScreamQueens/status/676945628711231491/photo/1" target="_blank" rel="nofollow">pic.twitter.c...om/byc1pjldc9</a>'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/GalGadot/status/677171651528687616', 'source_time' => '2015-12-16 17:01:17', 'text' => 'I welcome you into my dream. Here\'s an exclusive new Wonder Woman banner for <a href="https://twitter.com/BatmanvSuperman" target="_blank">@BatmanvSuperman</a>. <a href="https://pbs.twimg.com/media/CWXL_lVUwAAtvr8.jpg" target="_blank">pic.twitter.c...om/3wYP2KfWI4</a>'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/BatmanvSuperman/status/674045753606574082', 'source_time' => '2015-12-08 02:00:05', 'text' => 'The battle begins March 2016. <a href="https://twitter.com/search?q=%23BatmanvSuperman" target="_blank">#BatmanvSuperman</a> <a href="http://twitter.com/BatmanvSuperman/status/674045753606574082/photo/1" target="_blank" rel="nofollow">pic.twitter.c...om/RODmw0l2xq</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_Xj1-zGvr7/', 'source_time' => '2015-12-16 21:40:35', 'text' => 'Oooooh que bella '], ['provider' => 'twitter', 'uri' => 'https://twitter.com/MaximMag/status/677150484357058560', 'source_time' => '2015-12-16 15:37:10', 'text' => 'Arrow\'s Katrina Law talks girl crushes, Chinese food, and getting her attention <a href="http://MAXIMM.AG/lWsGR7O" target="_blank" rel="nofollow">MAXIMM.AG/lWsGR7O</a> <a href="https://pbs.twimg.com/media/CWW4xwHXIAEr6rG.jpg" target="_blank">pic.twitter.c...om/2YntBFvZ5y</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_Xt8UWTEYM/', 'source_time' => '2015-12-16 23:08:50', 'text' => 'Official \'CW\'s Legends Of Tomorrow\' Character Posters!'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_XeP6PwiUj/', 'source_time' => '2015-12-16 20:51:42', 'text' => '#katiecassidy #Coltonhaynes #arrow #flarrow #fandom #oliverqueen #laurellance #arsenal #royharper'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_X1vQFx4k2/', 'source_time' => '2015-12-17 00:16:57', 'text' => 'Jensen and Jared fangirling over Arrow. '], ['provider' => 'twitter', 'uri' => 'https://twitter.com/IGN/status/676902260752814080', 'source_time' => '2015-12-15 23:10:49', 'text' => 'BB-8 wasn\'t the only droid rocking the red carpet last night! Check out this dynamic duo. <a href="https://twitter.com/search?q=%23StarWars" target="_blank">#StarWars</a> <a href="https://twitter.com/search?q=%23ForceAwakens" target="_blank">#ForceAwakens</a> <a href="https://amp.twimg.com/v/08a8222b-ecb5-4a3e-94b8-bc56334d9e72" target="_blank" rel="nofollow">amp.twimg.com/v/08a8222b-ecb…</a>'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/Variety/status/677154500742799360', 'source_time' => '2015-12-16 15:53:08', 'text' => 'WATCH: <a href="https://twitter.com/search?q=%23ForceAwakens" target="_blank">#ForceAwakens</a> cast, <a href="https://twitter.com/jimmyfallon" target="_blank">@jimmyfallon</a>, <a href="https://twitter.com/theroots" target="_blank">@theroots</a> sing <a href="https://twitter.com/search?q=%23StarWars" target="_blank">#StarWars</a> theme music <a href="http://bit.ly/1RRHNQS" target="_blank" rel="nofollow">bit.ly/1RRHNQS</a> <a href="https://pbs.twimg.com/media/CWW77HsUsAIaDKS.jpg" target="_blank">pic.twitter.c...om/RIxrJUzoqr</a>'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/sweetyhigh/status/677292269712621568', 'source_time' => '2015-12-17 01:00:35', 'text' => 'TSWIFT DOPPELGANGER || Can you believe she looks as good as <a href="https://twitter.com/search?q=%23TaylorSwift" target="_blank">#TaylorSwift</a>? '], ['provider' => 'twitter', 'uri' => 'https://twitter.com/taylorswift13/status/676085322061512704', 'source_time' => '2015-12-13 17:04:36', 'text' => 'Thank you so much for all the birthday wishes. I have a little surprise for you. <a href="https://twitter.com/search?q=%231989WorldTourLIVE" target="_blank">#1989WorldTourLIVE</a> <a href="https://twitter.com/applemusic" target="_blank">@applemusic</a> <a href="https://amp.twimg.com/v/8bd5ae39-20c8-43f2-aa49-aaedfce0441e" target="_blank" rel="nofollow">amp.twimg.com/v/8bd5ae39-20c…</a>'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/ABCFpll/status/676533514225893378', 'source_time' => '2015-12-14 22:45:33', 'text' => 'They’re all hiding something. But what? Find out <a href="https://twitter.com/search?q=%23January12" target="_blank">#January12</a>, <a href="https://twitter.com/search?q=%235YearsForward" target="_blank">#5YearsForward</a> with the <a href="https://twitter.com/search?q=%23PrettyLittleLiars" target="_blank">#PrettyLittleLiars</a>! <a href="https://amp.twimg.com/v/806664f7-13c7-401e-9dc7-5be8166d87bf" target="_blank" rel="nofollow">amp.twimg.com/v/806664f7-13c…</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_a7joUxUDN/', 'source_time' => '2015-12-18 05:05:31', 'text' => '@caradelevingne ❤️'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_a_WlAgms-/', 'source_time' => '2015-12-18 05:38:41', 'text' => 'Who\'s your fav Angel? '], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_bRimhsNhO/', 'source_time' => '2015-12-18 08:17:37', 'text' => 'Happy Birthday to Miss Ashley Victoria Benson, a real sunshine in many people\'s life ❤️ I love you for who you are, absolutely beautiful and kind with your fans. More than that, you are the funniest idol I\'ve ever seen. '], ['provider' => 'twitter', 'uri' => 'https://twitter.com/soompi/status/674066953435238400', 'source_time' => '2015-12-08 03:24:19', 'text' => '<a href="https://twitter.com/search?q=%23GirlsGeneration" target="_blank">#GirlsGeneration</a>’s Taeyeon Talks About Her Unforgettable Year <a href="http://www.soompi.com/2015/12/07/girls-generations-taeyeon-talks-about-her-unforgettable-year/" target="_blank" rel="nofollow">soompi.com/2015/12/07/gir…</a> <a href="https://pbs.twimg.com/media/CVrERfcWEAAVoCK.png" target="_blank">pic.twitter.c...om/uJh7DjckPw</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_WEtWmRxWk/', 'source_time' => '2015-12-16 07:49:17', 'text' => '@Regrann from @hairshaftfred - Colored pencil #hairdrawing of #katyperry by @_artistiq #Regrann'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_WE2bvsYC6/', 'source_time' => '2015-12-16 07:50:32', 'text' => 'Gm loves❤️ -Mei Dong - #onedirection #justinbieber #shawnmendes #hacks #tips #diys #arianagrande #gainpost #follow4follow #like4like #tagsforlikes #followtrain #mileycyrus #disney #gorgeous #tumblrgirl #tagher #spamme #ifollowback #ifb #classyvouge #accountrates #sfs #tumblr #tumblraccount #nashgrier #camerondalla'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/BatmanvSuperman/status/674045753606574082', 'source_time' => '2015-12-08 02:00:05', 'text' => 'The battle begins March 2016. <a href="https://twitter.com/search?q=%23BatmanvSuperman" target="_blank">#BatmanvSuperman</a> <a href="http://twitter.com/BatmanvSuperman/status/674045753606574082/photo/1" target="_blank" rel="nofollow">pic.twitter.c...om/RODmw0l2xq</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_WB9xGrysx/', 'source_time' => '2015-12-16 07:25:19', 'text' => 'Her eyes in this picture!
#mockingjaypart2 #jenniferlawrence #katniss #katnisseverdeen #mockingjay'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/BELLOmag/status/676842280456556544', 'source_time' => '2015-12-15 19:12:29', 'text' => 'Happy Tuesday! Make sure you grab this months <a href="https://twitter.com/search?q=%23Beauty" target="_blank">#Beauty</a> issue with the beautiful <a href="https://twitter.com/search?q=%23BillieLourd" target="_blank">#BillieLourd</a> from <a href="https://twitter.com/search?q=%23ScreamQueens" target="_blank">#ScreamQueens</a> <a href="https://pbs.twimg.com/media/CWSgdofUYAAhfpA.jpg" target="_blank">pic.twitter.c...om/SmFCJHRav7</a>'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/DCComics/status/676472983574179841', 'source_time' => '2015-12-14 18:45:02', 'text' => 'Before tonight\'s episode, read our interview w/ Supergirl herself, <a href="https://twitter.com/melissabenoist" target="_blank">@melissabenoist</a>! <a href="http://bit.ly/1P3mUQ0" target="_blank" rel="nofollow">bit.ly/1P3mUQ0</a> <a href="https://pbs.twimg.com/media/CWNQmAlUYAAfhAL.jpg" target="_blank">pic.twitter.c...om/nPBLZNVy4c</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_WAb-vGHpM/', 'source_time' => '2015-12-16 07:11:58', 'text' => '#supergirl #cbs #DC #detectivecomics'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_WA30gl8k-/', 'source_time' => '2015-12-16 07:15:46', 'text' => '#yuri #yurilove #yurianime #animeyuri #animelove #yurilove #animecouple #mangayuri #manga #mangacouple #colour #shoujoai #shoujoaimanga #girls #girlslove #girlxgirl #glg #girlslikegirls #hug#cute #kawaii #catwoman #supergirl'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/starwars/status/676602412526768132', 'source_time' => '2015-12-15 03:19:20', 'text' => 'That\'s a wrap on our live stream! In case you missed a second, it\'ll be on the <a href="https://twitter.com/search?q=%23StarWars" target="_blank">#StarWars</a> Youtube channel soon. <a href="https://pbs.twimg.com/media/CWPGTsfUkAABNxs.jpg" target="_blank">pic.twitter.c...om/E69yrVI3OB</a>'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/LauInLA/status/676556706847916032', 'source_time' => '2015-12-15 00:17:43', 'text' => 'BB-8 is here, and took time to have a little dance to the theme music (but refused to answer questions) <a href="https://twitter.com/search?q=%23StarWars" target="_blank">#StarWars</a> <a href="https://pbs.twimg.com/ext_tw_video_thumb/676556571011248128/pu/img/PLyiMk2GHU_-PiHV.jpg" target="_blank">pic.twitter.c...om/eeJ8e8iGb7</a>'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/vine/status/676544569182429184', 'source_time' => '2015-12-14 23:29:29', 'text' => 'Now on Vine: <a href="https://twitter.com/search?q=%23StarWars" target="_blank">#StarWars</a> <a href="https://vine.co/channels/star-wars-tfa" target="_blank" rel="nofollow">vine.co/channels/star-…</a> <a href="https://vine.co/v/im7Kp6jrTxh" target="_blank" rel="nofollow">vine.co/v/im7Kp6jrTxh</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_VnP0QxaVW/', 'source_time' => '2015-12-16 03:31:51', 'text' => 'New edit'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_Vqrwaobbp/', 'source_time' => '2015-12-16 04:01:53', 'text' => 'Black Canary,Green Arrow,Speedy,Flash,Diggle,Hawkman and Hawkgirl vs Vandal Savage'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_X3rs3I0rV/', 'source_time' => '2015-12-17 00:33:57', 'text' => '#taeyeon #sone #snsd #girlsgeneration'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/DCComics/status/676782529135960064', 'source_time' => '2015-12-15 15:15:03', 'text' => '<a href="https://twitter.com/search?q=%23Supergirl" target="_blank">#Supergirl</a> fans! <a href="https://twitter.com/IGN" target="_blank">@IGN</a> has the details on the digital-first series ADVENTURES OF SUPERGIRL: <a href="http://bit.ly/224eU8z" target="_blank" rel="nofollow">bit.ly/224eU8z</a> <a href="https://pbs.twimg.com/media/CWRqH61XIAAX2mT.jpg" target="_blank">pic.twitter.c...om/5i1MUnL6zK</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_X4OhbHbAs/', 'source_time' => '2015-12-17 00:38:42', 'text' => 'Dear Lord. If this were real... my life would be complete.'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_Yme1ntQm_/', 'source_time' => '2015-12-17 07:22:53', 'text' => 'I know its no longer wednesday but these two talented, beautiful, amazing ladies will always be my women crush wednesday ! @carrieunderwood @taylorswift #wcw #gorgeous #talented #swifties #beautiful #1989 #storyteller #carrieunderwood #taylorswift'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/_auLdQpoUV/', 'source_time' => '2015-12-18 03:08:37', 'text' => ''], ['provider' => 'twitter', 'uri' => 'https://twitter.com/AngelAlessandra/status/675046023241326593', 'source_time' => '2015-12-10 20:14:48', 'text' => 'Snapshot backstage <a href="https://twitter.com/victoriassecret" target="_blank">@victoriassecret</a> <a href="https://twitter.com/search?q=%23vsfs2015" target="_blank">#vsfs2015</a> <a href="https://twitter.com/search?q=%23VSFashionShow" target="_blank">#VSFashionShow</a>'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/9h8em8jvCQ/', 'source_time' => '2015-11-01 05:25:28', 'text' => 'Olaf vibes.'], ['provider' => 'twitter', 'uri' => 'https://twitter.com/taylorswift13/status/673375405013790720', 'source_time' => '2015-12-06 00:36:13', 'text' => 'can we get a selfie tho'], ['provider' => 'instagram', 'uri' => 'https://www.instagram.com/p/9h8POJjvB2/', 'source_time' => '2015-11-01 05:23:22', 'text' => '"The cold never bothered me anyway." QUICK CHANGE @idinamenze']];
// create a new post for each item in the data array
foreach ($posts_data as $post_data) {
\App\Post::firstOrCreate($post_data);
}
}
/**
* Processes the Create Post request.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function postCreate(Request $request)
{
// validate request
$this->validate($request, ['provider' => 'required', 'uri' => 'required|url', 'source_time' => 'required']);
// parse request
$uri = $request->uri;
// create a post if it does not exist
$post = Post::firstOrCreate($request->except('_token'));
// get the user logged in
$user = \Auth::user();
// if a user is logged in and the post is not already associated,
// then associate the user with the post
if (isset($user) && !$user->posts->contains('id', $post->id)) {
$user->posts()->save($post);
}
// indicate saving of the post
\Session::flash('flash_message', 'Saved post <a href=\'' . $uri . '\' target=\'_blank\'>' . $uri . '</a>.');
// redirect to the previous page
$view = redirect(back()->getTargetUrl() . '#' . $post->id);
return $view;
}
public function findByTagOrCreate($postData)
{
return Post::firstOrCreate($postData);
}
public function testCreate()
{
// test firstOrCreate
$post = Post::firstOrCreate(['content' => 'post 1']);
// record exists
$this->assertEquals(1, $post->id);
$post = Post::firstOrCreate(['content' => 'post xxx']);
// record does not exist
$post = Post::where('content', '=', 'post xxx')->first();
$this->assertEquals('post xxx', $post->content);
// test firstOrNew
$post = Post::firstOrNew(['content' => 'post 1']);
// record exists
$this->assertEquals(1, $post->id);
$post = Post::firstOrNew(['content' => 'post yyy']);
// record does not exist
$this->assertEquals('post yyy', $post->content);
$this->assertFalse(property_exists($post, 'user_id'));
$post = Post::where('content', '=', 'post yyy')->first();
$this->assertNull($post);
}
