Skip to content

Instantly share code, notes, and snippets.

View dlgombert's full-sized avatar

Daniel Gombert dlgombert

View GitHub Profile
@dlgombert
dlgombert / Search my gists.md
Created October 8, 2022 23:36 — forked from santisbon/Search my gists.md
How to search gists

Enter this in the search box along with your search terms:

Get all gists from the user santisbon.
user:santisbon

Find all gists with a .yml extension.
extension:yml

Find all gists with HTML files.
language:html

@dlgombert
dlgombert / linefeed.cmd
Last active September 2, 2022 20:18
Windows batch File - Set variable to new line character
REM Credit: https://stackoverflow.com/a/5642300/1167442
REM Blank line after caret is required
(SET LF=^
)
@dlgombert
dlgombert / gist:a22f63a802efad60b8b3c155436c8603
Created July 5, 2022 14:05 — forked from hissy/gist:7352933
[WordPress] Add file to media library programmatically
<?php
$file = '/path/to/file.png';
$filename = basename($file);
$upload_file = wp_upload_bits($filename, null, file_get_contents($file));
if (!$upload_file['error']) {
$wp_filetype = wp_check_filetype($filename, null );
$attachment = array(
'post_mime_type' => $wp_filetype['type'],
'post_parent' => $parent_post_id,
@dlgombert
dlgombert / view_finder.sql
Created April 14, 2022 13:03
[sql view column finder] Finds columns in sql server views #tsql
SELECT
DISTINCT OBJECT_DEFINITION(sv.object_id)
FROM
sys.views sv
JOIN sys.columns sc ON (sv.object_id = sc.object_id)
WHERE
sc.name LIKE '%#{$1:COLUMN_NAME_SUBSTRING}%'
@dlgombert
dlgombert / new-referral.js
Created April 7, 2022 15:13
[truancy-tracker-new-referral] New Referral Bookmarklet for Truancy #bookmarklet
function populate() {
let y=Math.round(Math.random()*15)+2000;
let m=String(Math.round(Math.random()*11)+1).padStart(2, '0')
let d=String(Math.round(Math.random()*28)+1).padStart(2, '0')
$('#firstname').val(chance.first());
$('#lastname').val(chance.last());
$('#birthdate').val(`${y}-${m}-${d}`);
$fa('newReferral_submit').trigger('click');
}
$fa = (function (n) {
@dlgombert
dlgombert / parent.js
Last active April 7, 2022 15:08
[truancy tracker parent] Bookmarklet for Truancy tracker - on new referral parent add #bookmarklet
$f = (function (n) {
return $('.modal-body').find(`[name="${n}"]`);
});
$fa = (function (n) {
return $(`[name="${n}"]`);
});
function opened(){
$('.nav.nav-tabs').find('li:eq(1)').find('a').trigger('click');
populate();
}
@dlgombert
dlgombert / invision.css
Created March 1, 2022 18:43
[Invision white board scheme (my take)] Random css theme from an invision-template I liked #css #color
:root {
--gray-dark: #666b79;
--gray-light:#dddfe2;
--orange-dark:#fec065;
--orange-light:#fdefcc;
--green-dark:#a1c86d;
--green-light:#e8f3dc;
--forest-dark:#77bb7c;
--forest-light:#d7f0da;
--teal-dark:#71d3be;
@dlgombert
dlgombert / sqlhelp.md
Last active March 14, 2022 16:25
[MSSQL helper functions] `sp` command shortcuts built into SQL Server #tsql #sql

sp_columns

Returns column information for the specified objects that can be queried in the current environment. [[1]]

syntax

sp_columns [ @table_name = ] object  
     [ , [ @table_owner = ] owner ]   
     [ , [ @table_qualifier = ] qualifier ]   
 [ , [ @column_name = ] column ] 
@dlgombert
dlgombert / GetAssociatedTables.sql
Last active April 14, 2022 13:03
[tables in sp] Gets tables referenced in stored procedure #tsql #sql
-- Replace {{stored_procedure_name}} with Stored procedure name
DECLARE
@sp nvarchar(100)
SET @sp = N'{{stored_procedure_name}}'
-- Objects that depends on [@sp]
SELECT
referencing_entity_name
FROM sys.dm_sql_referencing_entities(@sp, 'OBJECT')