Comments (3)
I did some digging around and found that in bind.go:
var defaultBinds = map[int][]string{
DOLLAR: []string{"postgres", "pgx", "pq-timeouts", "cloudsqlpostgres", "ql", "nrpostgres", "cockroach"},
QUESTION: []string{"mysql", "sqlite3", "nrmysql", "nrsqlite3"},
NAMED: []string{"oci8", "ora", "goracle", "godror"},
AT: []string{"sqlserver"},
}
But db.DriverName() returns "azuresql", which means it gets "UNKNOWN" instead from func BindType.
from sqlx.
adding azuresql solved the problem, i.e. vi bind.go and:
AT: []string{"sqlserver", "azuresql"},
So now this code works:
db, err := sqlx.Open(azuread.DriverName, connectString)
query := "select * from test where region=:region"
arg := map[string]interface{}{
"region": region,
}
query, args, err := sqlx.Named(query, arg)
query = db.Rebind(query)
rows, err = db.Queryx(query, args...)
from sqlx.
closing as #927 has been merged
from sqlx.
Related Issues (20)
- NamedExec issues expanding `VALUES` HOT 3
- sqlx query a lot of data cause tokio bad task. HOT 2
- cpu is sharp increase. and log show can't assign requested address
- Transaction insertion issue
- EASY ONE: SQLX not passing sql.Drivers() through
- BindNamed() should not be deprecated HOT 1
- record and record[] fields coming back as text
- Is this project abandoned? HOT 9
- ConnectContext should close the db when PingContext returns an error
- I NEED YOUR HELP!!! query_as! UPDATE ... SET ...RETURNING...(unsupported type user_role for param #1) HOT 3
- [Question] Inverse of Get/Select? HOT 4
- missing destination name for field while it is not selected
- Behavioural differences between `sql.Named` with query vs `NamedExecContext` cause `UPDATE` error HOT 2
- how to call sqlite3_create_function_v2
- [Proposal] Replace the Test Host Level DB's with containers.
- Issue with mocking PrepareNamed
- Tag new version for dependency security updates HOT 1
- Batch insert still not working HOT 1
- Mysql "... update nowait" does not return error
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlx.