Events Script Sample

#-----------------------------------------------------------------------------
# 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["LOCATION"])
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)