PlItems

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: 115
PlCodelang: SSRS
PlGroup: Zahlen/Rechnen
PlItemTitle: DIV/0
Code: ' siehe auch: http://blogs.msdn.com/b/bwelcker/archive/2006/09/26/end-of-amnesia-_2800_avoiding-divide-by-zero-errors_2900_.aspx =IIf(Fields!SecondVal.Value = 0, "0", Fields!FirstVal.Value*100 / IIf(Fields!SecondVal.Value = 0, 1, Fields!SecondVal))

ID: 112
PlCodelang: Android
PlGroup: GUI, Dialoge
PlItemTitle: Hinweis-Dialog
Code: AlertDialog.Builder builder = new AlertDialog.Builder(this); builder.setMessage("Hinweis") .setTitle("Hinweis-Meldung") .setNeutralButton("OK", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) { dialog.cancel(); } }); AlertDialog alert = builder.create(); alert.show();

ID: 113
PlCodelang: Android
PlGroup: GUI, Dialoge
PlItemTitle: Abfrage-Dialog
Code: // siehe auch : http://developer.android.com/guide/topics/ui/dialogs.html AlertDialog.Builder builder = new AlertDialog.Builder(this); builder.setMessage("Are you sure you want to exit?") .setCancelable(false) .setPositiveButton("Yes", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int id) { WhatHaveYouDoneActivity.this.finish(); } }) .setNegativeButton("No", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int id) { dialog.cancel(); } }); AlertDialog alert = builder.create(); alert.show();

ID: 114
PlCodelang: Android
PlGroup: GUI, ComboBox
PlItemTitle: ComboBox füllen
Code: public void fillSpn() { String dummyarr[]; Spinner spn1 = (Spinner) findViewById(R.id.spn1); // Dummy Data dummyarr = new String[5]; int i; for (i=0;i<5;i++) { dummyarr[i]=String.valueOf(i); } ArrayAdapter adapter = new ArrayAdapter(this, android.R.layout.simple_spinner_dropdown_item, dummyarr); spn1.setAdapter(adapter); }

ID: 111
PlCodelang: HTML
PlGroup: Sonstiges
PlItemTitle: RSS Hinweis
Code: <link rel="alternate" type="application/rss+xml" title="RSS Feed" href="Feed-URL"/>

ID: 106
PlCodelang: WPF
PlGroup: GUI, .NET-WPF
PlItemTitle: WPF - Style MultiTrigger
Code: <Style TargetType="Button"> <Style.Triggers> <MultiTrigger> <MultiTrigger.Conditions> <Condition Property="IsMouseOver" Value="True" /> <Condition Property="Content" Value="Button 2" /> </MultiTrigger.Conditions> <Setter Property="FontWeight" Value="Bold"/> </MultiTrigger> </Style.Triggers> </Style>

ID: 274
PlCodelang: Python
PlGroup: Strings
PlItemTitle: Leerzeichen vor/hinter String entfernen
Code: myText = " x text x \r\n" print myText.strip()
Result Example:

x text x

ID: 280
PlCodelang: Python
PlGroup: Filehandling
PlItemTitle: Prüfen ob Verzeichnis existiert
Code: import os.path from os import path myFolder = "/tmp/test" if path.exists(myFolder) & path.isdir(myFolder): print "Folder exists!" else: print "Folder doesn't exist!"

ID: 281
PlCodelang: Python
PlGroup: Filehandling
PlItemTitle: Verzeichnis erstellen
Code: import os myFolder = "/tmp/test" try: os.mkdir(myFolder) except OSError: print ("Error creating directory: %s" % myFolder) else: print ("Directory created: %s " % myFolder)

ID: 70
PlCodelang: Python
PlGroup: Filehandling
PlItemTitle: Verzeichnis rekursiv durchsuchen
Code: import os searchPath = '/home/patrick/Desktop/' # os.walk will go through all subdirectories for pathentry in os.walk(searchPath, False): for dir in pathentry[1]: path = os.path.join(pathentry[0], dir) if os.path.islink(path): print path + "... is a link" # os.unlink(path) else: print path + "... is a dir" # os.rmdir(path) for file in pathentry[2]: path = os.path.join(pathentry[0], file) # os.unlink(path) print path + "... is a file" # os.listdir only the given path for file in os.listdir(searchPath): fullfilename = os.path.join(searchPath, file) if os.path.isfile(fullfilename): print fullfilename + "... is a file"

ID: 76
PlCodelang: Python
PlGroup: Netzwerk, Email
PlItemTitle: Email versenden
Code: # Found at (and little modified): http://www.semi-legitimate.com/sls/blog/37-quick-notes/62-command-line-smtp-from-python #!/usr/bin/python import smtplib, sys if len(sys.argv) != 5: print "You must call me like:" print " mailme from to subject msgfile" sys.exit() fromadr = sys.argv[1] toadr = sys.argv[2] subject = sys.argv[3] msgfile = sys.argv[4] try: f = open(msgfile) msg = f.read() except: print "Invalid Message File: " + msgfile sys.exit() m = "From: %s To: %s Subject: %s X-Mailer: My-Mail " \ % (fromadr, toadr, subject) smtpserver="mysmtp.lan" loginuser="Marty_McFly" loginpwd="DeLorean" smtp = smtplib.SMTP() smtp.connect(smtpserver) smtp.login(loginuser, loginpwd) smtp.ehlo() smtp.sendmail(fromadr, toadr, m+msg) smtp.close()

ID: 125
PlCodelang: Python
PlGroup: Encoding / Decoding
PlItemTitle: Datei nach Base64 encodieren
Code: myfile = 'myDoc.pdf' ReturnValue = open(myfile).read().encode("base64") # in ReturnValue ist nun der Base64-String

ID: 128
PlCodelang: Python
PlGroup: Konsolenverwaltung
PlItemTitle: Einlesen Konsoleneingabe
Code: yourname = raw_input('What\'s your name? ')

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: 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"

ID: 164
PlCodelang: Python
PlGroup: Variablen
PlItemTitle: Auflistung aller Variablen
Code: import pprint a="This is a test" b=1 c=True pprint.pprint(locals()) #{'__builtins__': <module '__builtin__' (built-in)>, # '__doc__': None, # '__name__': '__main__', # '__package__': None, # 'a': 'This is a test', # 'b': 1, # 'c': True, # 'pprint': <module 'pprint' from '/usr/lib/python2.7/pprint.pyc'>} pprint.pprint(globals())