dickyaryag6

INSERT INTO person
(name, country, job, age)
values ('Mike', 'England', 'Software Engineer', 30)
ON CONFLICT (name)
DO NOTHING;

dickyaryag6

INSERT INTO person
(name, country, job, age)
values ('Danny', 'England', 'Software Engineer', 30)
ON CONFLICT ON CONSTRAINT person_name_unique
DO NOTHING;

dickyaryag6

INSERT INTO person
(name, country, job, age)
values ('Danny', 'England', 'Software Engineer', 30)
ON CONFLICT (name)
DO NOTHING;

dickyaryag6

INSERT INTO person
("name", country, job, age)
values
('Danny', 'England', 'Software Engineer', 30),
('Peter', 'Egypt', 'Front End Engineer', 32);

dickyaryag6

ALTER TABLE person
ADD CONSTRAINT person_name_unique UNIQUE ("name");

dickyaryag6

CREATE TABLE person (
  id bigserial NOT NULL,
  name varchar NOT NULL,
  country varchar NOT NULL,
  job varchar NOT NULL,
  age int NOT NULL
);

dickyaryag6

package main

import (
	"context"
	"encoding/json"
	"fmt"
	"log"

	"google.golang.org/api/option"
	"google.golang.org/api/sheets/v4"

dickyaryag6

func GetCellValue(srv *sheets.Service) {
	values, err := srv.Spreadsheets.Values.Get(spreadsheetId, "Sheet1!A2:E7").Do()

	if err != nil {
		log.Fatalf("Unable to Get data from sheet: %v", err)
	}
	
	for _, value := range values.Values {
		fmt.Println(value)
	}

dickyaryag6

func ClearColumn(srv *sheets.Service) {

	cvr := sheets.ClearValuesRequest{}
	_, err := srv.Spreadsheets.Values.Clear(spreadsheetId, "Sheet1!C2:C", &cvr).Do()

	if err != nil {
		log.Fatalf("Unable to clear data from sheet: %v", err)
	}

}

dickyaryag6

func ClearCell(srv *sheets.Service) {
	
	cvr := &sheets.ClearValuesRequest{}
	_, err := srv.Spreadsheets.Values.Clear(spreadsheetId, "Sheet1!B2", cvr).Do()

	if err != nil {
		log.Fatalf("Unable to clear data from sheet: %v", err)
	}

}