🌐 Mailman 3 June 2000 - Tutor - python.org

Windons Task tray
by rhicks＠rma.edu July 4, 2001

July 4, 2001

Is it possible to minimize a python program to the task tray area of the taskbar in Windows95/98? Bob pop3.rma.edu

3 2

mirroring databases
by Timothy Wilson July 3, 2000

July 3, 2000

Hi everyone, I've been working on a project and it occurs to me that Python may be an excellent tool for the job. Having no previous experience with accessing databases directly with Python, I thought it would be a good idea to get a quick opinion from some gurus about the feasibility of the task. I'll try to simplify the situation, but leave the critical details. We've got a large Oracle database running at a remote site. This DB is accessible via the Internet and supports ODBC connections. We've also got a Linux box that could run either PostgreSQL and MySQL in your own network. We'd like to do a nightly mirror of the Oracle DB to PostgreSQL or MySQL. The Oracle contains data for many schools, and we would need to do a SQL select to pull out only the data relevant to our school. The database tables would have exactly the same format. Corollary: How would the problem change if our local SQL database were running on NT? I look forward to any ideas that you might have. -Tim -- Tim Wilson | Visit Sibley online: | Check out: Henry Sibley HS | http://www.isd197.k12.mn.us/ | http://www.zope.org/ W. St. Paul, MN | | http://slashdot.org/ wilson(a)visi.com | <dtml-var pithy_quote> | http://linux.com/

2 1

Having trouble with a form mail script.
by jason.brashear＠amd.com June 30, 2000

June 30, 2000

Hello, My problem is that I am trying to edit a script that creates a html page after the for has been filled out correctly. What I want to do is put a meta refresh but when I ad that Line I get an Internal server error. Here is the part that works: # Print confirmation print "Content-type: text/html\n" print "<HTML>\n" print "<HEAD>\n" print "<TITLE>Submission successful</TITLE>" print "</HEAD>\n" print "<BODY>\n" print "<H1>Submission successful</H1>\n" print "<P>Your submission has been mailed to the site administrators." print "<P>Confirmation has been sent to your email address." print "</P>\n" print "<P>Thank you.</P>\n" print "</BODY>\n"; print "</HTML>\n" But the user has to hit his or her back button. this is what I want to do: # Print confirmation print "Content-type: text/html\n" print "<HTML>\n" print "<HEAD>\n" print "<TITLE>Submission successful</TITLE>" print "<meta http-equiv="refresh" content="3;URL=http://k86tech">" print "</HEAD>\n" print "<BODY>\n" print "<H1>Submission successful</H1>\n" print "<P>Your submission has been mailed to the site administrators." print "<P>Confirmation has been sent to your email address." print "</P>\n" print "<P>Thank you.</P>\n" print "</BODY>\n"; print "</HTML>\n" But that doesn't work! So I then tried this: # Print confirmation print "Content-type: text/html\n" print "<HTML>\n" print "<HEAD>\n" print "<TITLE>Submission successful</TITLE>" print "<meta http-equiv="refresh" content="3;URL=http://k86tech">\n" print "</HEAD>\n" print "<BODY>\n" print "<H1>Submission successful</H1>\n" print "<P>Your submission has been mailed to the site administrators." print "<P>Confirmation has been sent to your email address." print "</P>\n" print "<P>Thank you.</P>\n" print "</BODY>\n"; print "</HTML>\n" That didn't work either.. Any Ideas? Can some one please help? If you would like to see the whole script here it is: #!/usr/bin/python """ 1/8/00 - Modified the original code to clean-up the email format. Cleared a bug in the output string concatenation. Filters out Submit and REQUIRED fields. A quick-and-dirty CGI form mailer. Requires Python 1.5.1. $Id: formmail.py,v 1.2 1999/01/28 11:42:57 larsga Exp $ """ OK=0 try: import cgi import StringIO import string import smtplib import sys # Standard modules import email import LBBemail # Config mailserver="techdoc.amd.com" mailrecip="k86access(a)techdoc.amd.com" # mailrecip="barnettl(a)techdoc.amd.com" subject="K86TECH Access Request Form" subject2="Automatic confirmation of your K86TECH access request." # Setup # Create output control # Process results form=cgi.FieldStorage() # Check that required fields are present OE=0 if form.has_key("REQUIRED"): missing=[] for field in string.split(form["REQUIRED"].value): if not form.has_key(field): missing.append(field) if form["Approvers_Email"].value == "Other: -->" : OE=1 if not form.has_key("Other_Email"): missing.append("Select or fill-in an email address.") if form.has_key("Your_Email") : A3 =form["Your_Email"].value youremail = LBBemail.testemail(A3) if missing!=[]: print "Content-type: text/html\n" print "<HTML>\n" print "<HEAD>\n" print "<TITLE>Submission unsuccessful</TITLE>" print "</HEAD>\n" print "<BODY>\n" print "<H1>Submission unsuccessful</H1>\n" print "<P>The following fields were missing:</P>\n" print "<UL>" for field in missing: print " <LI>"+field print "</UL>" print "<P>Please try again.</P>" print "</BODY>\n"; print "</HTML>\n" OK=1 sys.exit() # Set up the email # # This is code that will detect a mail recipient coded # into the HTML form. It is disabled to prevent the # unauthorized use of this script as a remailer. # # if form.has_key("email"): # mailrecip=form["email"].value # OK = 1 # LBBemail.testemail(mailrecip) if form.has_key("Approvers_Email"): sendor = form["Approvers_Email"].value if OE == 1 : sendor = form["Other_Email"].value OK = 1 A = LBBemail.testemail(sendor) # # Produce email. Check to see if form keys are used # prior to attempting to check their value or an # error will result. # out=StringIO.StringIO() out.write("To: %s\n" % A) out.write("Reply-to: %s\n" % mailrecip) out.write("Subject: %s\n\n" % subject) out.write(form["Your_Name"].value) out.write(" has requested access to the K86Tech web site\n") out.write("and has routed this request to you for approval. If you approve\n") out.write("this request, REPLY to this email, type APPROVED, then send, \n") out.write("including the information below, to %s\n\n" % mailrecip) out.write("The information submitted is:\n\n") # if form.has_key("Link") : # local_link = `form["Link"].value` # local_comments = "(none)" # local_comments = `form["comments"].value` C1 = "" C = "Test" # Telephone R = ( "Name: " + `form["Your_Name"].value` + "\n\n" + "Login: " + `form["Login"].value` + "\n\n" + "Temporary Password: " + `form["Password"].value` + "\n\n" + "Telephone: " + `form["Telephone"].value` + "\n\n" + "Email: " + youremail + "\n\n" ) if form.has_key("Comments") : C1 = "Comments:\n" + form["Comments"].value + "\n\n" C = R + C1 D = string.replace(C, "'", "") out.write(D) out.write("\n\nConfirmation was mailed to " + youremail) # # This is old code that scanned all form fields and printed the values. # It was replaced by the field-specific code, above. # # out.write("\n\n====================================\n") # out.write("\n\nThis is a complete listing of all raw data:\n\n") # for fieldname in form.keys(): # if fieldname != "REQUIRED" and fieldname != "submit" and fieldname != "": # out.write("---"+ fieldname +": \n") # B = form[fieldname].value # out.write( B + "\n\n") # Send email mail=smtplib.SMTP(mailserver) # mail.sendmail(mailrecip,[mailrecip],out.getvalue()) mail.sendmail(A,[A],out.getvalue()) # Print confirmation print "Content-type: text/html\n" print "<HTML>\n" print "<HEAD>\n" print "<TITLE>Submission successful</TITLE>" print "<meta http-equiv="refresh" content="3;URL=index.html">" print "</HEAD>\n" print "<BODY>\n" print "<H1>Submission successful</H1>\n" print "<P>Your submission has been mailed to the site administrators." print "<P>Confirmation has been sent to your email address." print "</P>\n" print "<P>Thank you.</P>\n" print "</BODY>\n"; print "</HTML>\n" # Send confirmation email to submittor. out2=StringIO.StringIO() out2.write("Reply-to: %s\n" % mailrecip) out2.write("From: %s\n" % mailrecip) out2.write("Subject: %s\n" % subject2) out2.write("To: %s\n\n" % `youremail`) out2.write("This is confirmation of your request for access\n") out2.write("to the K86Tech web site. Your request has been sent\nto ") out2.write(A) out2.write(" for approval.\n") out2.write("This email was automatically generated. The information\n") out2.write("you submitted was:\n\n\n") out2.write(D) mailrecip = youremail # TEST CODE # print "==============<P>\n\n" # print "Address: " # print A # rawtime = clock() # sub_time = localtime(rawtime) # print subtime # cgi.test() # END TEST CODE print "</P>\n" print "<P>Thank you.</P>\n" print "</BODY>\n"; print "</HTML>\n" # Send confirmation email to submittor. out2=StringIO.StringIO() out2.write("Reply-to: %s\n" % mailrecip) out2.write("From: %s\n" % mailrecip) out2.write("Subject: %s\n" % subject2) out2.write("To: %s\n\n" % `youremail`) out2.write("This is confirmation of your request for access\n") out2.write("to the K86Tech web site. Your request has been sent\nto ") out2.write(A) out2.write(" for approval.\n") out2.write("This email was automatically generated. The information\n") out2.write("you submitted was:\n\n\n") out2.write(D) mailrecip = youremail # TEST CODE # print "==============<P>\n\n" # print "Address: " # print A # rawtime = clock() # sub_time = localtime(rawtime) # print subtime # cgi.test() # END TEST CODEz Jason Brashear jason.brashear(a)amd.com Phone: 602-3708 ext. 53708 PCS: 296-4-AMD > /tutor

3 2

R: [Tutor] Having trouble with a form mail script.
by jason.brashear＠amd.com June 30, 2000

June 30, 2000

Thanks all You where all very helpful that solved the problem Blake. I did see what I missed. Thanks! But Blake why does Mine4 work? I see that you used ' ' instead if " " How and why does that work? Yours: print "<meta http-equiv="refresh" content="3;URL=index.html">" Mine4: print '<meta http-equiv="refresh" content="3;URL=index.html">' Mine5: print "<meta http-equiv=\"refresh\" content=\"3;URL=index.html\">" Jason Brashear jason.brashear(a)amd.com Phone: 602-3708 ext. 53708 PCS: 296-4-AMD

2 1

Class question
by masoga＠mail.com June 29, 2000

June 29, 2000

I read the tutorial several times and tried to run the examples in the tutorial but I get an error can someone explain to me what am I donig wrong!! Here is the class file: class BankAccount: def _init_(self, initialAmount): self.balance = initialAmount print "Account created with balance %5.2f" %self.balance def deposit(self, amount): self.balance = self.balance + amount def checkBalance(self): return self.balance Here is the code to test the above: from bankaccount import * a = BankAccount(500) a.deposit(100) print "A= ", a.checkBalance() Here is the error message: Traceback (innermost last): File "D:\Python1.52\Pythonwin\pywin\framework\scriptutils.py", line 237, in RunScript exec codeObject in __main__.__dict__ File "D:\Python1.52\deposit1.py", line 1, in ? from bankaccount import * File "bankaccount.py", line 3 self.balance = initialAmount ^ SyntaxError: invalid syntax Thanks masoga(a)mail.com ______________________________________________ FREE Personalized Email at Mail.com Sign up at http://www.mail.com/?sr=signup

4 3

(no subject)
by YaNkEeSfAn2485＠aol.com June 29, 2000

June 29, 2000

i need help

3 2

using global objects in classes
by Furmanek, Greg June 29, 2000

June 29, 2000

Here is a situation for you guys. I hope you can help me. I got 3 files. I want to create a global object which can be used in all three files. The definition of the class is in file 2. The object itself is created in main file (1). When I want to use the object in file 3 I get a NameErro. The only way I was able to use the global object is if I pass it to the new class. Is there any other way to define the object to be able to use it in any class without explicitly passing it into the class as an argument?? +----------------+ +----------------+ | | | | | file 1 - main | | file 2 | | global object | | class object | | created | | | | | | | | | | | | | | | | | | | +----------------+ +----------------+ +----------------+ | | | file 3 | | using global | | object | | | | | | | | | +----------------+

2 2

Function output
by william June 28, 2000

June 28, 2000

I guess I missed something fundamental in programming because I don't seem to find any references for this. A little background, I'm complete novice at programing with Python as my first language. (well a little Basic back in the 70's) I'm running Python on Windows 95 and I've been reading "Learning Python" , "Teach yourself Python in 24 hrs" and just about anything else I can find. The problem I'm having is how to get output from the functions in a module to the screen. I wanted to try writing something other than the book exercises to get a better feel for the process, I wrote a function that generated a random number and a second function that used that number to select from a list. When I type them in in the interactive prompt in Idle they do exactly that but when I place them in a module and save. They refuse to output to the screen either in Idle or from the DOS prompt. I've been working at this for several weeks and the error message(s) change depending on what I try, including no error message and no output. I added a test print message at the end and it does print so It appears to be that the function output isn't being captured or read. I'm less concerned with making this work than in why it won't and where I should be looking to find answers. W M Perry

7 8

RE: [Tutor] Function output
by alan.gauld＠bt.com June 28, 2000

June 28, 2000

> >From Idle screen: > > > >>> class rollum: > def funct1 (self): > s = " Hello World" > return s > def output (self): > a = funct1() > return a > > > >>> rollum.output() Others have picked up most of the points but for emphasis: the output function just returns a value. If you want to see that (outside of IDLE) you will need to use print. Thus it should be: >>> r = rollum() >>> print r.output() Alan G.

1 0

Re: [Tutor] Function output
by Wesley J. Chun June 28, 2000

June 28, 2000

> Date: Mon, 26 Jun 2000 22:51:42 -0500 > From: "William Perry" <wmperry(a)903internet.com> > > >>> class rollum: > def funct1 (self): > s = " Hello World" > return s > def output (self): > a = funct1() > return a > > >>> rollum.output() > Traceback (innermost last): > File "<pyshell#42>", line 1, in ? > rollum.output() > TypeError: unbound method must be called with class instance 1st argument > > >>> class rollum: > def funct1 (self): > s = " Hello World" > return s > def output (self): > a = funct1() > return a > def printer (self): > print self.output() > > >>> rollum.printer() > Traceback (innermost last): > File "<pyshell#47>", line 1, in ? > rollum.printer() > TypeError: unbound method must be called with class instance 1st argument hi... oh so close. the key to each problem you run into is due to the fact that the assignment you have in output() does not called with an instance. so change... > a = funct1() to > a = self.funct1() ... just like how you called self.output() from the printer method. then things should work fine. as you can probably tell when you call self.foo(), what's really happening is class.foo(self)... this is handled by the interpreter so you don't have to worry about (although you can make the latter call too)! if you wanted to try it, you would enter: rollum.funct1(self) # rather than self.funct1() in either case, an instance is passed in to appease the interpreter. hope this helps!! -wesley "Core Python Programming", Prentice-Hall, TBP Summer 2000 http://www.phptr.com/ptrbooks/ptr_0130260363.html http://www.softpro.com/languages-python.html wesley.j.chun :: wesc(a)alpha.ece.ucsb.edu cyberweb.consulting :: silicon.valley, ca http://www.roadkill.com/~wesc/cyberweb/

1 0