Questo esempio di script di evento aggiorna la tabella table_xyz durante l'esecuzione del caricamento dati.
#-----------------------------------------------------------------------------
# Sample to update table_xyz table during data load rule execution
#-----------------------------------------------------------------------------
query = "UPDATE table_xyz SET accountx = 'SCRIPT_' || account WHERE loadid = ? and accountx is NULL"
params = [ fdmContext["LOADID"] ]
print fdmAPI.executeDML(query, params, False)
fdmAPI.commitTransaction()
#-----------------------------------------------------------------------------
# Sample to import data from a custom SQL source and upload into FDMEE
# open interface table. This script should be called in BefImport Event.
# This is alternate to the FDMEE integration import script.
#-----------------------------------------------------------------------------
import java.sql as sql
batchName = "Batch_" + str(fdmContext["LOCNAME"])
insertStmt = """
INSERT INTO AIF_OPEN_INTERFACE (
BATCH_NAME
,COL01
,COL02
,AMOUNT
,DESC1
) VALUES (
?
,?
,?
,?
,?
)
"""
sourceConn = sql.DriverManager.getConnection("jdbcUrl", "user", "password");
# Limiting number of rows to 5 during the test runs.
selectStmt = "SELECT * FROM orders WHERE rownum < 6"
stmt = sourceConn.prepareStatement(selectStmt)
stmtRS = stmt.executeQuery()
while(stmtRS.next()):
params = [ batchName, stmtRS.getBigDecimal("Customer_Id"),
stmtRS.getString("Ship_Country"),
stmtRS.getBigDecimal("Freight"), stmtRS.getString("Ship_Name") ]
fdmAPI.executeDML(insertStmt, params, False)
fdmAPI.commitTransaction()
stmtRS.close()
stmt.close()
sourceConn.close()
#------------------------------------------------------------------------------
# Sample to send email messages using Jython SMTP library
-------------------------------------------------------------------------------
import smtplib
sender = "from@gmail.com"
receivers = "to@gmail.com"
message = """ This is a test e-mail message.
This is a test e-mail message. """
try:
smtpServer = smtplib.SMTP('smtp.gmail.com:587')
smtpServer.starttls()
smtpServer.login("user", "password")
smtpServer.sendmail(sender, receivers, message)
print "Successfully sent email"
smtpServer.quit()
except Exception, e:
print "Error: unable to send email: " + str(e)
Nota:
Fare riferimento alla documentazione in linea di Jython al collegamento indicato di seguito che presenta le eccezioni di Jython e la sintassi da usare quando si rilevano eccezioni negli script. Per ulteriori informazioni sull'uso dei meccanismi di gestione delle eccezioni in Jython, fare riferimento alla sezione Gestione delle eccezioni e debug.
Questa nota si applica a tutti i tipi di script.