williamdes

    private static ExampleObject getObject(Context c,String db_name){
        SharedPreferences sharedPreferences = c.getSharedPreferences(db_name, Context.MODE_PRIVATE);
        ExampleObject o = new ExampleObject();
        Field[] fields = o.getClass().getFields();
        try {
            for (Field field : fields) {
                Class<?> type = field.getType();
                try {
                    final String name = field.getName();
                    if (type == Character.TYPE || type.equals(String.class)) {

williamdes

#!/bin/bash

#
# Docker OR OPENVPN rules
#

#Reset rules
iptables -F
iptables -X
iptables -t nat -F

williamdes

#!/bin/sh
export PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin":$PATH
#echo $PATH
INPUT_PORTS="22,21,20,80,443,3306,8006"
FORWARD_PORTS="3306,80,443,8080"
cd /sbin/
echo "[IpTables] Reset..."
sleep 1
iptables -F
iptables -X

williamdes

# See : https://github.com/williamdes/sql-backup

williamdes

Keybase proof

I hereby claim:

• I am williamdes on github.
• I am williamdes (https://keybase.io/williamdes) on keybase.
• I have a public key whose fingerprint is C4D9 1FDF CEF6 B4A3 C653 FD78 90A0 EF1B 8251 A889

To claim this, I am signing this object:

williamdes

#!/bin/bash

# git: Having a branch/tag with the same name (error: dst refspec matches more than one.)
# run git branch --all and use a text editor to create a batch of commands
git tag -m "[imported from branch]" --force --sign "release/2019-09-10-1" $(git show-ref --hash "refs/remotes/origin/release/2019-09-10-1")

# https://markhneedham.com/blog/2013/06/13/git-having-a-branchtag-with-the-same-name-error-dst-refspec-matches-more-than-one/

# Delete ref from remote
git push origin :"refs/heads/release/2019-09-10-1"

williamdes

PHP Socket client server example

With this example you will be able to use modern PHP code and have multiple clients connected.

The code is inspired and sourced from the of the posted notes here.

If you CTRL-C stopped the server, run the script twice. The first time will clean up the left over socket. Or just remove the socket file before starting the server.

There is a "magic" command (STOP) in the code to stop the server, you can easily remove it.

williamdes

/**
 * Get fingerprint from a certificate in android.content.pm.Signature
 * @return String fingerprint that contains the SHA-256 digest
 */
private static String getFingerprint(android.content.pm.Signature ce){
    String certificate = "";
    InputStream input = new ByteArrayInputStream(ce.toByteArray());

    CertificateFactory cf = null;
    try {

williamdes

#!/bin/sh

# Source: https://gist.github.com/williamdes/7a63ba6af24ea91edaf988ba8078b0fa

set -eu

if [ -z "${1:-}" ]; then
  echo "Missing the domain name to add"
  echo "Use: ~/add-cert.sh mynewdomain.tld"
  echo "To add multiple domains you can use: ~/add-cert.sh \"mynewdomain.tld -d www.mynewdomain.tld\""

williamdes

-- Comments from: https://marmelab.com/blog/2017/01/09/sirene-import-sql.html
CREATE TABLE sirene_data (
    `siren` INT(9) UNSIGNED NOT NULL COMMENT "Identifiant de l’entreprise",
    `nic` SMALLINT(5) UNSIGNED NOT NULL COMMENT "Numéro interne de classement de l'établissement",
    `siret` BIGINT(10) UNSIGNED NOT NULL PRIMARY KEY COMMENT "Identifiant de l’entreprise",
    `statutDiffusionEtablissement` ENUM('O') NOT NULL COMMENT "Statut de diffusion de l’établissement",
    `dateCreationEtablissement` VARCHAR(10) NOT NULL COMMENT "Date de création de l’entreprise",
    `trancheEffectifsEtablissement` ENUM('NN', '00', '01', '02', '03', '11', '12', '21', '22', '31', '32', '41', '42', '51', '52', '53') NOT NULL COMMENT "Tranche d’effectif salarié de l’établissement",
    `anneeEffectifsEtablissement` VARCHAR(4) NOT NULL COMMENT "Année de validité de la tranche d’effectif salarié de l’établissement",
    `activitePrincipaleRegistreMetiersEtablissement` VARCHAR(6) NOT NULL COMMENT "Activité exercée par l’artisan