couchbase

Couchbase is distributed NoSQL cloud database.

---

create Scope

CREATE SCOPE royaltypool.raihan;

create collection

CREATE COLLECTION royaltypool.raihan.client;

Primary index

CREATE PRIMARY INDEX `default` ON`royaltypool`.`raihan`.`client`

Insert data

INSERT INTO royaltypool.raihan.client (KEY, VALUE) VALUES('airline_4485',
	{ "callsign": "MY-AIR",
	  "country": "United States",
	  "iata": "Z1",
	  "icao": "AQZ",
	  "name": "80-My Air",
	  "id": "4444",
	   "type": "airline"} )

Insert Multiple Data

INSERT INTO `royaltypool`.raihan.client (KEY,VALUE)
VALUES ( "airline_4444",
    { "callsign": "MY-AIR",
      "country": "United States",
      "iata": "Z1",
      "icao": "AQZ",
      "name": "80-My Air",
      "id": "4444",
      "type": "airline"} ),
VALUES ( "airline_4445",
    { "callsign": "AIR-X",
      "country": "United States",
      "iata": "X1",
      "icao": "ARX",
      "name": "10-AirX",
      "id": "4445",
      "type": "airline"} )
RETURNING *;

Read data

SELECT * FROM royaltypool.raihan.client WHERE id='4444'

Update data

UPDATE royaltypool.raihan.client SET country = "Bangladesh" WHERE id = "4444"

Delete data

DELETE FROM royaltypool.raihan.client WHERE id='4444'