-
Notifications
You must be signed in to change notification settings - Fork 35
Expand file tree
/
Copy pathcopyman.py
More file actions
841 lines (712 loc) · 21.9 KB
/
copyman.py
File metadata and controls
841 lines (712 loc) · 21.9 KB
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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
##
# .copyman - COPY manager
##
"""
Manage complex COPY operations; one-to-many COPY streaming.
Primarily this module houses the `CopyManager` class, and the `transfer`
function for a high-level interface to using the `CopyManager`.
"""
import sys
from abc import abstractmethod, abstractproperty
from collections.abc import Iterator
from .python.element import Element, ElementSet
from .python.structlib import ulong_unpack, ulong_pack
from .protocol.buffer import pq_message_stream
from .protocol.element3 import CopyData, CopyDone, Complete, cat_messages
from .protocol.xact3 import Complete as xactComplete
#: 10KB buffer for COPY messages by default.
default_buffer_size = 1024 * 10
class Fault(Exception):
pass
class ProducerFault(Fault):
"""
Exception raised when the Producer caused an exception.
Normally, Producer faults are fatal.
"""
def __init__(self, manager):
self.manager = manager
def __str__(self):
return "producer raised exception"
class ReceiverFault(Fault):
"""
Exception raised when Receivers cause an exception.
Faults should be trapped if recovery from an exception is
possible, or if the failed receiver is optional to the succes of the
operation.
The 'manager' attribute is the CopyManager that raised the fault.
The 'faults' attribute is a dictionary mapping the receiver to the exception
instance raised.
"""
def __init__(self, manager, faults):
self.manager = manager
self.faults = faults
def __str__(self):
return "{0} faults occurred".format(len(self.faults))
class CopyFail(Exception):
"""
Exception thrown by the CopyManager when the COPY operation failed.
The 'manager' attribute the CopyManager that raised the CopyFail.
The 'reason' attribute is a string indicating why it failed.
The 'receiver_faults' attribute is a mapping of receivers to exceptions that were
raised on exit.
The 'producer_fault' attribute specifies if the producer raise an exception
on exit.
"""
def __init__(self, manager, reason = None,
receiver_faults = None,
producer_fault = None,
):
self.manager = manager
self.reason = reason
self.receiver_faults = receiver_faults or {}
self.producer_fault = producer_fault
def __str__(self):
return self.reason or 'copy aborted'
# The identifier for PQv3 copy data.
PROTOCOL_PQv3 = "PQv3"
# The identifier for iterables of copy data sequences.
# iter([[row1, row2], [row3, row4]])
PROTOCOL_CHUNKS = "CHUNKS"
# The protocol identifier for NULL producers and receivers.
PROTOCOL_NULL = None
class ChunkProtocol(object):
__slots__ = ('buffer',)
def __init__(self):
self.buffer = pq_message_stream()
def __call__(self, data):
self.buffer.write(bytes(data))
return [x[1] for x in self.buffer.read()]
# Null protocol mapping.
def EmptyView(arg):
return memoryview(b'')
def EmptyList(arg):
return []
def ReturnNone(arg):
return None
# Zero-Transformation
def NoTransformation(arg):
return arg
# Copy protocols being at the Python level; *not* wire/serialization format.
copy_protocol_mappings = {
# PQv3 -> Chunks
(PROTOCOL_PQv3, PROTOCOL_CHUNKS) : ChunkProtocol,
# Chunks -> PQv3
(PROTOCOL_CHUNKS, PROTOCOL_PQv3) : lambda: cat_messages,
# Null Producers and Receivers
(PROTOCOL_NULL, PROTOCOL_PQv3) : lambda: EmptyView,
(PROTOCOL_NULL, PROTOCOL_CHUNKS) : lambda: EmptyList,
(PROTOCOL_PQv3, PROTOCOL_NULL) : lambda: ReturnNone,
(PROTOCOL_CHUNKS, PROTOCOL_NULL) : lambda: ReturnNone,
# Zero Transformations
(PROTOCOL_NULL, PROTOCOL_NULL) : lambda: NoTransformation,
(PROTOCOL_CHUNKS, PROTOCOL_CHUNKS) : lambda: NoTransformation,
(PROTOCOL_PQv3, PROTOCOL_PQv3) : lambda: NoTransformation,
}
# Used to manage the conversions of COPY data.
# Notably, chunks -> PQv3 or PQv3 -> chunks.
class CopyTransformer(object):
__slots__ = ('current', 'transformers', 'get')
def __init__(self, source_protocol, target_protocols):
self.current = {}
self.transformers = {
x : copy_protocol_mappings[(source_protocol, x)]()
for x in set(target_protocols)
}
self.get = self.current.__getitem__
def __call__(self, data):
for protocol, transformer in self.transformers.items():
self.current[protocol] = transformer(data)
##
# This is the object that does the magic.
# It tracks the state of the wire.
# It ends when non-COPY data is found.
class WireState(object):
"""
Manages the state of the wire.
This class manages three possible positions:
1. Between wire messages
2. Inside message header
3. Inside message (with complete header)
The wire state will become unusable when the configured condition is True.
"""
__slots__ = ('remaining_bytes', 'size_fragment', 'final_view', 'condition',)
def update(self, view, getlen = ulong_unpack, len = len):
"""
Given the state of the COPY and new data, advance the position on the
COPY stream.
"""
# Only usable until the terminating condition.
if self.final_view is not None:
raise RuntimeError("wire state encountered exceptional condition")
nmessages = 0
# State carried over from prior run.
remaining_bytes = self.remaining_bytes
size_fragment = self.size_fragment
# Terminating condition.
CONDITION = self.condition
# Is it a continuation of a message header?
if remaining_bytes == -1:
##
# Inside message header; after message type.
# Continue adding to the 'size_fragment'
# until there are four bytes to unpack.
##
o = len(size_fragment)
size_fragment += bytes(view[:4-o])
if len(size_fragment) == 4:
# The size fragment is completed; only part
# of the fragment remains to be consumed.
remaining_bytes = getlen(size_fragment) - o
size_fragment = b''
else:
assert len(size_fragment) < 4
# size_fragment got updated..
if remaining_bytes >= 0:
vlen = len(view)
while True:
if remaining_bytes:
##
# Inside message body. Message length has been unpacked.
##
view = view[remaining_bytes:]
# How much is remaining now?
rb = remaining_bytes - vlen
if rb <= 0:
# Finished it.
vlen = -rb
remaining_bytes = 0
nmessages += 1
else:
vlen = 0
remaining_bytes = rb
##
# In between protocol messages.
##
if not view:
# no more data to analyze
break
# There is at least one byte in the view.
if CONDITION(view[0]):
# State is dead now.
# User needs to handle unexpected message, then continue.
self.final_view = view
assert remaining_bytes == 0
break
if vlen < 5:
# Header continuation.
remaining_bytes = -1
view = view[1:]
size_fragment += bytes(view)
# Not enough left for the header of the next message?
break
# Update remaining_bytes to include the header, and start over.
remaining_bytes = getlen(view[1:5]) + 1
# Update the state for the next update.
self.remaining_bytes, self.size_fragment = (
remaining_bytes, size_fragment,
)
# Emit the number of messages "consumed" this round.
return nmessages
def __init__(self, condition = (CopyData.type[0].__ne__ if isinstance(memoryview(b'f')[0], int) else CopyData.type.__ne__)):
self.remaining_bytes = 0
self.size_fragment = b''
self.final_view = None
self.condition = condition
class Fitting(Element):
_e_label = 'FITTING'
def _e_metas(self):
yield None, '[' + self.state + ']'
@abstractproperty
def protocol(self):
"""
The COPY data format produced or consumed.
"""
# Used to setup the Receiver/Producer
def __enter__(self):
pass
# Used to tear down the Receiver/Producer
def __exit__(self, typ, val, tb):
pass
class Producer(Fitting, Iterator):
_e_label = 'PRODUCER'
def _e_metas(self):
for x in super()._e_metas():
yield x
yield 'data', str(self.total_bytes / (1024**2)) + 'MB'
yield 'messages', self.total_messages
yield 'average size', (self.total_bytes / self.total_messages)
def __init__(self):
self.total_messages = 0
self.total_bytes = 0
@abstractmethod
def realign(self):
"""
Method implemented by producers that emit COPY data that is not
guaranteed to be aligned.
This is only necessary in failure cases where receivers still need more
data to complete the message.
"""
@abstractmethod
def __next__(self):
"""
Produce the next set of data.
"""
class Receiver(Fitting):
_e_label = 'RECEIVER'
@abstractmethod
def transmit(self):
"""
Finish the reception of the accepted data.
"""
@abstractmethod
def accept(self, data):
"""
Take the data object to be processed.
"""
class NullProducer(Producer):
"""
Produces no copy data.
"""
_e_factors = ()
protocol = PROTOCOL_NULL
def realign(self):
# Never needs to realigned.
pass
def __next__(self):
raise StopIteration
class IteratorProducer(Producer):
_e_factors = ('iterator',)
protocol = PROTOCOL_CHUNKS
def __init__(self, iterator):
self.iterator = iter(iterator)
self.__next__ = self.iterator.__next__
super().__init__()
def realign(self):
# Never needs to realign; data is emitted on message boundaries.
pass
def __next__(self, next = next):
n = next(self.iterator)
self.total_messages += len(n)
self.total_bytes += sum(map(len, n))
return n
class ProtocolProducer(Producer):
"""
Producer using a PQv3 data stream.
Normally, this class needs to be subclassed as it assumes that the given
recv_into function will write COPY messages.
"""
protocol = PROTOCOL_PQv3
@abstractmethod
def recover(self, view):
"""
Given a view containing data read from the wire, recover the
controller's state.
This needs to be implemented by subclasses in order for the
ProtocolReceiver to pass control back to the original state machine.
"""
##
# When a COPY is interrupted, this can be used to accommodate
# the original state machine to identify the message boundaries.
def realign(self):
s = self._state
if s is None:
# It's already aligned.
self.nextchunk = iter(()).__next__
return
if s.final_view:
# It was at the end or non-COPY.
for_producer = bytes(s.final_view)
for_receivers = b''
elif s.remaining_bytes == -1:
# In the middle of a message header.
for_producer = CopyData.type + s.size_fragment
# receivers:
header = (self._state.size_fragment.ljust(3, b'\x00') + b'\x04')
# Don't include the already sent parts.
buf = header[len(self._state.size_fragment):]
bodylen = ulong_unpack(header) - 4
# This will often cause an invalid copy data error,
# but it doesn't matter much because we will issue a copy fail.
buf += b'\x00' * bodylen
for_receivers = buf
elif s.remaining_bytes > 0:
# In the middle of a message.
for_producer = CopyData.type + ulong_pack(s.remaining_bytes + 4)
for_receivers = b'\x00' * self._state.remaining_bytes
else:
for_producer = for_receivers = b''
self.recover(for_producer)
if for_receivers:
self.nextchunk = iter((for_receivers,)).__next__
else:
self.nextchunk = iter(()).__next__
def process_copy_data(self, view):
self.total_messages += self._state.update(view)
if self._state.final_view is not None:
# It's not COPY data.
fv = self._state.final_view
# Only publish up to the final_view.
if fv:
view = view[:-len(fv)]
# The next next() will handle the async, error, or completion.
self.recover(fv)
self._state = None
self.total_bytes += len(view)
return view
# Given a view, begin tracking the state of the wire.
def track_state(self, view):
self._state = WireState()
self.nextchunk = self.recv_view
return self.process_copy_data(view)
# The usual method for receiving more data.
def recv_view(self):
view = self.buffer_view[:self.recv_into(self.buffer, self.buffer_size)]
if not view:
# Zero read; let the subclass handle the situation.
self.recover(memoryview(b''))
return self.nextchunk()
view = self.process_copy_data(view)
return view
def nextchunk(self):
raise RuntimeError("producer not properly initialized")
def __next__(self):
return self.nextchunk()
def __init__(self,
recv_into,
buffer_size = default_buffer_size
):
super().__init__()
self.recv_into = recv_into
self.buffer_size = buffer_size
self.buffer = bytearray(buffer_size)
self.buffer_view = memoryview(self.buffer)
self._state = None
class StatementProducer(ProtocolProducer):
_e_factors = ('statement', 'parameters',)
def _e_metas(self):
for x in super()._e_metas():
yield x
@property
def state(self):
if self._chunks is None:
return 'created'
return 'producing'
def count(self):
return self._chunks.count()
def command(self):
return self._chunks.command()
def __init__(self, statement, *args, **kw):
super().__init__(statement.database.pq.socket.recv_into, **kw)
self.statement = statement
self.parameters = args
self._chunks = None
##
# Take any data held by the statement's chunks and connection.
def confiscate(self, next = next):
current = []
try:
while not current:
current.extend(next(self._chunks))
except StopIteration:
if not current:
# End of COPY.
raise
pq = self._chunks.database.pq
buffer = cat_messages(current) + pq.message_buffer.getvalue() + (pq.read_data or b'')
view = memoryview(buffer)
pq.read_data = None
pq.message_buffer.truncate()
# Reconstruct the buffer from the already parsed lines.
r = self.track_state(view)
# XXX: Better way? Probably shouldn't do the full track_state if complete..
if self._chunks._xact.state is xactComplete:
# It's over, don't hand off to recv_view.
self.nextchunk = self.confiscate
assert self._state.final_view is None
return r
def recover(self, view):
# Method used when non-COPY data is found.
self._chunks.database.pq.message_buffer.write(bytes(view))
self.nextchunk = self.confiscate
def __enter__(self):
super().__enter__()
if self._chunks is not None:
raise RuntimeError("receiver already used")
self._chunks = self.statement.chunks(*self.parameters)
# Start by confiscating the connection state.
self.nextchunk = self.confiscate
def __exit__(self, typ, val, tb):
if typ is None or issubclass(typ, Exception):
db = self.statement.database
if not db.closed and self._chunks._xact is not None:
# The COPY transaction is still happening,
# force an interrupt if the connection still exists.
db.interrupt()
if db.pq.xact:
# Raise, CopyManager should trap.
db._pq_complete()
super().__exit__(typ, val, tb)
class NullReceiver(Receiver):
_e_factors = ()
protocol = PROTOCOL_NULL
state = 'null'
def transmit(self):
# Nothing to do.
pass
def accept(self, data):
pass
class ProtocolReceiver(Receiver):
protocol = PROTOCOL_PQv3
__slots__ = ('send', 'view')
def __init__(self, send):
super().__init__()
self.send = send
self.view = memoryview(b'')
def accept(self, data):
self.view = data
def transmit(self):
while self.view:
self.view = self.view[self.send(self.view):]
def __enter__(self):
return self
def __exit__(self, typ, val, tb):
pass
class StatementReceiver(ProtocolReceiver):
_e_factors = ('statement', 'parameters',)
__slots__ = ProtocolReceiver.__slots__ + _e_factors + ('xact',)
def _e_metas(self):
yield None, '[' + self.state + ']'
def __init__(self, statement, *parameters):
self.statement = statement
self.parameters = parameters
self.xact = None
super().__init__(statement.database.pq.socket.send,)
# XXX: A bit of a hack...
# This is actually a good indication that statements need a .copy()
# execution method for producing a "CopyCursor" that reads or writes.
class WireReady(BaseException):
pass
def raise_wire_ready(self):
raise self.WireReady()
yield None
def __enter__(self, iter = iter):
super().__enter__()
# Get the connection in the COPY state.
try:
self.statement.load_chunks(
iter(self.raise_wire_ready()), *self.parameters
)
except self.WireReady:
# It's a BaseException; nothing should trap it.
# Note the transaction object; we'll use it on exit.
self.xact = self.statement.database.pq.xact
def __exit__(self, typ, val, tb):
if self.xact is None:
# Nothing to do.
return super().__exit__(typ, val, tb)
if self.view:
# The realigned producer emitted the necessary
# data for message boundary alignment.
#
# In this case, we unconditionally fail.
pq = self.statement.database.pq
# There shouldn't be any message_data, atm.
pq.message_data = bytes(self.view)
self.statement.database._pq_complete()
# It is possible for a non-alignment view to exist in cases of
# faults. However, exit should *not* be called in those cases.
##
elif typ is None:
# Success?
self.xact.messages = self.xact.CopyDoneSequence
# If not, this will blow up.
self.statement.database._pq_complete()
# Find the complete message for command and count.
for x in self.xact.messages_received():
if getattr(x, 'type', None) == Complete.type:
self._complete_message = x
elif issubclass(typ, Exception):
# Likely raises. CopyManager should trap.
self.statement.database._pq_complete()
return super().__exit__(typ, val, tb)
def count(self):
return self._complete_message.extract_count()
def command(self):
return self._complete_message.extract_command().decode('ascii')
class CallReceiver(Receiver):
"""
Call the given object with a list of COPY lines.
"""
_e_factors = ('callable',)
protocol = PROTOCOL_CHUNKS
def __init__(self, callable):
self.callable = callable
self.lines = None
super().__init__()
def transmit(self):
if self.lines is not None:
self.callable(self.lines)
self.lines = None
def accept(self, lines):
self.lines = lines
class CopyManager(Element, Iterator):
"""
A class for managing COPY operations.
Connects the producer to the receivers.
"""
_e_label = 'COPY'
_e_factors = ('producer', 'receivers',)
def _e_metas(self):
yield None, '[' + self.state + ']'
@property
def state(self):
if self.transformer is None:
return 'initialized'
return str(self.producer.total_messages) + ' messages transferred'
def __init__(self, producer, *receivers):
self.producer = producer
self.transformer = None
self.receivers = ElementSet(receivers)
self._seen_stop_iteration = False
rp = set()
add = rp.add
for x in self.receivers:
add(x.protocol)
self.protocols = rp
def __enter__(self):
if self.transformer:
raise RuntimeError("copy already started")
self._stats = (0, 0)
self.transformer = CopyTransformer(self.producer.protocol, self.protocols)
self.producer.__enter__()
try:
for x in self.receivers:
x.__enter__()
except Exception:
self.__exit__(*sys.exc_info())
return self
def __exit__(self, typ, val, tb):
##
# Exiting the CopyManager is a fairly complex operation.
#
# In cases of failure, re-alignment may need to happen
# for when the receivers are not on a message boundary.
##
if typ is not None and not issubclass(typ, Exception):
# Don't bother, it's an interrupt or sufficient resources.
return
profail = None
try:
# Does nothing if the COPY was successful.
self.producer.realign()
try:
##
# If the producer is not aligned to a message boundary,
# it can emit completion data that will put the receivers
# back on track.
# This last service call will move that data onto the receivers.
self._service_producer()
##
# The receivers need to handle any new data in their __exit__.
except StopIteration:
# No re-alignment needed.
pass
self.producer.__exit__(typ, val, tb)
except Exception as x:
# reference profail later.
profail = x
# No receivers? It wasn't a success.
if not self.receivers:
raise CopyFail(self, "no receivers", producer_fault = profail)
exit_faults = {}
for x in self.receivers:
try:
x.__exit__(typ, val, tb)
except Exception as e:
exit_faults[x] = e
if typ or exit_faults or profail or not self._seen_stop_iteration:
raise CopyFail(self,
"could not complete the COPY operation",
receiver_faults = exit_faults or None,
producer_fault = profail
)
def reconcile(self, r):
"""
Reconcile a receiver that faulted.
This method should be used to add back a receiver that failed to
complete its write operation, but is capable of completing the
operation at this time.
"""
if r.protocol not in self.protocols:
raise RuntimeError("cannot add new receivers to copy operations")
r.transmit()
# Okay, add it back.
self.receivers.add(r)
def _service_producer(self):
# Setup current data.
if not self.receivers:
# No receivers to take the data.
raise StopIteration
try:
nextdata = next(self.producer)
except StopIteration:
# Should be over.
self._seen_stop_iteration = True
raise
except Exception:
raise ProducerFault(self)
self.transformer(nextdata)
# Distribute data to receivers.
for x in self.receivers:
x.accept(self.transformer.get(x.protocol))
def _service_receivers(self):
faults = {}
for x in self.receivers:
# Process all the receivers.
try:
x.transmit()
except Exception as e:
faults[x] = e
if faults:
# The CopyManager is eager to continue the operation.
for x in faults:
self.receivers.discard(x)
raise ReceiverFault(self, faults)
# Run the COPY to completion.
def run(self):
with self:
try:
while True:
self._service_producer()
self._service_receivers()
except StopIteration:
# It's done.
pass
def __iter__(self):
return self
def __next__(self):
messages = self.producer.total_messages
bytes = self.producer.total_bytes
self._service_producer()
# Record the progress in case a receiver faults.
self._stats = (
self._stats[0] + (self.producer.total_messages - messages),
self._stats[1] + (self.producer.total_bytes - bytes),
)
self._service_receivers()
# Return the progress.
current_stats = self._stats
self._stats = (0, 0)
return current_stats
def transfer(producer, *receivers):
"""
Perform a COPY operation using the given statements::
>>> import copyman
>>> copyman.transfer(src.prepare("COPY table TO STDOUT"), dst.prepare("COPY table FROM STDIN"))
"""
cm = CopyManager(
StatementProducer(producer),
*[x if isinstance(x, Receiver) else StatementReceiver(x) for x in receivers]
)
cm.run()
return (cm.producer.total_messages, cm.producer.total_bytes)