| ############################################ analyza-nakupu ########################################################### | |
| /* centralServer LOG*/ select hodnota from cssetting where klic = $1 | |
| /* centralServer DETAIL*/ parameters: $1 = 'ACCESS_CONTROL_ALLOW_ORIGIN' | |
| /* centralServer LOG*/ select a.attname from pg_class c join pg_attribute a on a.attrelid = c.oid join pg_type t on t.oid = a.atttypid where relname = 'csuzivatel' and a.attnum > 0 and not a.attisdropped order by a.attnum | |
| /* centralServer LOG*/ SELECT max(dbversion) FROM dbversion WHERE needreimport = 't' | |
| /* centralServer LOG*/ select u.idcsuzivatel, u.jmeno, u.create_company, u.manage_all, u.create_user, u.change_password, u.delete_company, u.grant_permission, u.license_mgmt, u.deleted, u.blocked, u.blocked_text, u.create_dt, u.idcsskupina, u.sso_identifier, u.dbusername, u.default_role, u.given_name, u.family_name, u.email, u.mobile, u.system_user, u.last_dt, u.user_type from csuzivatel u where lower(u.jmeno) = lower($1) and not u.delet |
| --- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md | |
| --- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192 | |
| -- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB. | |
| ------------ | |
| -- Basics -- | |
| ------------ | |
| -- Get indexes of tables |
This tutorial demonstrates how to use Google Apps Script to:
Create copies of the Google Sheet in the desired destination folder automatically at set intervals.
Append the time stamp with each backup file's name.
Adjust time trigger for backing up every day/hour/minute.
| GovData.findEntityByNumber('00006947', | |
| function(entity) { | |
| console.info('Název:', entity.getName()); | |
| if(entity.hasVAT()) { | |
| console.info('Je plátcem DPH.'); | |
| var vat = entity.getVAT(); | |
| if(vat.hasAccounts()) { | |
| var accounts = vat.getAccounts(); |
Find the best resources for learning Google Apps Script, the glue that connects all GSuite services including Gmail, Google Drive, Calendar, Google Sheets, Forms, Maps, Analytics and more.
A good place to learn more about Google Apps Script is the official documentation available at developers.google.com. Here are other Apps Script resources that will help you get up to speed.