python: execute function on remote file through ssh.
os.system('ssh USER@REMOTE_IP python3 /PATH/TO/REMOTE/FILE.py ARGUMENT') note than the argument i'm using is 1 (as a random character, you can […]
python: import remote file as module
the 'dumb' solution i found was to download the module from the remote server, importing and deleting. i'm doing this on […]
python: execute function from shell or cli
example: python3 -c 'from scripts.apps.malla.sugarcrm.contacts.delete_contacts_by_title import *; delete_by_title_leads(0) '
prestashop: test requirements
download phppsinfo.php and add to root folder.
nginx: cannot get up and running
https://stackoverflow.com/questions/64814455/directive-is-not-allowed-here-in-etc-nginx-default-d-app-conf1-nginx-config-ec
pimcore installation
Install Pimcore 10 on Ubuntu 20.04 https://pimcore.com/docs/pimcore/current/Development_Documentation/Getting_Started/Installation.html https://pimcore.com/docs/pimcore/current/Development_Documentation/Getting_Started/Installation.html ./bin/console cache:clear
run a command which will survive terminal close?
source: https://superuser.com/questions/448445/run-bash-script-in-background-and-exit-terminal nohup CMD & OR CMD & disown for example nohup python3 /home/scripts/apps/mallasupply/migration/products/migrate_table_product.py &
prestashop: use the manufacturer image when no product image is available
in case of the product page: product-cover-thumbnails.tpls line 35: <img src="{$manufacturer_image_url}" style="width:100%;" /> on product list you […]
mysql: create local user and remote user
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass'; GRANT ALL ON *.* TO 'myuser'@'localhost'; CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass GRANT ALL […]
postgresl: order by first letter ascending
select c_bpartner_id, "name", em_mg_crm_account_id, em_mg_sync_to_msupply from adempiere.c_bpartner where c_bp_group_id = '1000003' -- and em_mg_msupply_manufacturer_id is not null and lower(c_bpartner.name) […]