Support Additional Virtual Table Functionality in apsw 3.41.0.0

[cancan101]

See release notes, specifically:

• export colUsed to python BestIndex rogerbinns/apsw#278
• Support estimatedRows for virtual table best index rogerbinns/apsw#188
• Better xBestIndex handling rogerbinns/apsw#332

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

[betodealmeida]

Yeah! I started working on this, but had some problems compiling from source. With the new release I should be able to jus use the wheel. Will finish the branch.

[gfieremans]

@betodealmeida - see discussion in rogerbinns/apsw#428. You need to increment the value of the argvIndex in your function BestIndexObject():

for i, constraint in enumerate(constraints_used): if isinstance(constraint, tuple): index_info.set_aConstraintUsage_argvIndex(i, constraint[0]**+1**) index_info.set_aConstraintUsage_omit(i, constraint[1])

[betodealmeida]

Ah, thanks, I'll fix it!

[gfieremans]

By the way - I applied your bestindex branch to 1.2.0 and built it and everything is working great. Also was able to get the multiselect constraintargs in the Filter() method. if you're interested I can share my changes for that - although I wonder whether that's not too specific to my use case.

[betodealmeida]

Also was able to get the multiselect constraintargs in the Filter() method.

You mean supporting IN statements? That would be great!

[gfieremans]

Yes, that's why I went with the BestIndexObject you provided. Shall I checkout a branch off the bestindex branch?

[betodealmeida]

The best index branch has been merged in master, so you can just use master.

[betodealmeida]

(I should start deleting branches.)

[ananbas]

hi, can you elaborate how to support IN statements?