AUX_SQL_QUERIES.md

AUX_SQL_QUERIES.md

Queries

Create Column

ALTER TABLE 
	"fbGroups_posts_clean" 
ADD COLUMN "POST_TAG" "TEXT"

ALTER TABLE 
	"fbGroups_posts_clean" 
ADD COLUMN "POST_TAG_TIMESTAMP" "TEXT"

Set values to Column

UPDATE fbGroups_posts_clean
	SET POST_TAG = "SIN_ETIQUETA"
WHERE POST_TAG is NULL;
   

OHTER

UPDATE fbGroups_posts_clean
SET "POST_REMOTE_IMAGE_LINK" = "https://firebasestorage.googleapis.com/v0/b/analytics-4ab50.appspot.com/o/default_bike.png?alt=media&token=7cd8860e-5e12-4f6e-b374-993f14bb667c"
WHERE "POST_REMOTE_IMAGE_LINK" is NULL;

Update post

UPDATE "fbGroups_posts_clean"
SET "POST_TAG" = "MASISTA",
    "POST_TAG_TIMESTAMP" = "2020-02-01 20:20:20"
WHERE POST_ID  == "999064333883907"

Delete rows

DELETE FROM fbGroups_posts_clean 
WHERE SCRAP_ORIGIN == "AlguienSabeBo"

List Posts

SELECT * FROM fbGroups_posts_clean
WHERE "POST_TAG" == "SIN_ETIQUETA"
LIMIT 5;

Docker

Get into docker iamge

docker exec -ti b7b1e0e884e3 sh