PlItems

ID: 143
PlCodelang: JavaScript
PlGroup: URL-Handling
PlItemTitle: Domain und Port einer URL
Code: domainAndPort = document.URL.split("/")[2]; // => 192.168.1.100:1234 // => myDNSname.com:6789

ID: 144
PlCodelang: JavaScript
PlGroup: Strings
PlItemTitle: String nach Delimenter zerlegen
Code: myTestString = "abc;def;ghj/1"; splittedString = myTestString.split(";"); elementTwo = splittedString[1]; // => def

ID: 145
PlCodelang: JavaScript
PlGroup: Strings
PlItemTitle: Anzahl an Zeichen in einem String ermitteln
Code: myString = "This is a string, containing some words. Try it, if you don't believe ;-)"; // Get the count of commas in the string: cntCommas = myString.split(",").length-1; // => 2

ID: 146
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: Tabelle kopieren
Code: CREATE TABLE new_table AS SELECT * FROM old_table -- this action can't be done cross databases

ID: 147
PlCodelang: PL/pgSQL
PlGroup: Datum, Zeit
PlItemTitle: Jahr aus Datum extrahieren
Code: select extract(year from now())

ID: 148
PlCodelang: PL/pgSQL
PlGroup: Strings
PlItemTitle: Strings miteinander verbinden
Code: -- Bei PL/pgSQL sollte man die Funktion concat verwenden. -- Felder verbinden mit || kann zu NULL im Ergebnisfeld führen SELECT field_a ,field_b ,NULL as field_c ,concat(field_a, field_b, field_c) as together FROM table_1

ID: 149
PlCodelang: Perl
PlGroup: Datum, Zeit
PlItemTitle: Jahr aus Datum extrahieren
Code: use POSIX qw/EXIT_SUCCESS EXIT_FAILURE/; # Datum Vorbereitung: my $DateTime = POSIX::strftime('%c', localtime(time)); my ($Date, $Time) = split(/\s+/, $DateTime); my ($Day, $Month, $Year) = split(/\./, $Date); my ($Hour, $Minute, $Second) = split(/:/, $Time ); my $Datum = "$Year"."$Month"."$Day"; #oder # my $Datum = "$Day"."$Month"."$Year"; my $Uhrzeit = "$Hour".":"."$Minute".":"."$Second";

ID: 150
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: DB-Funktion erstellen
Code: CREATE OR REPLACE FUNCTION whichContinent(country TEXT) RETURNS character varying AS $BODY$ DECLARE returnValue character varying; BEGIN SELECT INTO returnValue CASE country WHEN 'ARGENTINA' THEN 'SOUTH AMERICA' WHEN 'BELGIUM' THEN 'EUROPE' WHEN 'BRAZIL' THEN 'SOUTH AMERICA' WHEN 'CANADA' THEN 'NORTH AMERICA' WHEN 'DENMARK' THEN 'EUROPE' WHEN 'FINLAND' THEN 'EUROPE' WHEN 'FRANCE' THEN 'EUROPE' ELSE 'UNKNOWN' END; RETURN returnValue; END; $BODY$ LANGUAGE PLPGSQL;

ID: 151
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: Automatisch hochzählendes Feld
Code: CREATE TABLE myTable ( id INT IDENTIY(1,1), field1 varchar(100) )

ID: 152
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: Automatisch hochzählendes Feld
Code: CREATE TABLE myTable ( id SERIAL, field1 varchar(100) )

ID: 153
PlCodelang: PL/pgSQL
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: SELECT now();

ID: 154
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: Erstellen und Befüllen Tabelle aus Query
Code: DROP TABLE myTable; CREATE TABLE myTable AS SELECT * FROM mySecondTable;

ID: 155
PlCodelang: Python
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: from datetime import date iso_datum = date.today().isoformat() output = iso_datum print output # 2013-12-05 # or import datetime datetime.datetime.now().strftime("%Y-%m-%d_%H-%M-%S") # 2013-12-05_18-09-10

ID: 156
PlCodelang: PL/pgSQL
PlGroup: Datum, Zeit
PlItemTitle: Monat aus Datum extrahieren
Code: -- You get the local name for the spoken month name SELECT to_char(now(), 'TMMonth') -- results in german to "Januar" or "Dezember" (= "January", "December")

ID: 157
PlCodelang: PL/pgSQL
PlGroup: Datum, Zeit
PlItemTitle: Erster und letzter Tag des Monats ermitteln
Code: select date_trunc('month', now()) -- first day in month select date_trunc('month', now()) + interval '1 month - 1 day' -- last day in month

ID: 158
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: Schema-Vergleich
Code: SELECT * FROM ( SELECT TABLES_P.TABLE_SCHEMA AS [SCHEMA_P] , TABLES_P.TABLE_NAME AS [OBJECTNAME_P] , TABLES_P.TABLE_TYPE AS [OBJECTTYPE_P] FROM <DATABASE_PRODUCTION>.INFORMATION_SCHEMA.TABLES AS TABLES_P UNION ALL SELECT ROUTINES_P.ROUTINE_SCHEMA AS [SCHEMA_P] , ROUTINES_P.ROUTINE_NAME AS [OBJECTNAME_P] , ROUTINES_P.ROUTINE_TYPE AS [OBJECTTYPE_P] FROM <DATABASE_PRODUCTION>.INFORMATION_SCHEMA.ROUTINES AS ROUTINES_P UNION ALL SELECT '' AS [SCHEMA_P] , TRIG.name AS [OBJECTNAME_P] , 'TRIGGER TABLE' AS [OBJECTTYPE_P] FROM <DATABASE_PRODUCTION>.sys.triggers AS TRIG INNER JOIN <DATABASE_PRODUCTION>.sys.tables AS TAB ON TRIG.parent_id = TAB.object_id UNION ALL SELECT '' AS [SCHEMA_P] , TRIG.name AS [OBJECTNAME_P] , 'TRIGGER VIEW' AS [OBJECTTYPE_P] FROM <DATABASE_PRODUCTION>.sys.triggers AS TRIG INNER JOIN <DATABASE_PRODUCTION>.sys.views AS TAB ON TRIG.parent_id = TAB.object_id ) ss_P FULL OUTER JOIN ( SELECT TABLES_E.TABLE_SCHEMA AS [SCHEMA_E] , TABLES_E.TABLE_NAME AS [OBJECTNAME_E] , TABLES_E.TABLE_TYPE AS [OBJECTTYPE_E] FROM <DATABASE_DEVELOPMENT>.INFORMATION_SCHEMA.TABLES AS TABLES_E UNION ALL SELECT ROUTINES_E.ROUTINE_SCHEMA AS [SCHEMA_E] , ROUTINES_E.ROUTINE_NAME AS [OBJECTNAME_E] , ROUTINES_E.ROUTINE_TYPE AS [OBJECTTYPE_E] FROM <DATABASE_DEVELOPMENT>.INFORMATION_SCHEMA.ROUTINES AS ROUTINES_E UNION ALL SELECT '' AS [SCHEMA_P] , TRIG.name AS [OBJECTNAME_P] , 'TRIGGER TABLE' AS [OBJECTTYPE_P] FROM <DATABASE_DEVELOPMENT>.sys.triggers AS TRIG INNER JOIN <DATABASE_DEVELOPMENT>.sys.tables AS TAB ON TRIG.parent_id = TAB.object_id UNION ALL SELECT '' AS [SCHEMA_P] , TRIG.name AS [OBJECTNAME_P] , 'TRIGGER VIEW' AS [OBJECTTYPE_P] FROM <DATABASE_DEVELOPMENT>.sys.triggers AS TRIG INNER JOIN <DATABASE_DEVELOPMENT>.sys.views AS TAB ON TRIG.parent_id = TAB.object_id ) ss_E ON ss_P.[SCHEMA_P]=ss_E.[SCHEMA_E] AND ss_P.OBJECTNAME_P=ss_E.OBJECTNAME_E AND ss_P.OBJECTTYPE_P=ss_E.OBJECTTYPE_E

ID: 159
PlCodelang: Python
PlGroup: Textdateien
PlItemTitle: TextDatei auslesen
Code: myFilename = "file.txt" fileObj = open(myFilename , "r" ) array = [] for line in fileObj: array.append( line ) fileObj.close()

ID: 160
PlCodelang: Python
PlGroup: Exceptions
PlItemTitle: Try Catch Except
Code: try: print 1/0 except Exception as e: print traceback.extract_stack() else: print "this is the else block" finally: print "finally clean up or something"

ID: 161
PlCodelang: Python
PlGroup: Strings
PlItemTitle: String nach einem Teilstring durchsuchen
Code: # http://www.tutorialspoint.com/python/string_find.htm # this function is case sensitive fullstring = "This is my string" searchFor = "my" startPosition = fullstring.find(searchFor, 0, len(fullstring)) # startPosition will have 8 if startPosition>=0: print "I found it!" startPosition = fullstring.upper().find(searchFor.upper()) # case insensitive

ID: 162
PlCodelang: Python
PlGroup: Strings
PlItemTitle: String auf Wunschlänge zuschneiden
Code: myString = "Benzinverbrauch" print myString[2:10] # Ausgabe: "nzinverb"