Skip to content

Instantly share code, notes, and snippets.

View adriens's full-sized avatar

SALES adriens

56 followers · 141 following
View GitHub Profile
@adriens
adriens / linkedin_slack_orapki.cmd
Created July 13, 2017 09:20
cd C:\app\salad74\virtual\admin\DIDI3\wallet
orapki wallet create -wallet C:\app\salad74\virtual\admin\DIDI3\wallet -pwd WalletPasswd123 -auto_login
orapki wallet display -wallet C:\app\salad74\virtual\admin\DIDI3\wallet
orapki wallet add -wallet C:\app\salad74\virtual\admin\DIDI3\wallet -trusted_cert -cert SLACK.cer -pwd WalletPasswd123
orapki wallet display -wallet C:\app\salad74\virtual\admin\DIDI3\wallet
@adriens
adriens / linkedin_slack_create_user.sql
Created July 13, 2017 09:22
# in case you are in a container database, set some option for user creation
alter session set "_ORACLE_SCRIPT"=true;
create user slack identified by slack;
grant connect to slack;
grant create session to slack;
grant resource to slack;
@adriens
adriens / linkedin_slack_create_acl.sql
Last active July 13, 2017 09:24
begin
dbms_network_acl_admin.create_acl (
acl => 'utl_https_slack.xml',
description => 'Slack HTTPS Access',
principal => 'SLACK',
is_grant => TRUE,
privilege => 'connect',
start_date => null,
end_date => null
);
@adriens
adriens / linkedin_slack_create_procedure.sql
Created July 13, 2017 09:26
create or replace
procedure slack
is
req utl_http.req;
res utl_http.resp;
-- !!! here PUT YOUR WEBHOOK's url !!!
url varchar2(4000) := 'https://hooks.slack.com/services/THE_REST_OF_YOUR_SECRET_URL';
buffer varchar2(4000);
content varchar2(4000) := '{"channel":"#general", "username": "sqlplus*", "text":"Hi my tablespace if full :bangbang:"}';
@adriens
adriens / linkedin_slack_exec_proc.sql
Created July 13, 2017 09:27
set serveroutput on
call slack();
@adriens
adriens / LintsSample.java
Created October 24, 2017 21:03
manage csv with jtablesaw and h2
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package com.github.adriens.open.data.fromages;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
@adriens
adriens / QRAndLogo.java
Created December 28, 2017 05:20 — forked from wombat/QRAndLogo.java
QR-Code with embedded logo
// Create new configuration that specifies the error correction
Map<EncodeHintType, ErrorCorrectionLevel> hints = new HashMap<EncodeHintType, ErrorCorrectionLevel>();
hints.put(EncodeHintType.ERROR_CORRECTION, ErrorCorrectionLevel.H);
QRCodeWriter writer = new QRCodeWriter();
BitMatrix bitMatrix = null;
ByteArrayOutputStream baos = new ByteArrayOutputStream();
try {
// Create a qr code with the url as content and a size of 250x250 px
@adriens
adriens / opt-community-grah.md
Last active November 17, 2018 23:24
OPT community graph

Introduction

L'idée de gamification des idées est vraiment super. L'idée de pouvoir liker les idées et commentaires des autres aussi. Ca pousse et encourage la créativité, c'est très stimulant.

Idée générale sur la mise en oeuvre de graphe de données

Graphe de données ?

Voir :

@adriens
adriens / opt-idee-spontannee-donnees-files-attente.md
Last active November 19, 2018 22:49

Concept

Ce serait très intéressant, via de l'open data (csv à priori sreait parfait), de disposer des données d'attente :

  • par agence
  • date/heure
  • type de guichet (colis, telecom, compte postal)
  • temps d'attente

Avec des données ouvertes de la sorte, il serait possible de jouer avec les données, de produire du

@adriens
adriens / 2018-11-23 18_11_36-1 16jNO3Q9kD7XEpLTEIZ1Ug.png
Last active November 23, 2018 20:25
OPT Idée spontanée > Les "Dash Button" ... ou "Cagou Button"
2018-11-23 18_11_36-1 16jNO3Q9kD7XEpLTEIZ1Ug.png