VhSddlmZmZmZeZdZdZdZddl m Z ddl m Z ddl mZmZmZmZmZmZGdd eZd Zed k(rey y ) )absolute_importdivisionprint_functiona --- module: postgresql_sequence short_description: Create, drop, or alter a PostgreSQL sequence description: - Allows to create, drop or change the definition of a sequence generator. options: sequence: description: - The name of the sequence. required: true type: str aliases: - name state: description: - The sequence state. - If I(state=absent) other options will be ignored except of I(name) and I(schema). default: present choices: [ absent, present ] type: str data_type: description: - Specifies the data type of the sequence. Valid types are bigint, integer, and smallint. bigint is the default. The data type determines the default minimum and maximum values of the sequence. For more info see the documentation U(https://www.postgresql.org/docs/current/sql-createsequence.html). - Supported from PostgreSQL 10. choices: [ bigint, integer, smallint ] type: str increment: description: - Increment specifies which value is added to the current sequence value to create a new value. - A positive value will make an ascending sequence, a negative one a descending sequence. The default value is 1. type: int minvalue: description: - Minvalue determines the minimum value a sequence can generate. The default for an ascending sequence is 1. The default for a descending sequence is the minimum value of the data type. type: int aliases: - min maxvalue: description: - Maxvalue determines the maximum value for the sequence. The default for an ascending sequence is the maximum value of the data type. The default for a descending sequence is -1. type: int aliases: - max start: description: - Start allows the sequence to begin anywhere. The default starting value is I(minvalue) for ascending sequences and I(maxvalue) for descending ones. type: int cache: description: - Cache specifies how many sequence numbers are to be preallocated and stored in memory for faster access. The minimum value is 1 (only one value can be generated at a time, i.e., no cache), and this is also the default. type: int cycle: description: - The cycle option allows the sequence to wrap around when the I(maxvalue) or I(minvalue) has been reached by an ascending or descending sequence respectively. If the limit is reached, the next number generated will be the minvalue or maxvalue, respectively. - If C(false) (NO CYCLE) is specified, any calls to nextval after the sequence has reached its maximum value will return an error. False (NO CYCLE) is the default. type: bool default: false cascade: description: - Automatically drop objects that depend on the sequence, and in turn all objects that depend on those objects. - Ignored if I(state=present). - Only used with I(state=absent). type: bool default: false rename_to: description: - DEPRECATED (see the L(discussion,https://github.com/ansible-collections/community.postgresql/issues/820)). This option will be removed in version 5.0.0. To rename a sequence, use the M(community.postgresql.postgresql_query) module. - The new name for the I(sequence). - Works only for existing sequences. type: str owner: description: - Set the owner for the I(sequence). type: str schema: description: - The schema of the I(sequence). This is be used to create and relocate a I(sequence) in the given schema. default: public type: str newschema: description: - The new schema for the I(sequence). Will be used for moving a I(sequence) to another I(schema). - Works only for existing sequences. type: str 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 login_db: description: - Name of database to connect to and run queries against. - The V(db) and V(database) aliases are deprecated and will be removed in version 5.0.0. type: str default: '' aliases: - database - db trust_input: description: - If C(false), check whether values of parameters I(sequence), I(schema), I(rename_to), I(owner), I(newschema), I(session_role) 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' notes: - If you do not pass db parameter, sequence will be created in the database named postgres. attributes: check_mode: support: full seealso: - module: community.postgresql.postgresql_table - module: community.postgresql.postgresql_owner - module: community.postgresql.postgresql_privs - module: community.postgresql.postgresql_tablespace - name: CREATE SEQUENCE reference description: Complete reference of the CREATE SEQUENCE command documentation. link: https://www.postgresql.org/docs/current/sql-createsequence.html - name: ALTER SEQUENCE reference description: Complete reference of the ALTER SEQUENCE command documentation. link: https://www.postgresql.org/docs/current/sql-altersequence.html - name: DROP SEQUENCE reference description: Complete reference of the DROP SEQUENCE command documentation. link: https://www.postgresql.org/docs/current/sql-dropsequence.html author: - Tobias Birkefeld (@tcraxs) - Thomas O'Donnell (@andytom) extends_documentation_fragment: - community.postgresql.postgres a - name: Create an ascending bigint sequence called foobar in the default database community.postgresql.postgresql_sequence: name: foobar - name: Create an ascending integer sequence called foobar, starting at 101 community.postgresql.postgresql_sequence: name: foobar data_type: integer start: 101 - name: Create an descending sequence called foobar, starting at 101 and preallocated 10 sequence numbers in cache community.postgresql.postgresql_sequence: name: foobar increment: -1 cache: 10 start: 101 - name: Create an ascending sequence called foobar, which cycle between 1 to 10 community.postgresql.postgresql_sequence: name: foobar cycle: true min: 1 max: 10 - name: Create an ascending bigint sequence called foobar in the default database with owner foobar community.postgresql.postgresql_sequence: name: foobar owner: foobar - name: Change the schema of an existing sequence to foobar community.postgresql.postgresql_sequence: name: foobar newschema: foobar - name: Change the owner of an existing sequence to foobar community.postgresql.postgresql_sequence: name: foobar owner: foobar - name: Drop a sequence called foobar community.postgresql.postgresql_sequence: name: foobar state: absent - name: Drop a sequence called foobar with cascade community.postgresql.postgresql_sequence: name: foobar cascade: true state: absent a state: description: Sequence state at the end of execution. returned: success type: str sample: 'present' sequence: description: Sequence name. returned: success type: str sample: 'foobar' queries: description: List of queries that was tried to be executed. returned: success type: str sample: [ "CREATE SEQUENCE \"foo\"" ] schema: description: Name of the schema of the sequence. returned: success type: str sample: 'foo' data_type: description: Shows the current data type of the sequence. returned: success type: str sample: 'bigint' increment: description: The value of increment of the sequence. A positive value will make an ascending sequence, a negative one a descending sequence. returned: success type: int sample: -1 minvalue: description: The value of minvalue of the sequence. returned: success type: int sample: 1 maxvalue: description: The value of maxvalue of the sequence. returned: success type: int sample: 9223372036854775807 start: description: The value of start of the sequence. returned: success type: int sample: 12 cycle: description: Shows if the sequence cycle or not. returned: success type: bool sample: false owner: description: Shows the current owner of the sequence after the successful run of the task. returned: success type: str sample: 'postgres' newname: description: Shows the new sequence name after rename. returned: success type: str sample: 'barfoo' newschema: description: Shows the new schema of the sequence after schema change. returned: success type: str sample: 'foobar' ) AnsibleModule) check_input) connect_to_dbensure_required_libsexec_sqlget_conn_paramspg_cursor_argspostgres_common_argument_specc@eZdZdZdZdZdZdZdZdZ dZ d Z y ) SequenceaiImplements behavior of CREATE, ALTER or DROP SEQUENCE PostgreSQL command. Arguments: module (AnsibleModule) -- object of AnsibleModule class cursor (cursor) -- cursor object of psycopg library Attributes: module (AnsibleModule) -- object of AnsibleModule class cursor (cursor) -- cursor object of psycopg library changed (bool) -- something was changed after execution or not executed_queries (list) -- executed queries name (str) -- name of the sequence owner (str) -- name of the owner of the sequence schema (str) -- name of the schema (default: public) data_type (str) -- data type of the sequence start_value (int) -- value of the sequence start minvalue (int) -- minimum value of the sequence maxvalue (int) -- maximum value of the sequence increment (int) -- increment value of the sequence cycle (bool) -- sequence can cycle or not new_name (str) -- name of the renamed sequence new_schema (str) -- name of the new schema exists (bool) -- sequence exists or not cR||_||_g|_|jjd|_d|_|jjd|_d|_d|_d|_ d|_ d|_ d|_ d|_ d|_d|_|j!y)NsequenceschemaF)modulecursorexecuted_queriesparamsnameownerr data_type start_valueminvaluemaxvalue incrementcyclenew_name new_schemaexistsget_info)selfrrs |/home/dcms/DCMS/lib/python3.12/site-packages/ansible_collections/community/postgresql/plugins/modules/postgresql_sequence.py__init__zSequence.__init__Ws  "KK&&z2  kk((2       cfd}t|||j|jdd}|sd|_y|r}d|_|dd|_|dd|_|dd |_|dd |_|dd |_|dd |_|dd |_|dd|_ |dd|_ yy)z'Getter to refresh and get sequence infoa1SELECT s.sequence_schema AS schemaname, s.sequence_name AS sequencename, pg_get_userbyid(c.relowner) AS sequenceowner, s.data_type::regtype AS data_type, s.start_value AS start_value, s.minimum_value AS min_value, s.maximum_value AS max_value, s.increment AS increment_by, s.cycle_option AS cycle FROM information_schema.sequences s JOIN pg_class c ON c.relname = s.sequence_name LEFT JOIN pg_namespace n ON n.oid = c.relnamespace WHERE NOT pg_is_other_temp_schema(n.oid) AND c.relkind = 'S'::"char" AND sequence_name = %(name)s AND sequence_schema = %(schema)s)rrF) query_paramsadd_to_executedTr schemaname sequencename sequenceownerrr min_value max_value increment_byrN) r rrr"rrrrrrr)r$queryress r%r#zSequence.get_infojs4$tU-1YY$++$N',.DK DKa&.DKA~.DIQ0DJ VK0DN"1vm4D F;/DMF;/DM VN3DNQDJ r'cdg}|j|j|jjj dr+|jd|jjdz|jjj dr+|jd|jjdz|jjj dr+|jd|jjdz|jjj dr+|jd |jjdz|jjj d r+|jd |jjd z|jjj d r+|jd |jjd z|jjj dr|jdt |dj |dS)z,Implements CREATE SEQUENCE command behavior.zCREATE SEQUENCErzAS %srzINCREMENT BY %srz MINVALUE %srz MAXVALUE %sstartz START WITH %scachezCACHE %srCYCLE T return_boolappend_Sequence__add_schemarrgetr joinr$r1s r%createzSequence.creates"# T&&() ;;   ! !+ . LL4;;#5#5k#BB C ;;   ! !+ . LL*T[[-?-? -LL M ;;   ! !* - LL););J)GG H ;;   ! !* - LL););J)GG H ;;   ! !' * LL4;;+=+=g+FF G ;;   ! !' * LLdkk&8&8&AA B ;;   ! !' * LL !chhuo4@@r'cdg}|j|j|jjj dr|jdt |dj |dS)z*Implements DROP SEQUENCE command behavior.z DROP SEQUENCEcascadeCASCADEr7Tr8r:r?s r%dropz Sequence.dropsZ ! T&&() ;;   ! !) , LL #chhuo4@@r'cdg}|j|j|jd|jjdzt |dj |dS)z5Implements ALTER SEQUENCE RENAME TO command behavior.ALTER SEQUENCEzRENAME TO "%s" rename_tor7Tr8r;r<rrr r>r?s r%renamezSequence.renamesW!" T&&() % (:(:;(GGHchhuo4@@r'cdg}|j|j|jd|jjdzt |dj |dS)z4Implements ALTER SEQUENCE OWNER TO command behavior.rFz OWNER TO "%s"rr7Tr8rHr?s r% set_ownerzSequence.set_ownersV!" T&&() _t{{'9'9''BBCchhuo4@@r'cdg}|j|j|jd|jjdzt |dj |dS)z6Implements ALTER SEQUENCE SET SCHEMA command behavior.rFzSET SCHEMA "%s" newschemar7Tr8rHr?s r% set_schemazSequence.set_schemasW!" T&&() &););K)HHIchhuo4@@r'c<d|jd|jdS)N"z".")rr)r$s r% __add_schemazSequence.__add_schemas"kk49955r'N) __name__ __module__ __qualname____doc__r&r#r@rDrIrKrNr<r'r%rr=s52&&)PA8AAAA6r'rc$ t}|jtdddgtddddgtdgd td td d g td dg td td tddtddtddtdddtd td tddddgddddddddgtd tddt|dddgddgddgdd gdd!gdd"gdd#gdd$gdd%gdd&gd$dgd$dgd$dgd$d gd$d!gd$d"gd$d#gd$d%gd$d&gg'}|jd(s_t ||jd)|jd*|jd|jd%|jd&|jd+|j }t|t||j}t|||,\}}|jd3it}t||}d}|js|jd-dk(r|jjdr"|jd.|jd)z/|jjd&r"|jd0|jd)z/|j!}nO|js|jd-dk(rd}n.|jr"|jd-dk(r|j#}|jr]|jjdrB|j$|jdk7r&|j'}|r|jd|_|jd-dk(r|j+|jd-dk(r|jr|jjd%r,|j,|jd%k7r|j/}|jjd&rB|j0|jd&k7r&|j3}|r|jd&|_|j r|j7n|j9|j;|j;t|d|j$|j<|j0|j>|j@|jB|jD|jF|jH|j,1 } |jd-dk(r7|j(r|j(| d2<|j4r'|j4| d&<n|jd-dk(rd| d-<|jJd3i| y)4NstrTr)typerequiredaliasespresentabsent)rYdefaultchoices)bigintintegersmallint)rYr_int)rYmin)rYr[maxboolF)rYr^publicz5.0.0zcommunity.postgresql)rYremoved_in_versionremoved_from_collectionrdbdatabase)rversioncollection_name)rYr^r[deprecated_aliases)rstaterrrrr4r5rrrBrGrrMlogin_db session_role trust_inputrGrrrrr4r5rrBrrM) argument_specsupports_check_modemutually_exclusiverrrrrq) autocommitroz/Sequence '%s' does not exist, nothing to rename)msgz;Sequence '%s' does not exist, change of schema not possible) changedrorqueriesrrrrrr4rrnewnamerV)&r updatedictrrr check_moder r rrr rr"r= fail_jsonr@rDrrIr r#rrKrrNr!rollbackcommitcloserrrrrrr exit_json) rsrrv conn_params db_connectiondummyrdatarxkws r%mainrs@13M54&By8Y:OPE+LME"55'255'2.1&%0Eg/EGE"5"tZ6H"#9  #"#9  ^  u%fd3;># + & + & * % * % ' " ' " ' " ) $ ' " + &  $  $  #  #      $' F4 == '  MM* % MM( # MM+ & MM' " MM+ & MM. ) &&&J !&&--8K(TM5 !] ! ! 3N 3F FF #DG ;;6==1Y> ==  [ )   !RU[UbUbcmUn!n  o ==  [ )   !^agananoyaz!z  {++-[[V]]73x? w/8;))+ {{v}}((5 99 k2 2kkmG & k : }}W* }}W*t{{ ==  W %zzV]]733..* ==  [ ){{fmmK88//+&,mmK&@DO  LLN %%{{....jjjj B}}W* == MMByM ??"ooB{O w 8 +7 Frr'__main__N) __future__rrrrY __metaclass__ DOCUMENTATIONEXAMPLESRETURNansible.module_utils.basicrFansible_collections.community.postgresql.plugins.module_utils.databaserFansible_collections.community.postgresql.plugins.module_utils.postgresrr r r r r objectrrrRrVr'r%rskA@ d L5 nE P5T6vT6vfR zFr'