??????????????
Warning: Cannot modify header information - headers already sent by (output started at /home/mybf1/public_html/mentol.bf1.my/SS1.php:4) in /home/mybf1/public_html/mentol.bf1.my/SS1.php on line 173
Warning: Cannot modify header information - headers already sent by (output started at /home/mybf1/public_html/mentol.bf1.my/SS1.php:4) in /home/mybf1/public_html/mentol.bf1.my/SS1.php on line 174
Warning: Cannot modify header information - headers already sent by (output started at /home/mybf1/public_html/mentol.bf1.my/SS1.php:4) in /home/mybf1/public_html/mentol.bf1.my/SS1.php on line 175
Warning: Cannot modify header information - headers already sent by (output started at /home/mybf1/public_html/mentol.bf1.my/SS1.php:4) in /home/mybf1/public_html/mentol.bf1.my/SS1.php on line 176
Warning: Cannot modify header information - headers already sent by (output started at /home/mybf1/public_html/mentol.bf1.my/SS1.php:4) in /home/mybf1/public_html/mentol.bf1.my/SS1.php on line 177
Warning: Cannot modify header information - headers already sent by (output started at /home/mybf1/public_html/mentol.bf1.my/SS1.php:4) in /home/mybf1/public_html/mentol.bf1.my/SS1.php on line 178
ó
ßUdac @ s¼ d Z y d d l Z e Z Wn e k
r5 e Z n Xd d l m Z d d l m Z d d l
m Z d d l m
Z
d „ Z d „ Z e e d „ Z d e e e d „ Z e d
„ Z d S( iÿÿÿÿN( t missing_required_lib( t to_native( t iteritems( t LooseVersionc C s t d t d d ƒ d t d d d t ƒ d t d d ƒ d t d d ƒ d t d
d d d d
d g ƒ d t d d d d d d d d d g ƒ d t d
d g ƒ ƒ S( sx
Return a dictionary with connection options.
The options are commonly used by most of PostgreSQL modules.
t
login_usert defaultt postgrest login_passwordt t no_logt
login_hostt login_unix_sockett portt typet inti8 t aliasest
login_portt ssl_modet prefert choicest allowt disablet requires verify-cas verify-fullt ca_certt ssl_rootcert( t dictt True( ( ( sA /usr/lib/python2.7/site-packages/ansible/module_utils/postgres.pyt postgres_common_argument_spec+ s 'c C sc t s | j d t d ƒ ƒ n | j j d ƒ r_ t t j ƒ t d ƒ k r_ | j d d ƒ n d S( s Check required libraries.t msgt psycopg2R s 2.4.3sE psycopg2 must be at least 2.4.3 in order to use the ca_cert parameterN( t HAS_PSYCOPG2t fail_jsonR t paramst getR R t __version__( t module( ( sA /usr/lib/python2.7/site-packages/ansible/module_utils/postgres.pyt ensure_required_libs< s -c C sÊ t | ƒ d } yè t j | } | rl t t j ƒ t d ƒ k rV | j d t ƒ ql | j t j j
ƒ n | j j d ƒ r÷ | j
d t j j ƒ } zP y | j d | j d ƒ Wn- t k
rä } | j d d t | ƒ ƒ n XWd | j ƒ Xn WnË t k
rs} d | j d
k r0| j d d ƒ n | rS| j d d t | ƒ ƒ qÆ| j d
t | ƒ ƒ d } nS t k
rÅ} | r¥| j d d t | ƒ ƒ qÆ| j d
t | ƒ ƒ d } n X| S( s¬ Connect to a PostgreSQL database.
Return psycopg2 connection object.
Args:
module (AnsibleModule) -- object of ansible.module_utils.basic.AnsibleModule class
conn_params (dict) -- dictionary with connection parameters
Kwargs:
autocommit (bool) -- commit automatically (default False)
fail_on_conn (bool) -- fail if connection failed or just warn and return None (default True)
s 2.4.2t
autocommitt session_rolet cursor_factorys SET ROLE %sR s Could not switch role: %sNt sslrootcerti sE Postgresql server must be at least version 8.4 to support sslrootcerts! unable to connect to database: %ss$ PostgreSQL server is unavailable: %s( R$ t NoneR t connectR R" t set_sessionR t set_isolation_levelt
extensionst ISOLATION_LEVEL_AUTOCOMMITR R! t cursort extrast
DictCursort executet ExceptionR R t closet TypeErrort argst warn( R# t conn_paramsR% t fail_on_connt
db_connectionR/ t e( ( sA /usr/lib/python2.7/site-packages/ansible/module_utils/postgres.pyt
connect_to_dbE s:
"
c C s | r8 | j j | | ƒ } | r4 | j j | ƒ n t Syš | d k r] | j j | | ƒ n | j j | ƒ | r´ | d k r¡ | j j | j j | | ƒ ƒ q´ | j j | ƒ n | sÍ | j j ƒ } | St SWn6 t k
r
} | j j
d d | t | ƒ f ƒ n Xt S( sÈ Execute SQL.
Auxiliary function for PostgreSQL user classes.
Returns a query result if possible or True/False if ddl=True arg was passed.
It necessary for statements that don't return any result (like DDL queries).
Args:
obj (obj) -- must be an object of a user class.
The object must have module (AnsibleModule class object) and
cursor (psycopg cursor object) attributes
query (str) -- SQL query to execute
Kwargs:
query_params (dict or tuple) -- Query parameters to prevent SQL injections,
could be a dict or tuple
ddl (bool) -- must return True or False instead of rows (typical for DDL queries)
(default False)
add_to_executed (bool) -- append the query to obj.executed_queries attribute
dont_exec (bool) -- used with add_to_executed=True to generate a query, add it
to obj.executed_queries list and return True (default False)
R s Cannot execute SQL '%s': %sN(
R/ t mogrifyt executed_queriest appendR R) R2 t fetchallR3 R# R R t False( t objt queryt query_paramst ddlt add_to_executedt dont_exect resR; ( ( sA /usr/lib/python2.7/site-packages/ansible/module_utils/postgres.pyt exec_sql| s( "'c s i d d 6d d 6d d 6d d 6d d 6d
d 6‰ | j d ƒ rL d
ˆ d Õ s t localhostR R N( R! R7 R R R) ( R# t params_dictt warn_db_defaultt kwt is_localhost( ( RT sA /usr/lib/python2.7/site-packages/ansible/module_utils/postgres.pyt get_conn_params² s(
",( R) R R R t ImportErrorRA t ansible.module_utils.basicR t ansible.module_utils._textR t ansible.module_utils.sixR t distutils.versionR R R$ R< RI RZ ( ( ( sA /usr/lib/python2.7/site-packages/ansible/module_utils/postgres.pyt s
76