pq_driver.go 2.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119
  1. // Copyright 2015 The Xorm Authors. All rights reserved.
  2. // Use of this source code is governed by a BSD-style
  3. // license that can be found in the LICENSE file.
  4. package xorm
  5. import (
  6. "errors"
  7. "fmt"
  8. "net/url"
  9. "sort"
  10. "strings"
  11. "github.com/xormplus/core"
  12. )
  13. // func init() {
  14. // core.RegisterDriver("postgres", &pqDriver{})
  15. // }
  16. type pqDriver struct {
  17. }
  18. type values map[string]string
  19. func (vs values) Set(k, v string) {
  20. vs[k] = v
  21. }
  22. func (vs values) Get(k string) (v string) {
  23. return vs[k]
  24. }
  25. func errorf(s string, args ...interface{}) {
  26. panic(fmt.Errorf("pq: %s", fmt.Sprintf(s, args...)))
  27. }
  28. func parseURL(connstr string) (string, error) {
  29. u, err := url.Parse(connstr)
  30. if err != nil {
  31. return "", err
  32. }
  33. if u.Scheme != "postgres" {
  34. return "", fmt.Errorf("invalid connection protocol: %s", u.Scheme)
  35. }
  36. var kvs []string
  37. escaper := strings.NewReplacer(` `, `\ `, `'`, `\'`, `\`, `\\`)
  38. accrue := func(k, v string) {
  39. if v != "" {
  40. kvs = append(kvs, k+"="+escaper.Replace(v))
  41. }
  42. }
  43. if u.User != nil {
  44. v := u.User.Username()
  45. accrue("user", v)
  46. v, _ = u.User.Password()
  47. accrue("password", v)
  48. }
  49. i := strings.Index(u.Host, ":")
  50. if i < 0 {
  51. accrue("host", u.Host)
  52. } else {
  53. accrue("host", u.Host[:i])
  54. accrue("port", u.Host[i+1:])
  55. }
  56. if u.Path != "" {
  57. accrue("dbname", u.Path[1:])
  58. }
  59. q := u.Query()
  60. for k := range q {
  61. accrue(k, q.Get(k))
  62. }
  63. sort.Strings(kvs) // Makes testing easier (not a performance concern)
  64. return strings.Join(kvs, " "), nil
  65. }
  66. func parseOpts(name string, o values) {
  67. if len(name) == 0 {
  68. return
  69. }
  70. name = strings.TrimSpace(name)
  71. ps := strings.Split(name, " ")
  72. for _, p := range ps {
  73. kv := strings.Split(p, "=")
  74. if len(kv) < 2 {
  75. errorf("invalid option: %q", p)
  76. }
  77. o.Set(kv[0], kv[1])
  78. }
  79. }
  80. func (p *pqDriver) Parse(driverName, dataSourceName string) (*core.Uri, error) {
  81. db := &core.Uri{DbType: core.POSTGRES}
  82. o := make(values)
  83. var err error
  84. if strings.HasPrefix(dataSourceName, "postgres://") {
  85. dataSourceName, err = parseURL(dataSourceName)
  86. if err != nil {
  87. return nil, err
  88. }
  89. }
  90. parseOpts(dataSourceName, o)
  91. db.DbName = o.Get("dbname")
  92. if db.DbName == "" {
  93. return nil, errors.New("dbname is empty")
  94. }
  95. return db, nil
  96. }