Cesar Gimenes crgimenes

## README.md

      
              3 files
            
          
              2 forks
            
          
              5 comments
            
          
              7 stars
            
          
                crgimenes
                / README.md
            
            
              Last active
              July 12, 2023 09:42
            
              
                Example of pagination using PostgreSQL, Golang and SQLx
              
          
    Configure environment variable
export DATABASE_URL=postgres://postgres@localhost/dbname?sslmode=disable 
Run in CLI
go run main.go -page 1

  
## tempFileName.go
func newFileName() string {
	buff := make([]byte, 6)
	rand.Read(buff)
	return fmt.Sprintf("%v-%X\n", time.Now().UTC().Format("2006-01-02T150405"), buff)
}

## draftFilesystem.go
package main

import (
	"context"
	"flag"
	"fmt"
	"io"
	"os"
	"syscall"

## closer.go
package helper

// closer close descriptor and log error
func closer(f io.Closer) {
	err := f.Close()
	if err != nil {
		log.Errorln("closing ", err)
	}
}

## execHelper.go
func execHelper(path, name string, arg ...string) (err error) {
	cmd := exec.Command(name, arg...)
	cmd.Dir = path
	cmd.Stdout = os.Stdout
	cmd.Stderr = os.Stderr
	err = cmd.Run()
	return
}

## SeekingBuffer.go
// https://play.golang.org/p/8SjYn-cisj
package main

import (
	"bytes"
	"fmt"
	"io"
	"os"
)

## closer.go
func closer(body io.Closer) {
	err := body.Close()
	if err != nil {
		log.Errorln(err)
	}
}

// defer closer(fileDescriptor)

## TestHTTPHandler.go

func TestHTTPHandler(t *testing.T) {
	w := httptest.NewRecorder()
	expected := "{\n\t\"error\": \"test error\"\n}\n"

	HTTPHandler(w, nil)
	b := w.Body.Bytes()

	if string(b) != expected {
		t.Errorf("expected %q, want %q", expected, string(b))

## stringToReaderCloser.go
package main

import (
	"bytes"
	"fmt"
	"io"
	"os"
	"strings"
)

## memoizedFibonacci.go
package fibonacci

type Memoized func(int) int
var fibMem = Memoize(fib)

func Memoize(mf Memoized) Memoized {
	cache := make(map[int]int)
	return func(key int) int {
		if val, found := cache[key]; found {
			return val
	func newFileName() string {
	buff := make([]byte, 6)
	rand.Read(buff)
	return fmt.Sprintf("%v-%X\n", time.Now().UTC().Format("2006-01-02T150405"), buff)
	}
	package helper

	// closer close descriptor and log error
	func closer(f io.Closer) {
	err := f.Close()
	if err != nil {
	log.Errorln("closing ", err)
	}
	}
	func execHelper(path, name string, arg ...string) (err error) {
	cmd := exec.Command(name, arg...)
	cmd.Dir = path
	cmd.Stdout = os.Stdout
	cmd.Stderr = os.Stderr
	err = cmd.Run()
	return
	}
	// https://play.golang.org/p/8SjYn-cisj
	package main

	import (
	"bytes"
	"fmt"
	"io"
	"os"
	)
	func closer(body io.Closer) {
	err := body.Close()
	if err != nil {
	log.Errorln(err)
	}
	}

	// defer closer(fileDescriptor)

	func TestHTTPHandler(t *testing.T) {
	w := httptest.NewRecorder()
	expected := "{\n\t\"error\": \"test error\"\n}\n"

	HTTPHandler(w, nil)
	b := w.Body.Bytes()

	if string(b) != expected {
	t.Errorf("expected %q, want %q", expected, string(b))
	package fibonacci

	type Memoized func(int) int
	var fibMem = Memoize(fib)

	func Memoize(mf Memoized) Memoized {
	cache := make(map[int]int)
	return func(key int) int {
	if val, found := cache[key]; found {
	return val