There are two ways you can achieve it.
1.
cursor.execute(“PRAGMA table_info(tablename)”)
print cursor.fetchall()
2.
sql = sqlite3.connect(self.cFile)
c = sql.cursor()
query = “select * from preferences”
c.execute(query)
col = [tuple[0] for tuple in c.description]
print col
Note:
cur.description returns a tuple of information about each table. The entire tuple is : (name, type_code, display_size, internal_size, precision, scale, null_ok)
Use the following link to install Google Chrome offline installer.
Q: What is the difference between installations using ALLUSERS=””, ALLUSERS=1 and ALLUSERS=2 option?
ANS:
i. MSIINSTALLPERUSER ="": Per-Machine installation.
ii. MSIINSTALLPERUSER =1: Per-User installation
Q: What are the ADDLOCAL and ADDSOURCE properties?
Ans:
It is the property which contains the list of features, delimited by commas (,), which are to be installed locally. These features must be present in the Feature column of the Feature Table.
It is the property which contains the list of features, delimited by commas (,), which are to be installed to run from the Source. These features must be present in the Feature column of the Feature Table.
Q: Explain the difference between Property and PROPERTY
ANS:
Public properties can be changed anytime by a user, system or admin on the command line while installing, by applying a transform or by interacting with the authored user interface (Installation Interface)
They are always in upper case
The installer uses then internally and their values are initialized in the installation database (msi) or set by the values determined by the OS.
They are always in lower case.
Few issues or blocks which I found with App-V are as follows:
import time
import wx
import wx.gizmos as gizmos
from datetime import datetime
from pytz import timezone
import pytz
utc = pytz.utc
class LED_clock(wx.Frame):
“”"
Create nice LED clock showing the current time
“”"
def __init__(self, parent, id):
pos = wx.DefaultPosition
wx.Frame.__init__(self, parent, id, title=’maya World Clock, Ver: 0.0.1′, pos=pos, size=(200, 70))
self.SetIcon(wx.Icon(r”clock.ico”, wx.BITMAP_TYPE_ICO))
size = wx.DefaultSize
style = gizmos.LED_ALIGN_CENTER
self.estLed = gizmos.LEDNumberCtrl(self, -1, pos, size, style)
self.m_stESTTime = wx.StaticText( self, wx.ID_ANY, u”EST Time”, wx.DefaultPosition, wx.DefaultSize, wx.ALIGN_CENTRE|wx.STATIC_BORDER )
self.m_stESTTime.SetBackgroundColour( wx.Colour( 255, 221, 187 ) )
bSizer4 = wx.BoxSizer( wx.HORIZONTAL )
bSizer5 = wx.BoxSizer( wx.VERTICAL )
bSizer5.Add(self.m_stESTTime, 0, wx.ALIGN_CENTER|wx.ALIGN_CENTER_VERTICAL|wx.ALL|wx.EXPAND, 0 )
bSizer5.Add(self.estLed, 1, wx.EXPAND, 5 )
bSizer4.Add(bSizer5, 1, wx.EXPAND, 5 )
self.m_stIndiaTime = wx.StaticText( self, wx.ID_ANY, u”IST Time”, wx.DefaultPosition, wx.DefaultSize, wx.ALIGN_CENTRE|wx.STATIC_BORDER )
self.m_stIndiaTime.SetBackgroundColour( wx.Colour( 255, 221, 187 ) )
self.indiaLed = gizmos.LEDNumberCtrl(self, -1, pos, size, style)
bSizer1 = wx.BoxSizer( wx.VERTICAL )
bSizer1.Add(self.m_stIndiaTime , 0, wx.EXPAND|wx.ALIGN_CENTER|wx.ALIGN_CENTRE_HORIZONTAL, 5 )
bSizer1.Add(self.indiaLed, 1, wx.EXPAND, 5 )
bSizer4.Add(bSizer1, 1, wx.EXPAND, 5 )
self.SetSizer( bSizer4 )
self.Layout()
self.OnTimer(None)
self.timer = wx.Timer(self, -1)
self.timer.Start(1000)
self.Bind(wx.EVT_TIMER, self.OnTimer)
self.Centre()
def GetIndiaTime(self):
fmt = ‘%H %M %S’
india = timezone(’Asia/Kolkata’) #(’Asia/Kolkata’)
eastern = timezone(’US/Eastern’)
loc_dt = eastern.localize(datetime.now())
in_dt = loc_dt.astimezone(india)
return (in_dt.strftime(fmt))
def OnTimer(self, event):
current = time.localtime(time.time())
ts = time.strftime(”%H %M %S”, current)
self.estLed.SetValue(ts)
tst = self.GetIndiaTime()
self.indiaLed.SetValue(tst)
if __name__ == ‘__main__’:
app = wx.App()
frame = LED_clock(None, -1)
frame.Show(True)
app.SetTopWindow(frame)
app.MainLoop()
“NetLibrary now available thru Atlanta Fulton County Public Library
Free Stories from Thriller / Brilliance Audio podcasts
Complete Podiobook (Podcast audiobook) directory
Project Gutenberg’s Audiobooks
Miette’s Bedtime Story Podcast
LearnOutLoud Free Audio/Video Directory
set the http_proxy system variable as
set http_proxy=http://proxy.mj.com:8080
instead of
set http_proxy=proxy.mj.com:8080
QEMU-IMG can be used to convert virtualbox vdi file to vmware vmdk file
qemu-img.exe convert -O vmdk virtualbox.vdi vmware.vmdk
This is my wx.Calender demo in wx.python
########################################################################### # -*- coding: ISO-8859-1 -*- ## This program is free software: you can redistribute it and/or modify ## it under the terms of the GNU General Public License as published by ## the Free Software Foundation, either version 3 of the License, or ## (at your option) any later version. ## This program is distributed in the hope that it will be useful, ## but WITHOUT ANY WARRANTY; without even the implied warranty of ## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ## GNU General Public License for more details. ## You should have received a copy of the GNU General Public License ## along with this program. If not, see <http://www.gnu.org/licenses>. __author__ = "Mayank Johri" __copyright__ = "2009" __version__ = "0.0.1" __date__ = "Oct 13 2009" __license__ = "GNU 3 or latest." ########################################################################### import re import datetime import calendar import wx import string import wx.calendar as cal import sys import os APPDIR = sys.path[0] TBMENU_RESTORE = wx.NewId() TBMENU_CLOSE = wx.NewId() year = ['January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'] def thismonth(): """ Presently not using""" calendar.setfirstweekday(0) today = datetime.datetime.date(datetime.datetime.now()) current = re.split('-', str(today)) current_no = int(current[1]) current_month = year[current_no-1] current_day = int(re.sub('\A0', '', current[2])) current_yr = int(current[0]) myCal = '%s %s' %(current_month, current_yr) myCal = myCal + '\n' + "M T W Th F Sa Su" + '\n' month = calendar.monthcalendar(current_yr, current_no) nweeks = len(month) for w in range(0,nweeks): week = month[w] for x in xrange(0,7): day = week[x] if x == 5 or x == 6: classtype = 'weekend' else: classtype = 'day' if day == 0: classtype = 'X' myCal = myCal + str(classtype).ljust(3) elif day == current_day: myCal = myCal + str(day).ljust(3) else: myCal = myCal + str(day).ljust(3) myCal = myCal + '\n' return (myCal) class MyTaskBarIcon(wx.TaskBarIcon): def __init__(self, frame): wx.TaskBarIcon.__init__(self) self.frame = frame icon = wx.Icon(os.path.join(APPDIR, 'clock.ico'), wx.BITMAP_TYPE_ICO) self.SetIcon(icon) self.Bind(wx.EVT_TASKBAR_LEFT_DCLICK, self.OnTaskBarRightClick) self.Bind(wx.EVT_MENU, self.OnTaskBarActivate, id=1) self.Bind(wx.EVT_MENU, self.OnTaskBarClose, id=2) def OnTaskBarRightClick(self, event): if not self.frame.IsShown(): self.frame.Show() else: self.frame.Hide() def CreatePopupMenu(self): menu = wx.Menu() menu.Append(1, 'Show/Hide') menu.Append(2, 'Close') return menu def OnTaskBarClose(self, event): self.Destroy() self.frame.Destroy() def OnTaskBarActivate(self, event): if not self.frame.IsShown(): self.frame.Show() else: self.frame.Hide() def OnTaskBarDeactivate(self, event): if self.frame.IsShown(): self.frame.Hide() class MayaCalendar(wx.Dialog): def __init__(self, parent, id, title): wx.Dialog.__init__(self, parent, title="Maya Calender, Ver: 0.0.1") vbox = wx.BoxSizer(wx.VERTICAL) calend = cal.CalendarCtrl(self, -1, wx.DateTime_Now(), style = cal.CAL_SHOW_HOLIDAYS|cal.CAL_SEQUENTIAL_MONTH_SELECTION) vbox.Add(calend, 0, wx.EXPAND | wx.ALL, 20) self.Bind(cal.EVT_CALENDAR, self.OnCalSelected, id=calend.GetId()) self.SetSizerAndFit(vbox) self.Show(True) self.tskic = MyTaskBarIcon(self) self.Centre() def OnCalSelected(self, event): date = event.GetDate() dt = string.split(str(date), ' ') s = ' '.join([str(s) for s in dt]) self.text.SetLabel(s) class MyApp(wx.App): def OnInit(self): frame = MayaCalendar(None, -1, 'Maya Calender, Ver: 0.0.1') frame.Show(True) self.SetTopWindow(frame) return True app = MyApp(0) app.MainLoop()
Below is the demo code for wx.TaskBarIcon,
import wx
class sysTrayDemo(wx.Frame):
def __init__(self, parent, id, title):
pass
wx.Frame.__init__(self, parent, -1, title, size = (800, 600),
style=wx.DEFAULT_FRAME_STYLE|wx.NO_FULL_REPAINT_ON_RESIZE)
# FIXME: substitute your icon file here.
icon = wx.Icon('systray.ico', wx.BITMAP_TYPE_ICO)
self.SetIcon(icon)
if wx.Platform == '__WXMSW__':
# setup a taskbar icon, and catch some events from it
self.tbicon = wx.TaskBarIcon()
self.tbicon.SetIcon(icon, "SysTray Demo")
wx.EVT_TASKBAR_LEFT_DCLICK(self.tbicon, self.OnTaskBarActivate)
wx.EVT_TASKBAR_RIGHT_UP(self.tbicon, self.OnTaskBarMenu)
wx.EVT_MENU(self.tbicon, self.TBMENU_RESTORE, self.OnTaskBarActivate)
wx.EVT_MENU(self.tbicon, self.TBMENU_CLOSE, self.OnTaskBarClose)
wx.EVT_ICONIZE(self, self.OnIconify)
return
def OnIconify(self, evt):
self.Hide()
return
def OnTaskBarActivate(self, evt):
if self.IsIconized():
self.Iconize(False)
if not self.IsShown():
self.Show(True)
self.Raise()
return
def OnCloseWindow(self, event):
if hasattr(self, "tbicon"):
del self.tbicon
self.Destroy()
TBMENU_RESTORE = 1000
TBMENU_CLOSE = 1001
def OnTaskBarMenu(self, evt):
menu = wx.Menu()
menu.Append(self.TBMENU_RESTORE, "Restore SysTray Demo")
menu.Append(self.TBMENU_CLOSE, "Close")
self.tbicon.PopupMenu(menu)
menu.Destroy()
#---------------------------------------------
def OnTaskBarClose(self, evt):
self.Close()
# because of the way wx.TaskBarIcon.PopupMenu is implemented we have to
# prod the main idle handler a bit to get the window to actually close
wx.GetApp().ProcessIdle()
class MyApp(wx.App):
def OnInit(self):
self.redirect=True
frame = sysTrayDemo(None, -1, "SysTray Demo")
frame.Show(True)
return True
def main():
app = MyApp()
app.MainLoop()
if __name__ == '__main__':
main()
Add the “%appdata%\Microsoft\MS project\” to exclusion list to avoid error while streaming
def fm_bDeleteServerDetails(self, event): lst = self.m_gdServerDetails.GetNumberRows() selected = [] for r in range(lst): if self.m_gdServerDetails.IsInSelection(r, 0) == True: selected.append(r) selected.reverse() for r in selected: self.m_gdServerDetails.DeleteRows(r,1)
import os
import sys
import win32process
import win32api
import subprocess
import win32con
def setpriority(pid=None,priority=1):
priorityclasses = [win32process.IDLE_PRIORITY_CLASS,
win32process.BELOW_NORMAL_PRIORITY_CLASS,
win32process.NORMAL_PRIORITY_CLASS,
win32process.ABOVE_NORMAL_PRIORITY_CLASS,
win32process.HIGH_PRIORITY_CLASS,
win32process.REALTIME_PRIORITY_CLASS]
if pid == None:
pid = win32api.GetCurrentProcessId()
handle = win32api.OpenProcess(win32con.PROCESS_ALL_ACCESS, True, pid)
win32process.SetPriorityClass(handle, priorityclasses[priority])
if (len(sys.argv) == 0):
print("usage: processtame.exe ")
else:
if (os.path.exists(sys.argv[1])):
app = subprocess.Popen(sys.argv[1])
pid = app.pid
setpriority(pid, 0)
app.wait()
users: dsquery user -name “username”
Computers: dsquery computer -name “computername”
 | Serrano Pereira on recursive list files in a dir … |
 | Andriyadi on TIPS: OpenOffice->Impress: … |
 | Manoj on QA: MSI Interview: What is the… |
 | Mayank Johri on MSI Interview Questions |
 | aneeth on MSI Interview Questions |
