Skip to content

Instantly share code, notes, and snippets.

View demarchenac's full-sized avatar
🎯
Focusing

Cristhyan D. Marchena demarchenac

🎯
Focusing
44 followers · 122 following
  • Barranquilla, Colombia.
View GitHub Profile
@demarchenac
demarchenac / test
Created April 8, 2025 16:28
q87PC1JJRkaWnwcAV0VCUFZQOCCKnwcAEPUjnQEq0AdSCz5tMJRHpCUyqqZRzApQDYljQn5q76t8Dr88+pu++9PFx/0/6r6jKD/bfIR4E/5/48e6afz/7PUa8v9G/8N9IfYmf9j1J2M/ypkuEvdqA8f8jdH9y55XQ+6n/W8f71j/d+wN+vPlx9ev7CP7Rem5/Q83/256eX/k9On9Q/6Ho3+dvrCSlOtz3z6g/0H+D/ffvL4mci/Kv6f+j/dv/OfvH9BvIPhX8M/D/53/k/5P93vtS/xf/T/g+aXs//Z88H0P+Q/8X+b/137jfNf/t//D/ef674sf0T/ef+z/a/v//wvsN/XT/t/5f/VfFL/z/tx77P9f/6fy++CX91/3X7f/8T///Lr/5P3O/f/53/3f/p//X/gf7////QX/XP9j/+P97/wfjr/9v/6/7fxIfvR////J8GH9n/4//s/2Pt2fvD/5Pl7/q//S/cj/vfv/9lP9T/0f/7/2n/R+AD/9+2X/AP/r1S/kX++/43+Z/0fkq/lP+D/jf9H/2v8x64/lX3P+3/wn+g/6f+Y+Xb+N/8vMn2j/8f+V/vfZX+Y/mT+h/j/9T/5v9J++v3Y/0P/l/s/KX6E/VHsHflX9V/2/+H/z3/o/yX72/fZE98o8yvYX+N/yf/o/0f+0/cz4xfzf/n/tfYf+J/33/u9wf9kP/F/ofef/1eQL7L+53wFf1f/U//D/Vf7f94Pp6/2//z/xv+R+9fwQ+v//x/vvgU/o3+E/8v+V/1v5//XR//P/H8LP3j//v+8/4Hy4ftP/8/9qeTmLmjhfagFfIdzT4tdQq89OIAt1/+fcWNpVpLwdrNlaXz+e5mlpJfyW2krwrKaryTN79GPbDVRGyXV9nJLnU84/F+Ep8N4r11F1qoZhQ0Iu9BhM7/zmcUn++UNRNVe3Kf//cYf/8aa2a8E8GGe+l3JdSC4Q0ArujdsoYiiW/mNC9H/5RN6VjrJMgrwPX0trd4S4i4svd5YqZGIwf5VB1KO4
@demarchenac
demarchenac / .prettierrc
Created February 19, 2025 01:43
Next files
{
"semi": true,
"tabWidth": 2,
"useTabs": false,
"printWidth": 120,
"singleQuote": false,
"trailingComma": "es5",
"arrowParens": "always",
"jsxSingleQuote": false,
"plugins": ["prettier-plugin-tailwindcss"]
@demarchenac
demarchenac / .zshrc
Last active December 16, 2024 19:28
Environment settings
export ZSH="$HOME/.oh-my-zsh"
ZSH_THEME="spaceship"
plugins=(
git
npm
ssh
ssh-agent
)
@demarchenac
demarchenac / BurgerMaster_BAQ_2024.md
Last active May 2, 2024 21:29
Lugar Tipo de Carne Gramaje Quesos Tipo de Pan Tocineta Salsas Otros Ingredientes
Drip Burger Crew Res premium 130g Cheddar Brioche artesanal Sí Salsa de ajo de la casa Panceta de cerdo adobada, panceta confitada
American Burger Company Carne Angus americana 150g Colby Jack, Cheddar Butter bread Sí Smoking sweet Cebolla caramelizada
Raval Rooftop Res 130g Queso feta, queso suizo
@demarchenac
demarchenac / Spinner.jsx
Last active November 12, 2022 07:37
A basic spinner with tailwind css, taken from flowbite: https://flowbite.com/docs/components/spinner/.
export function Spinner() {
return (
<div role="status">
<svg
aria-hidden="true"
className="mr-2 w-8 h-8 text-gray-200 animate-spin dark:text-gray-600 fill-blue-600"
viewBox="0 0 100 101"
fill="none"
xmlns="http://www.w3.org/2000/svg"
>
@demarchenac
demarchenac / App.css
Last active August 29, 2022 07:05
Vite + React base setup
:root {
font-family: Inter, Avenir, Helvetica, Arial, sans-serif;
font-size: 16px;
line-height: 24px;
font-weight: 400;
color-scheme: light dark;
color: rgba(255, 255, 255, 0.87);
background-color: #242424;
@demarchenac
demarchenac / reset_cohorts.sql
Created June 1, 2022 00:13
A simple SQL to reset a cohort table on a given schema
DROP TABLE IF EXISTS @cdm_database_schema.@cohort_table;
CREATE TABLE IF NOT EXISTS @cdm_database_schema.@cohort_table (
"cohort_definition_id" integer NOT NULL,
"subject_id" integer NOT NULL,
"cohort_start_date" date NOT NULL,
"cohort_end_date" date NOT NULL
)
@demarchenac
demarchenac / outcome_cohort.sql
Created May 31, 2022 22:35
An outcome cohort generated using Atlas: https://atlas-demo.ohdsi.org/
CREATE TABLE #Codesets (
codeset_id int NOT NULL,
concept_id bigint NOT NULL
);
with primary_events (
event_id,
person_id,
start_date,
end_date,
op_start_date,
@demarchenac
demarchenac / target_cohort.sql
Created May 31, 2022 22:34
A target cohort generated using Atlas: https://atlas-demo.ohdsi.org/
CREATE TABLE #Codesets (
codeset_id int NOT NULL,
concept_id bigint NOT NULL
);
INSERT INTO #Codesets (codeset_id, concept_id)
SELECT 5 as codeset_id,
c.concept_id
FROM (
select distinct I.concept_id
FROM (
@demarchenac
demarchenac / messages.json
Last active April 21, 2022 00:26
A list of messages in JSON format.
[
{ "delta": 1000, "payload": { "type": "message", "user": { "id": 1, "user_name": "taco", "display_name": "Taco Spolsky" }, "message": { "id": 1, "text": "Hello!" } }},
{ "delta": 2000, "payload": { "type": "message", "user": { "id": 2, "user_name": "chorizo", "display_name": "Chorizo" }, "message": { "id": 2, "text": "Hi Taco!" } }},
{ "delta": 2100, "payload": { "type": "connect", "user": { "id": 3, "user_name": "pete", "display_name": "Pete the Computer" } }},
{ "delta": 3000, "payload": { "type": "message", "user": { "id": 3, "user_name": "pete", "display_name": "Pete the Computer" }, "message": { "id": 3, "text": "Hi Taco!" } }},
{ "delta": 4000, "payload": { "type": "message", "user": { "id": 1, "user_name": "pete", "display_name": "Pete the Computer" }, "message": { "id": 4, "text": "What's going on in here?" } }},
{ "delta": 5000, "payload": { "type": "message", "user": { "id": 2, "user_name": "chorizo", "display_name": "Chorizo" }, "message": { "id": 5, "text": "We're testing this chat r