Posts

Load JavaScript and CSS from JSON

 async function loadFile(file) { let x = await fetch(file); return await x.text(); } function loadjscssfile(fileobj){ let css = fileobj.css; let base = js.css; css.file.each(function(i){ loadjscssfile(base+'/'+i,'css'); }) let js = fileobj.js; base = js.base; js.file.each(function(i){ loadjscssfile(base+'/'+i,'js'); }) } function loadjscssfile(filename, filetype){ if (filetype=="js"){ //if filename is a external JavaScript file var fileref=document.createElement('script') fileref.setAttribute("type","text/javascript") fileref.setAttribute("src", filename) } else if (filetype=="css"){ //if filename is an external CSS file var fileref=document.createElement("link") fileref.setAttribute("rel", "stylesheet") fileref.setAttribute("type", "text/css") fileref.setAttribute("href", filename)
Post a Comment
Read more

Get List of tables within a Postgres database

 SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname != 'pg_catalog' AND schemaname != 'information_schema';
Post a Comment
Read more

Trigger In PostgreSQL

Create a Trigger CREATE OR REPLACE TRIGGER add_sms_retry_time BEFORE UPDATE  ON public.sms_pool FOR EACH ROW EXECUTE PROCEDURE public.add_sms_try_time(); Define the Trigger Function CREATE OR REPLACE FUNCTION update_modified_column() RETURNS TRIGGER  LANGUAGE PLPGSQL AS $$ BEGIN IF row(NEW.a2wackid) IS DISTINCT FROM row(OLD.a2wackid) THEN NEW.last_try = now()::TIMESTAMP;  NEW.try_time = concat(OLD.try_time ,', ', to_char(now(), 'DD/MM/YY HH24:MI:SS')); NEW.retry = OLD.retry - 1; END IF; RETURN NEW; END; $$ Remove Trigger and Function  DROP TRIGGER add_sms_retry_time ON sms_pool DROP FUNCTION add_sms_try_time() View the Function Body SELECT proname,prosrc FROM pg_proc WHERE proname= 'update_modified_column'; 
Post a Comment
Read more

Select element by attribute value

Post a Comment
Read more