//ruta a la carpeta de los snipets:
//~/.config/Code/User/profiles/
//-54d2ca4b/snippets/
// --- INICIO SNIPPETS PHP ---
{
	"Hola Mundo": {
		"prefix": "hola",
		"body": [
			"// Imprime Hola Mundo",
			"echo \"Hola, ${1:mundo}!\";"
		],
		"description": "Un atajo para crear un script PHP básico",
		"scope": "php"
	},
	"Echo Variable": {
		"prefix": "phpecho",
		"body": [
			"// Imprime el valor de una variable",
			"echo ${1:\\$variable};"
		],
		"description": "Imprime una variable con echo",
		"scope": "php"
	},
	"If Statement": {
		"prefix": "phpif",
		"body": [
			"// Estructura if con sintaxis alternativa",
			"if (${1:\\$condicion}):",
			"\t$0",
			"endif;"
		],
		"description": "Estructura if con sintaxis alternativa",
		"scope": "php"
	},
	"If-Else Statement": {
		"prefix": "phpifelse",
		"body": [
			"// Estructura if-else con sintaxis alternativa",
			"if (${1:\\$condicion}):",
			"\t${2:código si verdadero}",
			"else:",
			"\t${3:código si falso}",
			"endif;"
		],
		"description": "Estructura if-else con sintaxis alternativa",
		"scope": "php"
	},
	"Foreach Loop": {
		"prefix": "phpforeach",
		"body": [
			"// Bucle foreach con sintaxis alternativa",
			"foreach (${1:\\$array} as ${2:\\$key} => ${3:\\$value}):",
			"\t$0",
			"endforeach;"
		],
		"description": "Bucle foreach PHP con sintaxis alternativa",
		"scope": "php"
	},
	"For Loop": {
		"prefix": "phpfor",
		"body": [
			"// Bucle for con sintaxis alternativa",
			"for (${1:\\$i} = 0; ${1:\\$i} < ${2:count(\\$array)}; ${1:\\$i}++):",
			"\t$0",
			"endfor;"
		],
		"description": "For loop con sintaxis alternativa",
		"scope": "php"
	},
	"Function Declaration": {
		"prefix": "phpfunction",
		"body": [
			"// Declarar una función",
			"function ${1:nombreFuncion}(${2:parametros}) {",
			"\t$0",
			"}"
		],
		"description": "Declarar una función en PHP",
		"scope": "php"
	},
	"function constructor": {
		"prefix": "phpconstructor",
		"body": [
			"// Crear una function constructor",
			"class ${1:NombreClase} {",
			"\tpublic function __construct(${2}) {",
			"\t\t$0",
			"\t}",
			"}"
		],
		"description": "Crear una clase con constructor en PHP",
		"scope": "php"
	},
	"Class constructor": {
    "prefix": "phpclassconstructor",
    "body": [
        "// Crear una clase con constructor y propiedades",
        "class ${1:NombreClase} {",
        "\t/**",
        "\t * @var ${2:string} \t// Descripción de la propiedad",
        "\t */",
        "\tprivate $${3:nombre};",
        "",
        "\t/**",
        "\t * Constructor de la clase",
        "\t *",
        "\t * @param ${2:string} $${3:nombre} \t// Descripción del parámetro",
        "\t * @throws InvalidArgumentException",
        "\t */",
        "\tpublic function __construct(${2:string} $${3:nombre} = '') {",
        "\t\t$this->set${4/(.+)/${1:/capitalize}/}($${3:nombre});",
        "\t}",
        "",
        "\t/**",
        "\t * Setter para ${3:nombre}",
        "\t *",
        "\t * @param ${2:string} $${3:nombre}",
        "\t * @return void",
        "\t * @throws InvalidArgumentException",
        "\t */",
        "\tpublic function set${4/(.+)/${1:/capitalize}/}(${2:string} $${3:nombre}): void {",
        "\t\tif (empty($${3:nombre})) {",
        "\t\t\tthrow new InvalidArgumentException('El ${3:nombre} no puede estar vacío.');",
        "\t\t}",
        "\t\t$this->${3:nombre} = $${3:nombre};",
        "\t}",
        "",
        "\t/**",
        "\t * Getter para ${3:nombre}",
        "\t *",
        "\t * @return ${2:string}",
        "\t */",
        "\tpublic function get${4/(.+)/${1:/capitalize}/}(): ${2:string} {",
        "\t\treturn \$this->${3:nombre};",
        "\t}",
        "}"
    ],
    "description": "Clase PHP con propiedad, constructor, getter y setter con validación."
},
	"Try Catch": {
		"prefix": "phptry",
		"body": [
			"// Bloque try-catch",
			"try {",
			"\t$0",
			"} catch (${1:Exception} ${2:\\$e}) {",
			"\techo ${3:\\$e->getMessage()};",
			"}"
		],
		"description": "Bloque try-catch PHP",
		"scope": "php"
	},
	"Variable Dump": {
		"prefix": "phppre",
		"body": [
			"// Mostrar variable en formato legible",
			"echo '<pre>';",
			"var_dump(${1:\\$variable});",
			"echo '</pre>';"
		],
		"description": "Mostrar variable en formato legible con var_dump",
		"scope": "php"
	},
	"PHP Array": {
		"prefix": "phparray",
		"body": [
			"// Crear un array asociativo",
			"${1:\\$arrayName} = [",
			"\t${2:'key' => 'value'},",
			"\t$0",
			"];"
		],
		"description": "Crear un array asociativo en PHP",
		"scope": "php"
	},
// --- FIN SNIPPETS PHP ---

// --- INICIO SNIPPETS POSTGRES ---
	"Postgres Select": {
		"prefix": "pgselect",
		"body": [
			"-- Seleccionar datos de una tabla",
			"SELECT ${1:*} FROM ${2:tabla} WHERE ${3:condicion};"
		],
		"description": "Consulta SELECT básica en Postgres",
		"scope": "sql"
	},
	"Postgres Insert": {
		"prefix": "pginsert",
		"body": [
			"-- Insertar datos en una tabla",
			"INSERT INTO ${1:tabla} (${2:columna1}, ${3:columna2}) VALUES (${4:valor1}, ${5:valor2});"
		],
		"description": "Consulta INSERT básica en Postgres",
		"scope": "sql"
	},
	"Postgres Update": {
		"prefix": "pgupdate",
		"body": [
			"-- Actualizar datos en una tabla",
			"UPDATE ${1:tabla} SET ${2:columna} = ${3:nuevo_valor} WHERE ${4:condicion};"
		],
		"description": "Consulta UPDATE básica en Postgres",
		"scope": "sql"
	},
	"Postgres Delete": {
		"prefix": "pgdelete",
		"body": [
			"-- Eliminar datos de una tabla",
			"DELETE FROM ${1:tabla} WHERE ${2:condicion};"
		],
		"description": "Consulta DELETE básica en Postgres",
		"scope": "sql"
	},
	"Postgres Create Table": {
		"prefix": "pgcreatetable",
		"body": [
			"-- Crear una tabla",
			"CREATE TABLE ${1:tabla} (",
			"\t${2:id} SERIAL PRIMARY KEY,",
			"\t${3:columna} ${4:tipo},",
			"\t$0",
			");"
		],
		"description": "Crear una tabla en Postgres",
		"scope": "sql"
	},
	"Postgres Connect": {
		"prefix": "pgconnect",
		"body": [
			"-- Conectarse a una base de datos Postgres",
			"\\c ${1:nombre_base_de_datos};"
		],
		"description": "Conectarse a una base de datos Postgres",
		"scope": "sql"
	},
	"Postgres Drop Database": {
		"prefix": "pgdropdb",
		"body": [
			"-- Borrar una base de datos",
			"DROP DATABASE ${1:nombre_base_de_datos};"
		],
		"description": "Borrar una base de datos en Postgres",
		"scope": "sql"
	},
	"Postgres Create Database": {
		"prefix": "pgcreatedb",
		"body": [
			"-- Crear una base de datos",
			"CREATE DATABASE ${1:nombre_base_de_datos};"
		],
		"description": "Crear una base de datos en Postgres",
		"scope": "sql"
	},
	"Postgres Import Database": {
		"prefix": "pgimportdb",
		"body": [
			"-- Importar un archivo .sql a una base de datos",
			"psql -U ${1:usuario} -d ${2:base_de_datos} -f ${3:archivo.sql}"
		],
		"description": "Importar un archivo .sql a una base de datos Postgres",
		"scope": "sql"
	},
	"Postgres Export Database": {
		"prefix": "pgexportdb",
		"body": [
			"-- Exportar una base de datos a un archivo .sql",
			"pg_dump -U ${1:usuario} -d ${2:base_de_datos} -f ${3:archivo.sql}"
		],
		"description": "Exportar una base de datos Postgres a un archivo .sql",
		"scope": "sql"
	},
	"Postgres Create User": {
		"prefix": "pgcreateuser",
		"body": [
			"-- Crear un usuario en Postgres",
			"CREATE USER ${1:nombre_usuario} WITH PASSWORD '${2:contraseña}';"
		],
		"description": "Crear un usuario en Postgres",
		"scope": "sql"
	},
	"Postgres Grant Privileges": {
		"prefix": "pggrant",
		"body": [
			"-- Otorgar privilegios a un usuario",
			"GRANT ${1:ALL} PRIVILEGES ON DATABASE ${2:base_de_datos} TO ${3:usuario};"
		],
		"description": "Otorgar privilegios a un usuario en Postgres",
		"scope": "sql"
	},
// --- FIN SNIPPETS POSTGRES ---


// --- INICIO SNIPPETS LARAVEL ---
	"Laravel Route": {
		"prefix": "laravelroute",
		"body": [
			"// Definir una ruta en Laravel",
			"Route::${1:get}('${2:/ruta}', [${3:Controlador}::class, '${4:metodo}']);"
		],
		"description": "Definir una ruta en Laravel",
		"scope": "php"
	},
	"Laravel Controller": {
		"prefix": "laravelcontroller",
		"body": [
			"// Crear un controlador básico en Laravel",
			"namespace App\\Http\\Controllers;",
			"",
			"use Illuminate\\Http\\Request;",
			"",
			"class ${1:NombreController} extends Controller",
			"{",
			"\tpublic function ${2:index}()",
			"\t{",
			"\t\t$0",
			"\t}",
			"}"
		],
		"description": "Controlador básico en Laravel",
		"scope": "php"
	},
	"Laravel Migration": {
		"prefix": "laravelmigration",
		"body": [
			"// Crear una migración en Laravel",
			"Schema::create('${1:tabla}', function (Blueprint \$table) {",
			"\t\$table->id();",
			"\t\$table->string('${2:nombre}');",
			"\t\$table->timestamps();",
			"\t$0",
			"});"
		],
		"description": "Migración básica en Laravel",
		"scope": "php"
	},
	"Laravel Model": {
		"prefix": "laravelmodel",
		"body": [
			"// Crear un modelo en Laravel",
			"namespace App\\Models;",
			"",
			"use Illuminate\\Database\\Eloquent\\Model;",
			"",
			"class ${1:NombreModelo} extends Model",
			"{",
			"\tprotected \$fillable = [",
			"\t\t'${2:campo}',",
			"\t];",
			"\t$0",
			"}"
		],
		"description": "Modelo básico en Laravel",
		"scope": "php"
	},
	"Laravel Blade Foreach": {
		"prefix": "laravelforeach",
		"body": [
			"{{-- Bucle foreach en Blade --}}",
			"@foreach (${1:\\$items} as ${2:item})",
			"\t{{ ${2:item} }}",
			"@endforeach"
		],
		"description": "Bucle foreach en Blade",
		"scope": "php"
	},
	"Laravel Validation": {
		"prefix": "laravelvalidate",
		"body": [
			"// Validar datos en un controlador",
			"\$validated = \$request->validate([",
			"\t'${1:campo}' => '${2:required|string}',",
			"\t$0",
			"]);"
		],
		"description": "Validación de datos en Laravel",
		"scope": "php"
	},"Laravel Seeder": {
		"prefix": "laravelseeder",
		"body": [
			"// Crear un seeder en Laravel",
			"use Illuminate\\Database\\Seeder;",
			"",
			"class ${1:NombreSeeder} extends Seeder",
			"{",
			"\tpublic function run()",
			"\t{",
			"\t\t$0",
			"\t}",
			"}"
		],
		"description": "Seeder básico en Laravel",
		"scope": "php"
	},
	"Laravel Request": {
		"prefix": "laravelrequest",
		"body": [
			"// Obtener datos de una petición en Laravel",
			"\$${1:variable} = \$request->input('${2:campo}');"
		],
		"description": "Obtener datos de una petición en Laravel",
		"scope": "php"
	},
	"Laravel Middleware": {
		"prefix": "laravelmiddleware",
		"body": [
			"// Crear un middleware en Laravel",
			"namespace App\\Http\\Middleware;",
			"",
			"use Closure;",
			"",
			"class ${1:NombreMiddleware}",
			"{",
			"\tpublic function handle(\$request, Closure \$next)",
			"\t{",
			"\t\t$0",
			"\t\treturn \$next(\$request);",
			"\t}",
			"}"
		],
		"description": "Middleware básico en Laravel",
		"scope": "php"
	},
	"Laravel Blade If": {
		"prefix": "laravelbladeif",
		"body": [
			"{{-- Estructura if en Blade --}}",
			"@if (${1:condicion})",
			"\t${2:contenido}",
			"@endif"
		],
		"description": "Estructura if en Blade",
		"scope": "php"
	},
	"Laravel Blade Include": {
		"prefix": "laravelbladeinclude",
		"body": [
			"{{-- Incluir una vista en Blade --}}",
			"@include('${1:vista}')"
		],
		"description": "Incluir una vista en Blade",
		"scope": "php"
	},
	"Laravel Blade Layout": {
		"prefix": "laravelbladelayout",
		"body": [
			"{{-- Extender un layout en Blade --}}",
			"@extends('${1:layouts.app}')",
			"",
			"@section('${2:content}')",
			"\t$0",
			"@endsection"
		],
		"description": "Extender un layout en Blade",
		"scope": "php"
	}
// --- FIN SNIPPETS LARAVEL ---
}