Connection string not working for Python 2.7 and PostgreSQL 9.1

Question

I am making a user management system using PyQT4 + PostgreSQL 9.1. While writing the following code for establishing connection with the database, i get syntax error :-

from PyQt4 import QtSql, QtGui , QtCore
import _sha256
import psycopg2


def createConnection(): 

    QSqlDatabase db = QSqlDatabase.addDatabase("QPSQL"); 
    db.setDatabaseName("mysite");
    db.setUserName("postgres");
    db.setPassword("password");
    db.setHostName("localhost");
    bool ok = db.open();
    if not db.open():
        QtGui.QMessageBox.critical(None, QtGui.qApp.tr("Cannot open database"),
                QtGui.qApp.tr("Unable to establish a database connection.\n"
                              "This example needs PostgreSQL support."),
                QtGui.QMessageBox.Cancel)
        return False

    query = QtSql.QSqlQuery()
    query.exec_("create table usermanagement(ID int primary key,"
                "userid int,firstname varchar(20), lastname varchar(20),usertype varchar(15),password varchar(20),)")
    query.exec_("insert into usermanagement values(1, 'Danny','Boyle','normaluser','normaluser')")

    return True

The error message is as follows:-

QSqlDatabase db = QSqlDatabase.addDatabase("QPSQL"); ^ SyntaxError: invalid syntax

Wooble · Accepted Answer · 2012-08-30 11:23:23Z

1

You can't declare variable types in Python; a classname followed by a space followed by a variable name is not Python syntax.

Just do db = QSqlDatabase.addDatabase("QPSQL").

(You have the same problem at bool ok = ...)

Your code also doesn't define QSqlDatabase anywhere to begin with; presumably you mean to import it from somewhere.

Also remove all of the semicolons from your code; they're not required as statement terminators in Python and are considered bad style.

edited Aug 30, 2012 at 11:23

answered Aug 30, 2012 at 11:11

Wooble

90.5k12 gold badges111 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chetan Over a year ago

i don't get any errors after making the above changes.However, the table does not get created in PostgreSQL when i run the python file.

Chetan Over a year ago

db = QtSql.QSqlDatabase.addDatabase("QPSQL") db.setDatabaseName("mysite") db.setUserName("postgres") db.setPassword("password") db.setHostName("localhost") ok = db.open()

Collectives™ on Stack Overflow

Connection string not working for Python 2.7 and PostgreSQL 9.1

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related