sqltk

Functions for simple SQL queries and commands.

Try to make SQL actions more easily.

Install:

go get -v github.com/topxeq/sqltk

Usage:

See the test file(sqltk_test.go) for details.

or in short:

dbT, errT := sqltk.ConnectDB("goracle", dbConnectString)

tk.CheckErrf("failed to connect: %v", errT)

defer dbT.Close()

insertIDT, rowsAffectedT, errT := sqltk.ExecV(dbT, `DROP TABLE TXTEST`)

tk.Plvsr(insertIDT, rowsAffectedT, errT)

createStatementT := `
CREATE TABLE TXTEST (
	ID NUMBER(10),
	USER_NAME VARCHAR(256),
	CODE NUMBER,
	UPDATE_TIME DATE
)
`

insertIDT, rowsAffectedT, errT = sqltk.ExecV(dbT, createStatementT)

tk.CheckErrf("failed to create DB: %v", errT)

tk.Plvsr(insertIDT, rowsAffectedT)

insertIDT, rowsAffectedT, errT = sqltk.ExecV(dbT, `insert into TXTEST (ID, USER_NAME, CODE, UPDATE_TIME) values(:a1, :a2, :a3, TO_DATE(:a4 ,'yyyy-mm-dd hh24:mi:ss'))`, 1, "abc", 1.2, "2019-04-22 15:30:00")

tk.CheckErrf("failed to insert record: %v", errT)

tk.Plvsr(insertIDT, rowsAffectedT)

tk.Plvsr(sqltk.ExecV(dbT, `insert into TXTEST (ID, USER_NAME, CODE, UPDATE_TIME) values(:a1, :a2, :a3, TO_DATE(:a4 ,'yyyy-mm-dd hh24:mi:ss'))`, 1, "abc", 1.2, "2019-04-22 15:30:00"))

resultSetT, errT := sqltk.QueryDBNS(dbT, "select * from TXTEST")

tk.CheckErrf("failed to query: %v", errT)

tk.Plvsr(resultSetT)

tk.Plvsr(sqltk.QueryDBNS(dbT, "select count(*) from TXTEST"))

tk.Plvsr(sqltk.QueryDBI(dbT, "select * from TXTEST"))

tk.Plvsr(sqltk.QueryDBNS(dbT, "select * from TXTEST where ID=?", 3))