VhU/ddlmZmZmZeZdZdZdZddl m Z ddl m Z ddl mZmZmZmZmZgZdZd Zd Zd Zd Zd ZdZdZedk(reyy))absolute_importdivisionprint_functionaR --- module: postgresql_lang short_description: Adds, removes or changes procedural languages with a PostgreSQL database deprecated: removed_in: "4.0.0" why: As of PostgreSQL 9.1, most procedural languages have been made into extensions. alternative: Use M(community.postgresql.postgresql_ext) instead. description: - Adds, removes or changes procedural languages with a PostgreSQL database. - This module allows you to add a language, remote a language or change the trust relationship with a PostgreSQL database. - The module can be used on the machine where executed or on a remote host. - When removing a language from a database, it is possible that dependencies prevent the database from being removed. In that case, you can specify I(cascade=true) to automatically drop objects that depend on the language (such as functions in the language). - In case the language can't be deleted because it is required by the database system, you can specify I(fail_on_drop=false) to ignore the error. - Be careful when marking a language as trusted since this could be a potential security breach. Untrusted languages allow only users with the PostgreSQL superuser privilege to use this language to create new functions. options: lang: description: - Name of the procedural language to add, remove or change. required: true type: str aliases: - name trust: description: - Make this language trusted for the selected db. type: bool default: 'false' db: description: - Name of database to connect to and where the language will be added, removed or changed. type: str aliases: - login_db required: true force_trust: description: - Marks the language as trusted, even if it's marked as untrusted in pg_pltemplate. - Use with care! type: bool default: 'false' fail_on_drop: description: - If C(true), fail when removing a language. Otherwise just log and continue. - In some cases, it is not possible to remove a language (used by the db-system). - When dependencies block the removal, consider using I(cascade). type: bool default: 'true' cascade: description: - When dropping a language, also delete object that depend on this language. - Only used when I(state=absent). type: bool default: 'false' session_role: description: - Switch to session_role after connecting. - The specified I(session_role) must be a role that the current I(login_user) is a member of. - Permissions checking for SQL commands is carried out as though the I(session_role) were the one that had logged in originally. type: str state: description: - The state of the language for the selected database. type: str default: present choices: [ absent, present ] owner: description: - Set an owner for the language. - Ignored when I(state=absent). type: str version_added: '0.2.0' trust_input: description: - If C(false), check whether values of parameters I(lang), I(session_role), I(owner) are potentially dangerous. - It makes sense to use C(false) only when SQL injections via the parameters are possible. type: bool default: true version_added: '0.2.0' seealso: - name: PostgreSQL languages description: General information about PostgreSQL languages. link: https://www.postgresql.org/docs/current/xplang.html - name: CREATE LANGUAGE reference description: Complete reference of the CREATE LANGUAGE command documentation. link: https://www.postgresql.org/docs/current/sql-createlanguage.html - name: ALTER LANGUAGE reference description: Complete reference of the ALTER LANGUAGE command documentation. link: https://www.postgresql.org/docs/current/sql-alterlanguage.html - name: DROP LANGUAGE reference description: Complete reference of the DROP LANGUAGE command documentation. link: https://www.postgresql.org/docs/current/sql-droplanguage.html attributes: check_mode: support: full author: - Jens Depuydt (@jensdepuydt) - Thomas O'Donnell (@andytom) extends_documentation_fragment: - community.postgresql.postgres a - name: Add language pltclu to database testdb if it doesn't exist community.postgresql.postgresql_lang: db=testdb lang=pltclu state=present # Add language pltclu to database testdb if it doesn't exist and mark it as trusted. # Marks the language as trusted if it exists but isn't trusted yet. # force_trust makes sure that the language will be marked as trusted - name: Add language pltclu to database testdb if it doesn't exist and mark it as trusted community.postgresql.postgresql_lang: db: testdb lang: pltclu state: present trust: true force_trust: true - name: Remove language pltclu from database testdb community.postgresql.postgresql_lang: db: testdb lang: pltclu state: absent - name: Remove language pltclu from database testdb and remove all dependencies community.postgresql.postgresql_lang: db: testdb lang: pltclu state: absent cascade: true - name: Remove language c from database testdb but ignore errors if something prevents the removal community.postgresql.postgresql_lang: db: testdb lang: pltclu state: absent fail_on_drop: false - name: In testdb change owner of mylang to alice community.postgresql.postgresql_lang: db: testdb lang: mylang owner: alice zy queries: description: List of executed queries. returned: success type: list sample: ['CREATE LANGUAGE "acme"'] ) AnsibleModule) check_input) connect_to_dbensure_required_libsget_conn_paramspg_cursor_argspostgres_common_argument_speccLd}|j|d|i|jdkDS)z Checks if language exists for dbz8SELECT lanname FROM pg_language WHERE lanname = %(lang)slangr)executerowcountcursorrquerys x/home/dcms/DCMS/lib/python3.12/site-packages/ansible_collections/community/postgresql/plugins/modules/postgresql_lang.py lang_existsrs( FE NN564.) ??Q cTd}|j|d|i|jdS)z$Checks if language is trusted for dbz=SELECT lanpltrusted FROM pg_language WHERE lanname = %(lang)sr lanpltrustedrfetchoners rlang_istrustedrs+ KE NN564.) ?? ^ ,,rcd}|j|||dtj|j|||dy)z%Changes if language is trusted for dbzHUPDATE pg_language SET lanpltrusted = %(trust)s WHERE lanname = %(lang)s)trustrT)rexecuted_queriesappendmogrifyrrrrs rlang_altertrustr"s; VE NN5E489FNN5E42PQR rcj|rd|z}nd|z}tj||j|y)zAdds language for dbzCREATE TRUSTED LANGUAGE "%s"zCREATE LANGUAGE "%s"Trrrr!s rlang_addr%s6 .5&-E" NN5 rc|jd |rd|z}nd|z}tj||j||jdy#t$r%|jd|jdYywxYw)zDrops language for dbz!SAVEPOINT ansible_pgsql_lang_dropzDROP LANGUAGE "%s" CASCADEzDROP LANGUAGE "%s"z-ROLLBACK TO SAVEPOINT ansible_pgsql_lang_dropz)RELEASE SAVEPOINT ansible_pgsql_lang_dropFT)rrr Exception)rrcascaders r lang_dropr)s NN67  2T9E*T1E&u  NN>?  FGBCs3A+BBcTd}|j|d|i|jdS)zvGet language owner. Args: cursor (cursor): psycopg cursor object. lang (str): language name. zdSELECT r.rolname FROM pg_language l JOIN pg_roles r ON l.lanowner = r.oid WHERE l.lanname = %(lang)srrolnamerrs rget_lang_ownerr,s/*E NN564.) ?? Y ''rcbd|d|d}tj||j|y)zSet language owner. Args: cursor (cursor): psycopg cursor object. lang (str): language name. owner (str): name of new owner. zALTER LANGUAGE "z " OWNER TO ""Tr$)rrownerrs rset_lang_ownerr0s+8|jrd}d|d<n*t!|||}|r|sd}|j#|||d<| r-|dk(r(t||r| t%||k7r t'||| }|r-|jr| j)n| j+||d <t,|d!<| j/|j0d"i|y)#NstrTlogin_db)typerequiredaliasesnamepresentabsent)r4defaultchoicesboolfalse)r4r:true)r4) dbrstater force_trustr( fail_on_drop session_roler/ trust_input) argument_specsupports_check_moder?rr@rrAr(rBr/rCrDF) autocommit)r?rr lang_droppedz[unable to drop language, use cascade to delete dependencies or fail_on_drop=false to ignore)msgchangedqueries)r updatedictrparamsrr r rrr rr check_moder"r%r) fail_jsonr,r0rollbackcommitrclose exit_json)rEmoduler?rr@rrAr(rBr/rCrD conn_params db_connectiondummyrrJkw lang_trustedrIs rmainr\s13M UTJ< @ utfX >y8Y:OP0fg6&'2vv6u%ff5 # F t B == D MM' "E MM' "E-- .KmmI&G==0L MM' "E==0L-- .K FD,6 !&&--8K(OM5 !] ! ! 3N 3FGD5 1B  vt $)&$7LULU$$"G-fdEBG  "647-fdEBG vt $  %)>"#FD':TC$$$-%,>" )# vt $vt44(u=     " " $  "ByM$ByMFrr__main__N) __future__rrrr4 __metaclass__ DOCUMENTATIONEXAMPLESRETURNansible.module_utils.basicrFansible_collections.community.postgresql.plugins.module_utils.databaserFansible_collections.community.postgresql.plugins.module_utils.postgresrr r r r rrrr"r%r)r,r0r\__name__rLrrrgsA@ p d( T 5-$ ( Wt zFr