I have gone with ADO.Net on the admin web application, and this is fine as it's running within the .Net web application. It just deviates slightly from the codebase on the server which is running in the standard Python runtime, but I can live with that.
<br><br><br>On the BeautifulSoup, sorry - as a newb in the Python sphere I don't know what's common knowledge and what's not. BeautifulSoup is an excellent html parser, much better than the parsers that ship with Python, which sympathetically parses HTML so dealing with missing closing tags and other common malformed html issues - vital if you're scraping html from external sites over which you have no control. The project is here:
<a href="http://www.crummy.com/software/BeautifulSoup/">http://www.crummy.com/software/BeautifulSoup/</a> and there's a fair bit on the web for it too.<br><br><br><div><span class="gmail_quote">On 6/28/06, <b class="gmail_sendername">
Dino Viehland</b> <<a href="mailto:dinov@exchange.microsoft.com">dinov@exchange.microsoft.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">I would recommend going w/ .NET ADO. You can get started w/:</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">import clr</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">clr.AddReference('System.Data')</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">import System.Data as SD</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">and then you have SD.* available to you.</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">On the BeautifulSoup object – what is a BeautifulSoup object? You
can either give us more details here, or you can open an issue on CodePlex (<a href="http://www.codeplex.com/Wiki/View.aspx?ProjectName=IronPython" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.codeplex.com/Wiki/View.aspx?ProjectName=IronPython
</a>).
Unfortunately we're not planning on revisiting performance again until after
v1.0 ships, but it is something that we always care about.</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: solid none none; border-color: rgb(145, 192, 255) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p><b><span style="font-size: 9pt;">From:</span></b><span style="font-size: 9pt;"> <a href="mailto:users-bounces@lists.ironpython.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">users-bounces@lists.ironpython.com
</a>
[mailto:<a href="mailto:users-bounces@lists.ironpython.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">users-bounces@lists.ironpython.com</a>] <b>On Behalf Of </b>Mike Raath<br>
<b>Sent:</b> Tuesday, June 27, 2006 11:01 PM<br>
<b>To:</b> Discussion of IronPython<br>
<b>Subject:</b> Re: [IronPython] "no module named win32api" using
PyWin32-208</span></p>
</div></div><div><span class="e" id="q_10c1b2f8ed054a7d_1">
<p> </p>
<p style="margin-bottom: 12pt;">Thanks, Dino, I'm looking at
that. (It's a .pyc, btw)<br>
<br>
A bit of background - I've got some Python script running server-side which
does screen-scraping based on definitions in a MS SQL Server db, and I'm trying
to come up with a maintenance app where an administrator can define the
screen-scraping, and view the effect of their definition. The server script
uses COM ADO through the win32 extensions, and the admin app is in .Net. I was
hoping to be able to use the Python classes as-is, but I can modify the .py
file which will live with the webapp slightly so that it uses .Net ADO, or even
COM ADO. <br>
<br>
It's a great product, by the way. Just one thing - I've been reading about how
IronPython is pretty fast, but I've come across an area where it's quite slow.
It seems that creating a BeautifulSoup object to parse a web page is slow; not
sure if that's something you'd like to benchmark. <br>
<br>
Cheers,<br>
Mike</p>
<div>
<p><span>On 6/28/06, <b>Dino Viehland</b> <<a href="mailto:dinov@exchange.microsoft.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">dinov@exchange.microsoft.com</a>>
wrote:</span></p>
<div>
<div>
<div>
<p><span style="font-size: 10pt; color: black;">We don't support compiled Python modules (PYD's or PYC's, I'm not
sure which one pywin32 is though I'd bet PYD) and isn't anything we'll support
before 1.0. But if it's access to Win32 you want, there's a large amount
of Win32 exposed through the .NET APIs that you can access directly by
importing the appropriate namespaces (and adding references to the appropriate
assemblies if it's not mscorlib or System). </span></p>
</div>
<div>
<p> </p>
</div>
<div>
<p><span style="font-size: 10pt; color: black;">That may or may not work for you depending on what your goals
are. </span></p>
</div>
<div>
<p> </p>
</div>
<div>
<p> </p>
</div>
<div>
<div style="text-align: center;" align="center">
<hr align="center" size="2" width="100%">
</div>
<p style="margin-bottom: 12pt;"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:users-bounces@lists.ironpython.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
users-bounces@lists.ironpython.com</a>
On Behalf Of Mike Raath <br>
<b>Sent:</b> Tuesday, June 27, 2006 10:21 PM<br>
<b>To:</b> <a href="mailto:users@lists.ironpython.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">users@lists.ironpython.com</a><br>
<b>Subject:</b> [IronPython] "no module named win32api" using
PyWin32-208</span></p>
</div>
</div>
<div>
<div>
<p style="margin-bottom: 12pt;">I posted this on the <b><a href="http://groups.google.co.za/group/comp.lang.python" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">comp.lang.python</a>
</b>list yesterday but am not sure if that is the correct list to have posted
on, so apologies for the cross-post but I would really appreciate some help on
this.</p>
<p><span style="font-family: Courier;">I have Python 2.4 installed on my local
machine in c:\Python24. I have <br>
also downloaded the python for windows extensions installer <br>
pywin32-208.win32-py2.4.exe and installed this to <br>
C:\Python24\Lib\site-packages </span></p>
<p><span style="font-family: Courier;">Trying to run a python script through a C#
console app is causing me <br>
problems: the last line of code in the following block results in a no <br>
module named win32ap error. I'm not sure if this is because there is no <br>
win32api.py in the win32 folder off site-packages, just a win32api.pyc <br>
file. </span></p>
<p><span style="font-family: Courier;">
m_engine = new PythonEngine(); </span></p>
<p><span style="font-family: Courier;">
m_engine.AddToPath("C:\\Python24\\DLLs"); <br>
m_engine.AddToPath("C:\\Python24\\lib");
<br>
m_engine.AddToPath("C:\\Python24\\lib\\plat-win"); <br>
m_engine.AddToPath("C:\\Python24\\lib\\lib-tk"); </span></p>
<p><span style="font-family: Courier;">m_engine.AddToPath("C:\\Python24\\Lib\\site-packages\\pythonwin");
<br>
m_engine.AddToPath("C:\\Python24"); <br>
m_engine.AddToPath("C:\\Python24\\lib\\site-packages"); </span></p>
<p><span style="font-family: Courier;">m_engine.AddToPath("C:\\Python24\\lib\\site-packages\\win32");
</span></p>
<p><span style="font-family: Courier;">m_engine.AddToPath("C:\\Python24\\lib\\site-packages\\win32\\lib");
</span></p>
<p><span style="font-family: Courier;">
m_engine.Execute("from win32api import win32api"); </span></p>
<p><span style="font-family: Courier;">I have added all the addtopaths to get the
path to match the sys.path I <br>
see in a normal python console which can successfully import the <br>
module. </span></p>
<p><span style="font-family: Courier;">Incidentally, I have tried making the last
line <br>
m_engine.Execute("import
win32api"); <br>
with no luck. </span></p>
<p><span style="font-family: Courier;">Can the win32 extensions handle compiled
python modules? If not how can <br>
I get it to work? </span></p>
<p><span style="font-family: Courier;">Thanks, <br>
Mike </span></p>
</div>
</div>
</div>
<p style="margin-bottom: 12pt;"><br>
_______________________________________________<br>
users mailing list<br>
<a href="mailto:users@lists.ironpython.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">users@lists.ironpython.com</a><br>
<a href="http://lists.ironpython.com/listinfo.cgi/users-ironpython.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://lists.ironpython.com/listinfo.cgi/users-ironpython.com</a><br>
<br>
</p>
</div>
<p> </p>
</span></div><div></div>
</div>
</div><br>_______________________________________________<br>users mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:users@lists.ironpython.com">users@lists.ironpython.com</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.ironpython.com/listinfo.cgi/users-ironpython.com" target="_blank">
http://lists.ironpython.com/listinfo.cgi/users-ironpython.com</a><br><br><br></blockquote></div><br>