Last active
July 24, 2020 20:22
-
-
Save Maransatto/2da588d85e10709b5ea8782b12a207f4 to your computer and use it in GitHub Desktop.
Mês de safrinha
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"lastUpload":"2020-07-24T20:22:11.091Z","extensionVersion":"v3.4.3"} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "metadata": { | |
| "id": "fbabfcd4-ca52-4c9c-942d-2c96b3f89765", | |
| "publisherId": "loiane.angular-extension-pack", | |
| "publisherDisplayName": "loiane" | |
| }, | |
| "name": "angular-extension-pack", | |
| "publisher": "loiane", | |
| "version": "0.7.1" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "b3e2189e-2a1c-4a4f-94db-35f6b228ecf7", | |
| "publisherId": "1tontech.angular-material", | |
| "publisherDisplayName": "1tontech" | |
| }, | |
| "name": "angular-material", | |
| "publisher": "1tontech", | |
| "version": "0.13.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "e0b91637-e16b-4a66-b531-4459c494f514", | |
| "publisherId": "cyrilletuzi.angular-schematics", | |
| "publisherDisplayName": "cyrilletuzi" | |
| }, | |
| "name": "angular-schematics", | |
| "publisher": "cyrilletuzi", | |
| "version": "4.3.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "214cbfb9-7c06-4467-bad4-357ae83eb587", | |
| "publisherId": "johnpapa.Angular2", | |
| "publisherDisplayName": "johnpapa" | |
| }, | |
| "name": "Angular2", | |
| "publisher": "johnpapa", | |
| "version": "9.1.2" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "4e2d44a1-45d8-4f74-9e96-158c4c51ccc4", | |
| "publisherId": "UVBrain.Angular2", | |
| "publisherDisplayName": "UVBrain" | |
| }, | |
| "name": "Angular2", | |
| "publisher": "UVBrain", | |
| "version": "0.4.1" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "3a259045-e69a-48e3-a653-df434315df18", | |
| "publisherId": "infinity1207.angular2-switcher", | |
| "publisherDisplayName": "infinity1207" | |
| }, | |
| "name": "angular2-switcher", | |
| "publisher": "infinity1207", | |
| "version": "0.3.3" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "97836a62-1e44-40e5-bab5-0de4a78cc0fb", | |
| "publisherId": "MarinhoBrandao.Angular2Tests", | |
| "publisherDisplayName": "MarinhoBrandao" | |
| }, | |
| "name": "Angular2Tests", | |
| "publisher": "MarinhoBrandao", | |
| "version": "0.7.3" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "656418ba-af03-4c69-bb6e-f3e51d543ca6", | |
| "publisherId": "AngularDoc.angulardoc-vscode", | |
| "publisherDisplayName": "AngularDoc" | |
| }, | |
| "name": "angulardoc-vscode", | |
| "publisher": "AngularDoc", | |
| "version": "6.1.3" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "d3836729-9cc1-42c1-b2af-d50071f57d29", | |
| "publisherId": "formulahendry.auto-close-tag", | |
| "publisherDisplayName": "formulahendry" | |
| }, | |
| "name": "auto-close-tag", | |
| "publisher": "formulahendry", | |
| "version": "0.5.8" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "6e440e71-8ed9-4f25-bb78-4b13096b8a03", | |
| "publisherId": "formulahendry.auto-rename-tag", | |
| "publisherDisplayName": "formulahendry" | |
| }, | |
| "name": "auto-rename-tag", | |
| "publisher": "formulahendry", | |
| "version": "0.1.4" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "70378119-1d85-4935-9733-0298c7a369a2", | |
| "publisherId": "steoates.autoimport", | |
| "publisherDisplayName": "steoates" | |
| }, | |
| "name": "autoimport", | |
| "publisher": "steoates", | |
| "version": "1.5.3" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "697255a9-3f36-44c8-b084-d3b91edfb23a", | |
| "publisherId": "HookyQR.beautify", | |
| "publisherDisplayName": "HookyQR" | |
| }, | |
| "name": "beautify", | |
| "publisher": "HookyQR", | |
| "version": "1.5.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "7a0110bb-231a-4598-aa1b-0769ea46d28b", | |
| "publisherId": "aaron-bond.better-comments", | |
| "publisherDisplayName": "aaron-bond" | |
| }, | |
| "name": "better-comments", | |
| "publisher": "aaron-bond", | |
| "version": "2.1.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "f583eafd-aa0d-4ccb-8f44-d1e610389660", | |
| "publisherId": "CoenraadS.bracket-pair-colorizer", | |
| "publisherDisplayName": "CoenraadS" | |
| }, | |
| "name": "bracket-pair-colorizer", | |
| "publisher": "CoenraadS", | |
| "version": "1.0.61" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "5a6e2b21-1d61-4acd-b31b-907f9c23f18a", | |
| "publisherId": "CoenraadS.bracket-pair-colorizer-2", | |
| "publisherDisplayName": "CoenraadS" | |
| }, | |
| "name": "bracket-pair-colorizer-2", | |
| "publisher": "CoenraadS", | |
| "version": "0.2.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "e337c67b-55c2-4fef-8949-eb260e7fb7fd", | |
| "publisherId": "Shan.code-settings-sync", | |
| "publisherDisplayName": "Shan" | |
| }, | |
| "name": "code-settings-sync", | |
| "publisher": "Shan", | |
| "version": "3.4.3" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "1109f6fe-74e4-4f43-9b37-9e50ced7f70c", | |
| "publisherId": "msjsdiag.cordova-tools", | |
| "publisherDisplayName": "msjsdiag" | |
| }, | |
| "name": "cordova-tools", | |
| "publisher": "msjsdiag", | |
| "version": "1.9.4" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "1ec62ca5-d7f9-4ddb-a882-e8d018c0aefd", | |
| "publisherId": "msjsdiag.debugger-for-chrome", | |
| "publisherDisplayName": "msjsdiag" | |
| }, | |
| "name": "debugger-for-chrome", | |
| "publisher": "msjsdiag", | |
| "version": "4.12.9" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "f60a60a6-95ba-42d4-b41c-3d24c1b89588", | |
| "publisherId": "EditorConfig.EditorConfig", | |
| "publisherDisplayName": "EditorConfig" | |
| }, | |
| "name": "EditorConfig", | |
| "publisher": "EditorConfig", | |
| "version": "0.15.1" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "4de763bd-505d-4978-9575-2b7696ecf94e", | |
| "publisherId": "eamodio.gitlens", | |
| "publisherDisplayName": "eamodio" | |
| }, | |
| "name": "gitlens", | |
| "publisher": "eamodio", | |
| "version": "10.2.2" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "7b71fc1b-190d-4f7d-95d1-93e422649b0a", | |
| "publisherId": "Zignd.html-css-class-completion", | |
| "publisherDisplayName": "Zignd" | |
| }, | |
| "name": "html-css-class-completion", | |
| "publisher": "Zignd", | |
| "version": "1.19.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "a2cec723-5349-460d-9de9-0fd1f8d3456f", | |
| "publisherId": "xabikos.JavaScriptSnippets", | |
| "publisherDisplayName": "xabikos" | |
| }, | |
| "name": "JavaScriptSnippets", | |
| "publisher": "xabikos", | |
| "version": "1.8.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "0b0e4305-3ab6-4928-bce6-081b5f146df7", | |
| "publisherId": "GregorBiswanger.json2ts", | |
| "publisherDisplayName": "GregorBiswanger" | |
| }, | |
| "name": "json2ts", | |
| "publisher": "GregorBiswanger", | |
| "version": "0.0.6" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "ad94b437-b5a7-4249-bf5f-df472ae0d084", | |
| "publisherId": "ritwickdey.live-sass", | |
| "publisherDisplayName": "ritwickdey" | |
| }, | |
| "name": "live-sass", | |
| "publisher": "ritwickdey", | |
| "version": "3.0.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "b63c44fd-0457-4696-99e9-dbfdf70d77de", | |
| "publisherId": "ritwickdey.LiveServer", | |
| "publisherDisplayName": "ritwickdey" | |
| }, | |
| "name": "LiveServer", | |
| "publisher": "ritwickdey", | |
| "version": "5.6.1" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "5db78037-f674-459f-a236-db622c427c5b", | |
| "publisherId": "PKief.material-icon-theme", | |
| "publisherDisplayName": "PKief" | |
| }, | |
| "name": "material-icon-theme", | |
| "publisher": "PKief", | |
| "version": "4.2.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "9f47c6a1-da06-41ce-ba18-5e281296aa0a", | |
| "publisherId": "stringham.move-ts", | |
| "publisherDisplayName": "stringham" | |
| }, | |
| "name": "move-ts", | |
| "publisher": "stringham", | |
| "version": "1.12.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "15b2c0a1-c05e-41d8-87f8-f6515c32047c", | |
| "publisherId": "NG-42.ng-fortytwo-vscode-extension", | |
| "publisherDisplayName": "NG-42" | |
| }, | |
| "name": "ng-fortytwo-vscode-extension", | |
| "publisher": "NG-42", | |
| "version": "0.0.9" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "a92d457e-6f3f-4167-8087-1a54e1b6e00e", | |
| "publisherId": "Angular.ng-template", | |
| "publisherDisplayName": "Angular" | |
| }, | |
| "name": "ng-template", | |
| "publisher": "Angular", | |
| "version": "0.1000.4" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "dff6b801-247e-40e9-82e8-8c9b1d19d1b8", | |
| "publisherId": "christian-kohler.npm-intellisense", | |
| "publisherDisplayName": "christian-kohler" | |
| }, | |
| "name": "npm-intellisense", | |
| "publisher": "christian-kohler", | |
| "version": "1.3.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "a41c1549-4053-44d4-bf30-60fc809b4a86", | |
| "publisherId": "christian-kohler.path-intellisense", | |
| "publisherDisplayName": "christian-kohler" | |
| }, | |
| "name": "path-intellisense", | |
| "publisher": "christian-kohler", | |
| "version": "2.2.1" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "a7696c32-2e89-4fbb-8a90-f47309e6295e", | |
| "publisherId": "Luxcium.pop-n-lock-theme-vscode", | |
| "publisherDisplayName": "Luxcium" | |
| }, | |
| "name": "pop-n-lock-theme-vscode", | |
| "publisher": "Luxcium", | |
| "version": "3.28.5" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "96fa4707-6983-4489-b7c5-d5ffdfdcce90", | |
| "publisherId": "esbenp.prettier-vscode", | |
| "publisherDisplayName": "esbenp" | |
| }, | |
| "name": "prettier-vscode", | |
| "publisher": "esbenp", | |
| "version": "5.1.3" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "f1f59ae4-9318-4f3c-a9b5-81b2eaa5f8a5", | |
| "publisherId": "ms-python.python", | |
| "publisherDisplayName": "ms-python" | |
| }, | |
| "name": "python", | |
| "publisher": "ms-python", | |
| "version": "2020.7.96456" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "3792588c-3d35-442d-91ea-fe6a755e8155", | |
| "publisherId": "mechatroner.rainbow-csv", | |
| "publisherDisplayName": "mechatroner" | |
| }, | |
| "name": "rainbow-csv", | |
| "publisher": "mechatroner", | |
| "version": "1.7.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "dda49fd5-1f3b-4d25-bf61-4fc41905ede5", | |
| "publisherId": "humao.rest-client", | |
| "publisherDisplayName": "humao" | |
| }, | |
| "name": "rest-client", | |
| "publisher": "humao", | |
| "version": "0.24.1" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "129cc09c-af1b-4269-9570-e19ded564614", | |
| "publisherId": "SimonTest.simontest", | |
| "publisherDisplayName": "SimonTest" | |
| }, | |
| "name": "simontest", | |
| "publisher": "SimonTest", | |
| "version": "1.8.8" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "a7fa941e-bcda-486f-8141-8483a6286177", | |
| "publisherId": "SonarSource.sonarlint-vscode", | |
| "publisherDisplayName": "SonarSource" | |
| }, | |
| "name": "sonarlint-vscode", | |
| "publisher": "SonarSource", | |
| "version": "1.16.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "6a2bbab0-d8f0-43fa-9b26-e6a3b7892a0b", | |
| "publisherId": "mtxr.sqltools", | |
| "publisherDisplayName": "mtxr" | |
| }, | |
| "name": "sqltools", | |
| "publisher": "mtxr", | |
| "version": "0.22.11" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "45e19ef7-c10a-44ce-8413-0d9edfbbdcaa", | |
| "publisherId": "mtxr.sqltools-driver-mysql", | |
| "publisherDisplayName": "mtxr" | |
| }, | |
| "name": "sqltools-driver-mysql", | |
| "publisher": "mtxr", | |
| "version": "0.1.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "4e44877c-1c8d-4f9c-ba86-1372d0fbeeb1", | |
| "publisherId": "dracula-theme.theme-dracula", | |
| "publisherDisplayName": "dracula-theme" | |
| }, | |
| "name": "theme-dracula", | |
| "publisher": "dracula-theme", | |
| "version": "2.22.1" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "f5d7ffda-c1d6-4070-ba80-803c705a1ee6", | |
| "publisherId": "monokai.theme-monokai-pro-vscode", | |
| "publisherDisplayName": "monokai" | |
| }, | |
| "name": "theme-monokai-pro-vscode", | |
| "publisher": "monokai", | |
| "version": "1.1.17" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "38583aca-2ba1-417f-80fc-68ca8d717fb4", | |
| "publisherId": "rbbit.typescript-hero", | |
| "publisherDisplayName": "rbbit" | |
| }, | |
| "name": "typescript-hero", | |
| "publisher": "rbbit", | |
| "version": "3.0.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "e5bfbfb1-c110-4c06-94ee-d81dca5567b4", | |
| "publisherId": "jasonlhy.vscode-browser-sync", | |
| "publisherDisplayName": "jasonlhy" | |
| }, | |
| "name": "vscode-browser-sync", | |
| "publisher": "jasonlhy", | |
| "version": "1.3.1" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "726dd888-7465-4e27-a016-4288df7be24a", | |
| "publisherId": "KnisterPeter.vscode-commitizen", | |
| "publisherDisplayName": "KnisterPeter" | |
| }, | |
| "name": "vscode-commitizen", | |
| "publisher": "KnisterPeter", | |
| "version": "0.9.3" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "0b8f8d63-11a2-4194-969c-ca7488b3413a", | |
| "publisherId": "pranaygp.vscode-css-peek", | |
| "publisherDisplayName": "pranaygp" | |
| }, | |
| "name": "vscode-css-peek", | |
| "publisher": "pranaygp", | |
| "version": "3.0.2" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "9b0315c9-0a8b-42d9-a4e5-b15f4b005b0f", | |
| "publisherId": "mkloubert.vscode-deploy-reloaded", | |
| "publisherDisplayName": "mkloubert" | |
| }, | |
| "name": "vscode-deploy-reloaded", | |
| "publisher": "mkloubert", | |
| "version": "0.89.0" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "daf8b44d-8aae-4da2-80c5-1f770219f643", | |
| "publisherId": "DavidAnson.vscode-markdownlint", | |
| "publisherDisplayName": "DavidAnson" | |
| }, | |
| "name": "vscode-markdownlint", | |
| "publisher": "DavidAnson", | |
| "version": "0.36.1" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "ae9e3eb0-3357-4cc0-90ee-598d2d384757", | |
| "publisherId": "eg2.vscode-npm-script", | |
| "publisherDisplayName": "eg2" | |
| }, | |
| "name": "vscode-npm-script", | |
| "publisher": "eg2", | |
| "version": "0.3.12" | |
| }, | |
| { | |
| "metadata": { | |
| "id": "90a37ca1-92a2-488a-b196-7a8c0b0127ea", | |
| "publisherId": "ms-vscode.vscode-typescript-tslint-plugin", | |
| "publisherDisplayName": "ms-vscode" | |
| }, | |
| "name": "vscode-typescript-tslint-plugin", | |
| "publisher": "ms-vscode", | |
| "version": "1.2.3" | |
| } | |
| ] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "workbench.iconTheme": "Monokai Pro (Filter Spectrum) Icons", | |
| "git.enableSmartCommit": true, | |
| "git.autofetch": true, | |
| "window.zoomLevel": 2, | |
| "git.confirmSync": false, | |
| "[sql]": {}, | |
| "extensions.ignoreRecommendations": false, | |
| "vscode-mysql.keepResultWindow": true, | |
| "explorer.confirmDragAndDrop": false, | |
| "editor.renderWhitespace": "all", | |
| "editor.tabCompletion": "onlySnippets", | |
| "sqltools.connections": [ | |
| { | |
| "database": "napkinna_app_hom", | |
| "dialect": "MariaDB", | |
| "name": "napkinn-homologacao", | |
| "password": "CU}z2;Xt4u0d", | |
| "port": 3306, | |
| "server": "napkinn.a2hosted.com", | |
| "username": "napkinna_user_app_hom" | |
| }, | |
| { | |
| "database": "mysql", | |
| "dialect": "MariaDB", | |
| "name": "saude_web", | |
| "password": "root", | |
| "port": 3306, | |
| "server": "localhost", | |
| "username": "root" | |
| } | |
| ], | |
| "terminal.integrated.fontFamily": "MesloLGS NF", | |
| "workbench.startupEditor": "newUntitledFile", | |
| "editor.fontFamily": "monaco, monospace", | |
| "terminal.integrated.shell.osx": "/bin/zsh", | |
| "rest-client.fontWeight": "normal", | |
| "sqltools.useNodeRuntime": true, | |
| "tabnine.experimentalAutoImports": true, | |
| "editor.acceptSuggestionOnEnter": "off", | |
| "workbench.colorTheme": "Monokai Pro (Filter Spectrum)", | |
| "editor.snippetSuggestions": "top", | |
| "sync.gist": "2da588d85e10709b5ea8782b12a207f4", | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| // Place your snippets for http here. Each snippet is defined under a snippet name and has a prefix, body and | |
| // description. The prefix is what is used to trigger the snippet and the body will be expanded and inserted. Possible variables are: | |
| // $1, $2 for tab stops, $0 for the final cursor position, and ${1:label}, ${2:another} for placeholders. Placeholders with the | |
| // same ids are connected. | |
| // Example: | |
| // "Print to console": { | |
| // "prefix": "log", | |
| // "body": [ | |
| // "console.log('$1');", | |
| // "$2" | |
| // ], | |
| // "description": "Log output to console" | |
| // } | |
| "GET padrão HTTP" : { | |
| "prefix": "rest-http-get", | |
| "body": [ | |
| "# $descricao", | |
| "GET http://localhost:3000/$endpoint", | |
| "Content-Type: application/json", | |
| "Authorization: Bearer $token", | |
| "###", | |
| "$0" | |
| ], | |
| "description": "Criar um GET padrão para REST Client" | |
| } | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| // Place your snippets for java here. Each snippet is defined under a snippet name and has a prefix, body and | |
| // description. The prefix is what is used to trigger the snippet and the body will be expanded and inserted. Possible variables are: | |
| // $1, $2 for tab stops, $0 for the final cursor position, and ${1:label}, ${2:another} for placeholders. Placeholders with the | |
| // same ids are connected. | |
| // Example: | |
| // "Print to console": { | |
| // "prefix": "log", | |
| // "body": [ | |
| // "console.log('$1');", | |
| // "$2" | |
| // ], | |
| // "description": "Log output to console" | |
| // } | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "Novo método de controller": { | |
| "prefix" : "new-controller", | |
| "body" : [ | |
| "exports.$1 = (req, res, next) => {", | |
| " $0", | |
| "}" | |
| ], | |
| "description" : "Cria a estrutura de um novo método de controller para API" | |
| }, | |
| "Cria nova conexão": { | |
| "prefix": "new-connection", | |
| "body": [ | |
| "mysql.getConnection((error, conn) => {", | |
| " if (utils.getError(error)) { return res.status(500).send({ error: error }) }", | |
| " $0", | |
| "});" | |
| ], | |
| "description": "Retorna o mysql.getConnection" | |
| }, | |
| "Cria nova query": { | |
| "prefix": "new-query", | |
| "body": [ | |
| "const query = `$1`;", | |
| "conn.query(query,[$2],(error, results, fields) => {", | |
| " conn.release();", | |
| " if (utils.getError(error)) { return res.status(500).send({ error: error }) }", | |
| " $0", | |
| "});" | |
| ], | |
| "description": "Retorna uma conn.query()" | |
| }, | |
| "Retorna o erro 500 padrão com getError()": { | |
| "prefix": "get-return-error", | |
| "body": [ | |
| "if (utils.getError($1)) { return res.status(500).send({ error: $1 }); }$0" | |
| ], | |
| "description": "Retorna o erro 500 padrão" | |
| }, | |
| "Retorna o erro 500 padrão": { | |
| "prefix": "return-error", | |
| "body": [ | |
| "return res.status(500).send({ error: $1 });$0" | |
| ], | |
| "description": "Retorna o erro 500 padrão" | |
| }, | |
| "Cria controller de insert padrão": { | |
| "prefix": "controller-create", | |
| "body": [ | |
| "exports.$create = async (req, res, next) => {", | |
| " try {", | |
| " const query = `", | |
| " $command", | |
| " `;", | |
| " const result = await mysql.execute(query, [$fields]);", | |
| " return res.status(201).send({", | |
| " $recurso: {", | |
| " $id_recurso: result.insertId,", | |
| " $0", | |
| " }", | |
| " });", | |
| " } catch (error) {", | |
| " return res.status(500).send({ error: error });", | |
| " }", | |
| "};" | |
| ], | |
| "description": "Cria controller de insert padrão" | |
| }, | |
| } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "Retorna todas as tabelas relacionadas com a tabela indicada": { | |
| "prefix": "get-foreign-key", | |
| "body": [ | |
| "SELECT TABLE_NAME, ", | |
| " COLUMN_NAME,", | |
| " CONSTRAINT_NAME,", | |
| " REFERENCED_TABLE_NAME,", | |
| " REFERENCED_COLUMN_NAME", | |
| " FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE", | |
| " WHERE CONSTRAINT_SCHEMA = DATABASE()", | |
| " AND REFERENCED_TABLE_NAME = '$1';", | |
| "$0" | |
| ], | |
| "description": "Retorna as tabelas que possuem Foreign Key com a tabela informada" | |
| }, | |
| "Cria tabela": { | |
| "prefix": "create-table", | |
| "body": [ | |
| "CREATE TABLE IF NOT EXISTS $nome_da_tabela (", | |
| " $coluna_primary_key $tipo_pk NOT NULL PRIMARY KEY AUTO_INCREMENT,", | |
| " $coluna_foreign_key $tipo_fk,", | |
| " $coluna $tipo_coluna,", | |
| " FOREIGN KEY ($coluna_foreign_key) REFERENCES $tabela_foreign_key ($coluna_foreign_key)", | |
| ");", | |
| "$0" | |
| ], | |
| "description": "Gera um modelo padrão de criação de tabelas" | |
| }, | |
| "Rename Column": { | |
| "prefix": "rename-column", | |
| "body": [ | |
| "ALTER TABLE $table_name CHANGE $column_name $new_name $type;", | |
| "$0" | |
| ], | |
| "description": "Gera um modelo padrão de criação de tabelas" | |
| }, | |
| "Dropa uma Foreign Key": { | |
| "prefix": "drop-foreign-key", | |
| "body": [ | |
| "CALL pr_dropForeignKey('$tabela','$nome_foreign_key');", | |
| "$0" | |
| ], | |
| "description": "Remove uma foreign key" | |
| }, | |
| "Cria, Altera ou Dropa uma coluna": { | |
| "prefix": "manage-column", | |
| "body": [ | |
| "CALL pr_manageColumn('$tabela','$coluna','$acao','$mudancas');", | |
| "$0" | |
| ], | |
| "description": "Cria, altera ou dropa uma coluna" | |
| }, | |
| "Vê se existe coluna": { | |
| "prefix": "if-exists-column", | |
| "body": [ | |
| "IF EXISTS (", | |
| " SELECT 1", | |
| " FROM information_schema.columns", | |
| " WHERE TABLE_NAME = '$tabela'", | |
| " AND COLUMN_NAME = '$coluna'", | |
| " AND TABLE_SCHEMA = DATABASE()", | |
| ")", | |
| "THEN", | |
| " $0", | |
| "END IF;" | |
| ], | |
| "description": "Gera uma condição pra executar somente se existir uma coluna específica" | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment