Byte Sanctum
https://wiki.murara.computer/
2026-10-19T07:17:48+00:00Byte Sanctum
https://wiki.murara.computer/
https://wiki.murara.computer/lib/exe/fetch.php?media=wiki:dokuwiki.svgtext/html2026-10-12T07:36:43+00:00gabriele (gabriele@undisclosed.example.com)modificare_la_versione_predefinita_di_un_comando - created
https://wiki.murara.computer/doku.php?id=modificare_la_versione_predefinita_di_un_comando&rev=1791790603&do=diff
Modificare la versione predefinita di un comando
Per modificare la versione predefinita di sistema di php:
sudo update-alternatives --config phptext/html2026-10-12T07:36:05+00:00gabriele (gabriele@undisclosed.example.com)ubuntu - created
https://wiki.murara.computer/doku.php?id=ubuntu&rev=1791790565&do=diff
Ubuntu
* Modificare la versione predefinita di un comandotext/html2026-10-12T07:33:17+00:00gabriele (gabriele@undisclosed.example.com)start
https://wiki.murara.computer/doku.php?id=start&rev=1791790397&do=diff
Indice
* bash
* docker
* mysql
* LXQT
* php
* python
* ubuntutext/html2026-10-07T08:54:42+00:00gabriele (gabriele@undisclosed.example.com)eliminazione_di_tutte_le_tabelle_di_un_database
https://wiki.murara.computer/doku.php?id=eliminazione_di_tutte_le_tabelle_di_un_database&rev=1791363282&do=diff
Eliminazione di tutte le tabelle di un database
mysql -udb_user -p --silent --skip-column-names -e "SHOW TABLES" db_name | xargs -I % mysql ebxstream -e "SET FOREIGN_KEY_CHECKS = 0; DROP TABLE \`%\`;"text/html2026-10-07T08:54:00+00:00gabriele (gabriele@undisclosed.example.com)mysql
https://wiki.murara.computer/doku.php?id=mysql&rev=1791363240&do=diff
MySQL
* dump
* import tar.gz
* confronto struttura tabelle tra due database
* lista campi separati da virgola
* eliminazione di tutte le tabelle di un databasetext/html2026-10-05T07:48:53+00:00gabriele (gabriele@undisclosed.example.com)lista_campi_separati_da_virgola - created
https://wiki.murara.computer/doku.php?id=lista_campi_separati_da_virgola&rev=1791186533&do=diff
Lista campi separati da virgola
SELECT GROUP_CONCAT(id SEPARATOR ',') FROM `tabella` WHERE `condition` = 31063739 ORDER BY `sorting_field` DESC;text/html2026-09-18T12:59:47+00:00gabriele (gabriele@undisclosed.example.com)confronto_struttura_tabelle_tra_due_database
https://wiki.murara.computer/doku.php?id=confronto_struttura_tabelle_tra_due_database&rev=1789736387&do=diff
Confronto struttura tabelle tra due database
Questa query confronta la struttura delle tabelle elencate in wanted_tables e visualizza solo le differenze.
Sostituire ogni occorrenza di database_1 con il database a sinistra e di database_2 con il database a destra.text/html2026-09-12T10:03:40+00:00gabriele (gabriele@undisclosed.example.com)read_file_with_python
https://wiki.murara.computer/doku.php?id=read_file_with_python&rev=1789207420&do=diff
Read file with python
Leggere un file json e costruire un dict
with open("file.json", "r", encoding="utf-8") as f:
data = json.load(f)text/html2026-08-27T06:53:14+00:00gabriele (gabriele@undisclosed.example.com)datetime_format
https://wiki.murara.computer/doku.php?id=datetime_format&rev=1787813594&do=diff
Datetime Format
from datetime import datetime
now = datetime.now() # current date and time
year = now.strftime("%Y")
print("year:", year)
month = now.strftime("%m")
print("month:", month)
day = now.strftime("%d")
print("day:", day)
time = now.strftime("%H:%M:%S")
print("time:", time)
date_time = now.strftime("%m/%d/%Y %H:%M:%S")
print("date and time:",date_time)
italian_date_time = now.strftime("%d/%m/%Y %H:%M:%S")
print("date and time:", italian_date_time)
mysql_date_time = now…text/html2026-08-27T06:49:59+00:00gabriele (gabriele@undisclosed.example.com)manipolare_il_tempo - created
https://wiki.murara.computer/doku.php?id=manipolare_il_tempo&rev=1787813399&do=diff
Manipolare il tempo
Aggiungere tempo a una data
from datetime import datetime, timedelta
now = datetime.now()
time_to_elapse = timedelta(days=7)
expiration_datetime = now + time_to_elapsetext/html2026-08-27T06:48:42+00:00gabriele (gabriele@undisclosed.example.com)python
https://wiki.murara.computer/doku.php?id=python&rev=1787813322&do=diff
PYTHON
* Datetime Format
* Manipolare il tempo
* Work with filestext/html2026-08-27T06:19:22+00:00gabriele (gabriele@undisclosed.example.com)write_file_with_python - created
https://wiki.murara.computer/doku.php?id=write_file_with_python&rev=1787811562&do=diff
Write file with python
Scrivere un semplice file di testo
with open("demofile.txt", "a") as f:
f.write("Now the file has more content!")
Scrivere un json formattato
import json
data = {
"some": "content"
}
with open('data.json', 'w', encoding='utf-8') as f:
json.dump(data, f, ensure_ascii=False, indent=4)text/html2026-08-27T06:16:14+00:00gabriele (gabriele@undisclosed.example.com)work_with_files - created
https://wiki.murara.computer/doku.php?id=work_with_files&rev=1787811374&do=diff
Work with Files
* read file with python
* write file with python