File manager - Edit - /opt/saltstack/salt/lib/python3.10/site-packages/salt/modules/__pycache__/mssql.cpython-310.pyc
Back
o ;j 9 � @ s d Z ddlZzddlZdZW n ey dZY nw ddddddd �Zd d � Zd d � ZG dd� dej j j �Z dd� Z dd� Zdd� Zdd� Zd3dd�Zdd � Zd d � Zd d � Zd4d!d"�Zd#d$� Zd5d%d&�Z d6d'd(�Zd)d*� Zd7d+d,�Zd-d.� Z d8d/d0�Z d1d2� Z dS )9a� Module to provide MS SQL Server compatibility to salt. :depends: - FreeTDS - pymssql Python module :configuration: In order to connect to MS SQL Server, certain configuration is required in minion configs/pillars on the relevant minions. Some sample pillars might look like:: mssql.server: 'localhost' mssql.port: 1433 mssql.user: 'sysdba' mssql.password: 'Some preferable complex password' mssql.database: '' The default for the port is '1433' and for the database is '' (empty string); in most cases they can be left at the default setting. Options that are directly passed into functions will overwrite options from configs or pillars. � NTFZ localhosti� Zsysdba� �Zserver�port�user�password�database�as_dictc C s t rdS dS )zC Only load this module if all imports succeeded bin exists T)FzYThe mssql execution module cannot be loaded: the pymssql python library is not available.)�HAS_ALL_IMPORTS� r r �F/opt/saltstack/salt/lib/python3.10/site-packages/salt/modules/mssql.py� __virtual__+ s r c K sR i }dD ] }|| v r| | ||< qt d d| t�|d ��||< qtjdi |��S )Nr z config.optionzmssql.r )Z__salt__� _DEFAULTS�get�pymssql�connect)�kwargsZconnection_args�argr r r �_get_connection8 s �r c @ s e Zd Zdd� ZdS )� _MssqlEncoderc C s t |�S )N)�str)�self�or r r �defaultF s z_MssqlEncoder.defaultN)�__name__� __module__� __qualname__r r r r r r D s r c K st z t di |���� }|�| � tjj�t� �d|� � i��d W S t y9 } z dt |�ffW Y d}~S d}~ww )a Run a SQL query and return query result as list of tuples, or a list of dictionaries if as_dict was passed, or an empty list if no data is available. CLI Example: .. code-block:: bash salt minion mssql.tsql_query 'SELECT @@version as version' as_dict=True Z resultset)zCould not run the queryNr ) r �cursor�execute�salt�utils�json�loadsr �encodeZfetchall� Exceptionr )�queryr �cur�errr r r � tsql_queryJ s ����r' c K s t di | ��S )z Return the version of a MS SQL server. CLI Example: .. code-block:: bash salt minion mssql.version �SELECT @@versionN)r( �r' �r r r r �version` s r+ c K s dd� t dddi| ��D �S )z� Return the database list created on a MS SQL server. CLI Example: .. code-block:: bash salt minion mssql.db_list c S � g | ]}|d �qS �r r ��.0�rowr r r � <listcomp>w � ��zdb_list.<locals>.<listcomp>� SELECT name FROM sys.databasesr FN)r3 r) r* r r r �db_listm s �r4 c K s t td�| �fi |���dkS )z� Find if a specific database exists on the MS SQL server. CLI Example: .. code-block:: bash salt minion mssql.db_exists database_name='DBNAME' z5SELECT database_id FROM sys.databases WHERE NAME='{}'� )�lenr' �format)� database_namer r r r � db_exists} s ������r9 �NONEc K s� |dvrdS d| � d|� d�}|r|dd� |� 7 }d}zHztd i |��}|�d � |�� �|� W n$ tyV } zd |� �W Y d}~W |rQ|�d � |�� S S d}~ww W |rc|�d � |�� d S |rq|�d � |�� w w ) z� Creates a new database. Does not update options of existing databases. new_database_options can only be a list of strings CLI Example: .. code-block:: bash salt minion mssql.db_create DB_NAME )r: ZPARTIALz*CONTAINMENT can be one of NONE and PARTIALzCREATE DATABASE [z] CONTAINMENT = � � WITH �, NTz Could not create the database: Fr )�joinr � autocommitr r r# �close)r Z containmentZnew_database_optionsr �sql�conn�er r r � db_create� s6 ���� � �rD c K s� z;t | fi |��r9| dvr9tdi |��}|�d� |�� }|�d�| �� |�d| � �� |�d� |�� W dS W dS tyR } z d|� �W Y d}~S d}~ww ) z� Drops a specific database from the MS SQL server. It will not drop any of 'master', 'model', 'msdb' or 'tempdb'. CLI Example: .. code-block:: bash salt minion mssql.db_remove database_name='DBNAME' )ZmasterZmodelZmsdbZtempdbTz9ALTER DATABASE {} SET SINGLE_USER WITH ROLLBACK IMMEDIATEzDROP DATABASE Fz Could not find the database: Nr )r9 r r? r r r7 r@ r# )r8 r rB r% rC r r r � db_remove� s& �� ��rE c K s t dddd�| ��S )zp Lists database roles. CLI Example: .. code-block:: bash salt minion mssql.role_list Z sp_helproleT�r$ r Nr r) r* r r r � role_list� s rG c K s$ t tdd| � d�dd�|���dkS )z~ Checks if a role exists. CLI Example: .. code-block:: bash salt minion mssql.role_exists db_owner z sp_helprole "�"TrF r5 Nr �r6 r' )�roler r r r � role_exists� s $ rK c K s� |sg }d| � �}|r|d|� �7 }d}z[z(t d i |��}|�d� |�� �|� |D ]}|�� �d|� d| � d�� q+W n$ tya } zd|� �W Y d}~W |r\|�d � |�� S S d}~ww W |rn|�d � |�� dS |r||�d � |�� w w ) a� Creates a new database role. If no owner is specified, the role will be owned by the user that executes CREATE ROLE, which is the user argument or mssql.user option. grants is list of strings. CLI Example: .. code-block:: bash salt minion mssql.role_create role=product01 owner=sysdba grants='["SELECT", "INSERT", "UPDATE", "DELETE", "EXECUTE"]' z CREATE ROLE z AUTHORIZATION NTzGRANT z TO [�]zCould not create the role: Fr )r r? r r r# r@ )rJ �ownerZgrantsr rA rB ZgrantrC r r r � role_create� s< � ���� � �rN c K sx z$t di |��}|�d� |�� }|�d| � �� |�d� |�� W dS ty; } z d|� �W Y d}~S d}~ww )z� Remove a database role. CLI Example: .. code-block:: bash salt minion mssql.role_create role=test_role01 Tz DROP ROLE zCould not remove the role: Nr �r r? r r r@ r# )rJ r rB r% rC r r r � role_remove s ��rP c K sd |r |� d| � �} zt tddd�| �i|���dkW S ty1 } z d|� �W Y d}~S d}~ww )z� Find if a login exists in the MS SQL server. domain, if provided, will be prepended to login CLI Example: .. code-block:: bash salt minion mssql.login_exists 'LOGIN' �\r$ z.SELECT name FROM sys.syslogins WHERE name='{}'r5 zCould not find the login: Nr )r6 r' r7 r# )�login�domainr rC r r r � login_exists0 s& ������ ��rT c K s� t |�t |�kr dS t| |fi |��rdS |r |� d| � �} |s"g }|s&g }d| � d�}|r3|d7 }nt|t�rD|�dd|d�d �� n |�dd |� d �� |rY|d d �|� 7 }d}z[z(tdi |��}|�d� |�� � |� |D ]}|�� � d|� d| � d�� qrW n$ t y� } zd| � �W Y d} ~ W |r�|�d� |� � S S d} ~ ww W |r�|�d� |� � dS |r�|�d� |� � w w )aK Creates a new login. Does not update password of existing logins. For Windows authentication, provide ``new_login_domain``. For SQL Server authentication, prvide ``new_login_password``. Since hashed passwords are *varbinary* values, if the ``new_login_password`` is 'int / long', it will be considered to be HASHED. new_login_roles a list of SERVER roles new_login_options a list of strings CLI Example: .. code-block:: bash salt minion mssql.login_create LOGIN_NAME database=DBNAME [new_login_password=PASSWORD] FrQ zCREATE LOGIN [�] z FROM WINDOWS r z PASSWORD=0x�xz HASHEDz PASSWORD=N'�'r< r= NTzALTER SERVER ROLE [�] ADD MEMBER [rL z Could not create the login: r ) �boolrT � isinstance�int�insertr> r r? r r r# r@ ) rR Znew_login_passwordZnew_login_domainZnew_login_rolesZnew_login_optionsr rA rB rJ rC r r r � login_createO sV � ���� � �r] c K sz z%t di |��}|�d� |�� }|�d| � d�� |�d� |�� W dS ty< } z d|� �W Y d}~S d}~ww )zy Removes an login. CLI Example: .. code-block:: bash salt minion mssql.login_remove LOGINNAME Tz DROP LOGIN [rL Fz Could not remove the login: Nr rO )rR r rB r% rC r r r � login_remove� s ��r^ c K s@ |r |� d| � �} |r||d< t tddd| � d�i|���dkS ) z� Find if an user exists in a specific database on the MS SQL server. domain, if provided, will be prepended to username CLI Example: .. code-block:: bash salt minion mssql.user_exists 'USERNAME' [database='DBNAME'] rQ r r$ z&SELECT name FROM sysusers WHERE name='rW r5 Nr rI )�usernamerS r r r r r � user_exists� s �����r` c K s dd� t dddi| ��D �S )z� Get the user list for a specific database on the MS SQL server. CLI Example: .. code-block:: bash salt minion mssql.user_list [database='DBNAME'] c S r, r- r r. r r r r1 � r2 z user_list.<locals>.<listcomp>�9SELECT name FROM sysusers where issqluser=1 or isntuser=1r FN)ra r) r* r r r � user_list� s ����rb c K s� |r|sdS t | |fi |��rd| � d�S |r)|� d| � �} |r'|� d|� �n|}|r/||d< |s3g }|s7g }d| � d�}|rH|d|� d �7 }n|d 7 }|rW|d d �|� 7 }d }z[z(tdi |��}|�d� |�� �|� |D ]} |�� �d| � d| � d �� qpW n$ ty� } zd| � �W Y d } ~ W |r�|�d� |�� S S d } ~ ww W |r�|�d� |�� dS |r�|�d� |�� w w )a2 Creates a new user. If login is not specified, the user will be created without a login. domain, if provided, will be prepended to username. options can only be a list of strings CLI Example: .. code-block:: bash salt minion mssql.user_create USERNAME database=DBNAME z"domain cannot be set without loginzUser z already existsrQ r z CREATE USER [rU z FOR LOGIN [rL z WITHOUT LOGINr< r= NTz ALTER ROLE [rX zCould not create the user: Fr )r` r> r r? r r r# r@ ) r_ rR rS r Zroles�optionsr rA rB rJ rC r r r � user_create� sX � ���� � �rd c K s� d|vrdS z$t di |��}|�d� |�� }|�d| � �� |�d� |�� W dS tyA } z d|� �W Y d}~S d}~ww )z� Removes an user. CLI Example: .. code-block:: bash salt minion mssql.user_remove USERNAME database=DBNAME r FTz DROP USER zCould not remove the user: Nr rO )r_ r rB r% rC r r r � user_remove s ��re )r: N)NN)r )Nr NN)r N)Nr NNN) �__doc__Zsalt.utils.jsonr r r � ImportErrorr r r r r � JSONEncoderr r' r+ r4 r9 rD rE rG rK rN rP rT r] r^ r` rb rd re r r r r �<module> sP �� !$ % ! �B � 8
| ver. 1.4 |
Github
|
.
| PHP 8.2.30 | Generation time: 0 |
proxy
|
phpinfo
|
Settings