Mercurial with nautilus

Download dulu packagenya 

sudo apt-get install tortoisehg tortoisehg-nautilus

restart komputer

kemudian gua clone project gua dari code.google.com 

tinggal buka nautilus 

pilih menu tortoiseHQ > clone 

ikutin petunjuknya ...

Send Message via XMPP/Jabber/Googgle Talk using Python

Di python kita juga bisa kirim message ke user / friends via Google Talk atau messenger lain yang berbasis XMPP  ( Jabberd, openfire, Ejabberd). Scriptnya cukup sederhana. Sample ini gua udah test lewat google dan Openfire dikantor

Download / install dulu packagenya
sudo apt-get install python-xmpp

Kemudian ketik
nano test01.py

isi dengan

FROM_JABBER_ID = "myname@openfire"
JABBER_PASS = "123456"
JABBER_PORT = "52222"

JABBER_SERVER = "IPserver_openfire_jabber"
TO_JABBER_ID = "friends@openfire"

jid=xmpp.protocol.JID(FROM_JABBER_ID)
cl=xmpp.Client(jid.getDomain(),debug=[])
if not cl.connect((JABBER_SERVER,JABBER_PORT )):
    raise IOError('Can not connect to server.')
if not cl.auth(jid.getNode(),JABBER_PASS):
    raise IOError('Can not auth with server.')

cl.send( xmpp.Message( TO_JABBER_ID ,"Hello World again" ) )
cl.disconnect()

Kemudian run
python test.py

selesai

Powered by ScribeFire.

python, jabber, xmpp, sending message

Sending Email with attachment using Python

nyari di google akhirnya nemu ini ... ternyata simple juga buat attach email pake python ... library -nya juga standar.. ga perlu install lagi.. source aslinya liat disini

#!/usr/bin/python

import smtplib
from email.MIMEMultipart import MIMEMultipart
from email.MIMEBase import MIMEBase
from email.MIMEText import MIMEText
from email import Encoders
import os

gmail_user = "gmail.account@gmail.com"
gmail_pwd = "gmail_password"

def mail(to, subject, text, attach):
   msg = MIMEMultipart()

   msg['From'] = gmail_user
   msg['To'] = to
   msg['Subject'] = subject

   msg.attach(MIMEText(text))

   part = MIMEBase('application', 'octet-stream')
   part.set_payload(open(attach, 'rb').read())
   Encoders.encode_base64(part)
   part.add_header('Content-Disposition',
           'attachment; filename="%s"' % os.path.basename(attach))
   msg.attach(part)

   mailServer = smtplib.SMTP("smtp.gmail.com", 587)
   mailServer.ehlo()
   mailServer.starttls()
   mailServer.ehlo()
   mailServer.login(gmail_user, gmail_pwd)
   mailServer.sendmail(gmail_user, to, msg.as_string())
   # Should be mailServer.quit(), but that crashes...
   mailServer.close()

mail("destination@somewhere.outhere",
   "Hello from python!",
   "This is a email sent with python",
   "filename_attachment")

Powered by ScribeFire.

export Query dari SQL server ke CSV via Python+pymssql

Ternyata export import data lebih mudah di linux dibanding Windows, beberapa hari ini nyari caranya ternyata sangat mudah via Linux...
Pertama install dulu python dan pymssql

sudo apt-get install python2.5 python-pymssql python-csv

test dulu diterminal seperti ini

python
>>>import pymssql ,csv
>>>

kalau tidak ada error berarti packagenya sudah terinstall dengan baik.. selanjutnya ngoding, buat file test.py
##############
# test.py          #
##############
import pymssql , csv
conn = pymssql.connect(host='IP SQL server' , user='sa', password='password sa', database='nama databasenya') # connection to database
cur = conn.cursor() # set cursor
writer = csv.writer(open('export.csv','wb')) # Declaration for CSV file and CSV Object
cur.execute( 'select * from table1 ') # Execute query
row = cur.fetchall(row) # Retrieve result in tuple object
writer.writerows(row) # Write row Object into csv file
conn.close # close database connection

Selesai.. mantab kan ... cuman < 10 baris doank ... hehehehehehe

pymssql, python, export csv, sql server

Powered by ScribeFire.