Automated Python translation 2to3 error

Question

I want to translate Python2 code to Python 3.It is very simple,but it does not work

import sys
import MySQLdb
import Cookbook

try:
 conn = Cookbook.connect ()
print "Connected"
 except MySQLdb.Error, e:
 print "Cannot connect to server"
 print "Error code:", e.args[0]
 print "Error message:", e.args[1]
 sys.exit (1)

conn.close ()
print "Disconnected"

I got this in terminal

2to3 harness.py
RefactoringTool: Skipping optional fixer: buffer
RefactoringTool: Skipping optional fixer: idioms
RefactoringTool: Skipping optional fixer: set_literal
RefactoringTool: Skipping optional fixer: ws_comma
RefactoringTool: Can't parse harness.py: ParseError: bad input: type=1, value='print', context=('', (9, 0))
RefactoringTool: No files need to be modified.
RefactoringTool: There was 1 error:
RefactoringTool: Can't parse harness.py: ParseError: bad input: type=1, value='print', context=('', (9, 0))

Why?

Is this the indentation from your original file or was it messed up when posting here ? — Luci, Jul 25 '17 at 11:58
The indentation in itself is all effed up and in Python _identation is everything_. That's why it fails. — zwer, Jul 25 '17 at 12:09
If your program is not working only because of improper indentation, then your question itself is wrong — AKHIL MATHEW, Jul 25 '17 at 12:16

score 2 · Accepted Answer · answered Jul 25 '17 at 12:07

Don't know if this will solve your problem, but you could try fixing your indentation:

import sys
import MySQLdb
import Cookbook

try:
    conn = Cookbook.connect ()
    print "Connected"
except MySQLdb.Error, e:
    print "Cannot connect to server"
    print "Error code:", e.args[0]
    print "Error message:", e.args[1]
    sys.exit (1)

conn.close ()
print "Disconnected"

score 0 · Answer 2 · answered Jul 25 '17 at 12:01

0

I think the problem may be with MySQLdb. This package supports only upto 2.7 and won't support python 3. Currently MySQL-python 1.2.5 is the latest verions(25-07-2017)

MySQL versions 3.23 through 5.5 and Python-2.4 through 2.7 are currently supported. Python-3.0 will be supported in a future release. PyPy is supported.

answered Jul 25 '17 at 12:01

AKHIL MATHEW

1,237
2
29
59

No,I can use MySQLdb from python shell. – MishaVacic Jul 25 '17 at 12:07
What it prints for these lines print "Error code:", e.args[0] print "Error message:", e.args[1] – AKHIL MATHEW Jul 25 '17 at 12:10

score 0 · Answer 3 · answered Jul 25 '17 at 12:19

This is what 2to3 does

2to3 new.py
RefactoringTool: Skipping optional fixer: buffer
RefactoringTool: Skipping optional fixer: idioms
RefactoringTool: Skipping optional fixer: set_literal
RefactoringTool: Skipping optional fixer: ws_comma
RefactoringTool: Refactored new.py
--- new.py  (original)
+++ new.py  (refactored)
@@ -4,12 +4,12 @@

 try:
     conn = Cookbook.connect ()
-    print "Connected"
-except MySQLdb.Error, e:
-    print "Cannot connect to server"
-    print "Error code:", e.args[0]
-    print "Error message:", e.args[1]
+    print("Connected")
+except MySQLdb.Error as e:
+    print("Cannot connect to server")
+    print("Error code:", e.args[0])
+    print("Error message:", e.args[1])
     sys.exit (1)

 conn.close ()
-print "Disconnected"
+print("Disconnected")
RefactoringTool: Files that need to be modified:
RefactoringTool: new.py

I have changed furthermore

except MySQLdb.Error as e:

and now I have Python3 code.

Automated Python translation 2to3 error

3 Answers3