package db

import sq "github.com/lann/squirrel"

// CoreOfferRecordSelect is a sql fragment to help select form queries that
// select into a CoreOfferRecord
var CoreOfferRecordSelect = sq.Select(
	"co.accountid",
	"co.offerid",
).From("offers co")

// CoreOfferRecord is row of data from the `offers` table from stellar-core
type CoreOfferRecord struct {
	Accountid string
	Offerid   int64
}

package db

import sq "github.com/lann/squirrel"

// CoreOfferRecordSelect is a sql fragment to help select form queries that
// select into a CoreOfferRecord
var CoreOfferRecordSelect = sq.Select(
	"co.accountid",
	"co.offerid",
	"co.paysalphanumcurrency",
	"co.paysissuer",
	"co.getsalphanumcurrency",
	"co.getsissuer",
	"co.amount",
	"co.pricen",
	"co.priced",
	"co.price",
).From("offers co")

// CoreOfferRecord is row of data from the `offers` table from stellar-core
type CoreOfferRecord struct {
	Accountid            string
	Offerid              int64
	Paysalphanumcurrency string
	Paysissuer           string
	Getsalphanumcurrency string
	Getsissuer           string
	Amount               int64
	Pricen               int32
	Priced               int32
	Price                int64
}

Add additional columns to CoreOfferRecord
Add additional columns to CoreOfferRecord
