func GenMySQL(u *URL) (string, error) {
	host, port, dbname := hostname(u.Host), hostport(u.Host), strings.TrimPrefix(u.Path, "/")

	var dsn string

	// build user/pass
	if u.User != nil {
		if un := u.User.Username(); len(un) > 0 {
			if up, ok := u.User.Password(); ok {
				un += ":" + up
			}
			dsn += un + "@"
		}
	}

	// resolve path
	if u.Proto == "unix" {
		if host == "" {
			dbname = "/" + dbname
		}
		host, dbname = resolveSocket(stdpath.Join(host, dbname))
		port = ""
	}

	// save host, port, dbname
	if u.hostPortDB == nil {
		u.hostPortDB = []string{host, port, dbname}
	}

	// if host or proto is not empty
	if u.Proto != "unix" {
		if host == "" {
			host = "127.0.0.1"
		}
		if port == "" {
			port = "3306"
		}
	}
	if port != "" {
		port = ":" + port
	}

	dsn += u.Proto + "(" + host + port + ")"

	// add database name
	dsn += "/" + dbname

	return dsn + genQueryOptions(u.Query()), nil
}
func GenMySQL(u *URL) (string, error) {
	host, port, dbname := hostname(u.Host), hostport(u.Host), strings.TrimPrefix(u.Path, "/")

	var dsn string

	
	if u.User != nil {
		if un := u.User.Username(); len(un) > 0 {
			if up, ok := u.User.Password(); ok {
				un += ":" + up
			}
			dsn += un + "@"
		}
	}

	
	if u.Proto == "unix" {
		if host == "" {
			dbname = "/" + dbname
		}
		host, dbname = resolveSocket(stdpath.Join(host, dbname))
		port = ""
	}

	
	if u.hostPortDB == nil {
		u.hostPortDB = []string{host, port, dbname}
	}

	
	if u.Proto != "unix" {
		if host == "" {
			host = "127.0.0.1"
		}
		if port == "" {
			port = "3306"
		}
	}
	if port != "" {
		port = ":" + port
	}

	dsn += u.Proto + "(" + host + port + ")"

	
	dsn += "/" + dbname

	return dsn + genQueryOptions(u.Query()), nil
}
func GenMySQL ( u * URL ) ( string , error ) { host , port , dbname := hostname ( u . Host ) , hostport ( u . Host ) , strings . TrimPrefix ( u . Path , " " ) var dsn string // build user/pass if u . User != nil { if un := u . User . Username ( ) ; len ( un ) > 0 { if up , ok := u . User . Password ( ) ; ok { un += " " + up } dsn += un + " " } } // resolve path if u . Proto == " " { if host == " " { dbname = " " + dbname } host , dbname = resolveSocket ( stdpath . Join ( host , dbname ) ) port = " " } // save host, port, dbname if u . hostPortDB == nil { u . hostPortDB = [ ] string { host , port , dbname } } // if host or proto is not empty if u . Proto != " " { if host == " " { host = " " } if port == " " { port = " " } } if port != " " { port = " " + port } dsn += u . Proto + " " + host + port + " " // add database name dsn += " " + dbname return dsn + genQueryOptions ( u . Query ( ) ) , nil }
// // GenSybase generates a sqlany DSN from the passed URL.
// func GenSybase(u *URL) (string, error) {
// 	// of format "UID=DBA;PWD=sql;Host=demo12;DatabaseName=demo;ServerName=myserver"
// 	host, port, dbname := hostname(u.Host), hostport(u.Host), strings.TrimPrefix(u.Path, "/")
//
// 	// add instance name to host if present
// 	if i := strings.Index(dbname, "/"); i != -1 {
// 		host = host + `\` + dbname[:i]
// 		dbname = dbname[i+1:]
// 	}
//
// 	q := u.Query()
// 	q.Set("Host", host)
// 	if port != "" {
// 		q.Set("LINKS", "tcpip(PORT="+port+")")
// 	}
// 	q.Set("DatabaseName", dbname)
//
// 	// add user/pass
// 	if u.User != nil {
// 		q.Set("UID", u.User.Username())
// 		pass, _ := u.User.Password()
// 		q.Set("PWD", pass)
// 	}
//
// 	// save host, port, dbname
// 	if u.hostPortDB == nil {
// 		u.hostPortDB = []string{host, port, dbname}
// 	}
//
// 	return genOptionsODBC(q, true), nil
// }
// GenMySQL generates a mysql DSN from the passed URL.
// GenSybase generates a sqlany DSN from the passed URL . func GenSybase ( u * URL ) ( string error ) { // of format UID = DBA ; PWD = sql ; Host = demo12 ; DatabaseName = demo ; ServerName = myserver host port dbname : = hostname ( u . Host ) hostport ( u . Host ) strings . TrimPrefix ( u . Path / ) // add instance name to host if present if i : = strings . Index ( dbname / ) ; i ! = - 1 { host = host + \ + dbname [ : i ] dbname = dbname [ i + 1 : ] } q : = u . Query () q . Set ( Host host ) if port ! = { q . Set ( LINKS tcpip ( PORT = + port + ) ) } q . Set ( DatabaseName dbname ) // add user / pass if u . User ! = nil { q . Set ( UID u . User . Username () ) pass _ : = u . User . Password () q . Set ( PWD pass ) } // save host port dbname if u . hostPortDB == nil { u . hostPortDB = [] string { host port dbname } } return genOptionsODBC ( q true ) nil } GenMySQL generates a mysql DSN from the passed URL .