Forem: Jonathan Zarate

How to create a read-only user in PostgreSQL

Jonathan Zarate — Sat, 05 Oct 2024 19:42:08 +0000

Steps Overview

Connect to PostgreSQL: Start by connecting to the PostgreSQL database with superuser privileges.

Create a Role for Read-Only Access: We will create a group role that has only read privileges on all tables in the target database, ensuring future tables will also inherit these permissions.

Grant Necessary Privileges: We'll grant the SELECT privilege on all existing tables, views, and sequences in the schema. Additionally, default privileges will be set for any future tables.

Create a Login Role: A login role will be created and assigned to the read-only group role, ensuring it inherits the appropriate read-only permissions.

Restrict Permissions: Finally, we’ll ensure the user cannot create, modify, or delete data, and revoke any unnecessary permissions.

Connect to PostgreSQL

psql -U postgres -d database

Create a new Role Group

CREATE ROLE role_group NOINHERIT;

Assign privileges to role_group

GRANT CONNECT ON DATABASE database TO role_group;
GRANT USAGE ON SCHEMA public TO role_group;

SELECT 'GRANT SELECT ON '||schemaname||'."'||tablename||'" TO role_group;' FROM pg_tables WHERE schemaname IN ('public') ORDER BY schemaname, tablename;

You will see a list of GRANT statements.
Copy the GRANT statements generated by the query and then paste them into your terminal window.
To restrict access to a subset of tables, only run the GRANT statements for the corresponding tables.

Assign privileges SELECT to future tables

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO role_group;

Create user with password

CREATE ROLE user_read_only LOGIN PASSWORD 'password' NOSUPERUSER NOCREATEDB NOCREATEROLE;

Assign role group role_group to user user_read_only

GRANT role_group TO user_read_only;

Verify that the role group role_group not privileges of the postgres or public

REVOKE ALL ON SCHEMA public FROM public;
REVOKE ALL ON DATABASE database FROM public;

Test access

psql -U user_read_only -d database

Performs create table operations, update data in any table, delete items. You should receive a permission denied message.

Regards,

Laravel Presentable for Eloquent Models

Jonathan Zarate — Thu, 10 Mar 2022 00:07:52 +0000

Hey there!

Today was release of Laravel Presentable Package to 0.0.2 versión for support Laravel Framework v9.

This package allow create presenter classes for Eloquent models. A presenter class allows you to separate displays concerns from model data in a specific class.

Installation



composer require datacreativa/laravel-presentable

For example add the trait HasPresentable to User Model.




use App\Models\Presenters\UserPresenter;
use TheHiveTeam\Presentable\HasPresentable;

class User extends Model
{
    use HasPresentable;

    protected $presenter = UserPresenter::class;
}

$presenter property that defines the presenter class.

Here's an example of what a presenter class will look like:



namespace App\Models\Presenters;

use TheHiveTeam\Presentable\Presenter;

class UserPresenter extends Presenter
{
    public function name()
    {
        return ucwords($this->model->name);
    }
}

Using the User model as an example, you can now access presenter methods in the view:



$user->present()->name;

If you find that separating view display logic into a dedicated presenter class makes sense, this package could be an excellent fit.

For more info, here the repository
https://github.com/datacreativa/laravel-presentable

Regards,
Jonathan

Config XDebug for Laravel 9

Jonathan Zarate — Tue, 15 Feb 2022 05:50:23 +0000

Hey there!

In this post, we are going to configure XDebug for test coverage in Laravel Framework v9.

First, go to xdebug wizard https://xdebug.org/wizard, copy your phpinfo() and paste into the wizard, follow the instructions.

To enable test coverage you must edit the php.ini file, then add the following line:



xdebug.mode = coverage

Finally, execute:



php artisan test --coverage

Enjoy it!

Laragon for Laravel development on windows

Jonathan Zarate — Sat, 27 Feb 2021 23:39:31 +0000

Laragon for Laravel development

Hey, guys.

At this moment I want to share with you, how to work Laravel Framework in Windows.

Mexico city, March 22, 2020. When the COVID-19 pandemic started in Mexico City. I had to emigrate from the city and buy a computer with windows 10.

lol At this point I thought: how do I develop my laravel applications on windows?

So, I met Laragon, a tool is amazing.
Initially I had a lot of trouble running the PHPUnit tests. 🥺

Then I managed to run the tests:



.\vendor\bin\phpunit

Laragon benefits

Multiple php versions:
An important benefit is the change of PHP versions between 7.1 to 7.4, this is a headache when working with laravel valet on Mac OS.

Multiple database:
We can switch between mysql or mariadb. This depends on your projects.

Disadvantages

When we work with Windows, there are possibly problems with the directory path.

In my experience I had problems with the jest tests. because the node_modules directory cannot be found.

Anyway, Laragon is very elegant for laravel development.

Configure PHP-CS-Fixer for Laravel on Visual Code

Jonathan Zarate — Fri, 06 Dec 2019 18:15:43 +0000

Hi, developers. 😄

I will teach you how to configure php-cs-fixer for laravel in the visual code editor.

Often, when I write PHP code, I can make mistakes, such as lack of spaces, structure of conditions, etc. 😅

What is PHP-CS-Fixer?

PHP-CS-Fixer is a standard for ordened your code and apply code style guide PSR for PHP.

PHP-CS-Fixer It is a tool that helps to organize the application code, following the PSR standards.

Installation PHP-CS-Fixer.

Github PHP-CS-Fixer



$ brew install php-cs-fixer

Installation VSCode



brew update
brew tap caskroom/cask
brew cask search visual-studio-code

Configuration

Open VSCode editor
Add extension php cs fixer to VSCode
Add to settings.json file



{
  "editor.formatOnSave": true,

  "php-cs-fixer.onsave": true,
  "php-cs-fixer.executablePath": "${extensionPath}/php-cs-fixer.phar",
  "php-cs-fixer.config": "~/.vscode/.php_cs;",
}

Add config file .php_cs ```

$ cd ~/.vscode
$ touch .php_cs

- Open config file `.php_cs` and add PHPCSFixer configuration.


  


Ok, The configuration that I use to work PHP-CS-Fixer with Laravel applications is optional. :smile:

I will begin to explain the changes that I have made in the configuration file .php_cs.

  
  
  concat_space:


'concat_space' =&gt; array('spacing' =&gt; 'none'),

Example



  $this-&gt;load(__DIR__.'/Commands');


</code></pre></div>
<p>Spacing to apply around concatenation operator, I like it with no space.</p>
<h4>
  <a name="unsend-imports" href="#unsend-imports">
  </a>
  unsend imports:
</h4>

<p><code>'no_unused_imports' =&gt; true,</code></p>

<p>Remove imports that are not used in a class.</p>
<h4>
  <a name="orderedimports" href="#orderedimports">
  </a>
  ordered_imports
</h4>

<p><code>'ordered_imports' =&gt; array('sort_algorithm' =&gt; 'alpha'),</code></p>

<p>Currently in Laravel 6, the order of imports was included alphabetically, Here the <a href="https://github.com/laravel/framework/pull/29933">Pull Request</a> of the discussion for this change. :grimacing:</p>

<p>Personally, I liked the order by length. :smile:</p>
<h4>
  <a name="returntypedeclaration" href="#returntypedeclaration">
  </a>
  return_type_declaration
</h4>

<p><code>'return_type_declaration' =&gt; array('space_before' =&gt; 'one'),</code></p>

<p>There should be one or no space before colon, and one space after it in return type declarations, according to configuration.</p>

<p>example of my configuration.</p>
<div class="highlight"><pre class="highlight php"><code>

    <span class="cd">/**
     * Check if the user is a admin.
     *
     * @return bool
     */</span>
    <span class="k">public</span> <span class="k">function</span> <span class="n">isAdmin</span><span class="p">()</span> <span class="p">:</span> <span class="kt">bool</span>
    <span class="p">{</span>
        <span class="k">return</span> <span class="nv">$this</span><span class="o">-&gt;</span><span class="n">roles</span><span class="o">-&gt;</span><span class="nf">contains</span><span class="p">(</span><span class="s1">'name'</span><span class="p">,</span> <span class="nc">Role</span><span class="o">::</span><span class="no">ADMIN</span><span class="p">);</span>
    <span class="p">}</span>


</code></pre></div>
<p>Add a space before the colon.</p>
<h4>
  <a name="notoperatorwithsuccessorspace" href="#notoperatorwithsuccessorspace">
  </a>
  not_operator_with_successor_space
</h4>

<p><code>'not_operator_with_successor_space' =&gt; true,</code></p>

<p>Logical NOT operators (!) should have one trailing whitespace.</p>

<p>Example.</p>

<p>Input</p>
<div class="highlight"><pre class="highlight php"><code>

<span class="k">if</span> <span class="p">(</span><span class="o">!</span><span class="nv">$foo</span><span class="p">)</span> <span class="p">{</span>
    <span class="k">echo</span> <span class="s2">"Help!"</span><span class="p">;</span>
<span class="p">}</span>


</code></pre></div>
<p>Output</p>
<div class="highlight"><pre class="highlight php"><code>

<span class="k">if</span> <span class="p">(</span><span class="o">!</span> <span class="nv">$foo</span><span class="p">)</span> <span class="p">{</span>
    <span class="k">echo</span> <span class="s2">"Help!"</span><span class="p">;</span>
<span class="p">}</span>


</code></pre></div><h1>
  <a name="conclusion" href="#conclusion">
  </a>
  Conclusion.
</h1>

<p><strong>PHP-CS-Fixer</strong> is a very useful tool when writing PHP code in Laravel applications. :nerd_face: </p>

<p>I hope you like this post, if you have questions about me you can write a comment below or send a message to my twitter. :wave:</p>

<p>Thanks.</p>