GeezerVison is showing github.com — python-orm-benchmarks/benchmarks/sqlobject/test_a.py at dev · objectbox/python-orm-benchmarks

Expand file tree

test_a.py

Copy path

More file actions

25 lines (17 loc) · 645 Bytes

Copy path

25 lines (17 loc) · 645 Bytes

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

import gc

import os

import time

from random import choice

from models import Journal

LEVEL_CHOICE = [10, 20, 30, 40, 50]

count = int(os.environ.get("ITERATIONS", "1000"))

# SQLObject inserts the row when creating the object: only the values are prepared before the timer

values = [dict(level=choice(LEVEL_CHOICE), text=f"Insert from A, item {i}") for i in range(count)]

# Settle the GC: collect leftovers, keep existing objects out of collections while timed

gc.collect()

gc.freeze()

start = now = time.time()

for kwargs in values:

Journal(**kwargs)

now = time.time()

print(f"SQLObject, A: Rows/sec: {count / (now - start): 10.2f}")