加载服务ID
()
| 442 | |
| 443 | // 加载服务ID |
| 444 | func (this *SQLiteTask) loadServerIdMap() error { |
| 445 | { |
| 446 | rows, err := this.db.Query(`SELECT DISTINCT "serverId" FROM `+this.statTableName+" WHERE version=?", this.itemConfig.Version) |
| 447 | if err != nil { |
| 448 | return err |
| 449 | } |
| 450 | defer func() { |
| 451 | _ = rows.Close() |
| 452 | }() |
| 453 | |
| 454 | var serverId int64 |
| 455 | for rows.Next() { |
| 456 | err = rows.Scan(&serverId) |
| 457 | if err != nil { |
| 458 | return err |
| 459 | } |
| 460 | this.serverIdMapLocker.Lock() |
| 461 | this.serverIdMap[serverId] = zero.New() |
| 462 | this.serverIdMapLocker.Unlock() |
| 463 | } |
| 464 | } |
| 465 | |
| 466 | { |
| 467 | rows, err := this.db.Query(`SELECT DISTINCT "time" FROM `+this.statTableName+" WHERE version=?", this.itemConfig.Version) |
| 468 | if err != nil { |
| 469 | return err |
| 470 | } |
| 471 | defer func() { |
| 472 | _ = rows.Close() |
| 473 | }() |
| 474 | |
| 475 | var timeString string |
| 476 | for rows.Next() { |
| 477 | err = rows.Scan(&timeString) |
| 478 | if err != nil { |
| 479 | return err |
| 480 | } |
| 481 | this.serverIdMapLocker.Lock() |
| 482 | this.timeMap[timeString] = zero.New() |
| 483 | this.serverIdMapLocker.Unlock() |
| 484 | } |
| 485 | } |
| 486 | |
| 487 | return nil |
| 488 | } |
| 489 | |
| 490 | // 计算数量和综合 |
| 491 | func (this *SQLiteTask) sum(serverId int64, time string) (count int64, total float64, err error) { |