PostgreSQLDatabase

Description

The PostgreSQLDatabase object can be used to connect to a PostgreSQL database server.

This object was introduced in InCore 2.4.

› Inherits:NetworkDatabase

Overview

Properties

NetworkDatabase.password NetworkDatabase.port NetworkDatabase.server NetworkDatabase.user Database.autoOpen Database.closeOnConnectionError

Database.debugSqlQueries Database.error Database.errorDetails Database.errorString Database.name Database.ready

Database.reopenInterval Database.sqlQueries Database.tables Object.objectId Object.parent

Methods

Database.close() Database.dropAllTables() Database.open() Object.deserializeProperties() Object.fromJson() Object.serializeProperties() Object.toJson()

Signals

Database.errorOccurred() Database.sqlQueriesDataChanged() Database.tablesDataChanged() Object.completed()

Enumerations

Database.Error

Properties

Example

import InCore.Foundation 2.5
import InCore.Database 2.5

Application {
    PostgreSQLDatabase {
        user: "postgres"
        password: "postgres"
        server: "localhost"

        sqlQueries: [
            DatabaseSqlQuery {
                id: checkVersionQuery
                query: ("SELECT version();" )
                onErrorOccurred: console.log(errorString)
                onResultsChanged: console.log(JSON.stringify(results))
            }
        ]
    }

    onCompleted: checkVersionQuery.execute()
}