Skip to content

Instantly share code, notes, and snippets.

View alefra88's full-sized avatar

Alan.dev alefra88

1 follower · 3 following
View GitHub Profile
@alefra88
alefra88 / oracle_docker
Created March 10, 2025 06:26
descargar imagen de oracle XE con docker pull y correr la instancia con docker run
docker pull container-registry.oracle.com/database/express:latest
docker run --name oracle_docker_xe2 -p 1522:1521 -e ORACLE_PWD=dbdev container-registry.oracle.com/database/express:21.3.0-xe
@alefra88
alefra88 / customers_pk.dat
Created March 10, 2025 03:21
crear tabla en oracle db con pk incremental
CREATE TABLE customers (
customer_id NUMBER GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
customer_name VARCHAR2(250)
);
@alefra88
alefra88 / gist:9522ba1ff8c7451eb2a9c595b8e96c8f
Last active February 5, 2025 03:29
SCAFOLD
Scaffold-DbContext "Server=LAPTOP-S8HOTDC5\SQLEXPRESS;Database=Empresa1;User ID=sa; password=dbdev; TrustServerCertificate=True;" Microsoft.EntityFrameWorkCore.SqlServer -Tables "dbo.T_EMPLEADOS","dbo.T_CAT_PUESTO" -Context EmpresaContext -ContextDir Models -OutputDir Models -NoPluralize -Force
/*Inyectar Connection string a program*/
builder.Services.AddDbContext<DBTESTContext>(opcion =>
{
opcion.UseSqlServer(builder.Configuration.GetConnectionString("dbCon"));
});
@alefra88
alefra88 / spInsertarUsuario.sql
Last active November 5, 2024 21:54
sp en sql server para insertar usuario con password hasheada, se agregó mensaje de error
USE [DB_desde_transact]
GO
/****** Object: StoredProcedure [dbo].[spUsuariosInsertar] Script Date: 05/11/2024 03:52:16 p. m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spUsuariosInsertar]
(
@Email varchar(250),
@alefra88
alefra88 / constructor.cs
Created July 30, 2024 17:49
Constructor que recibe cadena de conexión desde appsettings.json y que usa el objeto ConfigurationBuilder
//En el método constructor se cargará la URL de la web api que se especifico en appsettings.json
//para esto se utiliza un objeto ConfigurationBuilder
var builder = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json").Build();
_urlWebAPI = builder.GetSection("urlWebAPI").Value;
@alefra88
alefra88 / BussinessLogicClassAsync.cs
Last active July 30, 2024 18:51
public class BLAlumnos
{
private string _urlWebAPI;
public BLAlumnos() { }
public async Task<List<Alumnos>> Consultar() { }
public async Task<Alumnos> Consultar(int? id) { }
public async Task<Alumnos> Agregar(Alumnos alumnos) { }
public async Task Actualizar(Alumnos alumnos) { }
public async Task Eliminar(int id) { }
}
@alefra88
alefra88 / program.cs
Created July 30, 2024 16:30
builder service into Program MVC core
// Add services to the container.
builder.Services.AddDbContext<NameContext>(options =>
options.UseSqlServer(builder.Configuration.GetConnectionString("DBConnectionName")));
// Add Authorization services
builder.Services.AddAuthorization();
@alefra88
alefra88 / scaffolding.txt
Created July 30, 2024 07:20
Scaffold-DbContext "Server=LAPTOP-S8HOTDC5\SQLEXPRESS;Database=DBName;User ID=sa; password=password;" Microsoft.EntityFrameWorkCore.SqlServer -Tables TableName -Context NameContext -ContextDir Models/Context -OutputDir Models/Entities -NoPluralize -Force
@alefra88
alefra88 / managerClick.js
Created July 14, 2024 01:18
Proteger de multiples clicks
function eventManager(){
let executing = false;
return async ()=>{
if(!executing){
executing = true;
await fn();
setTimeout(()=>{executing = false},2000);
}
}
}
@alefra88
alefra88 / app.js
Created March 12, 2023 10:36
142. WordPress REST API y Fetch
const d = document,
$site = d.getElementById("site"),
$posts = d.getElementById("posts"),
$loader = d.querySelector(".loader"),
$template = d.getElementById("post-template"),
$fragment = d.createDocumentFragment(),
DOMAIN = "https://malvestida.com",
SITE = `${DOMAIN}/wp-json`,
API_WP = `${SITE}/wp/v2`,
POSTS = `${API_WP}/posts?_embed`,