si3nloong / sqlike Goto Github PK

Currently, the native driver.Valuer doesn't support statement like CURRENT_TIMESTAMP or UUID() on INSERT, UPDATE and DELETE.

The priority of encoding :

1. reflect.TypeOf (actual data type)
2. db.SqlValuer
3. driver.Valuer
4. reflect.Kind

But reflect.TypeOf will affected pointer data type.

Describe the bug

Database.QueryRow doesn't close, led to a memory leak.

Foreign key also treat as a type of SQL INDEX.

Allow user to set the naming convention using env variable SQL_NAMING_CONVENTION.

References:
https://dev.mysql.com/blog-archive/mysql-8-0-uuid-support/
https://lefred.be/content/mysql-uuids/

CREATE TABLE my_table2 ( 
   uuid BINARY(16) DEFAULT (UUID_TO_BIN(UUID(), 1)) PRIMARY KEY, 
   name VARCHAR(20), 
   beers INT UNSIGNED
);

Dependabot can't resolve your Go dependency files.

As a result, Dependabot couldn't update your dependencies.

The error Dependabot encountered was:

go: go.mongodb.org/[email protected] requires
	github.com/xdg/[email protected]: invalid version: unknown revision

If you think the above is an error on Dependabot's side please don't hesitate to get in touch - we'll do whatever we can to fix it.

View the update logs.

Currently, the documentation in https://www.sqlike.com/docs/api/table is incomplete.

Describe the problem
OpenTracing has been deprecated and got replaced by OpenTelemetry.

Screenshots

SQL Driver Detail (please complete the following information):
Version 1.x.x

Possible Changes

1. when we pass cursor value to Cursor, maybe we should skip the cursor record
2. We required to +1 to check next recordset is exists

Describe the bug
QueryStatement method quotes the raw SQL statement which causes the DB to unable to execute query since it is a string.

To Reproduce
Steps to reproduce the behavior:

1. Code to reproduce:

package main

import (
	"context"
	"log"

	_ "github.com/go-sql-driver/mysql"
	"github.com/si3nloong/sqlike/sqlike"
	"github.com/si3nloong/sqlike/sqlike/options"
)

func main() {
	ctx := context.Background()

	client := sqlike.MustConnect(ctx, "mysql", options.Connect().
		SetUsername("root").
		SetPassword("password").
		SetHost("localhost").
		SetPort("3306"))

	db := client.Database("test")

	_, err := db.QueryStmt(ctx, `SELECT * FROM Product`)
	if err != nil {
		log.Println("err=> ", err)
		return
	}

}

2. Error thrown:

2022/10/16 19:24:53 err=>  Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`SELECT * FROM Product`' at line 1

Expected behavior
QueryStmt should not quote the query params and should execute the SQL statement using query as it is.

Screenshots

https://dev.mysql.com/blog-archive/mysql-8-0-1-using-skip-locked-and-nowait-to-handle-hot-rows/

The current Paginate API is quite frustrating, it's not user-friendly at all, especially when we use it for GraphQL, a lot of boilerplate codes. Suggesting converting it to iteration basic.

Proposed API :

result, err := db.Paginate(ctx, actions.Paginate())
if err != nil {
   panic(err)
}

result.StartCursor()
result.EndCursor()
result.ForEach(func(v T) {})
result.HasNext()
result.HasPrev()
result.Before(ctx, cursor)
result.After(ctx, cursor)

This is useful especially dump to an object storage.