def jdbc_test():
"""LJG: zxJDBC를 사용하면 한글처리가 에러나는데 JDBC를 직접 사용하면 한글처리가 성공한다
추후 시간을 갖고 한글관련 문제를 처리하자.오늘은 여기까지 새벽 3시다.. 정말 한글이 싫다.ㅋㅋ
"""
import sys
import java
from java.lang import Class
from java.sql import DriverManager, SQLException
jdbc_user = "******"
jdbc_password = "******"
jdbc_url = "jdbc:mysql://14.63.161.143/cdp"
DriverManager.registerDriver(Class.forName("com.mysql.jdbc.Driver").newInstance())
connection = DriverManager.getConnection(jdbc_url, jdbc_user, jdbc_password)
statement = connection.createStatement()
sql = "select * from test_sample"
rs = statement.executeQuery(sql)
while rs.next():
row = rs.getString(2)
print row
def simpleXmlUpdate(strArgs, caller):
DriverManager.registerDriver(
Class.forName(caller.jdbc_driver).newInstance())
connection = DriverManager.getConnection(caller.jdbc_url, caller.jdbc_user,
caller.jdbc_pass)
statement = connection.createStatement()
results = statement.executeUpdate(strArgs)
res = str(results)
return res
def simpleXmlQuery(strArgs, caller):
DriverManager.registerDriver(
Class.forName(caller.jdbc_driver).newInstance())
connection = DriverManager.getConnection(caller.jdbc_url, caller.jdbc_user,
caller.jdbc_pass)
statement = connection.createStatement()
results = statement.executeQuery(strArgs)
res = '<xml>\n' + "\n".join(XmlRowGenerator(results)) + '\n</xml>'
return res
def singleApduQuery(strArgs):
jdbc_url = "jdbc:sqlite:/root/test.db"
DriverManager.registerDriver(
Class.forName("org.sqlite.JDBC").newInstance())
connection = DriverManager.getConnection(jdbc_url, "", "")
statement = connection.createStatement()
results = statement.executeQuery(strArgs)
res = rowGenerator(results, lambda x: x.pop())
return res
def simpleQuery(strArgs):
jdbc_url = "jdbc:sqlite:/root/test.db"
DriverManager.registerDriver(
Class.forName("org.sqlite.JDBC").newInstance())
connection = DriverManager.getConnection(jdbc_url, "", "")
statement = connection.createStatement()
results = statement.executeQuery(strArgs)
#res= "\n".join (rowGenerator(results, '|'.join))
#res= "\n".join (rowGenerator(results, lambda x: str(len (x))))
res = "\n".join(stringRowGenerator(results, sep='\n'))
return res
def change_text(event):
lq1 = "SYSIBM"
aq1 = "%s.SQLSCHEMAS" % lq1
aq2 = "%s.SQLTABLES" % lq1
aq3 = "%s.SQLCOLUMNS" % lq1
aq4 = "select * from qsys2/systables select * from qsys2/syscolumns select * from qsys2/sysindexes"
DriverManager.registerDriver(AS400JDBCDriver())
logger.debug("Connecting...")
server = "AS400XO.noceast.dws.disney.com"
lq2 = "DVDSFIL"
tq1 = "%s.CTCMPF" % lq2
con = DriverManager.getConnection("jdbc:as400://%s/apilib;naming=sql;errors=full;date format=iso;extended dynamic=true;package=JDBCExa;package library=apilib" % server,
name, pwd)
logger.debug("Established Connection with: %s" % server)
query = "SELECT TABLE_NAME, TABLE_TEXT FROM %s where TABLE_SCHEM = '%s'" % (aq2, lq2)
#query = "SELECT COLUMN_NAME, COLUMN_TEXT, TYPE_NAME FROM %s where TABLE_SCHEM = '%s'" % (aq3, lq2)
logger.debug("Query: %s" % query)
stmnt = con.prepareStatement(query)
results = stmnt.executeQuery()
i = 0
while results.next():
i += 1
#logger.debug("%s" % results)
logger.debug("%s : %s" % (results.getString("TABLE_NAME"), results.getString("TABLE_TEXT")))
#logger.debug("%s : %s [%s]" % (results.getString("COLUMN_NAME"), results.getString("COLUMN_TEXT"), results.getString("TYPE_NAME")))
if i == 1000:
exit()
logger.debug("Success!")
from net.grinder.script import Test
testname = System.getProperty("sql.testname")
test = Test(0, testname)
testConfig = "./src/test/use-cases/"
sqlQueryFilename = testConfig + testname + ".sql"
connectionSettingsFile=testConfig + testname
jdbcConnectionSettings = Properties();
jdbcConnectionSettings.load( FileInputStream(connectionSettingsFile) )
sqlQuery = open(sqlQueryFilename,"r").readline()
# Load the JDBC drivers.
DriverManager.registerDriver(OracleDriver())
def getConnection():
return DriverManager.getConnection(jdbcConnectionSettings.getProperty("url"),
jdbcConnectionSettings.getProperty("username"),
jdbcConnectionSettings.getProperty("password"))
def ensureClosed(object):
try: object.close()
except: pass
class TestRunner:
def __call__(self):
connection = None
sqlStatement = None
try:
from net.grinder.script.Grinder import grinder
from net.grinder.script import Test
from java.util import Random
from java.sql import DriverManager
from com.mysql.jdbc import Driver
DriverManager.registerDriver(Driver())
p = grinder.getProperties()
p.setLong("grinder.threads", 8)
p.setLong("grinder.runs", 100000000)
p.setLong("grinder.duration", 120 * 1000)
t = Test(1, "Query")
def getConnection():
return DriverManager.getConnection(
"jdbc:mysql://server/geoip", "geoip", "geoip")
class TestRunner:
def __init__(self):
self.connection = getConnection()
def __call__(self):
r = Random()
s = self.connection.createStatement()
q = t.wrap(s)
