PlItems

ID: 243
PlCodelang: Bash Script
PlGroup: Datum, Zeit
PlItemTitle: Gestriges Datum
Code: #!/bin/sh myDate=$(date +"%Y-%m-%d" -d "yesterday") echo $myDate # 2014-01-13 myDate2=$(date -d @$(( $(date +"%s") - 86400)) +"%Y-%m-%d") # 014-01-13 # today: $(date +"%Y-%m-%d") # 2014-01-14 # Hint: -d parameter doesn't work on Solaris

ID: 244
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: SQL SELECT Statische Werte
Code: SELECT * FROM ( VALUES (1, 2), (3, 4) ) AS q (col1, col2) GO -- the same as: SELECT 1 AS col1, 2 AS col2 UNION ALL SELECT 3 AS col1, 4 AS col2 GO -- col1 | col2 -- =========== -- 1 | 2 -- ----------- -- 3 | 4

ID: 245
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: SQL SELECT Statische Werte
Code: SELECT * FROM ( VALUES (1, 2), (3, 4) ) AS q (col1, col2) ; -- the same as: SELECT 1 AS col1, 2 AS col2 UNION ALL SELECT 3 AS col1, 4 AS col2 ; -- col1 | col2 -- =========== -- 1 | 2 -- ----------- -- 3 | 4

ID: 246
PlCodelang: Bash Script
PlGroup: Filehandling
PlItemTitle: Filename-Manipultation Basics
Code: #!/bin/sh myFilename="$1" # or myFilename="/tmp/Test/myFile.txt" # Get only the path path_only=$(dirname "$myFilename") # /tmp/Test # if it is a local file in the path, then . will be prompted e.g. myFilename="myFile.txt" # Filename only filename_only=$(basename "$myFilename") # myFile.txt # get only filename without extention filename_without_ext="${filename_only%.*}" # myFile # get only the extension filename_extention_only="${myFilename##*.}" # txt # put them together again myFilename_together="${path_only}/${filename_without_ext}.${filename_extention_only}" # /tmp/Test/myFile.txt

ID: 247
PlCodelang: ORACLE PL/SQL
PlGroup: Datenbank
PlItemTitle: CSV erstellen
Code: SELECT FieldA, LISTAGG(CSVItem, ',') WITHIN GROUP (ORDER BY FieldA) AS Members FROM TableWithItems GROUP BY FieldA;

ID: 248
PlCodelang: PowerShell
PlGroup: Fallunterscheidung
PlItemTitle: Ternary operator
Code: ## Example from here: https://www.kongsli.net/2012/02/23/powershell-another-alternative-to-ternary-operator/ $thisVar='OK' $resultVar = @{$true=1;$false=2}[$thisVar -eq 'OK'] // same as if-else construction if ($thisVar -eq 'OK') { $resultVar = 1; } else { $resultVar = 2; }

ID: 249
PlCodelang: Python
PlGroup: Systeminfo
PlItemTitle: Betriebssystem ermitteln
Code: import os os.name # nt, posix import platform platform.system() # 'Windows', 'Linux', 'Darwin' platform.release() # Linux, Windows, Windows, Darwin '2.6.22-15-generic', 'Vista' ,'10', '8.11.1' # Example from https://stackoverflow.com/questions/1854/python-what-os-am-i-running-on from sys import platform as _platform if _platform == "linux" or _platform == "linux2": # linux elif _platform == "darwin": # MAC OS X elif _platform == "win32": # Windows elif _platform == "win64": # Windows 64-bit

ID: 250
PlCodelang: PHP
PlGroup: Strings
PlItemTitle: Erster Buchstable Groß in Wort
Code: $myString = "nothingspecial"; $uc = ucwords($myString); echo $uc; // Nothingspecial

ID: 251
PlCodelang: Python
PlGroup: Strings
PlItemTitle: Erster Buchstable Groß in Wort
Code: # Siehe auch: http://www.php2python.com/wiki/function.ucwords/ myString = "nothingspecial" import string uc = string.capwords(myString) print(uc) # Nothingspecial

ID: 252
PlCodelang: Python
PlGroup: Dateihandling
PlItemTitle: Textdatei schreiben
Code: # Modes # r: Read mode which is used when the file is only being read # w: Write mode which is used to edit and write new information to the file (any existing files with the same name will be erased when this mode is activated) # a: Appending mode, which is used to add new data to the end of the file; that is new information is automatically amended to the end # r+: Special read and write mode, which is used to handle both actions when working with a file myFile = open("myFile.txt","w") myFile.write("Hello World") myFile.close()

ID: 253
PlCodelang: T-SQL
PlGroup: Metadaten
PlItemTitle: Fremdschlüssel auflisten
Link Reference: https://stackoverflow.com/questions/483193/how-can-i-list-all-foreign-keys-referencing-a-given-table-in-sql-server
Code: SELECT [FK_NAME] = obj.name ,[Schema_Name] = sch.name ,[Table] = tab1.name ,[Column] = col1.name ,[Referenced_Schema_Name] = sch2.name ,[Referenced_Table] = tab2.name ,[Referenced_Column] = col2.name FROM sys.foreign_key_columns fkc INNER JOIN sys.objects obj ON obj.object_id = fkc.constraint_object_id INNER JOIN sys.tables tab1 ON tab1.object_id = fkc.parent_object_id INNER JOIN sys.schemas sch ON tab1.schema_id = sch.schema_id INNER JOIN sys.columns col1 ON col1.column_id = parent_column_id AND col1.object_id = tab1.object_id INNER JOIN sys.tables tab2 ON tab2.object_id = fkc.referenced_object_id INNER JOIN sys.columns col2 ON col2.column_id = referenced_column_id AND col2.object_id = tab2.object_id INNER JOIN sys.schemas sch2 ON tab2.schema_id = sch.schema_id
Result Example:

FK_NAME	Schema_Name	Table	Column	Referenced_Schema_Name	Referenced_Table	Referenced_Column
CountryFK	dbo	Adress	FK_Country	dbo	Countied	ID

ID: 254
PlCodelang: PowerShell
PlGroup: Filehandling
PlItemTitle: Alle Dateien aus Verzeichnis auslesen
Code: $CSVFullPath = "C:\Temp" $FileFilter = "*.csv" $ListOfFiles = (Get-ChildItem -Path $CSVFullPath -Filter $FileFilter) | Select Name, BaseName, DirectoryName, FullName, Extension $ListOfFiles.Name
Result Example:

a.csv
b.csv
c.csv

ID: 255
PlCodelang: PowerShell
PlGroup: Filehandling
PlItemTitle: Verzeichnis rekursiv durchsuchen
Code: $CSVFullPath = "C:\Temp" $FileFilter = "*.*" $ListOfFiles = (Get-ChildItem -Path $CSVFullPath -Filter $FileFilter -Recurse) | Select Name, BaseName, DirectoryName, FullName, Extension | Where {$_.DirectoryName -like "*not_processed*" } $ListOfFiles.FullName
Result Example:

C:\Temp\ready_for_import_not_processed\a.csv
C:\Temp\ready_for_import_not_processed\b.csv

ID: 256
PlCodelang: PowerShell
PlGroup: Textdateien
PlItemTitle: TextDatei auslesen
Code: $myFilename = "file.txt" $fileContent = (Get-Content $myFilename)

ID: 257
PlCodelang: PowerShell
PlGroup: Schleifen
PlItemTitle: For-Schleife
Code: $elements ="A;B;C" $elements.Split(";") | ForEach-Object { write-host $_ } Write-Host " - Next example -" $elements ="D;E;F" ForEach ($element in $elements.Split(";")) { Write-Host $element }
Result Example:

A
B
C
- Next example -
D
E
F

ID: 258
PlCodelang: PowerShell
PlGroup: Exceptions
PlItemTitle: Try Catch Except
Link Credits: https://ashrafur.wordpress.com/2010/03/04/powershell-rename-folderdirectory/
Code: $DirectoryName = "C:\Temp\rename_test_new" Try { $newDirectoryName = $DirectoryName -replace "_new", "_old" Rename-Item -path $DirectoryName -newName $newDirectoryName } Catch { Write-host "Error. Exit!" Write-Error $_.Exception.Message exit # Wenn das Script hart beendet werden soll, dann kann exit verwendet werden }

ID: 259
PlCodelang: PowerShell
PlGroup: Strings
PlItemTitle: Multiline String Variable
Link Reference: https://blogs.technet.microsoft.com/heyscriptingguy/2015/12/31/powertip-use-here-strings-with-powershell/
Link Credits: https://powershell.org/forums/topic/debugging-advanced-functions-with-multi-line-string-assignment-problems/
Code: # In PowerShell such variables are called: Here-Strings $mySQLString = @" SELECT 1 FROM dbo.TestTable WHERE 1=1 "@

ID: 260
PlCodelang: SQLite
PlGroup: Datenbank
PlItemTitle: Temporäre DB-Tabelle
Code: CREATE TEMPORARY TABLE myTempTable1 ( id INT ,myText TEXT )

ID: 261
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: CTAS
Code: -- Achtung, er werden nur Felder mit Datentypen übernommen. -- Keine Constraints (PK, FK, Defaults, ...) oder IDENTITY Informationen -- Sollte die Zieltabelle (myDestinationTable) bereits vorhanden sein, kommt es zu einer Fehlermeldung SELECT * INTO myDestinationTable FROM mySourceTable

ID: 262
PlCodelang: MS Access SQL
PlGroup: Datenbank
PlItemTitle: CTAS
Code: -- Sollte die Zieltabelle (myDestinationTable) bereits vorhanden sein -- wird diese überschrieben (neue Strukturen werden übernommen) SELECT * INTO myDestinationTable FROM mySourceTable