A starter for Python

[HiArt99]

I was looking on the forum for help to access the COM interface using Python and the only post I found dated back to 2013. I have had a little play and here is a starter that may help Python developers. I hope to create a class that can be imported into a jupyter workbook and will post the file here if I accomplish something.

You need to install Pythonnet

Code: Select all

pip3 install pythonnet

Import clr
Add a reference to the BettingAssistantCom.dll
You can then import the ComClass
Finally, create an instance of the ComClass

Code: Select all

import clr

clr.AddReference("c:/Program Files (x86)/Betting Assistant/BettingAssistantCom.dll")

from BettingAssistantCom.Application import ComClass

ba = ComClass()

From here you can access the COM methods:

Code: Select all

user_name = ba.getUserName()

print (user_name)

sports = ba.getSports()

for s in sports:
    print(f'{s.sport} {s.sportId}')

[Captain Sensible]

Good luck with that endeavour, I learnt some python ages ago for my own bots using the API, never got round to using the COM options on BA because I didn't think it provided as many options as going direct to the API and wasn't clued up with VBA ,C etc. Been looking at brushing up my python again so I'll be watching with intrest as I'm sure the COM has come a long way since it was introduced.

[HiArt99]

Well, here we go with a few caveats.

I am a c# (.net) programmer and python is a new language for me. Please excuse any non-python slip-ups.
I cannot get getHorseForm to return horse form, but you can still use getMetaData to access this data
I cannot get placeBets to return the bet Id for all the bets that it places.
Still ToDo is event handling. I'll come back to this when I have some spare time
WARNING: I had to add ".xlsm" to the file names to get around the Upload File filters. YOU MUST REMOVE this extension to use the files!
All the unit testing code works on my PC.

I have included the jupyter notebook I used to test the calls to the 'BAHandler' class as this provides examples on how to use the interface.

More than happy for folks with more python experience than me to add or amend these files.

Hopefully, this gives the python folks a leg up to using the COM interface.

Arthur

[GaryRussell]

I'll have a look when I get chance to see if getHorseForm and placeBets are issues I need to resolve.