scripts/puppet4ccb/vagrant-wls12c-centos64/puppet/modules/wls/templates/wlst/createJdbcDatasource.py.erb

wlsUser    = '<%= @wlsUser %>'  
password   = '<%= @password %>' 
machine    = '<%= @address %>'  
portNumber = '<%= @port %>'     

# init, will be overrided 
extraProperties            = ""
extraPropertiesValues      = ""
globalTransactionsProtocol = "xxxx"
                                
#dsName, jdbcDatasourceTargets, dsJNDIName,dsDriverName,dsURL,dsUserName,dsPassword,datasourceTargetType,globalTransactionsProtocol
<% @params.each do |param| -%>   
<%= param %>                    
<% end -%>                      

useStoreConfig = '<%= @useStoreConfig %>'

if useStoreConfig != "true":
    connect(wlsUser,password,'t3://'+machine+':'+portNumber)
else:
    connect(userConfigFile='<%= @userConfigFile %>', userKeyFile='<%= @userKeyFile %>', url='t3://'+machine+':'+portNumber)    

print "datasource " +dsName

datasourceTargets=String(jdbcDatasourceTargets).split(",")

if extraProperties:
   if extraPropertiesValues:
      properties=String(extraProperties).split(",")
      values=String(extraPropertiesValues).split(",")

      i = 0
      for property in properties:
        print "extra JDBC properties ",property, "=",values[i]
        i = i + 1

for datasourceTarget in datasourceTargets:
  print "Datasource Target",datasourceTarget

print "dsJNDIName " +dsJNDIName
print "dsDriverName " +dsDriverName
print "dsUserName " +dsUserName


edit()
startEdit()

try:
      cd('/')
      cmo.createJDBCSystemResource(dsName)
      cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName)
      cmo.setName(dsName)

      cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDataSourceParams/' + dsName )
      set('JNDINames',jarray.array([String('jdbc/' + dsName )], String))

      cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName )
      cmo.setUrl(dsURL)
      cmo.setDriverName( dsDriverName )
      cmo.setPassword(dsPassword)

      cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCConnectionPoolParams/' + dsName )
      cmo.setTestTableName('SQL SELECT 1 FROM DUAL')

      cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName + '/Properties/' + dsName )
      cmo.createProperty('user')
      cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName + '/Properties/' + dsName + '/Properties/user')
      cmo.setValue(dsUserName)

      if extraProperties:
          if extraPropertiesValues:
              properties=String(extraProperties).split(",")
              values=String(extraPropertiesValues).split(",")

              i = 0
              for property in properties:
                  cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName + '/Properties/' + dsName )
                  cmo.createProperty(property)
                  cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName + '/Properties/' + dsName + '/Properties/'+property)
                  cmo.setValue(values[i])
                  i = i + 1

      if globalTransactionsProtocol != "xxxx":
          cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDataSourceParams/' + dsName)
          cmo.setGlobalTransactionsProtocol('None')

      cd('/SystemResources/' + dsName )
      targetList = []
      for datasourceTarget in datasourceTargets:
        targetList.append( ObjectName('com.bea:Name=' + datasourceTarget + ',Type='+datasourceTargetType) )       

      set('Targets',jarray.array(targetList, ObjectName))

      save()
      activate()          

except:
      print "Unexpected error:", sys.exc_info()[0]
      undo('true','y')
      stopEdit('y')