Python/learning/Commence_com.py

## Commence COM Testing
## Some simple code testing the commence COM layer.
## EBorges
## 11.26.03

from win32com.client import Dispatch

#Initiate the object
commenceObj = Dispatch("Commence.DB")


#General DB info
print commenceObj.Name
print commenceObj.Path
print commenceObj.Version
print commenceObj.VersionExt


#Actuall DB contents
#This one is for a view.  You would put a 0 first if you wanted to query a catagory. i.e. the "Person" catagory.
contacts = c.GetCursor(1,'MWBB Labor Team',0)
#Number of records
contacts.RowCount
#get field info.  This one returns the second listing in the roledex
test = contacts.GetQueryRowSet(1,0)
test.GetRow(0,"/n",0)

# This section is for catagory
#Get a Cursor with all the info  (if you wanted to filter it you would use .SetFilter after getting the Cursor
todo = commenceObj.GetCursor(0,"To-Do",0)
#get a row count
items = todo.RowCount
#This grabs a row set.  One row in the database(Cursor)
test = todo.GetQueryRowSet(1,0) #you dont need to increment the first number to go to the next one. You should do a RowCount and just put this exact thing in a for range(RowCount)
#get the label (One of many methods once you have a RowSet
test2 = test.GetColumnLabel(1,1)#increment the first number to see all the other ones. you can also do a .ColumnCount
#get the row value after you figure out the label of the row.
test2 = test.GetRowValue(0,12,0) #the middle number is the column


#Some test code
>>> todo = commenceObj.GetCursor(0,"To-Do",0)
>>> list = []
>>> for row in range(todo.RowCount):
...     currentRow = todo.GetQueryRowSet(1,0)
...     list.append(currentRow.GetRowValue(0,0,0))
... 

Revision:	591
Committed:	Tue Nov 3 22:45:12 2015 UTC (10 years, 4 months ago) by nino.borges
Content type:	text/x-python
File size:	1684 byte(s)
Log Message:	Moved dir out of main dir.
#	Content
1	## Commence COM Testing
2	## Some simple code testing the commence COM layer.
3	## EBorges
4	## 11.26.03
5
6	from win32com.client import Dispatch
7
8	#Initiate the object
9	commenceObj = Dispatch("Commence.DB")
10
11
12
13	#General DB info
14	print commenceObj.Name
15	print commenceObj.Path
16	print commenceObj.Version
17	print commenceObj.VersionExt
18
19
20	#Actuall DB contents
21	#This one is for a view. You would put a 0 first if you wanted to query a catagory. i.e. the "Person" catagory.
22	contacts = c.GetCursor(1,'MWBB Labor Team',0)
23	#Number of records
24	contacts.RowCount
25	#get field info. This one returns the second listing in the roledex
26	test = contacts.GetQueryRowSet(1,0)
27	test.GetRow(0,"/n",0)
28
29	# This section is for catagory
30	#Get a Cursor with all the info (if you wanted to filter it you would use .SetFilter after getting the Cursor
31	todo = commenceObj.GetCursor(0,"To-Do",0)
32	#get a row count
33	items = todo.RowCount
34	#This grabs a row set. One row in the database(Cursor)
35	test = todo.GetQueryRowSet(1,0) #you dont need to increment the first number to go to the next one. You should do a RowCount and just put this exact thing in a for range(RowCount)
36	#get the label (One of many methods once you have a RowSet
37	test2 = test.GetColumnLabel(1,1)#increment the first number to see all the other ones. you can also do a .ColumnCount
38	#get the row value after you figure out the label of the row.
39	test2 = test.GetRowValue(0,12,0) #the middle number is the column
40
41
42	#Some test code
43	>>> todo = commenceObj.GetCursor(0,"To-Do",0)
44	>>> list = []
45	>>> for row in range(todo.RowCount):
46	... currentRow = todo.GetQueryRowSet(1,0)
47	... list.append(currentRow.GetRowValue(0,0,0))
48	...
49