AdminSysGNULinux

Outils pour utilisateurs

Outils du site

Piste : • blog
blog

Table des matières

8 billet(s) pour mars 2026

Notes conteneurs oras artifact OCI2026/03/23 21:13Jean-Baptiste
Notes podman secret2026/03/23 15:10Jean-Baptiste
Notes ansible podman2026/03/23 14:08Jean-Baptiste
Notes podman volume2026/03/23 14:00Jean-Baptiste
Find list - Trouver des fichiers à partir d'une liste2026/03/18 14:32Jean-Baptiste
AWX inventaire vault2026/03/17 18:04Jean-Baptiste
AWX - Configuration git en local (sans serveur web)2026/03/05 16:24Jean-Baptiste
OpenSMTP2026/03/03 16:58Jean-Baptiste

Notes Python DB - ORM - DAL - SqlAlchemy

Voir Notes Python DB - ORM - DAL

Core & ORM :

Voir ORM :

Lib :

RestApi pour DB SqlAlchemy :

Notes SQLAlchemy Core 

#import urllib.parse
import sqlalchemy
from sqlalchemy import create_engine, text
 
engine = create_engine('sqlite:////home/jean/tmp/test-sqlite.db')
 
# Exemple de SQL
sql = text('SELECT * FROM contacts;')
 
with engine.connect() as con:
	result = con.execute(sql)
 
print(result.all())
result.close()
 
 
# Exemple de code SQL
conn = engine.connect()
result = conn.execute(text("SELECT * FROM contacts"))
for row in result:
	print(row)
 
# Exemple de Select
from sqlalchemy import select
stmt = select(User).where(User.name == "spongebob")
 
 
# Introspection import Table
metadata=MetaData()
with engine.connect() as conn:
    table_contacts_reflected==Table("contacts", metadata, autoload_with=conn)
 
print(table_contacts.c)
print(table_contacts.primary_key)
 
 
# Champs descriptions
conn = engine.connect()
result = conn.execute(text("SELECT * FROM contacts"))
cursor=result.cursor
print(';'.join([ x[0] for x in cursor.description]))

Autres

Dataset

Voir :

Dataset: databases for lazy people 

import dataset
 
db = dataset.connect('sqlite:///:memory:')
 
table = db['sometable']
table.insert(dict(name='John Doe', age=37))
table.insert(dict(name='Jane Doe', age=34, gender='female'))
 
john = table.find_one(name='John Doe')
2025/03/24 15:06
, , , ,

Notes Python config

Source : https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html/9.4_release_notes/new-features#new-features-kernel

A new environment variable in Python to control parsing of email addresses

To mitigate CVE-2023-27043, a backward incompatible change to ensure stricter parsing of email addresses was introduced in Python 3.

This update introduces a new PYTHON_EMAIL_DISABLE_STRICT_ADDR_PARSING environment variable. When you set this variable to true, the previous, less strict parsing behavior is the default for the entire system: 

export PYTHON_EMAIL_DISABLE_STRICT_ADDR_PARSING=true

However, individual calls to the affected functions can still enable stricter behavior.

You can achieve the same result by creating the /etc/python/email.cfg configuration file with the following content:

/etc/python/email.cfg 

[email_addr_parsing]
PYTHON_EMAIL_DISABLE_STRICT_ADDR_PARSING = true

For more information, see the Knowledgebase article Mitigation of CVE-2023-27043 introducing stricter parsing of email addresses in Python.

2025/03/24 15:06
,

Notes Python - les objects - Class

Exemples

class Geeks: 
     def __init__(self): 
          self._age = 0
 
     # using property decorator 
     # a getter function 
     @property
     def age(self): 
         print("getter method called") 
         return self._age 
 
     # a setter function 
     @age.setter 
     def age(self, a): 
         if(a < 18): 
            raise ValueError("Sorry you age is below eligibility criteria") 
         print("setter method called") 
         self._age = a 
 
mark = Geeks() 
 
mark.age = 19
 
print(mark.age)

Source : https://www.geeksforgeeks.org/getter-and-setter-in-python/

2025/03/24 15:06
,

Notes Python - date - datetime

AM/PM

AM ante meridiem
PM post meridiem 
import datetime
#from datetime import datetime
format_date='%Y-%m-%d %I:%M %p'
 
date1=datetime.datetime(2023, 9, 25, 11, 59, 0, 0)
date2=datetime.datetime(2023, 9, 25, 12, 0, 0, 0)
date3=datetime.datetime(2023, 9, 25, 12, 1, 0, 0)
In [32]: datetime.datetime.strftime(date1, format_date)
Out[32]: '2023-09-25 11:59 AM'

In [33]: datetime.datetime.strftime(date2, format_date)
Out[33]: '2023-09-25 12:00 PM'

In [34]: datetime.datetime.strftime(date3, format_date)
Out[34]: '2023-09-25 12:01 PM'

TimeZone (TZ)

datetime.datetime(2023, 9, 25, 10, 0, 34, 441838, tzinfo=<UTC>)
import datetime
from dateutil import tz
 
TZ_PARIS=tz.gettz('Europe/Paris')
TZ_UTC=tz.gettz('UTC')
 
d_utc=datetime.datetime(2023, 10, 3, 1, 1, 1, 114228, tzinfo=TZ_UTC)
d_paris=datetime.datetime(2023, 10, 3, 1, 1, 1, 114228, tzinfo=TZ_PARIS)
In [4]: d_utc.isoformat(timespec='minutes')
Out[4]: '2023-10-03T01:01+00:00'

In [5]: d_paris.isoformat(timespec='minutes')
Out[5]: '2023-10-03T01:01+02:00'

Epoch time

def get_epoch_ms():
    return int(time.time() * 1000.0)

Temps

Mesure du temps d'exécution

Exemple 1 

print(f"started at {time.strftime('%X')}")
plop()
print(f"finished at {time.strftime('%X')}")

Exemple 2 

start = time.time()
asyncio.run(main())
end = time.time() - start
print('Total time: %.2f' % end)
2025/03/24 15:06
, ,

Install de Zabbix sous RedHat

Voir http://yum.postgresql.org/repopackages.php 

wget http://yum.postgresql.org/8.3/redhat/rhel-5-x86_64/pgdg-redhat93-9.3-1.noarch.rpm
rpm -Uvh pgdg-redhat93-9.3-1.noarch.rpm
 
yum install postgresql93-server postgresql93-contrib 
 
service postgresql-9.3 initdb
 
service postgresql-9.3 start
 
su - postgres
CREATE ROLE zabbix WITH login password 'zabbix';
CREATE DATABASE zabbix owner zabbix;

pg_hba.conf 

host    all             all             127.0.0.1/32            ident
host    all             all             127.0.0.1/32            md5

Pour se connecter à la base : 

psql -U zabbix -h localhost -W

Voir https://www.zabbix.com/documentation/2.2/manual/installation/install_from_packages#red_hat_enterprise_linux_centos 

wget http://repo.zabbix.com/zabbix/2.2/rhel/5/x86_64/zabbix-release-2.2-1.el5.noarch.rpm
 
rpm -Uvh zabbix-release-2.2-1.el5.noarch.rpm
 
yum install php53-common  php53-bcmath php53 php53-gd php53-xml php53-mbstring zabbix-web
yum install zabbix-server-pgsql zabbix-web-pgsql
yum install zabbix-get
yum install zabbix-agent
 
 
ls -l /usr/share/doc/zabbix-server-pgsql-2.2.2/create/
 
psql -U zabbix -h localhost -W -1 -f /usr/share/doc/zabbix-server-pgsql-2.2.2/create/schema.sql
psql -U zabbix -h localhost -W -1 -f /usr/share/doc/zabbix-server-pgsql-2.2.2/create/images.sql
psql -U zabbix -h localhost -W -1 -f /usr/share/doc/zabbix-server-pgsql-2.2.2/create/data.sql

vi /etc/httpd/conf.d/zabbix.conf

/etc/init.d/httpd restart php_value date.timezone Europe/Paris 

chkconfig --add zabbix-agent
service zabbix-agent start

http://localhost:8081/zabbix

http://localhost:8081/zabbix User : Admin Mdp : zabbix

/etc/zabbix/zabbix_agentd.conf 

    #Server=127.0.0.1
    Server=10.252.64.210

Exemple d'utilisation zabbix_get (depuis un serveur autorisé) : 

zabbix_get -s elp -k 'agent.version'
yum install zabbix-java-gateway
/etc/init.d/zabbix-java-gateway start
chkconfig --add zabbix-java-gateway
2025/03/24 15:06
, , , ,

<< Billets récents | Anciens billets >>

blog.txt · Dernière modification : de 127.0.0.1
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki