Querying Data
After you use the steps in Connecting to connect, and use one of the methods in Reflecting Metadata to reflect some of the metadata, you can use a session object to query data.
Querying Data Using the Query Method
If the mapping class has been prepared, use it with a session object to query the data source. After binding the engine to the session, provide the mapping class to the session's query method.For example:
engine = create_engine("azuredevops:///?AuthScheme=Basic;Organization=MyAzureDevOpsOrganization;Catalog=Project_dev;Schema=Project;PersonalAccessToken=MyPAT;") factory = sessionmaker(bind=engine) session = factory() for instance in session.query(WorkItems).filter_by(Reason="Manual"): print("Id: ", instance.Id) print("Id: ", instance.Id) print("BuildNumber: ", instance.BuildNumber) print("---------")
Querying Data Using the Execute Method
The session object can also run the query with the execute() method alongside the appropriate Table object. Assuming you have an active session, the following is just as viable:WorkItems_table = WorkItems.metadata.tables["WorkItems"] for instance in session.execute(WorkItems_table.select().where(WorkItems_table.c.Reason == "Manual")): print("Id: ", instance.Id) print("FullName: ", instance.Name) print("City: ", instance.BillingCity) print("---------")