Database Queries

-- Postgres

-- Read
select * from popularsongs.artists, popularsongs.albums, popularsongs.songs where artists.id = 9999999 and albums."artistID"= artists.id and songs."artistID"=artists.id;

-- Insert 

INSERT INTO "popularsongs"."albums"("artistID", "name", "imageUrl", "yearPublished") VALUES(1000001, 'John Doe', 'wwww.clonethis.com', 1999) RETURNING "artistID", "name", "imageUrl", "yearPublished";

-- Cassandra 

-- Read
select * from songsdata where id=999999;

-- Insert 
INSERT INTO songsdata (id, artistName, albumArtistID, albumName, imageUrl, yearPublished, songArtistID, songName, streams, length, popularity, inLibrary)
  VALUES (10000001, 'John Doe', 999, 'Jojo', 'wwww,thisisit.com', 1990, 90, 'hello', 903849803, 200, 9303939, true);