RSS category feeds

RSS site feeds

More

Home
Clear one contact history in Skype PDF Print E-mail
The Python/Pywin32 Script collection - Other

This simple script enables you to delete one contact history from your Skype local database.

Let's say your contact display name in Skype is 'Roger G'.

I'm using vacuum statement to compact database, I believe it's more secure that way.

 
import sqlite3
 
conn = sqlite3.connect('C:\\Users\\your_user_name\\AppData\\Roaming\\Skype\\skype_account_name\\main.db')
c = conn.cursor()
 
c.execute("SELECT DISTINCT convo_id FROM Messages WHERE from_dispname = 'Roger G';")
result = c.fetchone()
if result is not None:
    convo_id = int(result[0])
    c.execute("DELETE FROM Messages where convo_id = {}".format(convo_id))
    deleted = int(conn.total_changes)
    print("Deleted: {}".format(deleted))
    c.execute("VACUUM;")
    print("Vacuumed...")
conn.close()
print("Finished")
Last Updated ( Friday, 06 December 2013 )
 
Show the path of all Explorer Windows PDF Print E-mail
The Python/Pywin32 Script collection - Microsoft Windows

This piece of Python code shows the current path of all opened Explorer Windows

 
from win32com.client.gencache import EnsureDispatch
 
for w in EnsureDispatch("Shell.Application").Windows():
    print w.LocationName + "=" + w.LocationURL
Last Updated ( Wednesday, 30 January 2013 )
 
Simple VBA like MessageBox in Python PDF Print E-mail
Newsflash - Newsflash

Image

Some days ago I found a very easy pythonic way to show a VBA-like MessageBox. It was created with only one line of cpython code.

The code is very very easy. Simply change the last integer parameter to change the style of the message box.

 
import ctypes
 
msgbox = ctypes.windll.user32.MessageBoxA
ret = msgbox(None, 'Press OK to end the demo.', 'Deviare Python Demo', 0)
print ret
Last Updated ( Friday, 25 April 2014 )
 
<< Start < Prev 1 2 3 4 5 6 Next > End >>

Results 1 - 8 of 44

Feedback

Advertisement

Comments

  • I want to extract all the task information, durations, start date and end date o... More...
  • This code works very well for printing MS word file to prn. If I want print with... More...
  • Hello Roberto, that`s possible. Perhaps you should use the Pywin32 module or com... More...
  • Hi, I'm trying to connect CATIA with my svn server. Indeed I'm trying to make a ... More...
  • I have read your article very useful information for python class.This course is... More...

Login Form






Lost Password?

My prefered Python IDE

My prefered Python editor is Pyscripter from MMExperts. It is not only an editor. Pyscripter is a full Python IDE including (remote) debugging, a class browser, and all other nice helpers which a full featured IDE needs.

Do you have a script for me ?

Do you have an interesting Python script which does some really cool thing on Windows ? Please post them to this site. It`s very simple - simply copy&paste it to this form. No login is requiered.

Hint: For syntax highlighting and correct Python intendation place your code between html tags <pre> and </pre>.

My prefered web framework

My prefered web framework for developing web applications is Django. Django calls itself The web framework for perfectionists with deadlines. It is a really fast, scalable and (thanks Python) the sexiest web framework of the world.