96 '''This class represents the initial handshake sent from server to client.'''
98 def __init__(self, packed=None, protocol_version=10, server_version=b'',
99 thread_id=0, scramble=tuple([0] * 20), null1=0, capabilities=0,
100 charset=0, status=0, unused=tuple([0] * 13), null2=0):
114 server_version_length = packed[1:].index(b
'\x00')
116 data = struct.unpack(
'<I8BB2BB2B13B12BB', packed[2+server_version_length:])
118 self.
scramble = data[1:9] + data[28:40]
124 self.
null2 = data[40]
129 data += struct.pack(
'<I', self.
thread_id)
131 data += struct.pack(
'B2BB2B',
136 self.
status.value() & 0xFF,
137 (self.
status.value() >> 8) & 0xFF)
138 data += bytes(self.
unused)
140 data += struct.pack(
'B', self.
null2)
144 return '''ServerHandshake
145 protocol_version = %s
161 def testDefaultInit(self):
166 def testKeywordInit(self):
168 server_version=b
'test',
170 scramble=tuple([5] * 20),
175 unused=tuple([6] * 13),
180 def testUnpackInit(self):
181 data = struct.pack(
'B', 11)
183 data += struct.pack(
'<I', 1234)
184 data += bytes([5] * 8)
185 data += struct.pack(
'B2BB2B', 1, 255, 254, 253, 252, 251)
186 data += bytes([6] * 13)
187 data += bytes([5] * 12)
188 data += struct.pack(
'B', 2)
197 def verifyDefault(self, handshake):
198 self.assertEqual(handshake.protocol_version, 10)
199 self.assertEqual(handshake.server_version, b
'')
200 self.assertEqual(handshake.thread_id, 0)
201 self.assertEqual(handshake.scramble, tuple([0] * 20))
202 self.assertEqual(handshake.null1, 0)
203 self.assertEqual(handshake.capabilities.value(), 0)
204 self.assertEqual(handshake.charset, 0)
205 self.assertEqual(handshake.status.value(), 0)
206 self.assertEqual(handshake.unused, tuple([0] * 13))
207 self.assertEqual(handshake.null2, 0)
209 def verifyCustom(self, handshake):
210 self.assertEqual(handshake.protocol_version, 11)
211 self.assertEqual(handshake.server_version, b
'test')
212 self.assertEqual(handshake.thread_id, 1234)
213 self.assertEqual(handshake.scramble, tuple([5] * 20))
214 self.assertEqual(handshake.null1, 1)
215 self.assertEqual(handshake.capabilities.value(), 65279)
216 self.assertEqual(handshake.charset, 253)
217 self.assertEqual(handshake.status.value(), 64508)
218 self.assertEqual(handshake.unused, tuple([6] * 13))
219 self.assertEqual(handshake.null2, 2)
222 '''This class represents the client handshake sent back to the server.'''
224 def __init__(self, packed=None, capabilities=0, max_packet_size=0, charset=0,
225 unused=tuple([0] * 23), user=b
'', scramble_size=0,
226 scramble=
None, db=b
''):
237 data = struct.unpack(
'<IIB23B', packed[:32])
243 user_length = packed.index(b
'\x00')
244 self.
user = packed[:user_length]
245 packed = packed[1+user_length:]
251 if packed[-1:] == b
'\x00':
252 self.
db = packed[21:-1]
254 self.
db = packed[21:]
257 data = struct.pack(
'<IIB',
261 data += bytes(self.
unused)
262 data += self.
user + b
'\x00'
266 data += self.
db + b
'\x00'
270 return '''ClientHandshake
284 def testDefaultInit(self):
289 def testKeywordInit(self):
291 max_packet_size=64508,
293 unused=tuple([6] * 23),
296 scramble=tuple([5] * 20),
301 def testUnpackInit(self):
302 data = struct.pack(
'<IIB', 65279, 64508, 253)
303 data += bytes([6] * 23)
306 data += bytes([5] * 20)
316 def verifyDefault(self, handshake):
317 self.assertEqual(handshake.capabilities.value(), 0)
318 self.assertEqual(handshake.max_packet_size, 0)
319 self.assertEqual(handshake.charset, 0)
320 self.assertEqual(handshake.unused, tuple([0] * 23))
321 self.assertEqual(handshake.user, b
'')
322 self.assertEqual(handshake.scramble_size, 0)
323 self.assertEqual(handshake.scramble,
None)
324 self.assertEqual(handshake.db, b
'')
326 def verifyCustom(self, handshake):
327 self.assertEqual(handshake.capabilities.value(), 65279)
328 self.assertEqual(handshake.max_packet_size, 64508)
329 self.assertEqual(handshake.charset, 253)
330 self.assertEqual(handshake.unused, tuple([6] * 23))
331 self.assertEqual(handshake.user, b
'user')
332 self.assertEqual(handshake.scramble_size, 20)
333 self.assertEqual(handshake.scramble, tuple([5] * 20))
334 self.assertEqual(handshake.db, b
'db')