File Manager

003 File Manager

Current Path: /usr/local/lib/python3.8/site-packages/salt/pillar

usr / local / lib / python3.8 / site-packages / salt / pillar /

📁 ..
📄 __init__.py(48.72 KB)
📁 __pycache__
📄 azureblob.py(13.88 KB)
📄 cmd_json.py(787 B)
📄 cmd_yaml.py(893 B)
📄 cmd_yamlex.py(674 B)
📄 cobbler.py(1.64 KB)
📄 confidant.py(3.29 KB)
📄 consul_pillar.py(11.61 KB)
📄 csvpillar.py(1.85 KB)
📄 digicert.py(1007 B)
📄 django_orm.py(7.74 KB)
📄 ec2_pillar.py(10.12 KB)
📄 etcd_pillar.py(2.36 KB)
📄 extra_minion_data_in_pillar.py(2.18 KB)
📄 file_tree.py(18.03 KB)
📄 foreman.py(3.66 KB)
📄 git_pillar.py(19.61 KB)
📄 gpg.py(560 B)
📄 hg_pillar.py(3.19 KB)
📄 hiera.py(846 B)
📄 http_json.py(2.43 KB)
📄 http_yaml.py(2.43 KB)
📄 libvirt.py(5.78 KB)
📄 makostack.py(21.99 KB)
📄 mongo.py(5.6 KB)
📄 mysql.py(3.76 KB)
📄 nacl.py(744 B)
📄 netbox.py(29.5 KB)
📄 neutron.py(2.41 KB)
📄 nodegroups.py(1.7 KB)
📄 pepa.py(20.98 KB)
📄 pillar_ldap.py(10.95 KB)
📄 postgres.py(2.82 KB)
📄 puppet.py(846 B)
📄 reclass_adapter.py(4 KB)
📄 redismod.py(3.28 KB)
📄 rethinkdb_pillar.py(4.71 KB)
📄 s3.py(14.4 KB)
📄 saltclass.py(1.49 KB)
📄 sql_base.py(15.38 KB)
📄 sqlcipher.py(3.42 KB)
📄 sqlite3.py(2.67 KB)
📄 stack.py(22.07 KB)
📄 svn_pillar.py(5.74 KB)
📄 varstack_pillar.py(1.1 KB)
📄 vault.py(4.03 KB)
📄 venafi.py(966 B)
📄 virtkey.py(586 B)
📄 vmware_pillar.py(16.83 KB)

Editing: sqlcipher.py

"""
Retrieve Pillar data by running a SQLCipher query

.. versionadded:: 2016.3.0

Python SQLCipher support is provided by the pysqlcipher
Python package. You need this module installed to query
Pillar data from a SQLCipher database.

This module is a concrete implementation of the sql_base
ext_pillar for SQLCipher.

:maturity: new
:depends: pysqlcipher (for py2) or pysqlcipher3 (for py3)
:platform: all

Configuring the sqlcipher ext_pillar
====================================

Use the 'sqlcipher' key under ext_pillar for configuration of queries.

SQLCipher database connection configuration requires the following values
configured in the master config:

* ``sqlcipher.database`` - The SQLCipher database to connect to.
     Defaults to ``'/var/lib/salt/pillar-sqlcipher.db'``.
   * ``sqlcipher.pass`` - The SQLCipher database decryption password.
   * ``sqlcipher.timeout`` - The connection timeout in seconds.

Example configuration

.. code-block:: yaml

sqlcipher:
      database: /var/lib/salt/pillar-sqlcipher.db
      pass: strong_pass_phrase
      timeout: 5.0

Complete Example
================

.. code-block:: yaml

sqlcipher:
      database: '/var/lib/salt/pillar-sqlcipher.db'
      pass: strong_pass_phrase
      timeout: 5.0

ext_pillar:
      - sqlcipher:
          fromdb:
            query: 'SELECT col1,col2,col3,col4,col5,col6,col7
                      FROM some_random_table
                     WHERE minion_pattern LIKE ?'
            depth: 5
            as_list: True
            with_lists: [1,3]
"""

import logging
from contextlib import contextmanager

from salt.pillar.sql_base import SqlBaseExtPillar

# Set up logging
log = logging.getLogger(__name__)

try:
    from pysqlcipher import dbapi2 as sqlcipher

HAS_SQLCIPHER = True
except ImportError:
    HAS_SQLCIPHER = False

def __virtual__():
    if not HAS_SQLCIPHER:
        return False
    return True

class SQLCipherExtPillar(SqlBaseExtPillar):
    """
    This class receives and processes the database rows from SQLCipher.
    """

@classmethod
    def _db_name(cls):
        return "SQLCipher"

def _get_options(self):
        """
        Returns options used for the SQLCipher connection.
        """
        defaults = {
            "database": "/var/lib/salt/pillar-sqlcipher.db",
            "pass": "strong_pass_phrase",
            "timeout": 5.0,
        }
        _options = {}
        _opts = __opts__.get("sqlcipher", {})

for attr in defaults:
            if attr not in _opts:
                log.debug("Using default for SQLCipher pillar %s", attr)
                _options[attr] = defaults[attr]
                continue
            _options[attr] = _opts[attr]
        return _options

@contextmanager
    def _get_cursor(self):
        """
        Yield a SQLCipher cursor
        """
        _options = self._get_options()
        conn = sqlcipher.connect(
            _options.get("database"), timeout=float(_options.get("timeout"))
        )
        conn.execute('pragma key="{}"'.format(_options.get("pass")))
        cursor = conn.cursor()
        try:
            yield cursor
        except sqlcipher.Error as err:
            log.exception("Error in ext_pillar SQLCipher: %s", err.args)
        finally:
            conn.close()

def ext_pillar(minion_id, pillar, *args, **kwargs):
    """
    Execute queries against SQLCipher, merge and return as a dict
    """
    return SQLCipherExtPillar().fetch(minion_id, pillar, *args, **kwargs)

003 File Manager

Editing: sqlcipher.py

Upload File

Create Folder