VhddlmZmZmZeZdZdZdZddl m Z m Z ddl m Z dZ ddlZdZd Zed k(reyy#e$r Zd ZYdZ[dZ[wwxYw) )absolute_importdivisionprint_functiona  module: odbc author: "John Westcott IV (@john-westcott-iv)" version_added: "1.0.0" short_description: Execute SQL using ODBC description: - Read/Write info using ODBC drivers. extends_documentation_fragment: - community.general.attributes attributes: check_mode: support: none diff_mode: support: none options: dsn: description: - The connection string passed into ODBC. required: true type: str query: description: - The SQL query to perform. required: true type: str params: description: - Parameters to pass to the SQL query. type: list elements: str commit: description: - Perform a commit after the execution of the SQL query. - Some databases allow a commit after a select whereas others raise an exception. - Default is V(true) to support legacy module behavior. type: bool default: true version_added: 1.3.0 requirements: - "pyodbc" notes: - Like the command module, this module always returns V(changed=true) whether or not the query would change the database. - 'To alter this behavior you can use C(changed_when): [true or false].' - For details about return values (RV(description) and RV(row_count)) see U(https://github.com/mkleehammer/pyodbc/wiki/Cursor). a+ - name: Set some values in the test db community.general.odbc: dsn: "DRIVER={ODBC Driver 13 for SQL Server};Server=db.ansible.com;Database=my_db;UID=admin;PWD=password;" query: "Select * from table_a where column1 = ?" params: - "value1" commit: false changed_when: false a results: description: List of lists of strings containing selected rows, likely empty for DDL statements. returned: success type: list elements: list description: description: "List of dicts about the columns selected from the cursors, likely empty for DDL statements. See notes." returned: success type: list elements: dict row_count: description: "The number of rows selected or modified according to the cursor defaults to V(-1). See notes." returned: success type: str ) AnsibleModulemissing_required_lib) to_nativeNTFc ftttdddtddtddtdd  }|jjd }|jjd }|jjd }|jjd}ts|j t dd} tj|}tdgdg} |j}|r|j||n|j||r|j |jD]?} g} | D]"} | j!dj| $|dj!| A|j"D]Z} i} | d| d<| dj$| d<| d| d<| d| d<| d| d<| d | d!<| d"| d#<|d$j!| \|j&|d%<|j+|j+|j,d(i|y#t$r5}|j djt|Yd}~d}~wwxYw#tj($r }Yd}~d}~wt$r4}|j d&jt|Yd}~d}~wwxYw#t$r4}|j d'jt|Yd}~d}~wwxYw#|j+wxYw))NstrT)typerequiredno_log)r r list)r elementsbool)r default)dsnqueryparamscommit) argument_specrrrrpyodbc)msgzFailed to connect to DSN: {0})changed description row_countresultsz{0}rrnamer  display_size internal_size precisionscalenullablerrz!Exception while reading rows: {0}zFailed to execute query: {0})rdictrget HAS_PYODBC fail_jsonrrconnect Exceptionformatrcursorexecuterfetchallappendr__name__rowcountProgrammingErrorclose exit_json)modulerrrr connectioneresultr2rownew_rowcolumnrow_descriptionrpes j/home/dcms/DCMS/lib/python3.12/site-packages/ansible_collections/community/general/plugins/modules/odbc.pymainrEas %$t<ED1Ve4VT2  F --  E "C MM  g &E ]]  x (F ]]  x (F 1(;<JS^^C(  F'""$  NN5& ) NN5 !  MMO [( 2!9FNN5<<#789y!((1  2$*#5#5 : &5a&8 F#&5a&8&A&A F#.=a.@ N+/>q/A O,+:1+= K('6q'9 G$*9!*< J'}%,,[9 :#)//F;    Fvg S<CCIaLQRRSP&&   [   !D!K!KIVWL!Y  Z Z [ R;BB9Q<PQQR szIrPswA@ - ^  "KA  J IX zFaJs;A AA