1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
|
// Copyright (C) 2019-2023 Algorand, Inc.
// This file is part of go-algorand
//
// go-algorand is free software: you can redistribute it and/or modify
// it under the terms of the GNU Affero General Public License as
// published by the Free Software Foundation, either version 3 of the
// License, or (at your option) any later version.
//
// go-algorand is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU Affero General Public License for more details.
//
// You should have received a copy of the GNU Affero General Public License
// along with go-algorand. If not, see <https://www.gnu.org/licenses/>.
package account
import (
"database/sql"
"fmt"
)
// PartTableSchemaName is the name of the table in the Schema Versions table storing the table + version details
const PartTableSchemaName = "parttable"
// PartTableSchemaVersion is the latest version of the PartTable schema
const PartTableSchemaVersion = 3
// ErrUnsupportedSchema is the error returned when the PartTable schema version is wrong.
var ErrUnsupportedSchema = fmt.Errorf("unsupported participation file schema version (expected %d)", PartTableSchemaVersion)
func partInstallDatabase(tx *sql.Tx) error {
var err error
_, err = tx.Exec(`CREATE TABLE ParticipationAccount (
parent BLOB,
--* participation keys
vrf BLOB, --* msgpack encoding of ParticipationAccount.vrf
voting BLOB, --* msgpack encoding of ParticipationAccount.voting
firstValid INTEGER,
lastValid INTEGER,
keyDilution INTEGER NOT NULL DEFAULT 0,
stateProof BLOB --* msgpack encoding of ParticipationAccount.StateProof
);`)
if err != nil {
return err
}
_, err = tx.Exec(`CREATE TABLE schema (
tablename TEXT PRIMARY KEY,
version INTEGER
);`)
if err != nil {
return err
}
_, err = tx.Exec("INSERT INTO schema (tablename, version) VALUES (?, ?)",
PartTableSchemaName, PartTableSchemaVersion)
if err != nil {
return err
}
return nil
}
func partMigrate(tx *sql.Tx) (err error) {
rows, err := tx.Query("SELECT tablename, version FROM schema")
if err != nil {
return ErrUnsupportedSchema
}
defer rows.Close()
versions := make(map[string]int)
for rows.Next() {
var tableName string
var version int
err = rows.Scan(&tableName, &version)
if err != nil {
return err
}
versions[tableName] = version
}
err = rows.Err()
if err != nil {
return err
}
partVersion, has := versions[PartTableSchemaName]
if !has {
return ErrUnsupportedSchema
}
partVersion, err = updateDB(tx, partVersion)
if err != nil {
return err
}
if partVersion != PartTableSchemaVersion {
return ErrUnsupportedSchema
}
return nil
}
func updateDB(tx *sql.Tx, partVersion int) (int, error) {
if partVersion == 1 {
_, err := tx.Exec("ALTER TABLE ParticipationAccount ADD keyDilution INTEGER NOT NULL DEFAULT 0")
if err != nil {
return 0, err
}
partVersion = 2
_, err = tx.Exec("UPDATE schema SET version=? WHERE tablename=?", partVersion, PartTableSchemaName)
if err != nil {
return 0, err
}
}
if partVersion == 2 {
_, err := tx.Exec("ALTER TABLE ParticipationAccount ADD stateProof BLOB")
if err != nil {
return 0, err
}
partVersion = 3
_, err = tx.Exec("UPDATE schema SET version=? WHERE tablename=?", partVersion, PartTableSchemaName)
if err != nil {
return 0, err
}
}
return partVersion, nil
}
|
