Skip to content

Instantly share code, notes, and snippets.

View Louis-Saglio's full-sized avatar

Louis Saglio Louis-Saglio

View GitHub Profile
@Louis-Saglio
Louis-Saglio / cson.py
Last active July 11, 2017 09:12
Lecteur de format cson pour python
from pprint import pprint
class Iterateur:
def __init__(self):
self.prefix = []
self.rep = []
def iter_dico(self, dico: dict):
@Louis-Saglio
Louis-Saglio / scratch_9.py
Created August 8, 2017 13:29
Affiche un pyramide de lettre inversée si reverse=True
from os import system
PAUSE = 0.1
def incremente(lettres="abcdefghijk", reverse=False):
var = range(len(lettres))
if reverse:
var = reversed(var)
for i in var:
print(lettres[:i + 1:])
LD_PRELOAD='/usr/$LIB/libstdc++.so.6 /usr/$LIB/libgcc_s.so.1 /usr/$LIB/libxcb.so.1 /usr/$LIB/libgpg-error.so' android-studio
@Louis-Saglio
Louis-Saglio / gist:84c48c36b0093ed4f9fa437ab5c15227
Created June 22, 2018 09:09
Refresh source code changes in Docker container
docker build -t jestocke . && docker container stop jestocke_dev && docker container rm jestocke_dev && docker run -d --name=jestocke_dev -p 8000:8000 --network=dockernet jestocke
@Louis-Saglio
Louis-Saglio / languageiused.md
Last active December 21, 2018 13:25
language I used to code more than a Hello World

language I used to code more than a Hello World

  • Python
  • JavaScript/Node.js
  • Java
  • SQL
  • Kotlin
  • Bash
  • PHP
  • Golang
  • C++
2018-11-27 15:31:30.595 INFO 16527 --- [ main] GameAPI.PokerYnovGameApiApplication : No active profile set, falling back to default profiles: default
2018-11-27 15:31:30.969 INFO 16527 --- [ main] o.s.cloud.context.scope.GenericScope : BeanFactory id=d771e315-40ac-32d6-8b43-1ab984b1ec32
2018-11-27 15:31:31.011 INFO 16527 --- [ main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.cloud.autoconfigure.ConfigurationPropertiesRebinderAutoConfiguration' of type [org.springframework.cloud.autoconfigure.ConfigurationPropertiesRebinderAutoConfiguration$$EnhancerBySpringCGLIB$$73dd2509] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-11-27 15:31:31.177 INFO 16527 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8081 (http)
2018-11-27 15:31:31.189 INFO 16527 --- [ main] o.apache.catalina.core.StandardService : Starting service [T
/usr/lib/jvm/default-runtime/bin/java -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dcom.sun.management.jmxremote.port=37355 -Dcom.sun.management.jmxremote.authenticate=false -Dcom.sun.management.jmxremote.ssl=false -Djava.rmi.server.hostname=localhost -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -javaagent:/home/louis/.local/share/JetBrains/Toolbox/apps/IDEA-U/ch-0/183.4284.148/lib/idea_rt.jar=34819:/home/louis/.local/share/JetBrains/Toolbox/apps/IDEA-U/ch-0/183.4284.148/bin -Dfile.encoding=UTF-8 -classpath /usr/lib/jvm/default-runtime/jre/lib/charsets.jar:/usr/lib/jvm/default-runtime/jre/lib/ext/cldrdata.jar:/usr/lib/jvm/default-runtime/jre/lib/ext/dnsns.jar:/usr/lib/jvm/default-runtime/jre/lib/ext/jaccess.jar:/usr/lib/jvm/default-runtime/jre/lib/ext/localedata.jar:/usr/lib/jvm/default-runtime/jre/lib/ext/nashorn.jar:/usr/lib/jvm/default-runtime/jre/lib/ext/sunec.jar:/usr/lib/jvm/default-runtime/jre/lib/ext/sunjce_provider
USE LA300
SELECT date_format
from sys.dm_exec_sessions
where session_id = @@spid
set dateformat dmy
-- Affichez tous les employés de la société
SELECT NOM
POST https://banksserver1.org/
Content-Type: application/json
{
"debitedUserId": "sdfkvnbmsdwfv",
"debitedUserPassword": "hmpspfivubpsudfbv",
"amount": 42,
"paymentTimestamp": 1547887699,
"creditedUserId": "qsvcqefvcqefcv"
}
-- 1. SQL : lister les clients qui ont commandé en 1996 par ordre de CA décroissant pour l’année 1996 (1 pt)
SELECT CL.*
FROM CLIENTS CL
INNER JOIN COMMANDES C ON CL.CODE_CLIENT = C.CODE_CLIENT
INNER JOIN DETAILS_COMMANDES DC ON C.NO_COMMANDE = DC.NO_COMMANDE
WHERE year(DATE_COMMANDE) = 1996
GROUP BY SOCIETE, CL.CODE_CLIENT, ADRESSE, VILLE, CODE_POSTAL, PAYS, TELEPHONE, FAX
ORDER BY sum((DC.PRIX_UNITAIRE * DC.QUANTITE) * (1 - DC.REMISE)) DESC