TSQL

[arademaker]

ts = itsdb.TestSuite('../data/own-00')
for row in tsql.select('i-id i-origin i-input i-comment', ts):
    print(row)
    break

output

('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
('1', '02433381-v-1', 'organize anew, as after a setback; ', 'def')
...

Hi @goodmami , can you explain that behavior? Am I right that the break statement should have been called after the first print? Yes, my profile does contain more than one result per item, but I am asking for only fields from the item file; why the repetition?

[arademaker]

Sorry, my fault... I was running inside a Jupiter notebook with the %%timeit directive. It seems to execute the code many times to get statistics...

[goodmami]

Glad you figured it out :)