Vh|ddlmZmZmZeZdZdZdZddl m Z ddl m Z ddl mZmZmZmZmZdZed k(rey y ) )absolute_importdivisionprint_functiona  module: read_csv short_description: Read a CSV file description: - Read a CSV file and return a list or a dictionary, containing one dictionary per row. author: - Dag Wieers (@dagwieers) extends_documentation_fragment: - community.general.attributes attributes: check_mode: support: full diff_mode: support: none options: path: description: - The CSV filename to read data from. type: path required: true aliases: [filename] key: description: - The column name used as a key for the resulting dictionary. - If O(key) is unset, the module returns a list of dictionaries, where each dictionary is a row in the CSV file. type: str dialect: description: - The CSV dialect to use when parsing the CSV file. - Possible values include V(excel), V(excel-tab) or V(unix). type: str default: excel fieldnames: description: - A list of field names for every column. - This is needed if the CSV does not have a header. type: list elements: str unique: description: - Whether the O(key) used is expected to be unique. type: bool default: true delimiter: description: - A one-character string used to separate fields. - When using this parameter, you change the default value used by O(dialect). - The default value depends on the dialect used. type: str skipinitialspace: description: - Whether to ignore any whitespaces immediately following the delimiter. - When using this parameter, you change the default value used by O(dialect). - The default value depends on the dialect used. type: bool strict: description: - Whether to raise an exception on bad CSV input. - When using this parameter, you change the default value used by O(dialect). - The default value depends on the dialect used. type: bool seealso: - plugin: ansible.builtin.csvfile plugin_type: lookup description: Can be used to do selective lookups in CSV files from Jinja. a* # Example CSV file with header # # name,uid,gid # dag,500,500 # jeroen,501,500 # Read a CSV file and access user 'dag' - name: Read users from CSV file and return a dictionary community.general.read_csv: path: users.csv key: name register: users delegate_to: localhost - ansible.builtin.debug: msg: 'User {{ users.dict.dag.name }} has UID {{ users.dict.dag.uid }} and GID {{ users.dict.dag.gid }}' # Read a CSV file and access the first item - name: Read users from CSV file and return a list community.general.read_csv: path: users.csv register: users delegate_to: localhost - ansible.builtin.debug: msg: 'User {{ users.list.1.name }} has UID {{ users.list.1.uid }} and GID {{ users.list.1.gid }}' # Example CSV file without header and semi-colon delimiter # # dag;500;500 # jeroen;501;500 # Read a CSV file without headers - name: Read users from CSV file and return a list community.general.read_csv: path: users.csv fieldnames: name,uid,gid delimiter: ';' register: users delegate_to: localhost a dict: description: The CSV content as a dictionary. returned: success type: dict sample: dag: name: dag uid: 500 gid: 500 jeroen: name: jeroen uid: 501 gid: 500 list: description: The CSV content as a list. returned: success type: list sample: - name: dag uid: 500 gid: 500 - name: jeroen uid: 501 gid: 500 ) AnsibleModule) to_native)initialize_dialectread_csvCSVErrorDialectNotAvailableErrorCustomDialectFailureErrorctttdddgtddtdd td d td dtd td td d}|jd}|jd}|jd}|jd}|jd}|jd|jd|jdd} t|fi|} t|d5}|j} dddt ||} |r?|| jvr1|j d|ddj| jt} t} | | D]} | j!| n6 | D]/} |r#| || vr|j d|d| |d | | | |<1 |j%| | !y#tt f$r&}|j t|Yd}~d}~wwxYw#1swY xYw#ttf$r)}|j dt|zYd}~@d}~wwxYw#t"$r(}|j dt|zYd}~d}~wwxYw#t"$r(}|j dt|zYd}~d}~wwxYw)"NpathTfilename)typerequiredaliasesstrexcel)rdefaultF)rno_loglist)relementsbool)r)rdialectkey fieldnamesunique delimiterskipinitialspacestrict) argument_specsupports_check_moderrrrrrr )rrr )msgrbzUnable to open file: %szKey 'z*' was not found in the CSV header fields: z, zUnable to process file: %sz' is not unique for value '')dictr)rr&paramsrr r fail_jsonropenreadIOErrorOSErrorr rjoinrappendr exit_json)modulerrrrrdialect_paramsefdatareader data_dict data_listrows n/home/dcms/DCMS/lib/python3.12/site-packages/ansible_collections/community/general/plugins/modules/read_csv.pymainr:s 6D:,GeW5%.%8VT2&!v.V$  ! F == DmmI&G -- C|,J ]]8 $F]];/"MM*<=--)N +$W??G $  668D  dGZ 0F s&+++VY[_[d[dekevev[wxyII { N &  % &  N *c#h)3$$TWY\]`Ya)b$c&) #c(# * ))4A &'? @+Yq\**+   W G61EFFG N   != ! !L  M M N N   != ! !L  M M Nsx/ G)< H.H!H.I) 4J)H8HH!H+&H..I&=I!!I&) J2JJ K&K  K__main__N) __future__rrrr __metaclass__ DOCUMENTATIONEXAMPLESRETURNansible.module_utils.basicr+ansible.module_utils.common.text.convertersr>ansible_collections.community.general.plugins.module_utils.csvrr r r r r:__name__r9rGsYA@ A F) V 65Agg =5@ zFrF