Skip to content

Instantly share code, notes, and snippets.

View mugan86's full-sized avatar
💻
💪💪

Anartz Mugika Ledo mugan86

💻
💪💪
View GitHub Profile
@rxaviers
rxaviers / gist:7360908
Last active May 3, 2024 16:14
Complete list of github markdown emoji markup

People

:bowtie: :bowtie: 😄 :smile: 😆 :laughing:
😊 :blush: 😃 :smiley: ☺️ :relaxed:
😏 :smirk: 😍 :heart_eyes: 😘 :kissing_heart:
😚 :kissing_closed_eyes: 😳 :flushed: 😌 :relieved:
😆 :satisfied: 😁 :grin: 😉 :wink:
😜 :stuck_out_tongue_winking_eye: 😝 :stuck_out_tongue_closed_eyes: 😀 :grinning:
😗 :kissing: 😙 :kissing_smiling_eyes: 😛 :stuck_out_tongue:
@iPaulPro
iPaulPro / include_list_viewpager.xml
Last active March 7, 2024 11:13
CollapsingToolbarLayout with TabLayout
<?xml version="1.0" encoding="utf-8"?><!--
~ Copyright (C) 2015 The Android Open Source Project
~
~ Licensed under the Apache License, Version 2.0 (the "License");
~ you may not use this file except in compliance with the License.
~ You may obtain a copy of the License at
~
~ http://www.apache.org/licenses/LICENSE-2.0
~
~ Unless required by applicable law or agreed to in writing, software
anonymous
anonymous / LocationTrackingService.kt
Created July 26, 2016 12:06
Android location tracking background service in Kotlin language. Referenced from: http://stackoverflow.com/a/28535885/1441324
import android.app.Service
import android.content.Context
import android.content.Intent
import android.location.Location
import android.location.LocationManager
import android.os.Bundle
import android.util.Log
class LocationTrackingService : Service() {
@mugan86
mugan86 / gist:4c9ffa1033a581655da4db11e9483ca8
Created January 23, 2018 05:55 — forked from rxaviers/gist:7360908
Complete list of github markdown emoji markup

People

:bowtie: :bowtie: 😄 :smile: 😆 :laughing:
😊 :blush: 😃 :smiley: ☺️ :relaxed:
😏 :smirk: 😍 :heart_eyes: 😘 :kissing_heart:
😚 :kissing_closed_eyes: 😳 :flushed: 😌 :relieved:
😆 :satisfied: 😁 :grin: 😉 :wink:
😜 :stuck_out_tongue_winking_eye: 😝 :stuck_out_tongue_closed_eyes: 😀 :grinning:
😗 :kissing: 😙 :kissing_smiling_eyes: 😛 :stuck_out_tongue:
@mugan86
mugan86 / movies.sql
Last active December 1, 2019 07:58
Movies Script
CREATE TABLE genre (
id int NOT NULL PRIMARY KEY,
name varchar(150) NOT NULL
);
INSERT INTO genre VALUES(0, 'None');
INSERT INTO genre VALUES(12, 'Adventure');
INSERT INTO genre VALUES(14, 'Fantasy');
INSERT INTO genre VALUES(16, 'Animation');
INSERT INTO genre VALUES(18, 'Drama');
@mugan86
mugan86 / qax.sql
Created December 1, 2019 07:53
Sistema de preguntas y respuestas
create table users(
id int not null primary key,
name varchar(50) not null,
lastname varchar(50) not null,
username varchar(50),
email varchar(255) not null,
password varchar(60) not null,
image varchar(255) not null,
is_active boolean not null,
is_admin boolean not null,
@mugan86
mugan86 / paises.csv
Created January 14, 2020 18:52 — forked from brenes/README.md
CSV de paises, con nombre en castellano, ingles, codigo ISO y prefijo telefónico del país
nombre name nom iso2 iso3 phone_code
Afganistán Afghanistan Afghanistan AF AFG 93
Albania Albania Albanie AL ALB 355
Alemania Germany Allemagne DE DEU 49
Algeria Algeria Algérie DZ DZA 213
Andorra Andorra Andorra AD AND 376
Angola Angola Angola AO AGO 244
Anguila Anguilla Anguilla AI AIA 1 264
Antártida Antarctica L'Antarctique AQ ATA 672
Antigua y Barbuda Antigua and Barbuda Antigua et Barbuda AG ATG 1 268
@mugan86
mugan86 / aggregation-mongodb.txt
Created April 11, 2020 09:00
Añadiré las consultas para hacer inner join con MongoDB
Obtener los nombres de los datos principales del producto, limitado a 5 y que sean plataforma PC
db.products_platforms.aggregate( [{ $lookup: { from: 'products', localField: 'product_id', foreignField: 'id', as: 'info_general' } }, {$match: {platform_id: '4'}}, { $project: { product_id: 0 } }, {$limit: 5}]).pretty()
@mugan86
mugan86 / take-all-branches.sh
Created April 21, 2020 23:35
Descargar todas las ramas remotas a local
git branch -r | grep -v '\->' | while read remote; do git branch --track "${remote#origin/}" "$remote"; done
git fetch --all
git pull --all
@mugan86
mugan86 / index.js
Created July 12, 2020 06:11
Servidor básico con lo mínimo en GraphQL haciendo uso de GraphiQL
const express = require("express");
const { buildSchema } = require("graphql");
const { graphqlHTTP } = require("express-graphql");
const bodyParser = require('body-parser');
const courses = [
{
id: 1,
title: "GraphQL de 0 a experto",
views: 29290,
},