Example #1
0
func GetDB() (*sql.DB, error) {
	p, err := ds.DefaultCachePath()
	if err != nil {
		return nil, err
	}
	err = mkDir(p)
	var version string
	if err != nil {
		return nil, err
	}
	fp := path.Join(p, fileName)
	mp := path.Join(p, metaName)
	if exists(fp) && exists(mp) {
		b, err := ioutil.ReadFile(mp)
		if err != nil {
			return nil, err
		}
		version = strings.Trim(string(b[:]), "\n\r")
	}
	err = updateDB(version, p)
	if err != nil {
		return nil, err
	}
	return sql.Open("sqlite3", fp)
}
Example #2
0
func main() {
	db, err := GetDB()
	if err != nil {
		log.Fatal(err)
	}
	games, err := queryDB(db, query)
	if err != nil {
		log.Fatal(err)
	}
	p, err := ds.DefaultCachePath()
	if err != nil {
		log.Fatal(err)
	}
	os.RemoveAll(path.Join(p, dbName))
	if err != nil {
		log.Fatal(err)
	}
	ldb, err := leveldb.OpenFile(path.Join(p, dbName), nil)
	if err != nil {
		log.Fatal(err)
	}
	defer ldb.Close()
	for _, g := range games {
		b, err := marshalGame(g)
		if err != nil {
			log.Fatal(err)
		}
		batch := new(leveldb.Batch)
		i := []byte(g.RomID)
		h := []byte(g.Hash)
		hn := []byte(g.Hash + "-name")
		fn := []byte(strings.ToLower(g.FileName))
		batch.Put(i, b)
		batch.Put(h, i)
		batch.Put(fn, i)
		batch.Put(hn, fn)
		err = ldb.Write(batch, nil)
		if err != nil {
			log.Fatal(err)
		}
	}
}
Example #3
0
func main() {
	bioRE := regexp.MustCompile(`- (CAST|CONTRIBUTE|PORTS|SCORING|SERIES|STAFF|TECHNICAL|TRIVIA|UPDATES) -`)
	f, err := os.Open("history.dat")
	if err != nil {
		log.Fatal(err)
	}
	defer f.Close()
	scanner := New(f)
	p, err := ds.DefaultCachePath()
	if err != nil {
		log.Fatal(err)
	}
	os.RemoveAll(filepath.Join(p, dbName))
	if err != nil {
		log.Fatal(err)
	}
	ldb, err := leveldb.OpenFile(filepath.Join(p, dbName), nil)
	if err != nil {
		log.Fatal(err)
	}
	defer ldb.Close()
	var count int
	for {
		e, err := scanner.Scan()
		if err != nil {
			if err == io.EOF {
				break
			}
			log.Fatal(err)
		}
		rID := make([]byte, 4)
		for {
			_, err = rand.Read(rID)
			if err != nil {
				log.Fatal("error:", err)
			}
			ok, err := ldb.Has(rID, nil)
			if err != nil {
				log.Fatal(err)
			}
			if !ok {
				break
			}
		}
		batch := new(leveldb.Batch)
		i := []byte(e.Name)
		bparts := bioRE.Split(e.Bio, 2)
		d := []byte(bparts[0])
		batch.Put(i, rID)
		for _, cs := range e.Clones {
			c := []byte(cs)
			batch.Put(c, rID)
		}
		batch.Put(rID, d)
		err = ldb.Write(batch, nil)
		if err != nil {
			log.Fatal(err)
		}
		count++
	}
	fmt.Printf("Found: %d\n", count)
}