Пример #1
0
// Get a connection. Notice that this shall not be called from initialization thread.
func New() *mysql.Client {
	mutex.Lock()
	db := cachedb
	now := time.Now()
	if db != nil {
		// There was a cached db connection, use it.
		cachedb = nil
	}
	if db != nil && now.Sub(released) > 1e11 {
		// The saved db was too old, discard it as we don't trust it
		// TODO: Better would be a way to test if it is still valid, but it must not take time.
		db = nil
		// log.Println("Discard the old db")
	}
	mutex.Unlock()
	if db == nil {
		// There was no local cache to be used
		var err error
		db, err = mysql.DialTCP(dbLicenseDatabase, dbDatabaseLogin, dbDatabasePassword, dbDatabaseName)
		if err != nil {
			countFailure++
			if countFailure == maxRetries {
				log.Println(err, "(last warning)")
			} else if countFailure < maxRetries {
				log.Println(err)
			}
		} else {
			countFailure = 0
		}
	}
	return db
}
Пример #2
0
func trymysql() {
	db, err := mysql.DialTCP("localhost", "tim", "letmein", "tim")

	if err != nil {
		os.Exit(1)
	}

	err = db.Query("select name, age, length(name) namelen from tabletest;")
	if err != nil {
		os.Exit(1)
	}

	result, err := db.StoreResult()
	if err != nil {
		os.Exit(1)
	}

	info, err := gemini.LoadTableFromMySQL(result)
	if err != nil {
		fmt.Println(err)
		os.Exit(1)
	}

	tables := make(gemini.TableSet)
	tables["people"] = info
	fmt.Printf("%v\n", *tables["people"])
}
Пример #3
0
func (d *MySQLDriver) Open(dsn string) (driver.Conn, error) {
	hostport, user, passwd, dbname, err := parseDSN(dsn)
	if err != nil {
		return nil, err
	}

	//fmt.Printf("host=%s user=%s pass=%s db=%s\n", hostport, user, passwd, dbname)

	client, err := mysql.DialTCP(hostport, user, passwd, dbname)
	if err != nil {
		return nil, err
	}

	return &MySQLConn{client}, nil
}