sequence.xo.go

// Package models contains the types for schema 'public'.
package models

// Code generated by xo. DO NOT EDIT.

// Sequence represents a row from '[custom sequence]'.
type Sequence struct {
	TableName string // table_name
}

// PgSequences runs a custom query, returning results as Sequence.
func PgSequences(db XODB, schema string) ([]*Sequence, error) {
	var err error

	// sql query
	const sqlstr = `SELECT ` +
		`t.relname ` + // ::varchar AS table_name
		`FROM pg_class s ` +
		`JOIN pg_depend d ON d.objid = s.oid ` +
		`JOIN pg_class t ON d.objid = s.oid AND d.refobjid = t.oid ` +
		`JOIN pg_namespace n ON n.oid = s.relnamespace ` +
		`WHERE n.nspname = $1 AND s.relkind = 'S'`

	// run query
	XOLog(sqlstr, schema)
	q, err := db.Query(sqlstr, schema)
	if err != nil {
		return nil, err
	}
	defer q.Close()

	// load results
	res := []*Sequence{}
	for q.Next() {
		s := Sequence{}

		// scan
		err = q.Scan(&s.TableName)
		if err != nil {
			return nil, err
		}

		res = append(res, &s)
	}

	return res, nil
}