Automate Joomla Upgrade - Joomla! Forum - community, help and support

dear joomla community,

i maintaining several joomla pages , wrote ansible scripts (configuration management tool) automatically set-up, configure , secure sites on server. also, can read-out latest version of joomla , inform user has upgrade.

now, asking myself how best automatically update joomla in linux (via ansible).
as far understand upgrade consists of 2 parts:
a) update files
b) update database

my questions:
1) a) automatically checkout latest version via git (as of https://github.com/joomla/joomla-cms/tree/3.7.2). see disadvantages here compared pulling upgrade zip folder , overwrite files? find simpler using git repo maintain , git pull/checkout latest version.
2) joomla upgrade procedure in backend when comes upgrading database? there equivalent script can run (e.g. 1 in installation/sql/mysql/joomla.sql)?

thanks lot feedback! willing share scripts if there interest.

(joomla great, me computer scientist want automate , not rely on clicking in gui =) - , yes, want avoid joomla extensions doing automated upgrades me here.)

best munich
sören

make copy of plugin notifies of new joomla version ... rename , edit files reflect new name. modify (instead of sending email) run script(s) components >>> joomla update ... runs when manually click update ?

you possibly similar auto updating 3rd party extensions ?

addendum
or @ https://extensions.joomla.org/extension ... or-joomla/ ?