Open platform to collect and prioritize feedback
package backup
import (
"context"
"database/sql"
"encoding/json"
"fmt"
"strconv"
"github.com/getfider/fider/app"
"github.com/getfider/fider/app/models/entity"
"github.com/getfider/fider/app/pkg/dbx"
)
func exportTable(ctx context.Context, tableName string) ([]byte, error) {
trx := ctx.Value(app.TransactionCtxKey).(*dbx.Trx)
tenant, _ := ctx.Value(app.TenantCtxKey).(*entity.Tenant)
columnName := "tenant_id"
if tableName == "tenants" {
columnName = "id"
}
rows, err := trx.Query(fmt.Sprintf("SELECT * FROM %s WHERE %s = $1", tableName, columnName), tenant.ID)
if err != nil {
return nil, err
}
return json.Marshal(jsonify(rows))
}
func jsonify(rows *sql.Rows) []map[string]any {
defer func() { _ = rows.Close() }()
columns, err := rows.Columns()
if err != nil {
panic(err.Error())
}
allResults := make([]map[string]any, 0)
for rows.Next() {
results := make(map[string]any)
values := make([]any, len(columns))
scanArgs := make([]any, len(values))
for i := range values {
scanArgs[i] = &values[i]
}
err = rows.Scan(scanArgs...)
if err != nil {
panic(err.Error())
}
for i, value := range values {
switch value := value.(type) {
case nil:
results[columns[i]] = nil
case []byte:
s := string(value)
x, err := strconv.Atoi(s)
if err != nil {
results[columns[i]] = s
} else {
results[columns[i]] = x
}
default:
results[columns[i]] = value
}
}
allResults = append(allResults, results)
}
return allResults
}