MySQLDatabase

Description

The MySQLDatabase object can be used to connect to a MySQL database server.

› 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 {
    MySQLDatabase {
        server: "127.0.0.1"
        user: "root"
        password: "mysql"
        name: "mysql"

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

    onCompleted: checkVersionQuery.execute()
}