Macros/Base/ba002

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Macros
• General Macros
• Macros for Writer
• Macros for Calc
• Macros for Impress
• Macros for Draw
• Macros for Base
• Macros for Math
• Basic/Python

Description

Execute update in current database

Basic

Sub main()
    doc = ThisComponent
    conn = doc.DataSource.getConnection("", "")

    sql = "UPDATE ""contactos"" SET ""numbers""=TRIM(""numbers"")"
    cursor = conn.prepareStatement(sql)
    result = cursor.executeUpdate()
    doc.store()
    MsgBox result
End Sub

Python

def main():
    doc = XSCRIPTCONTEXT.getDocument()
    conn = doc.DataSource.getConnection('', '')

    sql = 'UPDATE "contactos" SET "numbers"=TRIM("numbers")'
    cursor = conn.prepareStatement(sql)
    result = cursor.executeUpdate()
    doc.store()
    print(result)  # silent if Python console is absent
    return

Note: Input/Output to screen helps overcoming the absence of Python standard output. Python scripts can be prototyped by use of the Python shell and its Read Execute Print Loop (REPL) mechanism. Refer to Output to Consoles in order to enable such facility