rmulley/go-fast-sql

Go library to increase SQL performance and ease development

go-fast-sql's Issues

Add support for Channels

Ideally a user should be able to drop queries, probably of a specified struct type, into a channel and allow the go-fast-sql library to handle flushing behind the scenes.

'ON DUPLICATE KEY UPDATE' queries do not work

Automated integration tests

Batch updates

Speed up Updates by batching them as explained at http://stackoverflow.com/questions/1006969/why-are-batch-inserts-updates-faster-how-do-batch-updates-work

UPDATE mytable
SET 
  mytext = myvalues.mytext,
  myint = myvalues.myint
FROM (
  VALUES
    (1, 'textA', 99),
    (2, 'textB', 88),
    ...
) AS myvalues (mykey, mytext, myint)
WHERE mytable.mykey = myvalues.mykey

Cleanup based on golint feedback

Use the golint tool and incorporate feedback.

Rename and restructure

Renamed repo, need to restructure for expansion beyond INSERTs

Indexing error with space between Value and parenthesis

If you write a query like:

INSERT INTO
    table
VALUES
    (?, ?);

Parsing of the query fails due to the space between the S in VALUES and the opening (. The parsing should account for this.

Add support for database transactions

Design go-fast-sql as a wrapper around database/sql

Similar to sqlx, create a custom DB struct that wraps Go's built-in database/sql pkg. This will mean users only need to create one struct, fastsql.DB instead of two. It will also allow users to access all std library functions from database/sql.

Snippet taken from https://github.com/jmoiron/sqlx/blob/master/sqlx.go

// DB is a wrapper around sql.DB which keeps track of the driverName upon Open,
// used mostly to automatically bind named queries using the right bindvars.
type DB struct {
*sql.DB
driverName string
unsafe bool
Mapper *reflectx.Mapper
}
// NewDb returns a new sqlx DB wrapper for a pre-existing *sql.DB. The
// driverName of the original database is required for named query support.
func NewDb(db *sql.DB, driverName string) *DB {
return &DB{DB: db, driverName: driverName, Mapper: mapper()}
}
// DriverName returns the driverName passed to the Open function for this DB.
func (db *DB) DriverName() string {
return db.driverName
}
// Open is the same as sql.Open, but returns an *sqlx.DB instead.
func Open(driverName, dataSourceName string) (*DB, error) {
db, err := sql.Open(driverName, dataSourceName)
if err != nil {
return nil, err
}
return &DB{DB: db, driverName: driverName, Mapper: mapper()}, err
}

Add support for different insert queries

I perform four different INSERT types in my program and I want to batch them. Normal usage of BatchInsert doesn't allow it (result: sql expected arguments error). I know I could create four different DB's but SQLite would not handle that.

What about restructuring your lib (without breaking API) to provide support for different INSERTs? It would be really great feature.