db.go (1324B)
1 package main 2 3 const INSERT_PROVIDER = "INSERT INTO c2ec.provider (name, payto_target_type, backend_base_url, backend_credentials) VALUES ($1,$2,$3,$4)" 4 const INSERT_TERMINAL = "INSERT INTO c2ec.terminal (access_token, description, provider_id) VALUES ($1,$2,$3)" 5 const DEACTIVATE_TERMINAL = "UPDATE c2ec.terminal SET active = false WHERE terminal_id=$1" 6 const ACTIVATE_TERMINAL = "UPDATE c2ec.terminal SET active = true WHERE terminal_id=$1" 7 const GET_PROVIDER_BY_NAME = "SELECT * FROM c2ec.provider WHERE name=$1" 8 const GET_LAST_INSERTED_TERMINAL = "SELECT * FROM c2ec.terminal WHERE terminal_id = (SELECT MAX(terminal_id) FROM c2ec.terminal)" 9 const GET_WITHDRAWAL_BY_WOPID = "SELECT * FROM c2ec.withdrawal WHERE wopid=$1" 10 const GET_WITHDRAWAL_BY_PROVIDER_TRANSACTION_ID = "SELECT * FROM c2ec.withdrawal WHERE provider_transaction_id=$1" 11 12 type Provider struct { 13 ProviderId int64 `db:"provider_id"` 14 Name string `db:"name"` 15 PaytoTargetType string `db:"payto_target_type"` 16 BackendBaseURL string `db:"backend_base_url"` 17 BackendCredentials string `db:"backend_credentials"` 18 } 19 20 type Terminal struct { 21 TerminalID int64 `db:"terminal_id"` 22 AccessToken []byte `db:"access_token"` 23 Active bool `db:"active"` 24 Description string `db:"description"` 25 ProviderID int64 `db:"provider_id"` 26 }