Skip to content

Database Manipulation - get_adapter_gateway_info Lab - Weeks 4/5 #4

@jwasserzug

Description

@jwasserzug
INSTRUCTIONS:
    1. Add a print function to the AdapterInfo class which should print the
       five values in the class
    2. Create a function called 'get_all_adapters_gateway_info' which does not
       take in any arguments.
    3. Print an introductory sentence inside this function
    4. Login to OAT's IORS database using get_data_from_mssql_db() and these
       connection parameters:
           server_port = DC-SQL01\SQM1,59897
           database    = iors_gts_oat_gts01
           user        = iors_gts_oat_gts01
           password    = iors_gts_oat_gts01
    5. Pass this query into get_data_from_mssql_db():
           SELECT * FROM iors_gts_oat_gts01.dbo.adapter_instance_config
           WHERE property_name in ('node', 'port', 'backupNode', 'backupPort');
    6. Make sure to save the data get_data_from_mssql_db returns in a variable.
    7. Create an object of type AdapterInfo and properly assign the values from
       the database into this new object. Make sure you create a new object for
       each adapter from the database. You should have 9 adapters/objects.
    8. Store each adapter_id, node and port in a dictionary
        - Key: adapter_id
        - Value: AdapterInfo object
    9. Print the adapter's details using the print function you created
    10. Return the dictionary

@vraghunandan @bdambola @kwokman @dsapienza @DRozentsvay @gganeshan @cbautista1002 @xingj53 @wcorrea @rklotz @isehgu @akbamaa

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions