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
}

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
}

--- 
+++ 
@@ -7,10 +7,26 @@
 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
+	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
