def _getFriends():
 path = os.path.expanduser((('~/Library/Application Support/Skype/' + getUserName()) + '/main.db'))
 with contextlib.closing(sqlite3.connect(path).cursor()) as db:
  db.execute('SELECT skypename,fullname,displayname FROM Contacts WHERE type=1 AND is_permanent=1')
  return db.fetchall()

def _getFriends ( ) : path = os . path . expanduser ( ( ( '~/Library/Application Support/Skype/' + getUserName ( ) ) + '/main.db' ) ) with contextlib . closing ( sqlite3 . connect ( path ) . cursor ( ) ) as db : db . execute ( 'SELECT skypename,fullname,displayname FROM Contacts WHERE type=1 AND is_permanent=1' ) return db . fetchall ( )
get friends from skype database :return: list of tuples of friends .