-
Notifications
You must be signed in to change notification settings - Fork 801
/
CHANGES.txt
1170 lines (916 loc) · 49.5 KB
/
CHANGES.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
A changelog for recent builds:
Generally created by hand after running:
git log -rb3xx:
However contributors are encouraged to add their own entries for their work.
Note that build 228 was the last version supporting Python 2.
Since build 303:
----------------
* Fixed Unicode issues in the `dde` module (#1861, @markuskimius )
* Add `PRINTER_INFO_6` support for Set/GetPrinter (#1853, @CristiFati)
* Fixed codepage/mojibake issues when non-ascii characters were included in
COM exceptions raised by Python apps. This should be invisible, but might
break any workarounds which were used, such as using specific encodings in
these strings. (#1823, #1833)
* Fixed a bug triggering `win32print.SetJob` to fail due to data type
(`char*` / `wchar_t*`) mismatch (#1849, @CristiFati)
* Fix eventlog initialization (#1845, #1846, @kxrob)
Since build 302:
----------------
* Tweaks to how DLLs are loaded and our installation found, which should
improve virtualenv support and version mismatch issues (#1787, #1794)
* Fixed a bug where `win32clipboard.GetClipboardData()` may have returned extra
data.
* Binary installers for 32-bit 3.10+ are no longer released (#1805)
Since build 301:
----------------
* Fixed support for unicode as a `win32crypt.CREDENTIAL_ATTRIBUTE.Value`
* Support for Python 10, dropped support for Python 3.5 (3.5 security support
ended 13 Sep 2020)
* Merged win2kras into win32ras. In the unlikely case that anyone is still
using win2kras, there is a win2kras.py that imports all of win32ras. If you
import win2kras and it fails with 'you must import win32ras first', then it
means an old win2kras.pyd exists, which you should remove.
* github branch 'master' was renamed to 'main'.
Since build 300:
----------------
* Fix some confusion on how dynamic COM object properties work. The old
code was confused, so there's a chance there will be some subtle
regression here - please open a bug if you find anything, but this
should fix #1427.
* COM objects are now registered with the full path to pythoncomXX.dll, fixes
#1704.
* Creating a `win32crypt.CRYPT_ATTRIBUTE` object now correctly sets `cbData`.
* Add wrap and unwrap operations defined in the GSSAPI to the sspi module
and enhance the examples given in this module.
(#1692, Emmanuel Coirier)
* Fix a bug in `win32profile.GetEnvironmentStrings()` relating to environment
variables with an equals sign (@maxim-krikun in #1661)
* Fixed a bug where certain COM dates would fail to be converted to a Python
datetime object with `ValueError: microsecond must be in 0..999999`. Shoutout
to @hujiaxing for reporting and helping reproduce the issue (#1655)
* Added win32com.shell.SHGetKnownFolderPath() and related constants.
* CoClass objects should work better with special methods like __len__ etc.
(#1699)
* Shifted work in win32.lib.pywin32_bootstrap to Python's import system from
manual path manipulations (@wkschwartz in #1651)
* Fixed a bug where win32print.DeviceCapabilities would return strings
containing the null character followed by junk characters.
(#1654, #1660, Lincoln Puzey)
Since build 228:
----------------
* Fixed a bug where win32com.client.VARIANT params were returned in the reverse
order. This only happened when win32com.client.VARIANT was explicitly used
(ie, not when normal params were passed) For example:
```python
arg1 = VARIANT(pythoncom.VT_R4 | pythoncom.VT_BYREF, 2.0)
arg2 = VARIANT(pythoncom.VT_BOOL | pythoncom.VT_BYREF, True)
object.SomeFunction(arg1, arg2)
```
after this call, `arg1.value` was actually the value for `arg2`, and
vice-versa (#1303, #622).
* Fixed a bug that Pythonwin had an empty `sys.argv` (@kxrob in #1607)
* Fixed a bug that prevented win32process.ReadProcessMemory() from working
in all scenarios (#1599)
* Changed how Services implemented with win32serviceutil.ServiceFramework
report that they have stopped. Now if the SvcRun() method (or the SvcDoRun()
method, which is called by SvcRun() by default) raises on Exception,
the Service will report a final SERVICE_STOPPED status with a non-zero error
code. This will cause the Service's recovery actions to be triggered if the
Service has the "Enable actions for stops with errors" option enabled.
(#1563, Lincoln Puzey)
* adodbapi connect() method now accepts a "mode" keyword argument which is the
"Mode" property to set on the ADO "Connection" object before opening the
Connection. See "ConnectModeEnum" for valid values.
(Lincoln Puzey)
* The Windows 10 SDK is now used to build the project. This shouldn't cause any
visible changes, but should make it much easier to build the project yourself.
Python 2 is no longer supported - so long, Python 2, you served us well!
Notable changes in this transition:
* Python 3 builds used to erroneously turn "bytes" into a tuple of integers
instead of a buffer type object. Because this special-casing is important for
performance when using massive buffers, this has been fixed in Python 3 so
it matches the old Python 2 behavior. If you use arrays of VT_UI1 and expect
get back tuples of integers, your code may break.
* Pythonwin's default encoding is now utf-8 (#1559)
* The build environment has been greatly simplified - you just need Visual
Studio and a Windows 10 SDK. (The free compilers probably work too, but
haven't been tested - let me know your experiences!)
Since build 227:
----------------
* Support for for win32evtlog.EvtFormatMessage and EvtCreateRenderContext
(#1308)
* Support more elements in the SECURITY_LOGON_SESSION_DATA struct
returned by win32security.LsaGetLogonSession (#1515)
* Remove trailing \0 char from win32file.FindFileNames results (#1511)
* Added win32process.ReadProcessMemory/WriteProcessMemory (#1502)
* Added win32process.VirtualAllocEx/VirtualFreeEx (#1509)
* Added win32gui.ValidateRect (#1504)
* Adodbapi corrected and updated to version 2.6.2. With this change the pywin32
repo will become the definitive source code for adodbapi, so files should never
be missing again. Includes bug fix for 'named' paramstyle SF#28.
* Added a __repr__ implementation for PySecBufferDesc and PySecBuffer.
* Fix bug when trying to free a PySecBuffer object when the buffer was not
allocated by the caller. This can occur when decrypting a message with a
SECBUFFER_STREAM and SECBUFFER_DATA buffer when calling DecryptMessage().
Since build 226:
----------------
* Improved the search for pywin32 system DLLs logic. Useful when installed
in virtual environments (#1442, @CristiFati)
* Added MAPI IMsgServiceAdmin2 interface (Nick Czeczulin, #1411)
Since build 225:
----------------
* The directory with the pywin32 system DLLs is now added to the start of PATH
for version 3.7 and earlier, and passed to os.add_dll_directory() on 3.8 and
later. This will hopefully work around problems loading pywintypes.dll in
various situations.
* Conversions to and from COM VT_DATE types should no longer lose milliseconds.
* Formatting eventlog messages should now handle larger messages and inserts
(Ofek Lev via #1421)
* Fixed that win32help was very broken everywhere except 32bit 2.7 (#1434)
* A number of MAPI improvements from Nick Czeczulin.
Since build 224:
----------------
* Huge shout-out to @thopiekar for helping with github triage, getting CI
working and sane, and other general help and patches!
* Significant work by @joankaradimov in porting pywin32 so that it works in a
MingGW/msys2 environment.
* ntsecuritycon.FILE_ALL_ACCESS had an incorrect value (#1354)
* SetSecurityDescriptorGroup now accepts None as group value (#1382)
* Fix an issue where win32gui.EnumChildWindows may throw a spurious exception.
(#1350)
* Better support for numpy objects in COM methods (#1388, @panikc and
@SReicheltPTV)
* PythonWin is now able to start with non-English active keyboard layout.
* Corrected wMilliseconds truncation in PyTime::getattro (Dorian Bivolaru)
* Implement PdhGetFormattedCounterArray (#1306, konserw)
Since build 223:
----------------
* Built with a released version of Python 3.7, which fixes various date related
issues with Python 3.7
* Fix a regression introduced in build 220 around how some COM properties are
handled (#1211 and #1199)
* Everything is now build with the Windows 8.1 SDK. While this should typically
be invisible, it is mentioned because it might explain obscure issues that
creep in, so it should be explicitly called out as a change.
On the plus side, this makes building the extensions far simpler.
* win32serviceutil - in GetServiceClassString, skip rewrite of file name (fname)
when win32api.FindFiles returns an empty list, e.g., if the service has been
packaged in a zip or exe. (fixes issue #642)
Since build 222:
----------------
* pywin32.pth now arranges for the pywin32_system32 directory to be on
PATH to help with pypi installations (thanks to @xovian via #1153)
Since build 221:
----------------
* !! Moved to github for development !!. https://github.com/mhammond/pywin32
is the new home of pywin32 and all builds will be released there.
The build process now also builds "wheels", so "pip install pywin32" should
also work (but see README.md for some limitiations of using pip)
Particular thanks to @xoviat, who helped with prompting me to make the
change, imported all the issues from sourceforge, and helped with the
process for creating the wheels.
As a part of this, I've changed every issue in this file from "#xxx" to
"#sfxxx" to indicate they refer to the old sourceforge issue numbers.
* Older Python versions are no longer supported - builds are only made
available for Python 2.7 and Python 3.5+.
* For Python 3.x, a win32 FILETIME or TimeStamp which is greater than the
datetime module can handle will return datetime.datetime.max instead of
throwing (fixes issue #748)
* win32file - fix ERROR_BAD_LENGTH in GetFileInformationByHandleEx
in x86 builds(issue #752, rbschk)
* MakeModuleForTypelib no longer catches COM exceptions, so no longer can
return None. This is what the docstring always claimed the behaviour was
and makes things less error prone. If you explicitly call this function and
handle None, you will need to wrap the call in an exception handler.
* Change PyIMAPIFolder CopyMessages, DeleteMessages, and EmptyFolder to return
the HRESULT (Nick Czeczulin via patch #sf162)
* Fix a reference leak of Py_None in a couple of MAPI methods (Nick Czeczulin
via patch #sf149)
Since build 220:
----------------
* Add PyIMapiSession::AdminServices method (Nick Czeczulin via patch #sf161)
* Allow win32com.client.CastTo() to have a typelib specified, which will be
used to locate the object definition (Pieter Aarnoutse via patch #sf136)
* Add pythoncom.StgOpenStorageOnILockBytes (Nick Czeczulin via patch #sf135)
* IDispatch failures will try and get error information via IErrorInfo (Stefan
Schukat via patch #sf130)
* A null SPropTagArray will now return None instead of crashing.
* New mapi/exchange interfaces PyIExchangeManageStoreEx, PyIMAPIAdviseSink,
PyIMsgStore::Advise, PyIMsgStore::Unadvise, HrAllocAdviseSink,
HrThisThreadAdviseSink, and HrDispatchNotifications (Nick Czeczulin)
Since build 219:
----------------
* win32com - sys.argv[0] may be set to a bytes object instead of a string on
Python 3 when implementing an in-process COM object.
* Fix that allows a property to be fetched on COM objects to work in more cases
(Fredrik Orderud via patch #sf155)
* Disabled exchange and exchdapi modules on Python 2.5 due to unresolved
build issues.
* Fix potential crash in SHGetIDListFromObject and SHGetFileInfo issues (rupole)
* Allow GetShortPathName to handle long paths in unicode mode (ruple)
* Fix intermittent crash in win32cred.CredRead() (bug #sf670, rupole)
* Support PT_MV_BINARY MAPI properties, (patch #sf37) and many other MAPI
improvements (Nick Czeczulin)
* Fix username used with EvtOpenSession (bug #sf688, rupole)
* Fix OutputDebugString encoding in wide builds (patch #sf142, rupole)
Since build 218:
----------------
* win32com.mapi
Addded outlook interface IConverterSession with methods MIMEToMAPI, MAPIToMIMEStm, and SetAdrBook
Added method OpenStreamOnFile (Nick Czeczulin)
Ignore PT_MV_TSTRING along with PT_TSTRING (Nick Czeczulin)
Bugfix to support PT_MV_BINARY properties (Nick Czeczulin via patch #sf37)
* Conversions from a Python object to a variant now does a better job at
deciding what variant type to use, taking into account the size and sign of
the value (Stefan Schukat via patch #sf127)
* Add support for VT_I8 and VT_UI8 when converting a variant into a Python
object (Stefan Schukat via patch #sf128)
* win32com.mapi.exchange
Added 64-bit support by excluding the 32-bit Ex2kSdk.lib functions from 64-bit builds.
Unfortunately, this means that only IExchangeManageStore::CreateStoreEntryID
is currently available in a 64-bit build. (Nick Czeczulin)
* adodbapi updated to version 2.6 -- new examples folder includes short programs for
reading and writing .xls spreadsheets and reading ACCESS .mdb files using SQL.
New functions .is64bit.Python() and .is64bit.os() to help pick the correct drivers.
New function .schema_table.names() returns a list of all tables in a database.
Ability for a Windows computer to be a database proxy for a remote (Linux or Windows) unit.
see adodbapi/README.txt for more information.
* Fix issue implementing COM objects from within a virtualenv (Kevin Smyth
via issue #3597965)
* Fix some issues using decimal objects with Python 3.3 and later (rupole)
* Add a counterpart to VB's Nothing, from patch 3609027 by Stefan Schukat
* win32api
Handle REG_QWORD (64-bit ints) (rupole)
Add GetEnvironmentVariableW and SetEnvironmentVariableW (rupole)
Fix function pointer check for win32api.GetNativeSystemInfo (bug#sf665)
* win32com.shell
Add interfaces IFileOperation and IFileOperationProgressSink
Add SHParseDisplayName (feature req #3585998) (rupole)
* win32com.propsys
Add interfaces IPropertyChange, IPropertyChangeArray, and IObjectWithPropertyKey
Add functions PSCreateSimplePropertyChange, PSCreatePropertyChangeArray, and SHSetDefaultProperties
* win32crypt
Add functions and objects for handling certificates and certificate stores
* win32gui
Add RegisterHotKey (rupole)
* win32evtlog
Add several more Evt* functions (Vista+ event log API)
* win32prociess
Add EnumProcessModulesEx (feature request 3608155) (rupole)
* pythonwin
Fix a hang using the tools menu
Since build 217:
----------------
* mapiutil.py GetPropTagName has been modified to return the fully qualified
PT_UNICODE and PT_STRING8 type name. Added optional argument to override
rawType default in GetMapiTypeName. (Nick Czeczulin)
* Fix the count of replaced terms in Pythonwin's search/replace (rupole).
* Fix obscure issues in the Pythonwin code browser and other uses of the
"hierlist" widget (rupole).
* Fix a crash using a COM "record" that holds an array (rupole).
* Fix error return in win32gui.GetClassName (rupole).
* Some misc fixed to win32timezone (Jason R. Coombs).
* Some fixes to win32com gencache for Python 3.x (Tim Golden)
* Fix ActiveScript exception hresults.
* RegQueryValueEx now return an empty list for blank REG_MULTI_SZ
(rupole via bug #3531456)
* Add win32pdh.AddEnglishCounter (rupole via feature request #3529527)
* Fix post_install script use of the registry (rupole via bug #3536122)
* Python 3.3 version is built with VS2010.
* win32com.shell - added function SHCreateStreamOnFileEx and
interfaces IShellItem2, IEnumShellItems, IApplicationDocumentLists,
IApplicationDestinations, ITaskbarList, IEnumObjects,
IKnownFolder, IKnownFolderManager, IObjectArray, IObjectCollection,
ICustomDestinationList, and IShellLibrary; enhance SHAddToRecentDocs.
* win32com.propsys - Many Property System interfaces and functions added
* pythoncom - added StgCreateStorageEx
* win32com.client -
Fix iteration of objects that don't declare an enumerator in their typelib
Validate syntax of constants written to makepy generated files
* win32file - Add GetFileInformationByHandleEx, ReOpenFile and OpenFileById,
SetFileInformationByHandle. SetFileTime() has an extra param to allow UTC
time to be specified.
* win32api - Allow UpdateResource to remove a resource
Since build 216:
----------------
* ISAPI extension works with Python 3.x
* Python service module will now have their directory added to the start
of sys.path rather than the end to avoid cryptic error messages if a
module of the same name is already on the path (rvolpe via #3194663)
* Various Pythonwin autocomplete enhancements (kxroberto via #3468282 and
Oliver Tengler via #3433953)
* The Pythonwin editor now remembers previous searches made in this session.
(patch #3468280 from kxroberto).
* The LOGFONT struct implementation (win32util) was extended to support the
full LOGFONT struct as published by Microsoft. This includes changes to
win32util.LogFontToDict and win32util.DictToLogFont. (Feature request
3433757 by Kris Hardy)
* Remove some duplicated menu code from pythonwin which should avoid
having py2exe pulling in most of the pythonwin framework in some cases
(patch 3433527 from kxroberto.)
* A new win32com.client.VARIANT object can be used for advanced control over
the parameter types passed to some COM methods. See the documentation in
win32com/HTML/variant.html (also included in the help file)
* The win32com.adsi and win32com.mapi packages have been upgraded to work on
Python 3.x and as a result, there is a slight risk that regressions to
these packages have been introduced in the Python 2.x versions. Please
file a bug if any problems are found.
* Pythonwin now warns, but allows you to continue, when saving a file with
an invalid encoding line (bug 3139486)
* Fix win32com.client.WithEvents on py3k (bug 3199843)
* When passing integers/unsigned integers to COM objects which did not fit
into 32bits, OverflowErrors were silently discarded and -1 was silently
passed. This has been fixed for signed integers (an OverflowError is now
raised) and unsigned integers now allow for values with the high-bit set to
be passed correctly.
* Fix win32com.client.WithEvents() on py3k.
* makepy may have generated syntax errors if 'helpstring' elements in typelibs
had strange quoting or slashes (bug 3199631)
* Fixed that in some cases win32file.GetOpenFileName and GetSaveFileName
could have returned trailing garbage after an embedded NULL character.
(bug 3277647)
* Some functions which accepted a DWORD did not accept long integers which
fit in 32bits with the most signficant bit set (eg, 0x80000000).
* Source-code management moved from CVS to Mercurual.
* win32com.shell - Added SHCreateShellItem and fixed some 64bit issues.
* win32evtlog - Added some of the new event log functions introduced in
Vista/Windows 7
* win32service - Added EnumServicesStatusEx, and support startup type
"delayed" for Python services
* win32net - Fix a problem with NetFileEnum on 64-bit (bug #3376041)
Since build 215:
----------------
* New loader module for COM objects to avoid some CRT manifest issues.
pythoncomloaderxx.dll will be copied to your System32 directory and used as
the entry-point for COM objects instead of pythoncomxx.dll. This DLL
is very small - includes a manifest referencing the C runtime library and
simply loads pythoncomxx.dll and deletes the COM object creation back to it.
You will need to re-register any COM objects you have to take advantage of
this.
* Performance Monitor and ISAPI DLLs now include a manifest to fix potential
CRT related issues using those features.
* Fix potential crash in ISAPI GetServerVariable functions.
* Fix printing on pythonwin on 3.x
* Pythonwin gets an option to set the background color of the selected text.
Since build 214:
----------------
* Update adodbapi to version 2.4,2 -- in this version,
1. The cursor has a new .query attribute. It returns the (possibly converted) query sent to ADO. [Thanks to William Dode.]
This may be useful for testing paramstyle 'format' and 'named' queries. .query is an extension borrowed from psycopg2.
2. Added .command and .parameters attributes, which are copies of the original command and parameters sent the the cursor.
3. Added tests using a PostgreSQL server. Tests are now run for ACCESS, MS SQL, MySQL and PostgreSQL.
4. Column name data access is now case insignificant (since PostgreSQL returns lower case column names).
so (if a row object 'r' contains a first column 'spam') r[0], r.Spam, r.spam and r['SPAM'] are all equivalent.
5. The connection has new attributes .dbms_name and .dbms_version to display the underlying database engine. (like mxODBC)
* Update adodbapi to version 2.4.0 -- in this version,
"fetchall()" and "fetchmany()" return an SQLrows object
...which emulates a sequence of SQLrow objects.
"fetchone()" or the cursor's "next()" method return an SQLrow object.
An SQLrow object emulates a tuple of data fields.
An SQLrow object also appears to have an attribute for each column of data.
therefore...
>>> import adodbapi
>>> myConnection = adodbapi.connection('someDSN')
>>> cur = myConnection.cursor()
>>> cur.execute("select name, rank, serialNumber from soldiers")
>>> row = cur.fetchone()
>>> assert row[0] == row['name']
>>> assert row[1] == row.rank
>>> rows = cur.fecthall()
>>> assert rows[4,'serialNumber'] == rows[4][2]
* Update adodbapi to version 2.3.0 -- this is includes major refactoring and
specifically adds features for django support, including the ability for the
programmer to change ado's SQL "paramstyle" at run time to select between
'qmark', 'format' and 'named' methods of passing SQL parameters.
** also, in response to user requests, adodbapi will now use client-side
cursors by default. This will make rowcount and stored procedure return
parameter values more readily available.
* Remove manifest for Python 2.6 and later binaries which should make things
work much better when the VS2008 redist components aren't installed.
* Fix problem causing ASP pages to fail when reloaded.
* mapiutil.py functions GetMapiTypeName and GetPropTagName have been modified
to better distinguish between PT_UNICODE and PT_STRING8 type names
during reverse lookups. (Nick Czeczulin)
* Fix encoding problem in makepy (Massa, Harald Armin)
* Pythonwin: trim leading and trailing whitespace in calltip text (kxroberto)
* Pythonwin: fix reload of package modules and support for 'pyw' and 'pyx'
extensions (kxroberto)
* Pythonwin: PYTHONSTARTUP is honoured, just like when using python.exe
(kxroberto)
* Pythonwin: Better support for international keyboards. (Bug 896502 and
help from kxroberto)
* New win32api functions GetKeyboardLayoutName, MapVirtualKey and ToAsciiEx
* Add win32file.WSAEnumNetworkEvents (Ziga Seilnacht via patch 3022832)
* Get vtable interfaces working on 64bit windows (Nikolay Igotti via patch
3002383)
* Pythonwin: if the interactive window is cleared, avoid the blue color and
large font on the new line (markt via patch 2813056)
* Fix Python reference leak when calling MAPI/Exchange functions which
take an SRowSet param.
* Fix Pythonwin's Edit/Replace dialog in Python 2.3 (bug 2962078)
* Fix a few axscript issues with py3k.
* Pythonwin now offers to create the file when attempting to open a file
that doesn't exist (ghazel via bug 1409321)
* Many functions in win32event would swallow exceptions due to things like
invalid handles etc (Ziga Seilnacht via issue 3136751)
Since build 213:
----------------
* pythoncom gets better support for 64bit integers, including in arrays.
* pythoncom may fail to import on Windows 2000 installs with a default IE
(Roger)
* Fix Pythonwin when backspacing over an extended character (from markt
(metolone), via bug 2618277)
* Fixed a regression which would cause an error if you compared a PyTime
object to any other type, including None
Since build 212:
----------------
* py3k work - see the notes in the main documentation index for details,
but this entailed a huge overhaul of almost all the pywin32 sources.
Many things have been modernized for the first time in over a decade,
and may new tests have been added. As a result, build 213 will not
be recommended for production work and should be treated as beta quality.
Huge thanks to:
- Roger Upole: for starting the py3k work, and without whom the py3k work
would literally not yet have started.
- Jason R. Coombs: for help porting win32timezone to py3k and for helping
with the new datetime object support.
- Vernon Cole: for help with porting adodbapi to py3k.
* win32eventlog.OpenEventLog and OpenBackupEventLog now return a PyHANDLE
object which auto-closes on destruction.
* pythoncom servers which implemented 'universal' vtable interfaces from a
typelib could cause Data Execution Protection (DEP) to be triggered if
enabled. This has been resolved and such servers now work correctly with
DEP enabled.
* Fixed memory leak in win32wnet.WNetEnumResource.
* Added win32wnet.WNetAddConnection3 allowing a HWND to be specified for
authentication.
* isapi:
* Refactored isapi.install primarily to support installing extensions into
the root of a site (Jason R. Coombs)
* New IIS6-only functionality HSE_REQ_EXEC_URL which avoids the need to use
a filter in most cases, including new demos for this.
* Other misc support functions (HSE_REQ_REPORT_UNHEALTHY,
HSE_REQ_GET_ANONYMOUS_TOKEN, etc)
* "Modernization" changes, instigated by py3k:
- Many older modules now accept unicode arguments where previously they
only accepted strings - notably, win32ui, win32wnet ...
- win32wnet: NCB and NETRESOURCE attributes are now types rather than
methods. NETRESOURCE string attributes may return None if the win32
structure has a NULL pointer (previously an empty string was returned)
* Added win32inet.WinHttpGetDefaultProxyConfiguration()
* Pythonwin updates from R�mi Paucher; enter completes auto-complete in
the editor and interactive windows, auto-complete should now work on French
keyboards. (XXX - some of this was reverted - update!)
* Lots of work to better support unicode, py3k and 64bits from Roger.
Most of these changes will be invisible, and those that are not
are detailed elsewhere.
* ODBC module - todo - add more about this.
* pythoncom.__future_currency__ is no longer supported - the decimal
module is now used unconditionally when returning 'currency' variants.
See the win32com readme for more.
* If you *implement* (not use) any of the following interfaces, take note:
IErrorLog, IPropertyBag, ICatInformation and IStorage have been upgraded
to have unicode passed instead of strings as args to the implementation
methods.
* win32gui: RegisterDeviceNotification and EnumPropsExW didn't release the
GIL, which could cause a deadlock in multi-threaded Python apps.
* Fix bug in win32timezone.GetSortedTimeZoneNames() on WinNT.
* win32com.internet gets support for IDocHostUIHandler, IHTMLOMWindowServices
and IInternetSecurityManager interfaces, and CoInternetCreateSecurityManager
function.
* win32com.axcontrol gets support for IOleControlSite,
IOleInPlaceActiveObject, IOleInPlaceFrame and IOleInPlaceUIWindow
interfaces, and OleTranslateAccelerator function.
* MsgWaitForMultipleObjectsEx() would crash in all cases. Fix from
Ziga Seilnacht via [2141368].
* pywintypes.error and com_error get support for attributes as
well as indexing (ie, exc.winerror can now be used in place of exc[0].)
See the help file for details on the attribute names.
* MAPI gets support for IMAPIAdviseSink
* win32com.shell gets support for IContextMenu2 and IContextMenu3
* add win32api.GetNativeSystemInfo(), win32api.GetKeyboardLayout(),
win32api.GetPwrCapabilities.
* add win32file.ConnectEx() and win32file.TransmitFile() (ionel and Roger via
[1962146])
Since build 211:
----------------
* adodbapi updated to version 2.2. Supports Iron Python. Better
logic for .rowcount. New .cvtString convertion method. Multiple
result sets work correctly. Code cleanup and eliminate classic
classes and string exceptions. Fix CoInitialize bug.
* Remove warning about VARDESCs in obscure circumstances when using
COM objects.
* Add winapi.SetSystemPowerState(), win32pipe.TransactNamedPipe(),
win32net.NetValidatePasswordPolicy(),
* win32api.GetConsoleTitle() could raise win32api.error with an error
code of 0 when the title was > 64 characters. It now returns the
full title.
* New IExplorerPaneVisibility interface, minor shell bugfixes.
* Fix a couple of makepy related unicode issues, and generate to
a .temp file so an error doesn't leave a 1/2 generated module.
* Fix so makepy works in IDLE in non-English locales.
* Pythonwin changes from Roger:
- Right-click menu gets "Copy code without prompts" and "Execute
code from clipboard" options.
- If text is selected when period key is pressed, replace text
instead of doing autocomplete
- Add a keyboard shortcut to fold up second level indents
- Allow keypad keys to perform original function when folding
is disabled (feature req 1798328)
* Add some extra service configuration parameters introduced with Vista
Since build 210:
----------------
* Support for RegisterDeviceNotification in win32gui and for packing and
unpacking the various structures in win32gui_struct. Demos in
win32\Demos\win32gui_devicenotify.py and service\serviceEvents.py
* adodbapi added to pywin32 package CVS tree:
- this pure python package is a fully dbapi 2.0 compliant database access
method. This is a copy of the code from the adodbapi sourceforge project,
which will eventually become obsolete in favor of this site. Inclusion here
and maintenance of the package are by Vernon Cole.
* Available for AMD64 versions of Windows for Python 2.6 and later (support
for Python 2.5 is just too hard, sorry). Lots of help from Roger,
Steve Yin and Sidnei da Silva.
* com related changes:
- win32com.bits: Sidnei da Silva from Enfold Systems added support for
BITS (Background Intelligent Transfer Service). Not fully complete
(missing Ranges-related APIs and a couple others) but the basic
functionality is in place. See the demos in
win32comext/bits/test/*.py
- makepy accepts a program id to process its typelib and generates long
integer literals for constants > sys.maxint. The way typelibs are generated
also changes slightly, fixing a bug with certain hex version numbers in
the registry. Fix a bug [1548903] that could cause incomplete generated
files when a typelib was missing
- win32com.client: Fix a bug [1587023] that prevented Get and Set properties
working for ITypeComp implementing objects. Add automatic "cast" to an
interface when using iterators [1707700]
- win32com.axcontrol: Module for using ActiveX controls independently of
pythonwin/win32ui/MFC. Includes a demo of embedding Internet Explorer
inside a win32gui window.
- win32com.internet:
* Add CoInternetIsFeatureEnabled and CoInternetSetFeatureEnabled
- pythoncom:
* event handlers implemented in Python that were called with named params
may have presented the arguments to Python in the incorrect order - this
has been fixed.
* Always return -1 (VARIANT_TRUE), rather than 1, when a VARIANT_BOOL is
requested.
* When passing a Python integer, always use VT_I4 when possible, VT_UI4
otherwise (previous versions did VT_I4 only, 209 did VT_UI4 only)
* New functions CoMarshalInterface, CoUnmarshalInterface,
CoReleaseMarshalData, ReadClassStm, WriteClassStm, CreateStreamOnHGlobal,
CreateILockBytesOnHGlobal.
* Fix possible buffer overflow using IStream.
- win32com.shell:
* PyIExtractImage by Steven James.
* PyIEmptyVolumecache, IEmptyVolumeCache2, IEmptyVolumeCacheCallBack by
Sidnei da Silva from Enfold Systems.
* IsUserAnAdmin
* More coverage of the shell interfaces and demos, including many Vista
specific functions and interfaces (see win32comext\shell\demos)
* win32transaction: New module containing Kernel Transaction Manager (KTM)
functions as used with transacted NTFS and transacted registry functions
* win32api:
- Transacted registry functions and demos from Roger
- New functions RegCopyTree, RegDeleteTree, RegSaveKeyEx,
RegRestoreKey, RegCreateKeyEx, RegQueryInfoKeyW,
RegEnumKeyExW, Get/SetSystemFileCacheSize, GlobalMemoryStatus,
GlobalMemoryStatusEx, GetDllDirectory, SetDllDirectory,
RegDeleteKeyEx, RegOpenCurrentUser, RegOverridePredefKey
- Fix memory leak in GetShortPathName
- Fix VkKeyScan arg handling
* win32file:
- Fixed bug in ReadDirectoryChanges that ignored 1 char filenames.
(from Niki Spahiev)
Added Transactional NTFS functions, CreateSymbolicLink and other new
Vista API functions, System file checker (Sfc) functions,
DuplicateEncryptionInfoFile, GetVolumePathNamesForVolumeName,
GetFinalPathNameByHandle,
CreateMailslot, GetMailslotInfo, SetMailslotInfo
- FindFiles and FindFilesIterator now accept an optional transaction handle
to perform a transacted search
- FindStreams function that calls FindFirstStream and FindNextStream to
enumerate a file's data streams.
- FindFileNames using FindFirstFileName, FindFirstFileNameTransacted, and FindNextFileName
* win32service:
- Service and service control manager handles are now returned as
self-closing PySC_HANDLEs instead of plain int handles
- Service dependencies are returned as list of Unicode strings instead
of a single string, which lost multiple dependencies (could break
code, but old handling was insane)
- Allow for services to handle additional events and the data that comes
with them - see win32\demos\service\serviceEvents.py.
* win32gui:
- GDI object handles (bitmaps, fonts, regions, pens, brushes) are returned
as another PyHANDLE subclass (PyGdiHandle)
- A large number of new text drawing, line and curve drawing, region, path,
and coordinate space functions
- Window class name can now be used interchangeably with class atom
(fixes bug #1267366)
- Add DrawTextW (feature request #1173716), PtInRect, EnumPropsEx,
DrawTextW, SetMenuInfo, GetMenuInfo, ExtCreatePen, CreateBrushIndirect,
lots of other GDI functions.
* win32pipe:
Add GetNamedPipeClientSessionId, GetNamedPipeServerSessionId,
GetNamedPipeInfo, GetNamedPipeClientProcessId, GetNamedPipeServerProcessId
* win32process:
New functions Get/SetThreadPriorityBoost, Get/SetProcessPriorityBoost,
GetGuiResources, GetProcessId, IsWow64Process
* win32print:
- Printer handles are now returned as self-closing PyHANDLE subclass
- FlushPrinter, GetDefaultPrinterW, and SetDefaultPrinterW
* win32security:
- Added DuplicateTokenEx, AddMandatoryAce, IsTokenRestricted, LogonUserEx
- GetTokenInformation and SetTokenInformation support new Vista
information classes
* win32trace works better on Vista
* mmapfile:
- Fix crash caused by reopening named mapping with excess size
- Accept offset and view size parameters, enabling use of files larger
than physical memory
- Document use in help file, and a demo script
* win32timezone: support Vista and 2007 timezones.
* pythonwin:
- Refcounting / GIL problems fixed by kxroberto.
- Background pychecker plugin by kxroberto
- Fix COM browser
- Problems calling SetWindowPost on an ActiveX control.
- Upgrade to scintilla 1.75
- Fix problems locating the Python DLL at startup.
* isapi:
- Handle server variables > 8k in length and also handle IIS6 'UNICODE_'
variables.
- TransmitFile, MapURLToPath, IsKeepConn, DisableNotifications
- New FilterContext attribute can be used to store arbitrary Python
objects in an ECB.
- Filter and Extension errors that happen during initialization are
written to the Windows Event Log to help diagnose them. A couple
of potential deadlocks during init errors also fixed.
* win32pipe:
GetNamedPipeClientProcessId
GetNamedPipeServerProcessId
GetNamedPipeClientSessionId
GetNamedPipeServerSessionId
GetNamedPipeInfo
Build 210 - Sept. 23 2006
-------------------------
* Roger created win32profile module for working with user profiles
* Roger created win32cred module - interface to credentials management
* Roger added win32file functions for backing up and restoring encrypted files
* Add win32api.GetModuleFileNameW(), SetEnvironmentVariable()
* win32file.AcceptEx now indicates if the function was successful.
* OVERLAPPED objects are now hashable [ 1408485 ]
* Roger added win32file.ReplaceFile, CopyFileEx and MoveFileWithProgress
* Added win32uiole.AfxOleInit, SetMessagePendingDelay,
EnableNotRespondingDialog and EnableBusyDialog.
* win32net gets support for USER_INFO_4 structures
* Roger changes win32file.MoveFileEx to accept NULL for destination, added
SetFileShortName
* Missing typelibs could cause incomplete gen_py cache file [ 1548903 ]
* DISPIDs would sometime be incorrect when multiple typelibs used [ 1457673 ]
* ISAPI filters get support for HTTP_FILTER_AUTHENT and HTTP_FILTER_RAW_DATA
* Prevent ISAPI filters and extensions getting "\\?\c:\" style filenames.
* win32com.shell.shell fixes bug in FILEDESCRIPTORW packing, gets a few
unicode related additions.
* Fix memory leak when passing datetime() objects to COM functions.
Build 209
---------
* Roger Upole added IEnumString, IShellLinkDataList, IUniformResourceLocator
and IActiveDesktop interfaces, win32gui.GetDlgItemText/GetDlgItemInt,
win32process.AttachThreadInput, win32api.Get/SetHandleInformation, amongst
others
* Roger added a new win32ts module, wrapping Terminal Service functions
* Roger enhanced/fixed win32api.GetLongPathName, PyIBindCtx,
win32gui.SystemParametersInfo/SetLayeredWindowAttributes/
GetLayeredWindowAttributes, win32net.WNetGetResourceParent, various
win32job methods, shell.SHFileOperation and added many monitor and display
related functions.
* Stefan Rank and Roger enhanced DEVMODE support
* Add asynch (overlapped) support for ReadDirectoryChangesW
* Prevent warnings in later Python 2.5 releases.
* Makepy now generates working code when a method etc is named 'None'
* isapi package now handles site names with extended characters.
* Fix unwanted string value padding by using SQL_VARCHAR instead of SQL_CHAR
in ODBC module.
* Allow extended chars in comments in IE/ASP and other AXScript applications.
* win32api.GetShortPathName now handled unicode (callingGetShortPathNameW)
* When passing large integers via win32com, we now attempt to pass as a 64
bit integer before falling back to a float.
* Added win32process.CreateRemoteThread, win32gui.ExtTextOut/SetBkColor/
DrawAnimatedRects, win32api.SetLastError
* Fix return code from ConnectNamedPipe when the function succeeds.
* win32gui_menu demo shows how to do owner-draw menus.
* set_file_audit demo shows ACL inheritance.
* win32gui is no longer 'split' in the help file.
* Fix errors if a timer callback or win32ui Window handler removed themselves.
* Fix memory leaks related to win32ui.CreateWnd
Build 208
---------
* pywintypes: fix reference leak in PyOVERLAPPED objects.
* isapi: fix memory leak; filter "load order" handling; error
rendering.
* pythonwin: Disable some old DDE hacks to prevent Data Execution Prevention
(DEP) errors in Pythonwin.
* odbc: gets support for Unicode, corrects support for BIT, and
SQLDataSources() method.
* win32job: New win32job module for access to the win32 "job" functions
* win32inet: Add WinHttpGetIEProxyConfigForCurrentUser()
* pythoncom.Empty now does what it implies - passes a variant with VT_EMPTY.
New pythoncom.ArgNotFound supports the old behaviour (of VT_ERROR with
DISP_E_PARAMNOTFOUND); CoInitializeEx change described in Build 206 was
not implemented - now it is!
* win32com: large unsigned ints may previously have been returned as negative
Python integers; makepy no longer displays a GUI progress dialog by default.
* win32com.authorization: New package from Roger Upole.
* win32com.mapi: New IProviderAdmin support from John Nielsen; add
IMAPIStatus support
* win32com.shell: Allow SHFileOperation to accept a string containing
multiple file names, prevent Windows handle leak in IQueryAssociations.
* win32com.adsi: Always return extended error info when available, and expose
ADsGetLastError explicitly.
* Leonard Ritter and Robert F�rtsch contributed some IE extension samples
(see win32com\demos)
* .chm documentation now includes a link to search MSDN and google for many
API functions
* Many other minor fixes and enhancements.
Build 207
--------
* Fix an error in win32gui.CreateDC() arg handling, introduced with the
Windows CE changes in build 206.
Build 206
--------
* Prevent the "display name" of a COM object ever being Unicode and
therefore a possible cause of unexpected Unicode decode errors.
* Correct and document behaviour of CoInitializeEx/CoInitialize exception
throwing behaviour - previously a failure would leave a stale Python
exception.
* Fix memory leak when doing str(PySID) (Roger Upole)
* New IE Toolbar demo contributed by Leonard Ritter, plus a few new
AXControl related interfaces that were necessary.
* win32timezone now works in non-English Windows versions. timezone
objects can now be pickled (Jason Coombs)
* Prevent stale Windows errors causing win32api.GetConsoleTitle() to fail.
* Remove workaround for Python bug so we again write a file encoding to
makepy generated files in all Python versions.
* New win32gui function CreateIconFromResource.
* Add win32file.QueryDosDevice (Roger Upole)