# sqltk

**Repository Path**: topxeq/sqltk

## Basic Information

- **Project Name**: sqltk
- **Description**: Functions for simple SQL queries and commands
- **Primary Language**: Go
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-04-24
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 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))