Re: Python Web Site?
"Michael B. Trausch" <"mike$#at^&nospam!%trauschus"> wrote: > Tim Chase wrote: >>> Is there a problem with the Python and wxPython web sites? >>> I cannot seem to get them up >> >> Sounds like someone needs some pyagra... >> >> (grins, ducks, and runs) >> > > Interesting. I thought at first it was a problem with Python's sites... > but I got through to the Python site just now... but I can't get through > to the wx* sites (wxwidgets.org, wxpython.org at the very least). Seems > that my trouble with the Python web site itself was coincidental. > > -- Mike I have the problem all the time. I just wait a couple of hours and all works again. John -- http://mail.python.org/mailman/listinfo/python-list
Re: Python and CMS
Echo wrote: > I am going to start working on a church website. And since I like > python, I decided to use WSGI. However, I later found out about all > the different CMS's in php. So I wondered if there where any in > python. > > Sadly, I only found Plone, skeletonz, and PyLucid (If there is any > more, please let me know). Of those three, only PyLucid supports WSGI > and it didn't look very nice to me. > Both Plone and skeletonz looked very nice. However, they can't be > hosted on a regular web host(at least to my knowledge) since they run > as the web server themselves. So hosting would cost more, at least 2-3 > times more from what I've seen. > > So I'm thinking of making a python CMS based on WSGI. I'm now trying > to figure out a few things like the best way to store the content and > how to manage/use plugins. For storing the content, the only ways I > know of are as files or in a database. But I'm not sure what would be > better. And as for how to do plugings, I plan on looking at Plone and > skeletonz. > > As for working with WSGI, I have found > Colubrid(http://wsgiarea.pocoo.org/colubrid/) and > Paste(http://pythonpaste.org/). I was wondering if anyone knew of any > other libraries that make working with WSGI easier. Also, I wondering > if anyone would like to share their experiences of working with those. > > > ps. I know that this is a big and complicated project. But no matter > how far I get, it will be fun because its Python:) > Turbogears??? John -- http://mail.python.org/mailman/listinfo/python-list
Re: Python visual IDE
king kikapu wrote: > > Hi to all, > > i am not sure if this question really belongs here but anyway, here it > goes: I have seen a lot of IDEs for Python, a lot of good stuff but > actually none of them has what, for example, Visual Studio has: a > Visual Editor (with the ability to place controls on forms etc etc), > or RAD > > I know that there is Glade but does anybody knows of some product, or > an ongoing effort to this direction so i can have a look at ? > > Coming from Windows and vs.net world, i think the only missing point > here is the integration of the Pyrthon with a RAD IDE... > > Thanks a lot and i apologize if this isn't the correct place for this > question... > > > Kikapu You might want to check out "dabo" www.dabodev.com. It's only at .7 but it has a GUI designer (uses wxPython). Has a 3 tier design and able to use MySQL, Postgres, FireBird, and soon MSSQL. The project has a ways to go but it's goal is to be similar to windows IDEs such as VFP, VB6 and VS. John -- http://mail.python.org/mailman/listinfo/python-list
Re: MySQLdb windows binaries for Python 2.5?? Yes, but from a World of Warcraft guild.
John Nagle wrote: > Jan Dries wrote: >> [EMAIL PROTECTED] wrote: >> >>> I'm also looking for a MySQLdb binary for windows. This is holding me >>> from upgrading from Python 2.4 to Python 2.5 ! >>> >> >> If you search the Help Forum of the MySQLdb project on SourceForge, you >> will find a couple of people who have successfully built MySQLdb on >> Windows for 2.5, and are willing to share their installers. >> That's how I got my binaries. >> >> Regards, >> Jan > > Yes, see > > http://sourceforge.net/forum/forum.php?thread_id=1571110&forum_id=70461 > > for an untested version created by a World of Warcraft guild: > > http://www.guildmanus.com/uploaded/MySQL-python.exe-1.2.2b2.win32-py2.5.exe > > This, apparently, is the extent of current Python support for MySQL. > Want to install that executable, as root, on your production machines? > > This is embarassing for the Python community. Perl and PHP come > with MySQL support built in. Python is out to lunch on this. > > John Nagle > Animats I couldn't disagree more. That fact that no Database drivers are built-in makes Python stronger - allowing Python to access any Data Engine that supports DBI 2.0. Of course I'm not including pickle in my assessment. Johnf -- http://mail.python.org/mailman/listinfo/python-list
Re: your opinion about psycopg vs pygresql
Martin P. Hellwig wrote: > Hi all, > > I'm playing a bit with PostgreSQL, in which I've set me the target to > create a python script which with user input creates a new user role and > a database with that owner (connecting to template1 since I know that at > least that db exists). > > Ok so I installed PostGreSQL and pygresql since it looked like that this > is endorsed by PG, I had some trouble with the DB-API2 (complains about > there is already a connection to template1, even when I closed and > deleted the connector) so I solved it by using the pg api. > > But I was intrigued by this problem and started googling and by that > time I've noticed that python projects like Django seem to favor the > psycopg module. > > So I installed that one (the 1.1 version, since Django uses that too) > and it looked like it has the same problem of creating a user after a > database, I'm sure that there is a user error in there somewhere :-) > > However, given the choice, what in your opinion would be the reason why > someone would chose one over the other? Now I know this could easily get > into a flamewar, so if you comment (but please do so) I'll still > investigate that, since at this moment I don't even have a clue how they > differ and on what reason, why does PostgreSQL seem to favour pygresql > and Pythoneers psycopg? > > Thanks in advance. > I have not used pygresql but I see it often as a standard package with the SUSE DISTRO. But I use Psycopg 2. I find that it is very fast and provides a few extentions that I have used. Reported bugs are fixed immediately. John -- http://mail.python.org/mailman/listinfo/python-list
Re: db access
king kikapu wrote: > Hi to all, > > is there a way to use an RDBMS (in my case, SQL Server) from Python by > using some built-in module of the language (v. 2.5) and through ODBC ?? > I saw some samples that use statements like "import dbi" or "import > odbc" but neither modules (dbi, odbc) are present on my system... > > Any hint(s) ?? > > Thanks in advance Although others have suggested using ODBC or ADO I have a different solution. If you wanted a multi-platform I would use FreeTDS with psmssql.py. psmssql.py does support the DB API 2.0 although it does not support any of the extendsions. Works with Linux, Mac and Windows. Johnf -- http://mail.python.org/mailman/listinfo/python-list
Re: INSERT statements not INSERTING when using mysql from python
Ben wrote:
> I don't know whether anyone can help, but I have an odd problem. I have
> a PSP (Spyce) script that makes many calls to populate a database. They
> all work without any problem except for one statement.
>
> I first connect to the database...
>
> self.con = MySQLdb.connect(user=username, passwd =password)
> self.cursor = self.con.cursor()
> self.cursor.execute("SET max_error_count=0")
>
> All the neccesary tables are created...
>
> self.cursor.execute("CREATE DATABASE IF NOT EXISTS "+name)
> self.cursor.execute("USE "+name)
>
> self.cursor.execute("CREATE TABLE IF NOT EXISTS networks (SM
> varchar(20),DMC int,DM varchar(50),NOS int,OS varchar(50),NID
> varchar(20))
>
> Then I execute many insert statements in various different loops on
> various tables, all of which are fine, and result in multiple table
> entries. The following one is executed many times also. and seems
> identical to the rest. The print statements output to the browser
> window, and appear repeatedly, so the query must be being called
> repeatedly also:
>
> print "SQL query executing"
> self.cursor.execute("INSERT INTO networks VALUES ('a',' "+i+"
> ','c','2','e','f','g')")
> print "SQL query executed"
>
> I have, for debugging, set "i" up as a counter variable.
>
> No errors are given, but the only entry to appear in the final database
> is that from the final execution of the INSERT statement (the last
> value of i)
>
> I suspect that this is to vague for anyone to be able to help, but if
> anyone has any ideas I'd be really grateful :-)
>
> It occured to me that if I could access the mysql query log that might
> help, but I was unsure how to enable logging for MysQL with python.
>
> Cheers,
>
> Ben
Not sure this will help but where is the "commit"? I don't use MySQL but
most SQL engines require a commit.
Johnf
--
http://mail.python.org/mailman/listinfo/python-list
I want to see all the variables
Hi, When I use dir() I don't see the __ underscore items. Is there anything that will show all the private vars and functions? johnf -- http://mail.python.org/mailman/listinfo/python-list
Re: I want to see all the variables
Steven D'Aprano wrote: > On Fri, 29 Dec 2006 08:20:22 -0600, Larry Bates wrote: > >> johnf wrote: >>> Hi, >>> When I use dir() I don't see the __ underscore items. Is there anything >>> that will show all the private vars and functions? >>> >>> johnf >> >> The idea of the underscore items is that they aren't to be used by >> you. > > Double leading+trailing underscore attributes are NOT private, they are > *special* but public (e.g. __dict__, __class__, __str__, etc.). If you > don't believe me, have a look at dir(int) and count the underscored > attributes listed. Then try to find __dict__, __name__, __bases__, > __base__ or __mro__ within the list. Why are they suppressed? > > But even if underscored attributes were private, the Python philosophy is > that private attributes are private by convention only -- even > name-mangled __private methods can be reached if you know how. > > >> If you wish to access private variables and functions you will >> almost certainly have to look at the source code to make sure of >> what they are and how they can be utilized. > > Not so. > >>>> class Parrot(object): > ... def _private(self): > ... """Private method, returns a magic string.""" > ... return "Don't touch!!!" > ... >>>> Parrot._private.__doc__ > "Private method, returns a magic string." > > > Ok then how do debug when I have something like "__source" and I need to know what is available for the object? John -- http://mail.python.org/mailman/listinfo/python-list
Re: I want to see all the variables
Steven D'Aprano wrote: > > There are three other underscore conventions in use: > > (1) Objects with a single leading underscore like _attribute are private > by convention, but Python doesn't enforce it. Starting an object with a > single underscore is like writing "# Private! Don't touch!" after it. > > (2) By convention, if you want to create a name that is the same as a > built-in object without shadowing (hiding) the built-in, put a single > trailing underscore after it like "file_". That's just a style convention > though, you are free to call it FiLE ,or anything else, if you prefer. > > (3) Last but not least, class attributes with two leading and trailing > underscores are considered special but public, like __init__ and __repr__. > It is probably a bad idea to invent your own. > > > Very detailed. But I was attempting to debug some code which subclassed other code. I got a traceback that something like "no mySubClass.__source.query() did not exist". The superclass had something like "myClass.__source.query(sql)" which worked but "mySubClass.__source.query(sql)" did not work. So I tried to debug using "dir(myClass.__source)" and got an error. And I also got error when I "dir(mySubClass.__source". So how could I have debugged the problem if dir() will not display information on the __source? I hope that explains my issue. Thanks Johnf -- http://mail.python.org/mailman/listinfo/python-list
Re: gui application on cross platform
james_027 wrote: > Hi, > > I am using delphi to develop gui application, and wish to make a shift > to python. here are some of my question/concern... > > 1. is python develop gui application a cross platform? just like java > swing? > 2. delphi makes things easy for me like coding for a specific event on > a specific component, could it be the same for python? > 3. are there cool library of component like in delphi available for > python that will make database application more usesable? > 4. where do I start the learning curve? I did some research and I > don't know which one to take among wxwdiget, pygtk, and etc. > > > Thanks > james May I suggest you take a close look at Dabo (www.dabodev.com). Dabo was designed from the ground up to do exact what you are asking for. Take a look at the Dabo screencast (http://leafe.com/screencasts/dataenvironment1.html) which will provide an easy review of most of what Dabo can do. Johnf -- http://mail.python.org/mailman/listinfo/python-list
Re: Database intensive application
Rohit wrote: > I am a novice. I want to know whether Python can be used to develop > client/server database and web applications like .NET. Which is the > best book/source to learn Python? IMO you should use Dabo (www.dabodev.com). If you want to strike on your own check using SQLAlchemy as your database connection. Check out the O'Reilly books. John -- http://mail.python.org/mailman/listinfo/python-list
Re: Read from database, write to another database, simultaneously
Bjoern Schliessmann wrote: > Sean Davis wrote: > >> The author of one of the python database clients mentioned that >> using one thread to retrieve the data from the oracle database and >> another to insert the data into postgresql with something like a >> pipe between the two threads might make sense, keeping both IO >> streams busy. > > IMHO he's wrong. Network interaction is quite slow compared with CPU > performance, so there's no gain (maybe even overhead due to thread > management and locking stuff). That's true even on multiprocessor > machines, not only because there's almost nothing to compute but > only IO traffic. CMIIW. > > Using multiplexing, you'll get good results with simple code without > the danger of deadlocks. Have a look at asyncore (standard library) > or the Twisted framework -- personally, I prefer the latter. > > Regards, > > > Björn > Sean you can't win - everyone has a different idea! You need to explain that oracle has millions of records and it's possible to a pipe open to feed the Postgres side. One thing I didn't get - is this a one time transfer or something that is going to happen often. One time transfer live to the time issue. Johnf -- http://mail.python.org/mailman/listinfo/python-list
RE: Learning Python book, new edition?
Demel, Jeff wrote: > This email is intended only for the individual or entity to which it is > addressed. This email may contain information that is privileged, > confidential or otherwise protected from disclosure. Dissemination, > distribution or copying of this e-mail or any attachments by anyone other > than the intended recipient, or an employee or agent responsible for > delivering the message to the intended recipient, is prohibited. If you > are not the intended recipient of this message or the employee or agent > responsible for delivery of this email to the intended recipient, please > notify the sender by replying to this message and then delete it from your > system. Any use, dissemination, distribution, or reproduction of this > message by unintended recipients is strictly prohibited and may be > unlawful. So what happens with google bots etc... Information provided in the email could be helpful to others that are NOT the original recipient. And what happens to the archive stuff? John -- http://mail.python.org/mailman/listinfo/python-list
Re: Which Object Database would you recommend for cross platform application?
Thomas Ploch wrote: > Hello folks, > > I am currently developing an open source Event Managment software > (events in real-life, like concerts, exhibitions etc. :-) ) using wx for > the GUI, and I need an Object database. Since this is the first time I > actually need doing this, I wondered if anybody here could recommend > one. It can be fairly simple. It doesn't need threading support and will > only host one client (the application, but I am thinking about making > this database accessible via the web, but this is still far in the > future), although the database might get big (around 1GiB). It should be > available for linux, mac os and windows. > > I looked into ZODB, but thats totally overloaded for my purpose. I > looked into Durus (a re-implementation of ZODB, but without this > overloaded stuff, but the documentation is very thin). Both of them > don't really appeal. > > So I wondered if any of you could recommend one that (more or less) best > fits the described conditions. > > Thanks in advance, > Thomas This answer does not really answer your question. But have you looked a dabo (www.dabodev.com). It doesn't support the web (yet) but you said that's in the furture. Dabo was built for this type of app. Dabo supports Postgres,MsSQL,MySQL,Firebird, and SQLite. Non of the DB's are what I'd call an object database but is that a real requirement? BTW the first 4 DB's can support 1GB and more. Johnf -- http://mail.python.org/mailman/listinfo/python-list
Re: PyCon blogs?
[EMAIL PROTECTED] wrote: > Was anybody blogging about PyCon (talks and/or sprints)? Got any > pointers? > > Thanks, > > Skip At least one session was posted on YouTube http://dabodev.com/pycon2007 Johnf -- http://mail.python.org/mailman/listinfo/python-list
where is uno?
I'm using SUSE 10.3 have installed OpenOffice Python interface from the distro DVD. But still I need help because I can't "import uno". And that's because it's not in my site-packages. I read about how to use it and have reviewed code that uses it but no where did any of the articles explain where to retrieve the actual 'uno' py package. Can someone provide a hint? Johnf -- http://mail.python.org/mailman/listinfo/python-list
Re: Write ooxml .ods (spreadsheat) from python?
Neal Becker wrote: > I'd like to output some data directly in .ods format. This format appears > to be quite complex. Is there any python software available to do this? > I > did look at pyuno briefly. It looks pretty complicated also, and it looks > like it uses it's own private version of python, which would not help me. Try import ooolib #http://ooolib.sourceforge.net -- http://mail.python.org/mailman/listinfo/python-list
