python_sysadmin/oracleGenerateDataSource.py at master · neotycoder/python_sysadmin · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
#!/usr/bin/python

# Script Name: oracleDataSourceCreate.py
# Date: 06/30/2016
# Description: This is a simple script that will generate an XML stub for a WebSphere Liberty JVM's server.xml file.

"""
Sample Usage and Output:

./oracleGenerateDataSource.py
Application Name: appname
JNDI Name: jdbc/test
DB Server Name: dbserver
DB Port: 1521
DB Name: dbname
User: user
Password: thisismypassw0rd
{xor}Kzc2LDYsMiYvPiwsKG8tOw==

--------- CUT BELOW THIS LINE ---------

<!-- Data source entry for appname-->
<dataSource jndiName="jdbc/test" type="javax.sql.DataSource">
	<jdbcDriver libraryRef="oracleLib"/>
	<properties.oracle URL="jdbc:oracle:thin:@dbserver:1521:dbname" databaseName="dbname" driverType="thin" password="{xor}Kzc2LDYsMiYvPiwsKG8tOw==" portNumber="1521" serverName="dbserver" user="user"/>
</dataSource>
<!-- End Data source entry for appname-->

--------- CUT ABOVE THIS LINE ---------


"""

import subprocess

def inputOracleParam():
	"""Input all the required Oracle Parameters
	for the XML stub.
	"""

	# Input Appication Name
	appName=raw_input('Application Name: ')
	# Input JNDI
	jndi=raw_input('JNDI Name: ')
	# Input Server
	server = raw_input('DB Server Name: ')
	# Input Port
	port = raw_input('DB Port: ')
	# Input DB Name
	db = raw_input('DB Name: ')
	# Input user
	user = raw_input('User: ')
	# Input Password
	password = raw_input('Password: ')

	return appName, jndi, server, port, db, user, password

def createXML(appName, jndi, server, port, db, user, password):

	comment1="<!-- Data source entry for " + appName + "-->\n"
	ds1="<dataSource jndiName=\"" + jndi + "\" type=\"javax.sql.DataSource\">\n"
	ds2="\t<jdbcDriver libraryRef=\"oracleLib\"/>\n"
	ds3="\t<properties.oracle URL=\"jdbc:oracle:thin:@" + server + ":" + port + ":" + db + "\" databaseName=\"" + db + "\" driverType=\"thin\" password=\""+ password +"\" portNumber=\""+ port +"\" serverName=\""+ server +"\" user=\""+ user +"\"/>\n"
	ds4="</dataSource>\n"
	comment2="<!-- End Data source entry for " + appName + "-->\n"

	return comment1+ds1+ds2+ds3+ds4+comment2

def generateOutput(datasource):

	print "--------- CUT BELOW THIS LINE ---------\n"
	print datasource
	print "--------- CUT ABOVE THIS LINE ---------\n"

def encodePassword(password):

	# Path to securityUtility
	secUtilityPath="/opt/IBM/WebSphere/Liberty/bin/securityUtility "
	secUtilityParam1="encode "
	secUtilityParam2=" --notrim"
	cmd=secUtilityPath+secUtilityParam1+password+secUtilityParam2
	encodedPassword = subprocess.check_output(cmd, shell=True)

	return encodedPassword.rstrip("\n")

def main():
	appName, jndi, server, port, db, user, password = inputOracleParam()
	encodedPassword = encodePassword(password)
	datasource = createXML(appName, jndi, server, port, db, user, encodedPassword)
	generateOutput(datasource)

if __name__ == '__main__':
	main()