IMPORTAR ESTRUCTURA DE BASE DE DATOS COMPLETA
php app/console doctrine:mapping:convert xml ./src/MB/ProductoBundle/Resources/config/doctrine/metadata/orm --from-database --force
php app/console doctrine:mapping:import MBProductoBundle annotation
php app/console doctrine:generate:entities MBProductoBundle

IMPORTAR ESTRUCTURA DE BASE DE DATOS DE UNA O VARIAS TABLAS SYMFONY2
sudo php app/console doctrine:mapping:convert xml ./src/MB/ProductoBundle/Resources/config/doctrine/metadata/orm --from-database --filter="ParametrosTienda" --force
sudo php app/console doctrine:mapping:import MBProductoBundle annotation --filter="ParametrosTienda"
sudo php app/console doctrine:generate:entities MBProductoBundle --no-backup

IMPORTAR ESTRUCTURA DE BASE DE DATOS DE UNA O VARIAS TABLAS SYMFONY3
sudo php bin/console doctrine:mapping:convert xml ./src/AppBundle/Resources/config/doctrine/metadata/orm --from-database --filter="Maetdc" --force
sudo php bin/console doctrine:mapping:import AppBundle annotation --filter="Tabla"
sudo php bin/console doctrine:generate:entities AppBundle --no-backup

GENERAR CRUD
php app/console generate:doctrine:crud

GENERAR BUNDLE
php app/console generate:bundle 
(MB/NombreBundle,yml,yes)

GENERAR UN CONTROLADOR
php app/console generate:controller
(MBProductoBundle:Documento,annotations,twig)

	
(MBProductoBundle:Maelin,yes,annotation,/linea)

GENERAR FORMA
php app/console generate:doctrine:form MBProductoBundle:Detmov


http://stackoverflow.com/questions/2095394/doctrine-how-to-print-out-the-real-sql-not-just-the-prepared-statement

php app/console generate:doctrine:form MBProductoBundle:ParametrosGlobales

sudo app/console cache:clear --env=dev
sudo chmod -R 777 app/cache
sudo chmod -R 777 app/logs

mysql 5.7
Gm5I,msBfkMi
sudo launchctl load -w /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
sudo launchctl unload -w /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

mysql 5.5
/usr/local/opt/mysql@5.5/bin/mysql.server restart

mysql 5.6
/usr/local/opt/mysql@5.6/bin/mysql.server restart

FORMATEAR CRUD
Modificar: menu.html.twig
Agregar: security.yml
Controler: (copiar cambios de MaedepController.php)
	use Symfony\Component\HttpFoundation\Response;
	indexAction
	createCustomForm
	createAction -> template
	newAction -> template
	showAction
	editAction/updateAction -> template
	deleteAction
	updateAction -> template
	MaeXXX / Set XXX
		use
		generatedValue (quitar)
		entity
		sePuedeBorrar
		Not Blank, Not Null
	XXXType
		getName


Generar una entidad en 3.3:
sudo php bin/console generate:doctrine:entity
sudo php bin/console doctrine:schema:update --force

Limpiar cache:
sudo php bin/console cache:clear --no-warmup

PETKOPARA CRUD:
sudo php bin/console petkopara:generate:crud

crontab -e
php app/console --version
sudo apachectl restart
sudo /usr/libexec/locate.updatedb
sudo apachectl -S

chmod 755 -R web
svn ci -m "mensaje"
svn ci -m "cambios y mejoras"

sudo chown manuelbustamante:access_bpf resttest

COMPOSER_ALLOW_XDEBUG=1 composer install

sudo launchctl limit maxfiles 300000 2000000

#!/bin/bash
sudo launchctl limit maxfiles 30000 2000000
echo "Fin !"

sudo lsof -n | perl -pe '$x = <>; while(<>) { ($cmd, $pid, $rest) = split(/\s+/); $cmds{$pid} = $cmd; $pids{$pid}++;} while( ($key, $val) = each %pids) { if ($val > $max) { $max = $val; $maxpid = $key; } } print "pid: $maxpid ($cmds{$maxpid}) has the most ($max) filedescriptors \n";'

http://www.macrobasesa.com/mensajitos/uploaded_files/files/FACTURA_ELECTRONICA_EN_LINEA_FEL50010000000001.pdf

sudo find /var/www/html -name "*.pdf" -type f -mtime +7 -delete
sudo find /var/www/html -name "*.xls" -type f -mtime +7 -delete

sudo grep -r --include=\parameters.yml 'app_dev.php' ./

sudo du -h --max-depth=1 | sort -hr

df -h

sudo launchctl limit maxfiles 300000 2000000

To make these limits persistent, you can use /etc/sysctl.conf file and add for example:

kern.maxprocperuid=1000
kern.maxproc=2000
kern.maxfilesperproc=20000
kern.maxfiles=50000


killall Dock


Listado de archivos con permisos en numeros
stat -c "%a %n" *

Rutas;
php bin/console debug:router

SVN:
Ignorar multiples archivos y directorios
svn propset svn:ignore -F svnignore.txt .

Revisar que está ignorado
svn proplist -v

Instalación GUZZLE Symfony 3 
sudo php -d memory_limit=-1 composer.phar require guzzlehttp/guzzle
sudo sh mblimpiar 


VS CODE SETTINGS
{
	"files.associations": {
		"*.html": "twig",
		"*.twig": "twig",
		"*.yml": "yaml"
	},
	"workbench.editor.enablePreview": false,
	"git.enabled": false,
	"files.exclude": {
		"**/app/cache/*": true,
		"**/cache": true,
		"**/var/*": true
	},
	"php.suggest.basic": false,
	"git.autorefresh": false,
	"git.autoRepositoryDetection": false,
	"files.watcherExclude": {
		"**/app/**": true,
		"**/var/**": true
	},
	"search.exclude": {
		"**/.svn/*": true,
		"**/app/*.php": true,
		"**/app/**": true,
		"**/cache": true,
		"**/var/*": true
	},
	"files.autoSave": "onWindowChange",
	"php.validate.enable": false,
	"emmet.excludeLanguages": ["markdown", "php"],
	"breadcrumbs.symbolSortOrder": "name",
	"[php]": {
		"editor.defaultFormatter": "bmewburn.vscode-intelephense-client",
		"editor.formatOnSave": true,
		"editor.tabSize": 4
	},
	"debug.inlineValues": true,
	"debug.allowBreakpointsEverywhere": true,
	"debug.openExplorerOnEnd": true,
	"debug.showSubSessionsInToolBar": true,
	"window.zoomLevel": 0,
	"prettier.proseWrap": "never",
	"emmet.triggerExpansionOnTab": true,
	"svn.enableProposedApi": "product",
	"debug.openDebug": "openOnDebugBreak",
	"diffEditor.ignoreTrimWhitespace": false,
	"debug.internalConsoleOptions": "openOnSessionStart",
	"twig-language-2.forceIndent": true,
	"twig-language-2.braceStyle": "expand",
	"intelephense.diagnostics.undefinedSymbols": false,
	"intelephense.diagnostics.undefinedMethods": false,
	"terminal.integrated.setLocalVariables": true,
	"workbench.colorCustomizations": {
		"editor.lineHighlightBackground": "#44475a"
	},
	"workbench.startupEditor": "newUntitledFile",
	"prettier.useTabs": true,
	"prettier.tabWidth": 4,
	"prettier.printWidth": 120,
	"twig-language-2.bracePadding": true,
	"twig-language-2.indentLevel": 4,
	"html-css-class-completion.enableEmmetSupport": true,
	"emmet.includeLanguages": {
		"twig": "html",
		"*.html.twig": "html"
	},
	"emmet.showSuggestionsAsSnippets": true,
	"[html]": {
		"editor.defaultFormatter": "esbenp.prettier-vscode"
	},
	"prettier.vueIndentScriptAndStyle": true,
	"editor.wordWrapColumn": 120,
	"[jsonc]": {
		"editor.defaultFormatter": "esbenp.prettier-vscode"
	},
	"[json]": {
		"editor.defaultFormatter": "esbenp.prettier-vscode"
	},
	"php-cs-fixer.rules": "@Symfony",
	"[markdown]": {
		"editor.wordWrap": "off",
		"editor.quickSuggestions": false
	},
	"editor.minimap.maxColumn": 120,
	"intelephense.environment.phpVersion": "7.1",
	"phpcs.showWarnings": false,
	"phpcs.errorSeverity": 6
}


Cambio de clave: passwd

https://report.feel.com.gt/ingfacereport/ingfacereport_documento?uuid=CCF0970A-1093-4C38-9808-D8F8B7A03893

sudo /usr/bin/mysql -u root -Bse "GRANT  SELECT ON mbinvcookieshop.hdettra TO 'christianvaldez'@'%'"

Extraer SQL query de los logs binarios
sudo mysqlbinlog  --base64-output=decode-rows --verbose /var/log/mysql/mysql-bin.004438 > binlog.txt

curl -O -J  "http://localhost/mbapi/web/app_dev.php/api/dump?base=supervet"

RServer
http://74.208.206.88:8787

Parallels$123
Clave suscripción: E72GSC-XVV3AR-PFBFKA-6M23YQ-PSE790
Clave suscripción: 6J98JG-KNM69D-3D68WX-62RZ2H-XVKXH7

Clave Win 11: DTVBN-3MVMX-9KGTD-4WHC8-MTDDQ

sudo nano /usr/local/etc/my.cnf 


arch -x86_64 brew install gnu-sed 
arch -x86_64 brew install subversion

arch -x86_64 brew remove apr-util subversion && arch -x86_64 brew install subversion && svn --version

ncdu

sudo rename 's/20220313/_Sun/' *