DEV Community: wolfiton

Laravel 7 short-cuts to writing foreign keys

wolfiton — Sun, 16 Aug 2020 13:16:19 +0000

Hi everyone,

Today I want to write about a quick tip to use when writing foreign keys in Laravel 7.

This method will help you write shorter migrations and make your code more readable.

For our example, I am going to use the user_id which is very common but this can be applied to any foreign key.

In the past we would write something like this:

$table->unsignedBigInteger('user_id')
->index();

$table->foreign('user_id')
->references('id')
->on('users')
->onDelete('cascade');

Hmm, pretty verbose right?

The good news Dear reader is that we can write now like this:

$table->foreignId('user_id')
->index()
->constrained()
->onDelete('cascade');

Much nicer and easier to read, I hope you enjoyed this tip Dear Reader.

If you find it useful share it on social with your friends.

Have a nice day.

Credits:

Image cover: Long Road

What stack(technologies) would you use to rebuild dev.to from scratch

wolfiton — Mon, 27 Jul 2020 18:14:19 +0000

Hi everyone,

If you have to rebuild dev.to from scratch what stack would you use?

Thanks in advance to all participants to this discussion

Laravel Lighthouse Sanctum role based authorization best practices

wolfiton — Fri, 17 Jul 2020 10:01:57 +0000

Hi everyone,

I am looking to understand if my following statement is te correct way to implement authorization using sanctum with graphql:

Now for the tricky part, once I create a login mutation, I need to verify that the user has the corresponding role and generate a token ability based on that check, also when the app goes offline or enters PWA mode.
I need to revoke any tokens abilities with:

create
delete
update I couldn't find in the docs any solutions to this problem, that is a real-world necessity. I can only leave the show and index abilities active.

My idea is like this:

Create a custom arg resolver for the mutation somehow bring the middleware and generate a token based on roles.

The verification will be made server-side than issue a token with abilities.

Bad idea: To store the role with the token.

So the real solution is this and I don't care how many people will argue because in reality security is very important and should be handled by experts in the field. That being said paseto is and will remain a real option if we can build it.

Why paseto read this post from a security expert that works with this every day.

https://developer.okta.com/blog/2019/10/17/a-thorough-introduction-to-paseto

So this is the answer.

Thanks for reading.

Paseto example with Graphql(Lighthouse Laravel)

wolfiton — Sun, 14 Jun 2020 11:43:06 +0000

Hi everyone,

Update: I create a request for paseto implementation in PHP Lighthouse, if you like this idea please give a thumbs up so that this request can get noticed and implemented. Thank you, the request is here

Update 2: I will try to create a passeto option for laravel 7 to auth and authroize following the specs but I will need the help of security experts and laravel devs to create this under MIT.
If somebody is interested let me know.

I am looking for a paseto example with Graphql(Lighthouse Laravel) or how to create paseto's for each resource using the user roles and types. Or how to restrict access to only specific resources.

I only found this:

Thanks in advance for any direction or info

What projects should somebody have and experience to be a senior?

wolfiton — Sat, 13 Jun 2020 19:08:47 +0000

Hi everyone,

What projects(any language) should somebody have to be considered:

junior?
mid-level?
senior?
senior ahitect?
tech lead?

Thanks in advance

Credits:
Thinking statue link

(Solved)Graphql vue apollo define category{connect: Int!}

wolfiton — Wed, 10 Jun 2020 12:29:07 +0000

Hi everyone,

Solved:
Solved with the help of @benheimberg here https://stackoverflow.com/questions/62304716/how-to-create-nested-relationships-in-laravel-lighthouse-and-vue-apollo/62305347#62305347

Th repos are here

You can play with this whole project by cloning my repos https://github.com/wolfiton/booksql-laravel backend

https://github.com/wolfiton/booksql-vue frontend

mutation (

      $categoryId: ID!
)

createBook(
    input: 
      category: {connect: $categoryId]
    }

Update: Before someone will say that I can do this

category: Int!
category: $category

variables: {

        $category: this.categoryId,
      },

Unfortunately I can't because the backend framewok requires me to send the mutation like this

variables: {

        $category: { connect: this.categoryId },
      },

So any help is apreciated.

I was working graphql an I need to define the following type:

category: {connect:ID!}

mutation (
      $title: String!
      $image: String!
      $author: String!
      $description: String!
      $link: String!
      $featured: Boolean
      $category: { connect: Int! }
)
{
  createBook(
    input: {
      title: $title
      image: $image
      author: $author
      description: $description
      link: $link
      featured: $featured
      category: $category
    }
  ) {
    id
    title
    author
  }
}

My form uses model to recieve the data for the connect from a select.

I dont know how to define this variable for my mutation:

variables: {

        $category: { connect: this.categoryId },
      },

I need to replace this:

$category: { connect: Int! }

with something like this

$category: { connect: this.categoryId }

Does someone know how i can define this type?

Thanks in advance

Concerns regarding using payment with graphql and js in general

wolfiton — Sun, 31 May 2020 12:42:18 +0000

Hi everyone,

I am having concerns processing payments with graphql or js in general, what are your expriences on this subject?

Would you process payments using react vue or SSR solutions without worries of attacks?

Also I am looking for an advice here from people that work in web security and ethical hacking.

Update:For anyone looking for the suggestion from @dakotalewallen you can find it here Stripe Checkout

Thank you in adavnce

Credits:

Credit card image link

@dakotalewallen - thanks for suggesting stripe checkout

(Solved)Apache2 virtualhost problem for Wordpress 5 local config

wolfiton — Sat, 30 May 2020 11:32:55 +0000

Hi everyone,

I have a problem with Wordpress Apache2 Virtualhost and rewrite through .htaccess.
Update:
After deleting the cache several times and also completely stoped apach2 and start it again it works.

My config looks like this for apache2 virtualhost:

<VirtualHost *:80>

     DocumentRoot /var/www/example.com/
     ServerName example.com
     ServerAlias www.example.com

     <Directory /var/www/example.com/>
        Options +FollowSymlinks
        AllowOverride All
        Require all granted
     </Directory>

     ErrorLog ${APACHE_LOG_DIR}/error.log
     CustomLog ${APACHE_LOG_DIR}/access.log combined

</VirtualHost>

I also have this in my /etc/hosts:

127.0.0.1 example.com

If I enable the vhost in apache2 with sudo a2eniste exmaple.com and reatrt the server with sudo systemctl apache2 reload and also test the config with apachectl configtest. All is correct and I get

apachectl configtest                                                                   
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
Syntax OK

Also the permissions on example.com and on the files and folders:

ls -ail /var/www/example.com                                                             
total 220
55577117 drwxr-xr-x  5 www-data www-data  4096 mai 30 13:26 .
55590166 drwxr-xr-x  4 root     root      4096 mai 30 13:53 ..
55575637 -rw-r--r--  1 www-data www-data   481 mai 30 13:27 .htaccess
42995800 -rw-r--r--  1 www-data www-data   405 feb  6 08:33 index.php
42995817 -rw-r--r--  1 www-data www-data 19915 feb 12 13:54 license.txt
42995782 -rw-r--r--  1 www-data www-data  7278 ian 10 16:05 readme.html
42997479 -rw-r--r--  1 www-data www-data  6912 feb  6 08:33 wp-activate.php
42997480 drwxr-xr-x  9 www-data www-data  4096 apr 29 21:58 wp-admin
42995781 -rw-r--r--  1 www-data www-data   351 feb  6 08:33 wp-blog-header.php
42998543 -rw-r--r--  1 www-data www-data  2275 feb  6 08:33 wp-comments-post.php
42995807 -rw-r--r--  1 www-data www-data  2889 mai 24 17:29 wp-config.php
42995818 drwxr-xr-x  7 www-data www-data  4096 mai 29 13:50 wp-content
42995805 -rw-r--r--  1 www-data www-data  3940 feb  6 08:33 wp-cron.php
42996116 drwxr-xr-x 21 www-data www-data 12288 apr 29 21:58 wp-includes
42996114 -rw-r--r--  1 www-data www-data  2496 feb  6 08:33 wp-links-opml.php
42996115 -rw-r--r--  1 www-data www-data  3300 feb  6 08:33 wp-load.php
42995815 -rw-r--r--  1 www-data www-data 47874 feb 10 05:50 wp-login.php
42996113 -rw-r--r--  1 www-data www-data  8509 apr 14 14:34 wp-mail.php
42995816 -rw-r--r--  1 www-data www-data 19396 apr 10 06:59 wp-settings.php
42995797 -rw-r--r--  1 www-data www-data 31111 feb  6 08:33 wp-signup.php
42998542 -rw-r--r--  1 www-data www-data  4755 feb  6 08:33 wp-trackback.php
42995777 -rw-r--r--  1 www-data www-data  3133 feb  6 08:33 xmlrpc.php

So I am wondering what am I doing wrong and how it can be fixed?

Thanks in advance

Best Wordpress providers in Europe?

wolfiton — Sun, 24 May 2020 10:19:40 +0000

Hi everyone,

I want to write again and create a Wordpress Blog to better understand SEO and also to see what is new.

Can you recommend me a good provider in Europe that has:

SSL
Very good speed
Latest PHP
Dedicated IP
AV

Update:

I think I will go with https://www.hostpapa.com, they are enough for what I need right now. Because I also have a lot of projects and technologies to learn right now.

Also if you like to see some sites hosted with them try this link https://www.webhostinghero.com/websites-hosted-by-hostpapa/

I have no affiliation with either of these sites

If anyone has a better solution please let me know by providing a site hosted with that recommendation.

Thanks again @ian for all the info and patience describing your experience.

Thanks in advance

ExecCommand obsolete can't find an alternative(confused)

wolfiton — Sat, 23 May 2020 20:58:49 +0000

Hi everyone,

So execCommand is obsolete right now, MDN doesn't offer an alternative.

MDN link: execCommand

Can someone point me at what the alternative is?

Thanks

Definitive guides vs articles every day?

wolfiton — Sat, 23 May 2020 13:00:16 +0000

Hi, everyone

Would you like to read an article every day or get a complete guide that covers a lot of articles but gets right to the point?

So what is your take on this:

more articles?
fewer articles but more value in a single read?

Thanks in advance for all the participants to this discussion

Sapper SSR svelte: trying to add toast ui to the default template in index.svelte

wolfiton — Thu, 14 May 2020 13:16:35 +0000

Hi everyone,

I am trying to add toast-ui editor to the default sapper webpack template.
Update:
Create a github repo with the problem here
This is my index.svelte from src/routes and my moddifications so far:

<script>
  import { onMount } from "svelte";
  import marked from "marked";

  let markdown = "# Example Title\n\n- this\n- is\n- a list";

  onMount(async () => {
    let Editor = await import('@toast-ui/editor');
    const editor = new Editor({
      target: document.querySelector("#editor"),
      height: "500px",
      initialEditType: "markdown",
      previewStyle: "vertical"
    });
    editor.getHtml();
  });
</script>

<style>
  h1,
  figure,
  p {
    text-align: center;
    margin: 0 auto;
  }

  h1 {
    font-size: 2.8em;
    text-transform: uppercase;
    font-weight: 700;
    margin: 0 0 0.5em 0;
  }

  figure {
    margin: 0 0 1em 0;
  }

  img {
    width: 100%;
    max-width: 400px;
    margin: 0 0 1em 0;
  }

  p {
    margin: 1em auto;
  }

  @media (min-width: 480px) {
    h1 {
      font-size: 4em;
    }
  }
</style>

<svelte:head>
  <title>Sapper project template</title>
</svelte:head>

<h1>Great success!</h1>

<figure>
  <img alt="Success Kid" src="successkid.jpg" />
  <figcaption>Have fun with Sapper!</figcaption>
</figure>
<textarea bind:value={markdown} placeholder="Enter markdown here" />
<div class="preview">
  {@html marked(markdown)}
</div>
<div id="editor" />
<p>
  <strong>
    Try editing this file (src/routes/index.svelte) to test live reloading.
  </strong>
</p>

My question is how to make this work and get rid of this error:

TypeError: Editor is not a constructor

Thanks in advance