Skip to content

Instantly share code, notes, and snippets.

View marcelodeandrade's full-sized avatar

Marcelo de Andrade marcelodeandrade

20 followers · 67 following
View GitHub Profile
@marcelodeandrade
marcelodeandrade / mount_windows.sh
Created July 11, 2018 20:57
Mount a remote windows directory
#!/bin/bash
sudo mount --verbose -t cifs -o username=USERNAME,domain=DOMAIN,password=PASSWORD,uid=$USER,vers=2.0 //IP_ADDRESS/D$ /mnt/DIR_TO_MOUNT
@marcelodeandrade
marcelodeandrade / search_in_xml.php
Created May 29, 2018 14:41
Search nodes wich contains a keyword and delete node, if want
$xml = new DOMDocument();
$xml->preserveWhiteSpace = false;
$xml->formatOutput = true;
$xml->load('file.xml');
$xpath = new DOMXPath($xml);
// Search in node ITEMS wich contains the keyword KEYWORD
$items = $xpath->query('//item[contains(.,"KEYWORD")]');
for ($i = $items->length - 1; $i >= 0; $i--) {
@marcelodeandrade
marcelodeandrade / delete_branch.sh
Created April 20, 2018 16:45
Delete multiples branchs with a prefix
# List branchs
git branch -r | awk -F/ '/\/PREFIX/{print $2}'
# Delete from local
git branch -D `git branch -r | awk -F/ '/\/PREFIX/{print $2}'`
# Delete from remote
git branch -r | awk -F/ '/\/PREFIX/{print $2}' | xargs git push origin --delete
@marcelodeandrade
marcelodeandrade / nextWeekDay.sql
Created March 27, 2018 19:56
Get the next day of week starting from date
DECLARE @NextDayID INT = 4 -- 0=Mon, 1=Tue, 2 = Wed, ..., 5=Sat, 6=Sun
SELECT DATEADD(DAY, (DATEDIFF(DAY, @NextDayID, GETDATE()) / 7) * 7 + 7, @NextDayID) AS NextDay
@marcelodeandrade
marcelodeandrade / getset.code-snippets
Created March 7, 2018 15:21
GET & SET for ASP Models
{
"GET & SET for ASP Models": {
"scope": "asp, vb, vbs",
"prefix": "getset",
"body": [
"\t' GET & SET for attribute {$1}",
"\t' ",
"\t' @return {$1}",
"\tPublic Property Get $1()",
"\t\t$1 = m_$1",
@marcelodeandrade
marcelodeandrade / mount.sh
Created March 5, 2018 13:58
Mount a remote folder
# Create if not exists
sudo mkdir -p /mnt/newFolder
# Mount in
sudo mount //<server_address>/<folder> -t cifs -o uid=1000,gid=1000,username=<username>,password=<password> /mnt/newFolder/
@marcelodeandrade
marcelodeandrade / rename.sh
Created December 4, 2017 20:58
Rename and change extension for all files in directory
for file in *.oldExtension; do
mv "$file" "$(basename "$file" .oldExtension).newExtension"
done
@marcelodeandrade
marcelodeandrade / cursor_example.sql
Created September 28, 2017 13:00
Example for use a CURSOR in SQL SERVER
DECLARE
@variable1 INT,
@variable2 INT
-- Create a new cursor
DECLARE cursor_example CURSOR FOR
SELECT field1, field2 FROM [table]
@marcelodeandrade
marcelodeandrade / recordsetArray.vbs
Created September 21, 2017 19:00
Get a recordset and use getRows
Function GetRSArray(strSQL)
Set objRS = Conn.Execute(strSQL)
If Not objRS.EOF Then arrRS = objRS.GetRows()
Set objRS = Nothing
GetRSArray = arrRS
End Function
arrRS = GetRSArray("SELECT ID, Name FROM users;")
If IsArray(arrRS) Then
@marcelodeandrade
marcelodeandrade / common_columns_between_tables.sql
Created August 25, 2017 11:56
Get columns which exists between two tables
SELECT A.COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS A
JOIN INFORMATION_SCHEMA.COLUMNS B ON A.COLUMN_NAME = B.COLUMN_NAME
WHERE A.TABLE_NAME = 'table_a'
AND B.TABLE_NAME = 'table_b'