def setUp(self):
self.connection = drda.connect(
host=self.host,
database=self.database,
user=self.user,
password=self.password,
port=self.port,
)
def hello():
conn = drda.connect(host='localhost', database='db', port=1527)
cur = conn.cursor()
cur.execute('select * from test')
strValue = ''
for r in cur.fetchall():
strValue = strValue + ' ' + str(r[0])
print(strValue)
return strValue
def connect(self):
self.initConnection()
try:
self.connector = drda.connect(host=self.hostname,
database=self.db,
port=self.port)
except drda.OperationalError as ex:
raise SqlmapConnectionException(getSafeExString(ex))
self.initCursor()
self.printConnected()
def setUp(self):
self.connection = drda.connect(
host=self.host,
database=self.database,
port=self.port,
)
cur = self.connection.cursor()
try:
cur.execute("""
CREATE TABLE test_basic (
s VARCHAR(20),
i int,
d1 decimal(2, 1),
d2 decimal(11, 2)
)
""")
except drda.OperationalError:
pass
cur.execute("DELETE FROM test_basic")
def setUp(self):
self.connection = drda.connect(
host=self.host,
database=self.database,
user=self.user,
password=self.password,
port=self.port,
)
cur = self.connection.cursor()
try:
cur.execute("DROP TABLE test_basic")
except drda.OperationalError:
pass
cur.execute("""
CREATE TABLE test_basic (
s varchar(20),
i int,
d1 decimal(2, 1),
d2 decimal(11, 2)
)
""")
self.connection.commit()
# -*- coding: utf-8 -*-
# Print Statement
print("Get Tabele Data")
# DRDA protocol (https://en.wikipedia.org/wiki/DRDA) python database driver.
import drda
conn = drda.connect(host='localhost', database='db', port=1527)
cur = conn.cursor()
cur.execute('select * from test')
for r in cur.fetchall():
print(r[0])
def setUp(self):
self.connection = drda.connect(
host=self.host,
database=self.database,
port=self.port,
)
