misc

package main

import (
	"fmt"

	"github.com/horus-es/go-util/v2/errores"
	"github.com/horus-es/go-util/v2/formato"
	"github.com/horus-es/go-util/v2/misc"
	"github.com/jackc/pgx/v5/pgtype"
)

func main() {
	unDia := pgtype.Interval{Days: 1, Valid: true}
	fechaInicial, err := formato.ParseTimestamp("4/7/2023 12:00", formato.DMA)
	errores.PanicIfError(err)
	fechaSiguiente := misc.AddInterval(fechaInicial, unDia)
	fmt.Println(formato.PrintTimestamp(fechaSiguiente, formato.DMA))
}

Output:

05/07/2023 12:00

package main

import (
	"fmt"

	"github.com/horus-es/go-util/v2/misc"
)

func main() {
	sql := `select * from tabla where nombre=` + misc.EscapeSQL("O'Brian")
	fmt.Println(sql)
}

Output:

select * from tabla where nombre='O''Brian'

package main

import (
	"fmt"

	"github.com/horus-es/go-util/v2/misc"
)

func main() {
	codigos := []string{"cero", "uno", "dos", "tres"}
	sql := `select * from tabla where codigo` + misc.SqlIn(codigos[1:]...)
	fmt.Println(sql)
}

Output:

select * from tabla where codigo in ('uno','dos','tres')

package main

import (
	"fmt"

	"github.com/horus-es/go-util/v2/errores"
	"github.com/horus-es/go-util/v2/formato"
	"github.com/horus-es/go-util/v2/misc"
	"github.com/jackc/pgx/v5/pgtype"
)

func main() {
	unDia := pgtype.Interval{Days: 1, Valid: true}
	fechaInicial, err := formato.ParseTimestamp("4/7/2023 12:00", formato.DMA)
	errores.PanicIfError(err)
	fechaAnterior := misc.SubInterval(fechaInicial, unDia)
	fmt.Println(formato.PrintTimestamp(fechaAnterior, formato.DMA))
}

Output:

03/07/2023 12:00

package main

import (
	"fmt"

	"github.com/horus-es/go-util/v2/misc"
)

func main() {
	fmt.Println(misc.Title("hola mundo otra vEZ"))
}

Output:

Hola Mundo Otra VEZ