GraphQL w/ Laravel & Vue - Lighthouse Package Backend - Part 2

[@rudolphstamaria8782]

I can't believe I've only just discovered this channel. Your explanation for the concepts are clear, concise, and practical. Looking forward to finishing this series!

[@SimonDaviesOfCourse]

great series so far, your making GraphQL look more understandable and easier to read than I have seen before, good work keep it up. A continuation with authentication would be super :-) 👍

[@drehimself]

Thanks for watching! I'll look into auth in separate videos :)

[@josuebarros-desenvolvedorw2490]

So this is where the project really starts? cool!!! Thanks andre for this awesome content! You rock!

[@freekmurze]

Really interesting, thank you for creating these videos.

[@drehimself]

Looking forward to amazing spatie/graphql packages in 3...2... 😂

[@health-harmony-tips]

Did Intertia js not kill GraphQL?

[@creative-commons-videos]

please make a video on subscription using beyondcode laravel websocket and lighthouse

[@MrFranciscoooooo]

I want to use @update, but my client sends different values from DB how can I do that?

[@justadhithya]

HI i’m try to create Book mutation { createBook(title:"test book",author:"sss",category:1) { id title } } I got error "debugMessage": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category' in 'field list' (SQL: insert into `books` (`title`, `author`, `category`, `updated_at`, `created_at`) values (test book, sss, 1, 2020-08-22 01:02:45, 2020-08-22 01:02:45))", "message": "Internal server error", "extensions": { "category": "internal" },

[@thirstypooch]

yes me too i get this error. how you solved it?

[@AdrianaPerez-sk4jo]

Hi, good tutorial! I'm having a problem with the base url to open graphql playground. It says that the server can't be reached. I guess i'm doing something wrong. where can i find the correct base url?

[@haroldcreslaingo1332]

I have the same problem

[@h3lltronik768]

The correct URL is the one that the command "php artisan serve" gives you, like "127.0.0.1:8000/" then just add "graphql" like this "127.0.0.1:8000/graphql" or "127.0.0.1:8000/graphql-playground" in the web browser

[@haroldcreslaingo1332]

@@h3lltronik768 I have another question. my custom resolver is not showing on the intellisense in playground. did I did something wrong?

[@h3lltronik768]

@@haroldcreslaingo1332 when the playground doesn't autocomplete ur query while typing then you have an error in your schema, most likely, could be anything like a missing quote or square bracket, read carefully

[@qadir03232803023]

How if we want to filter books in category query ? you added booksByFeature thats ok but how if i want books related to that category with ratings >3 ?

[@MAHMUDULHASAN-xo3nt]

How can i refresh the graphql playgrounds app🤨? I am windows user

[@weizhang8954]

Hi sir，why for my case I have to use "category_id" instead of "category" in createBook & updateBook!? I checked the schema and create_book_table =>up(below) exactly the same! mutation{ updateBook( id: 26, title: "new book 2", author: "me 2", category_id: 2) { id title author } } public function up() { Schema::create('books', function (Blueprint $table) { $table->increments('id'); $table->string('title'); $table->string('author'); $table->string('image')->nullable(); $table->text('description')->nullable(); $table->string('link')->nullable(); $table->boolean('featured')->default(false); $table->unsignedInteger('category_id'); $table->foreign('category_id')->references('id')->on('categories')->onUpdate('cascade'); $table->timestamps(); }); }

[@muhsinzyne695]

Hi, can you do a video on laravel subscription with pusher and lighthouse config. in local and a production server. i am in the mid of something which could 't complete

[@Spharian]

Awesome videos! Any specific reason you don't create the front-end into the same Laravel app?

[@maxidual4462]

good question, I think it is for the flexibility than others frameworks or libraries offers for front-end such as React, angula or Vue..

[@GeraudSchmit]

Hi Andre, Very helpful. I have a question though. Let's say that your site has evolved into a private club of authenticated users sharing their private lists of books (it's just another onetomany relationship between users and books added on top of your schema. Nothing fancy.). What would be the best way to query all the featured books for a specific user ? You need to select the books by user id AND by featured=true (2 filters). My solution: I've created this query: booksByFeatured(user_id: Int! @eq, featured: Boolean! @eq): [Book] @all where user_id is the foreign key for users in my books table. It seems to work but it feels more like a dirty hack than an elegant solution. Any suggestion ?

[@khaledel-eskandarany4888]

Would be awesome to have an episode that would include multiple GraphQL schemas and check playground's support for it

[@TheShowMv]

Hi, Andre Madarang ! I have question, how to make custom name for field laravel (write transformer / resource). For example I have field my database "image_src" I want to transform (rename) for example to "pictureSrc" in my GraphQL requestion.

[@michaelerwin8744]

I just literally started learning few hours ago. I think you need what is called "alias". graphql.org/learn/queries/#aliases.

[@ironyh]

By @rename directive type Book{ pictureSrc: String @rename(attribute:"image_src") }

[@markchriztophermarilag74]

Hi andre thanks for the tuts. By anychance where do you get the resources for the visual design in ps?

[@drehimself]

Like I said in the first video, I ripped the design from ihbooks.com :). I re-created it in Sketch and made some minor modifications.

[@EvertonPaiva]

Fantastic! Thank you very much for sharing. Great work.

[@neeonline]

Do you have any tutorial on how to get the terminal/theme/plugins that you use? Thanks!

[@drehimself]

No, but I plan to do a "Tools I use" series when I get a new computer (hopefully soon).

[@TYPOlight]

All these endpoints are query to DB through model. But how to connect graphQL to controller? Sometimes we need not only get some data from DB but also add some logic. BTW really good tutorial ;)

[@drehimself]

You can use custom resolvers :)

[@jafetl.ch.8961]

I have a question, how we can add a token verification with passport or jwt? thanks for the videos!

[@drehimself]

I haven't looked into using Auth/Passport with GraphQL yet but I imagine it's similar to the traditional REST way. Will take a look in the future and maybe make videos about it :)

[@timetosleep8055]

I get the following error when i try to create a mutation: Response not successful: Received status code 500. This is not the case with queries. edit: had a stupid syntax mistake which caused this error...

[@rosalialive6569]

where did u find the mistake ? cs i have same problem

[@qaisarabbas2488]

Please make videos on how to render Vue or React in the server-side for SEO friendly in Laravel.

[@mescalito2]

Andre, how did you start the app? In here (kzbin.info/www/bejne/j6PcdJ2oj5yJp9U) you went directly from adding a simple Book query to run that query in Playground. how can I run the app? I think there is a gap of events in the timeline

[@darshanwala5561]

good explaining

[@jovannyrch9209]

I really like to watch your videos, Saludos desde México :)

[@drehimself]

Thanks for watching!

[@jhoanborges6574]

You're the best

[@drehimself]

Thanks for watching!

[@jhoanborges6574]

@@drehimself Where are the methods? i mean createUser for example.

[@hoanngocle6992]

Nice tutorial. thank you so much :D

[@floodyboy5307]

Nice tutorial 👍🏻🌹

[@drehimself]

Thanks for watching!

[@paulobruno1267]

Thank you 😍🙌🙌🙌👏

[@drehimself]

Thanks for watching!

[@Maartz]

For those who will be blocked by the migration : Replace -> $table->unsignedInteger('category_id'); with the following : $table->bigInteger('category_id')->unsigned()->index(); Because it have to match with type of category id which is bigIncrements. Thanks !

[@The606P]

@Ryan Eggleston Schema::create('books', function (Blueprint $table) { $table->id(); $table->string('title'); $table->string('author'); $table->string('image')->nullable(); $table->text('description')->nullable(); $table->string('link')->nullable(); $table->boolean('featured')->default(false); $table->unsignedBigInteger('category_id'); $table->timestamps(); $table->foreign('category_id')->references('id')->on('categories')->onUpdate('cascade'); }); works on laravel 7

[@thirstypooch]

still i am getting the following: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'category' in 'field list' (SQL: insert into `books` (`title`, `author`, `category`, `updated_at`, `created_at`) values ...

[@nadiefuego]

Saludos. ☺👍

[@drehimself]

Thanks for watching!