RSS category feeds

RSS site feeds

More

Home
Clear one contact history in Skype 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 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 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

Comments

  • Incase someone is looking at this today: I had the same problem, because I tried... More...
  • Hi, I am new to python and I did try above example but not able to play music fi... More...
  • not work error import lib win32ras can you help me for this error More...
  • What difference does this have with the SendKeys method from the "WScript.WShell... More...
  • Here is variant with win32con for buttons and icons: import ctypes from win32con... 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.