connecting to Sybase/MsSQL from python
Hi, I'm hoping someone on the list has connected to sybase/MsSQL with something that works with DBAPI 2.0 from a linux box (SUSE 9.2) because I can't seem to get it done. I found Object Craft's python code that uses FreeTDS. But I can't get it compiled. The code is looking for "sybdb.h" (first error) - of course I don't have "sybdb.h". It is not in Object Crafts code nor in the FreeTDS source. I'm guessing that I need sybase develop lib's but I don't know where they are to be found. So is there a kind sole out there that can help with instructions on what is needed to get python talking to MsSQL. jOHN -- http://mail.python.org/mailman/listinfo/python-list
Second posting - Howto connect to MsSQL
Hi, Since this is (sort of) my second request it must not be an easy solution. Are there others using Python to connect MsSQL? At the moment I'd accept even a windows solution - although, I'm looking for a Linux solution. John -- http://mail.python.org/mailman/listinfo/python-list
Re: Second posting - Howto connect to MsSQL
John Fabiani wrote: > Hi, > Since this is (sort of) my second request it must not be an easy solution. > Are there others using Python to connect MsSQL? At the moment I'd accept > even a windows solution - although, I'm looking for a Linux solution. > > John Thanks all - it looks like it will work with windows at least. John -- http://mail.python.org/mailman/listinfo/python-list
Is it possible to open a dbf
Hi, I'm wondering if there is a module available that will open a dbf (actually sco foxpro 2.6) file under linux. Hopefully it will be DAPI 2.0 but I'll accept anything at this point. John -- http://mail.python.org/mailman/listinfo/python-list
Re: Is it possible to open a dbf
Paul Rubin wrote: > John Fabiani <[EMAIL PROTECTED]> writes: >> I'm wondering if there is a module available that will open a dbf >> (actually >> sco foxpro 2.6) file under linux. Hopefully it will be DAPI 2.0 but I'll >> accept anything at this point. > > Yes, there is, I found such a thing with a minute or so of Google > searching when I needed one a while back. I don't have the url any > more but I'm sure you can find it the same way I did. So far (more than a minute) I have discovered a reader only. So if you have a URL or a search string it would be very helpful. TIA John -- http://mail.python.org/mailman/listinfo/python-list
Re: Python plugin (semantic-aware) for the Qt Creator IDE
What about debugging? On Jan 16, 2016 6:02 AM, "Leandro T. C. Melo" wrote: > Hi again... > > Sorry, but I have a new url for the video (it's just slightly modified). > > https://youtu.be/71aqIwv3vJs > > Thanks, > Leandro > > > On Thursday, January 14, 2016 at 9:23:47 AM UTC-2, Leandro T. C. Melo > wrote: > > Hi everyone, > > > > I've recently published a Python (and other languages) plugin for the Qt > Creator IDE. In fact, Qt Creator already has some official Python support, > but it consists of only basic editing features. The plugin I'm working on > gives you semantic highlighting, diagnostics, and completion. > > > > Here you go with an introduction video: https://youtu.be/XHrnvswtW6o > > > > The implementation is probably not mature enough to replace an > industrial Python IDE or text editor yet, but hopefully I'll get there. If > you'd like to try it out, please be patient with eventual bugs but feel > free to report them to me. > > > > Notice the plugin is actually a thin layer bridging Qt Creator and the > Uaiso engine[1], which is multi-language source code modeller. So if by any > chance you'd like to write a plugin for any other IDE or text editor, > you'll get the other languages out of the box (currently there's D and Go). > > > > Any kind of feed become is welcome. > > > > Thanks, > > Leandro > > > > [1] https://github.com/ltcmelo/uaiso > > -- > https://mail.python.org/mailman/listinfo/python-announce-list > > Support the Python Software Foundation: > http://www.python.org/psf/donations/ > -- https://mail.python.org/mailman/listinfo/python-list
Re: Am I interacting with the database correctly?
Hussein B wrote: > Hey, > I'm new with database interactions in Python and I'm not sure if I'm > handling the cursor and transactions correctly: > > cursor = db.cursor(MySQLdb.cursors.DictCursor) > cursor.execute(flate_rate_pkgs_sql) > rows = cursor.fetchall() > #I have for loop here to iterate over rows >cursor.execute() >rows = cursor.fetchall() ># some more cursor.execute() calls but only SQL select statements ># here is another for loop that contains try block > # here are cursor.execute() calls, both insert and update > db.commit() > # in the except code block, I use db.rollback() > > As you see, my script contains only one db object and one cursor > object and both the db and cursor objects are used multiple times, it > is ok? > As you might figured, this is a script for reports :) > Thanks. I have never worked with MySQL. I do work with others. The first part looks fine. If you insert, update or delete then you need a 'commit' or a 'rollback'. Preparing data for a report it is unlikely that you need to commit or rollback anything. After all you are only using 'select'. John -- http://mail.python.org/mailman/listinfo/python-list
openOffic, windows, and Python 2.5
Hi, OpenOffice 3 on windows uses python 2.3.x (I have no idea why). Does anyone know where I can get whatever is needed to get python 2.5 working. I don't want to learn how recompile openoffice because it has a steep learning curve and is just to much when I can just use M$ word. BTW using the openSUSE update to install openOffice3 uses my installed python. Maybe someone has already done the compile and is willing to share? Thanks in advance Johnf -- http://mail.python.org/mailman/listinfo/python-list
Re: openOffic, windows, and Python 2.5
Terry Reedy wrote: > John Fabiani wrote: >> Hi, >> OpenOffice 3 on windows uses python 2.3.x (I have no idea why). > > I presume because no one has volunteered to do the update for the Py-UNO > bridge. In any case, why do you consider that to be a problem. It is > common for apps to include the Python they are known to work with. > > tjr Thanks for the response. The reason is the others apps are written in python 2.5.x. All the testing was done on Linux using 2.5 and now we need it to work on the windows side too. -- http://mail.python.org/mailman/listinfo/python-list
tutorial on parser
Hi, I'm attempting to learn how to convert MsSQl Transact-SQL to postgres pgsql. So far my readings have led me to finding a parser. I'm looking for a tutorial on how to get it done. I did find a commercial product but they want over $10,000 us. This way beyond my means. Therefore, I need to get it done either myself to find a open source project. Thanks in advance. John Fabiani -- http://mail.python.org/mailman/listinfo/python-list
Re: Best GUI toolkit with Table support
deech wrote: > Hi all, > I am making a cross-platform frontend to a sqlite3 database. Which > python GUI toolkit has the best table support? Tkinter doesn't seem to > support them (without additional package installation). > > The issue is that the application must run off a flash drive with a > vanilla Python install on both Windows and Linux. Or if there is a way > to store additional packages on the flash drive and call them in some > portable way, this would work too. > > -deech Take a look at Dabo (www.dabodev.com) which was developed to deal the with very thing you are asking for data. BTW running from a flash drive these days does not present a big deal - 16 gb is plenty of room for an OS and your app. And there is even bigger 32GB flash drives. I'll bet that by the end of the year there will 64GB flash drives. -- http://mail.python.org/mailman/listinfo/python-list
Re: [OT] large db question about no joins
Daniel Fetchinson wrote: > Hi folks, I've come across many times the claim that 'joins are bad' > for large databases because they don't scale IMO that's bull... -- http://mail.python.org/mailman/listinfo/python-list
Re: What is the best framework or module in Python for a small GUI based application development?
srinivasan srinivas wrote: > > Hi, > Could you suggest me some modules in Python which can be used to develop > GUI based applications? and tell me which could be the best(in terms of > efficiency) one for a small GUI based application development? > > Thanks, > Srini > > > Bollywood news, movie reviews, film trailers and more! Go to > http://in.movies.yahoo.com/ You might consider Dabo (www.dabodev.com) if access to data is required. John -- http://mail.python.org/mailman/listinfo/python-list
Re: Newb question: underscore
Skye wrote: > What is this doing? > > print >> fd, _(__doc__) > > > I'm guessing line-splitting __doc__ into a list, but what's that > leading underscore do? > > Thanks! I think it is standard practice to use the underscore for unicode converts. -- http://mail.python.org/mailman/listinfo/python-list
Re: Python + RDBM framework?
bukzor wrote: > It seems that whenever I have an application that uses a database > (MySQL) I end up writing a database framework from scratch. Is there > some accepted pre-existing project that has done this? > > I see Django, but that seems to have a lot of web-framework that I > don't (necessarily) need. I just want to have my objects go in and out > of the database in a consistent manner without writing a ton of code. > Can you just use the database part without making a full-blow web app? > > I see Zope, but that doesn't use MySQL (as far as I can tell), which > I've invested a lot of time learning to use and optimize. Also, my > manager wants to be able to log into a MySQL prompt and be able to > look at the data. > > --Buck Not sure of your project but you might consider Dabo (www.dabodev.com). John -- http://mail.python.org/mailman/listinfo/python-list
need thumbnail from video
Hi, I need a py tool that will provide a thumbnail (bmp?) from a video (avi, wmv) that will be cross platform (linux, windows). Research has provided pymedia for Linux but I haven't found anything for windows. Hopefully, someone has had to do this in the past and knows what has to be done. Thanks in Advance, Johnf -- http://mail.python.org/mailman/listinfo/python-list
Re: GUI programming with python
Alan Franzoni wrote: > zamil was kind enough to say: > > [cut] > > If your needs are very basic, you can stick with the tk module that comes > with python. It's not really feature-packed, but it's maintained and > pretty cross-platform. > > Otherwise, you can pick any supported widget set you like and use the > proper python bindings. You didn't tell us which OS you'd work with, hence > we can't tell you what's the best choice (if there's any). > > BTW you should be able to enjoy GTK+, QT or Swing (if using Jython on > Java) or anything found in MS.NET (if using IronPython) - or you can go > for wxPython as well. > > GUI Designers are widget-set related - I can suggest gazpacho for GTK+. > You might want to take a look at Dabo (www.dabodev.com). Check out the screencast. Johnf -- http://mail.python.org/mailman/listinfo/python-list
Re: configure kdevelop for python
Sindhu wrote: > am a newbie to python language and kdevelop, so i would like to know > how to configure kdevelop for python programming? complete with a > debugger? I have not used python and kdevelop but I do know it requires qt and the link below has several video's of a developer using python qt and qtdesigner. http://tv.dgplug.org/devel-inside.html I hope this helps. Johnf -- http://mail.python.org/mailman/listinfo/python-list
Re: Launching a subprocess without waiting around for the result?
erikcw wrote: > On Sep 18, 3:33 pm, Ben Finney <[EMAIL PROTECTED]> > wrote: >> erikcw <[EMAIL PROTECTED]> writes: >> > I have a cgi script where users are uploading large files for >> > processing. I want to launch a subprocess to process the file so the >> > user doesn't have to wait for the page to load. >> >> For "how do I deal with subprocesses from Python", the (new in Python >> 2.4) 'subprocess' module is the default go-to answer >> http://www.python.org/doc/lib/module-subprocess>, replacing a >> rather fragmented set of modules before it. >> >> > What is the correct way to launch subprocess without waiting for the >> > result to return? >> >> Creating an instance of 'subprocess.Popen' will launch the process and >> return the Popen instance. You then have the option of polling it or >> waiting for it to complete. >> >> -- >> \ “To stay young requires unceasing cultivation of the ability to | >> `\ unlearn old falsehoods.” —Robert Anson Heinlein | >> _o__) | >> Ben Finney > > So if I create a Popen object and then just ignore the object and exit > the program the subproccess will finish it's work and then exit itself > cleanly? Just so happens that I ran into the same problem recently. I started with exec(), then os.system(), next os.popen(), and last os.spawn(). This is what I discovered on a windows platform. The exec() replaced the current running process. os.system did not start a completely new process. os.popen() created a new process but did not open a command box to display any print statements. Lastly os.spawn() worked - it created a new process and opened a command box to display any print statements I needed. Johnf -- http://mail.python.org/mailman/listinfo/python-list
Re: Open source python projects
[email protected] wrote: > Saurabh, > > 1. The Dabo crew is doing some exciting thing. Might be worth checking > out. > http://dabodev.com yes Dabo is doing a lot these days. Using wxPython for the GUI, a fast interface for data supporting SQLite, MySQL,Postgres, Firebird, MsSQL and Now a web like program that supports the code from Dabo projects over the web. The report writer has had many improvements recently. People from everywhere are joining in - very cool. -- http://mail.python.org/mailman/listinfo/python-list
Re: What does Guido want in a GUI toolkit for Python?
Casey Hawthorne wrote: >>So, what *does* Guido want in a GUI toolkit for Python? > > I saw a talk by a school teacher on pyFLTK: GUI programming made easy. > > On another note: I#: Groovy makes it easy to tie into the Java Swing > GUI, so if Python could do that, with the added complication being the > user would need a JVM. > > -- > Regards, > Casey Dabo makes it transparent when it come to tying the data to the widget. Based on the wxPython. So it meets Guido's requirements. -- http://mail.python.org/mailman/listinfo/python-list
