Guest User

Untitled

a guest
Feb 20th, 2018
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. # This results in 2 inserts
  2. my_objects = [{'a': 1, 'b': 2}, {'a': 1}]
  3. session.bulk_insert_mappings(MY_OBJECT, my_objects, render_nulls=True)
  4.  
  5. # This results in 2 inserts
  6. my_objects = [{'a': 1, 'b': 2}, {'a': 1}]
  7. session.bulk_insert_mappings(MY_OBJECT, my_objects, render_nulls=False)
  8.  
  9. # This results in 2 inserts
  10. my_object = [{'a': 1, 'b': 2}, {'a': 1, 'b': None}]
  11. session.bulk_insert_mappings(MY_OBJECT, my_objects, render_nulls=False)
  12.  
  13. # This results in 1 insert - BETTER PERFORMANCE
  14. my_object = [{'a': 1, 'b': 2}, {'a': 1, 'b': None}]
  15. session.bulk_insert_mappings(MY_OBJECT, my_objects, render_nulls=True)
  16.  
  17. # This will result in 2 inserts - BETTER PERFORMANCE
  18. my_objects = [{'a': 1, 'b': 2}, {'a': 2, 'b': 3}, {'a': 4}]
  19. session.bulk_insert_mappings(MY_OBJECT, my_objects)
  20. # This will result in 3 inserts
  21. my_objects = [{'a': 1, 'b': 2}, {'a': 4}, {'a': 2, 'b': 3}]
  22. session.bulk_insert_mappings(MY_OBJECT, my_objects)
Add Comment
Please, Sign In to add comment