AOO410/main/qadevOOo/tests/basic/ifc/sdbc/XResultSetUpdate/sdbc_XResultSetUpdate.xba

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">
<script:module xmlns:script="http://openoffice.org/2000/script" script:name="sdbc_XResultSetUpdate" script:language="StarBasic">


'*************************************************************************
'
'  Licensed to the Apache Software Foundation (ASF) under one
'  or more contributor license agreements.  See the NOTICE file
'  distributed with this work for additional information
'  regarding copyright ownership.  The ASF licenses this file
'  to you under the Apache License, Version 2.0 (the
'  "License"); you may not use this file except in compliance
'  with the License.  You may obtain a copy of the License at
'  
'    http://www.apache.org/licenses/LICENSE-2.0
'  
'  Unless required by applicable law or agreed to in writing,
'  software distributed under the License is distributed on an
'  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
'  KIND, either express or implied.  See the License for the
'  specific language governing permissions and limitations
'  under the License.
'
'*************************************************************************





'*************************************************************************
' This Interface/Service test depends on the following GLOBAL variables,
' which must be specified in the object creation:

'     - Global textColumn As String

'*************************************************************************





Sub RunTest()

'*************************************************************************
' INTERFACE: 
' com.sun.star.sdbc.XResultSetUpdate
'*************************************************************************
On Error Goto ErrHndl
    Dim bOK As Boolean
    Dim iCount As Integer
    Dim cString As String
    Dim colIdx As Integer
    
    colIdx = oObj.findColumn(textColumn)

    Test.StartMethod("insertRow()")
    bOK = true
    iCount = countRows()
    Out.Log("Initially " + countRows() + " records")
    oObj.moveToInsertRow()
    oObj.updateString(colIdx, "New string")
    oObj.insertRow()
    Out.Log("After inserting " + countRows() + " records")
    oObj.last()
    bOK = bOK AND oObj.getString(colIdx) = "New string"
    bOK = bOK AND iCount = countRows() - 1
    Test.MethodTested("insertRow()", bOK)

    Test.StartMethod("cancelRowUpdates()")
    bOK = true
    oObj.last()
    oObj.updateString(colIdx, "Changed string")
    oObj.cancelRowUpdates()
    bOK = bOK AND oObj.getString(colIdx) = "New string"
    bOK = bOK AND iCount = countRows() - 1
    Test.MethodTested("cancelRowUpdates()", bOK)

    Test.StartMethod("updateRow()")
    bOK = true
    oObj.last()
    oObj.updateString(colIdx, "Changed string")
    oObj.updateRow()
    bOK = bOK AND oObj.getString(colIdx) = "Changed string"
    bOK = bOK AND iCount = countRows() - 1
    Test.MethodTested("updateRow()", bOK)

    Test.StartMethod("deleteRow()")
    Dim rowsBefore As Integer, rowsAfter As Integer
    bOK = true
    rowsBefore = countRows()
    oObj.Last()
    oObj.deleteRow()
    rowsAfter = countRows()
    Out.Log("Rows before: " + rowsBefore + ", rows after: " + rowsAfter)
    bOK = bOK AND iCount = rowsAfter
    oObj.Last()
    Out.Log(oObj.getString(colIdx))
    Test.MethodTested("deleteRow()", bOK)

    Test.StartMethod("moveToInsertRow()")
    bOK = true
    oObj.moveToInsertRow()
    bOK = bOK AND oObj.getString(colIdx) = ""
    Test.MethodTested("moveToInsertRow()", bOK)

    Test.StartMethod("moveToCurrentRow()")
    bOK = true
    oObj.first()
    oObj.next()
    cString = oObj.getString(colIdx)
    oObj.moveToInsertRow()
    oObj.moveToCurrentRow()
    bOK = bOK AND oObj.getString(colIdx) = cString
    Test.MethodTested("moveToCurrentRow()", bOK)

Exit Sub
ErrHndl:
    Test.Exception()
    bOK = false
    resume next
End Sub
Function countRows() As Integer
    Dim iCount As Integer
    iCount = 0
    oObj.first()
    while NOT oObj.isAfterLast()
        iCount = iCount + 1
        oObj.next()
    wend
    countRows() = iCount
End Function
</script:module>