Skip to content

Instantly share code, notes, and snippets.

@Veve2
Veve2 / vibrate.js
Created February 10, 2016 10:04
Faire vibrer un téléphone en Javascript
// Permet de préfixer les navigateurs
navigator.vibrate = navigator.vibrate || navigator.webkitVibrate || navigator.mozVibrate || navigator.msVibrate;
// Si l'API vibrate est supportée, on fait vibrer le téléphone 1/2 seconde
if (navigator.vibrate) {
navigator.vibrate(500);
}
//Il est également possible de faire vibrer plusieurs fois le téléphone en passant un tableau en paramètre :
if (navigator.vibrate) {
@Veve2
Veve2 / gist:b3d3a72a240313bab04c
Created February 10, 2016 16:33
Composer parallel downloads
composer global require hirak/prestissimo
@Veve2
Veve2 / gist:119f486b4a81d190e1fa
Created February 18, 2016 09:25
Effacer plusieurs tables MySQL ayant un même préfixe
-- Set up variable to delete ALL tables starting with 'temp_'
SET GROUP_CONCAT_MAX_LEN=10000;
SET @tbls = (SELECT GROUP_CONCAT(TABLE_NAME)
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'my_database'
AND TABLE_NAME LIKE 'temp_%');
SET @delStmt = CONCAT('DROP TABLE ', @tbls);
-- SELECT @delStmt;
PREPARE stmt FROM @delStmt;
EXECUTE stmt;
@Veve2
Veve2 / mysqldump_from_parameters_yml.sh
Created March 1, 2016 13:54
Script to dump a mysql database from the parameters of a Symfony project (script from A.L, http://stackoverflow.com/a/35724475/4074148)
#!/bin/bash
# See http://stackoverflow.com/questions/59895/can-a-bash-script-tell-what-directory-its-stored-in/23905052#23905052
ROOT=$(readlink -f $(dirname "$0"))
cd $ROOT
# Get database parameters
dbname=$(grep "database_name" ./app/config/parameters.yml | cut -d " " -f 6)
dbuser=$(grep "database_user" ./app/config/parameters.yml | cut -d " " -f 6)
@Veve2
Veve2 / gist:61fc99be44b5972412af
Created March 24, 2016 10:41
Doctrine: Contrainte unique sur des champs mutiples
/**
* @ORM\Entity
* @ORM\Table(name="ecommerce_products",uniqueConstraints={
* @ORM\UniqueConstraint(name="search_idx", columns={"name", "email"})})
*/
@Veve2
Veve2 / gist:deeaab7763535781c2022869e0cabe77
Created May 10, 2016 07:41
Exécuter des commandes git avec une clé ssh spécifique
ssh-agent bash -c 'ssh-add /home/myuser/.ssh/github.key; git pull git@github.com:MYPROJECT/myproject.git'
@Veve2
Veve2 / gist:f73b7f57f2582d2ab5e693f7a3a3403d
Created July 19, 2016 14:32
Sync Local and Remote MySQL Databases with a Single Command
mysqldump -u username -ppassword databasename |
ssh user@ipaddress "mysql -u root -ppassword databasename"
@Veve2
Veve2 / gist:b236a2d58917a80ba05af47cce2fdc27
Created September 1, 2016 07:22
Removing every node_modules from every projects
(use with caution):
find /www -d 2 -name node_modules -print0 | xargs -0 rm -r
From https://twitter.com/FGRibreau/status/770699612646768644
@Veve2
Veve2 / install.sh
Created September 16, 2016 09:04
Installation script for Symfony projects
#!/bin/bash
clear
rm -rf var/cache/*
composer install
bin/console assets:install --ansi -n
php bin/console doctrine:schema:update --force --em=default
php bin/console assetic:dump --env=prod
HTTPDUSER=`ps aux | grep -E '[a]pache|[h]ttpd|[_]www|[w]ww-data|[n]ginx' | grep -v root | head -1 | cut -d\ -f1`
@Veve2
Veve2 / gist:7f7e50883bc4d9a9e9e4849892abe3dd
Created October 13, 2016 13:22
Cache Doctrine queries & metadata
http://symfony.com/doc/current/reference/configuration/doctrine.html#caching-drivers :
doctrine:
orm:
metadata_cache_driver: apc
query_cache_driver: apc