sqautoincrement.xo.go

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

// Code generated by xo. DO NOT EDIT.

// SqAutoIncrement represents a row from '[custom sq_auto_increment]'.
type SqAutoIncrement struct {
	TableName string // table_name
	SQL       string // sql
}

// SqAutoIncrements runs a custom query, returning results as SqAutoIncrement.
func SqAutoIncrements(db XODB) ([]*SqAutoIncrement, error) {
	var err error

	// sql query
	const sqlstr = `SELECT ` +
		`name as table_name, sql ` +
		`FROM sqlite_master ` +
		`WHERE type='table' ` +
		`ORDER BY name`

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

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

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

		res = append(res, &sai)
	}

	return res, nil
}