movie.gen.go

package models

// ************************************************************
// This is an example Postgres generated model.
// ************************************************************
// Options:
//   postgresInt64JsonString: true
//   createdDateFields: created_at
//   updatedDateFields: updated_at

import (
	"fmt"
	"github.com/lib/pq"
	"strings"
	"time"
)

type Movie struct {
	Id                   *int32          `db:"id" json:"id"`
	Budget               *int64          `db:"budget" json:"budget,string"`
	ClientId             *string         `db:"client_id" json:"client_id"`
	CompletedCoordinates interface{}     `db:"completed_coordinates" json:"completed_coordinates"`
	CreatedAt            *time.Time      `db:"created_at" json:"created_at"`
	DataSyncedAt         *time.Time      `db:"data_synced_at" json:"data_synced_at"`
	DistanceToPlace      *float64        `db:"distance_to_place" json:"distance_to_place"`
	Homepage             *string         `db:"homepage" json:"homepage"`
	IsCompleted          *bool           `db:"is_completed" json:"is_completed"`
	Keywords             *pq.StringArray `db:"keywords" json:"keywords"`
	KeywordsSearch       *string         `db:"keywords_search" json:"keywords_search"`
	LocationAccuracy     *int32          `db:"location_accuracy" json:"location_accuracy"`
	OriginalLanguage     *string         `db:"original_language" json:"original_language"`
	OriginalTitle        *string         `db:"original_title" json:"original_title"`
	Overview             *string         `db:"overview" json:"overview"`
	Popularity           *float64        `db:"popularity" json:"popularity"`
	ReleaseDate          *time.Time      `db:"release_date" json:"release_date"`
	Revenue              *int64          `db:"revenue" json:"revenue,string"`
	Runtime              *int32          `db:"runtime" json:"runtime"`
	SearchVector         *string         `db:"search_vector" json:"search_vector"`
	Status               *string         `db:"status" json:"status"`
	Summary              *string         `db:"summary" json:"summary"`
	Synopsis             *string         `db:"synopsis" json:"synopsis"`
	Tagline              *string         `db:"tagline" json:"tagline"`
	Title                *string         `db:"title" json:"title"`
	TitleSearch          *string         `db:"title_search" json:"title_search"`
	UpdatedAt            *time.Time      `db:"updated_at" json:"updated_at"`
	VoteAverage          *float64        `db:"vote_average" json:"vote_average"`
	VoteCount            *int32          `db:"vote_count" json:"vote_count"`
}

func (m *Movie) String() string {
	content := strings.Join(
		[]string{
			fmt.Sprintf("Id: %v", *m.Id),
			fmt.Sprintf("Budget: %v", *m.Budget),
			fmt.Sprintf("ClientId: %v", *m.ClientId),
			// fmt.Sprintf("CompletedCoordinates: %v", *m.CompletedCoordinates),
			fmt.Sprintf("CreatedAt: %v", *m.CreatedAt),
			fmt.Sprintf("DataSyncedAt: %v", *m.DataSyncedAt),
			fmt.Sprintf("DistanceToPlace: %v", *m.DistanceToPlace),
			fmt.Sprintf("Homepage: %v", *m.Homepage),
			fmt.Sprintf("IsCompleted: %v", *m.IsCompleted),
			fmt.Sprintf("Keywords: %v", *m.Keywords),
			fmt.Sprintf("KeywordsSearch: %v", *m.KeywordsSearch),
			fmt.Sprintf("LocationAccuracy: %v", *m.LocationAccuracy),
			fmt.Sprintf("OriginalLanguage: %v", *m.OriginalLanguage),
			fmt.Sprintf("OriginalTitle: %v", *m.OriginalTitle),
			fmt.Sprintf("Overview: %v", *m.Overview),
			fmt.Sprintf("Popularity: %v", *m.Popularity),
			fmt.Sprintf("ReleaseDate: %v", *m.ReleaseDate),
			fmt.Sprintf("Revenue: %v", *m.Revenue),
			fmt.Sprintf("Runtime: %v", *m.Runtime),
			fmt.Sprintf("SearchVector: %v", *m.SearchVector),
			fmt.Sprintf("Status: %v", *m.Status),
			fmt.Sprintf("Summary: %v", *m.Summary),
			fmt.Sprintf("Synopsis: %v", *m.Synopsis),
			fmt.Sprintf("Tagline: %v", *m.Tagline),
			fmt.Sprintf("Title: %v", *m.Title),
			fmt.Sprintf("TitleSearch: %v", *m.TitleSearch),
			fmt.Sprintf("UpdatedAt: %v", *m.UpdatedAt),
			fmt.Sprintf("VoteAverage: %v", *m.VoteAverage),
			fmt.Sprintf("VoteCount: %v", *m.VoteCount),
		},
		", ",
	)

	return fmt.Sprintf("Movie{%s}", content)
}

func (m *Movie) TableName() string {
	return "public.movies"
}

func (m *Movie) PrimaryKey() []string {
	return []string{
		"id",
	}
}

func (m *Movie) InsertQuery() string {
	return movieInsertSql
}

func (m *Movie) CountQuery() string {
	return movieModelCountSql
}

func (m *Movie) FindAllQuery() string {
	return movieFindAllSql
}

func (m *Movie) FindFirstQuery() string {
	return movieFindFirstSql
}

func (m *Movie) FindByPkQuery() string {
	return movieFindByPkSql
}

func (m *Movie) DeleteByPkQuery() string {
	return movieDeleteByPkSql
}

func (m *Movie) DeleteAllQuery() string {
	return movieDeleteAllSql
}

func (m *Movie) GetPkWhere() string {
	return moviePkFieldsWhere
}

func (m *Movie) GetAllFieldsWhere() string {
	return movieAllFieldsWhere
}

func (m *Movie) GetReturning() string {
	return movieReturningFields
}

// language=postgresql
var movieAllFieldsWhere = `
WHERE TRUE
    AND (CAST(:id AS INT4) IS NULL or id = :id)
    AND (CAST(:budget AS INT8) IS NULL or budget = :budget)
    AND (CAST(:client_id AS VARCHAR) IS NULL or client_id = :client_id)
    -- completed_coordinates / POINT is not supported here
    AND (CAST(:created_at AS TIMESTAMP) IS NULL or created_at = :created_at)
    AND (CAST(:data_synced_at AS TIMESTAMP) IS NULL or data_synced_at = :data_synced_at)
    AND (CAST(:distance_to_place AS NUMERIC) IS NULL or distance_to_place = :distance_to_place)
    AND (CAST(:homepage AS TEXT) IS NULL or homepage = :homepage)
    AND (CAST(:is_completed AS BOOL) IS NULL or is_completed = :is_completed)
    AND (CAST(:keywords AS TEXT) IS NULL or keywords = :keywords)
    AND (CAST(:keywords_search AS TSVECTOR) IS NULL or keywords_search = :keywords_search)
    AND (CAST(:location_accuracy AS INT4) IS NULL or location_accuracy = :location_accuracy)
    AND (CAST(:original_language AS TEXT) IS NULL or original_language = :original_language)
    AND (CAST(:original_title AS TEXT) IS NULL or original_title = :original_title)
    AND (CAST(:overview AS TEXT) IS NULL or overview = :overview)
    AND (CAST(:popularity AS FLOAT8) IS NULL or popularity = :popularity)
    AND (CAST(:release_date AS DATE) IS NULL or release_date = :release_date)
    AND (CAST(:revenue AS INT8) IS NULL or revenue = :revenue)
    AND (CAST(:runtime AS INT4) IS NULL or runtime = :runtime)
    AND (CAST(:search_vector AS TSVECTOR) IS NULL or search_vector = :search_vector)
    AND (CAST(:status AS TEXT) IS NULL or status = :status)
    AND (CAST(:summary AS VARCHAR) IS NULL or summary = :summary)
    AND (CAST(:synopsis AS VARCHAR) IS NULL or synopsis = :synopsis)
    AND (CAST(:tagline AS TEXT) IS NULL or tagline = :tagline)
    AND (CAST(:title AS TEXT) IS NULL or title = :title)
    AND (CAST(:title_search AS TSVECTOR) IS NULL or title_search = :title_search)
    AND (CAST(:updated_at AS TIMESTAMP) IS NULL or updated_at = :updated_at)
    AND (CAST(:vote_average AS FLOAT8) IS NULL or vote_average = :vote_average)
    AND (CAST(:vote_count AS INT4) IS NULL or vote_count = :vote_count)
`

// language=postgresql
var moviePkFieldsWhere = `
 WHERE id = :id
`

// language=postgresql
var movieReturningFields = `
 RETURNING id,
 budget,
 client_id,
 completed_coordinates,
 created_at,
 data_synced_at,
 distance_to_place,
 homepage,
 is_completed,
 keywords,
 keywords_search,
 location_accuracy,
 original_language,
 original_title,
 overview,
 popularity,
 release_date,
 revenue,
 runtime,
 search_vector,
 status,
 summary,
 synopsis,
 tagline,
 title,
 title_search,
 updated_at,
 vote_average,
 vote_count;
`

// language=postgresql
var movieInsertSql = `
INSERT INTO public.movies(
  budget,
  client_id,
  completed_coordinates,
  created_at,
  data_synced_at,
  distance_to_place,
  homepage,
  is_completed,
  keywords,
  location_accuracy,
  original_language,
  original_title,
  overview,
  popularity,
  release_date,
  revenue,
  runtime,
  search_vector,
  status,
  summary,
  synopsis,
  tagline,
  title,
  updated_at,
  vote_average,
  vote_count
)
VALUES (
  :budget,
  :client_id,
  :completed_coordinates,
  now(),
  :data_synced_at,
  :distance_to_place,
  :homepage,
  :is_completed,
  :keywords,
  :location_accuracy,
  :original_language,
  :original_title,
  :overview,
  :popularity,
  :release_date,
  :revenue,
  :runtime,
  :search_vector,
  :status,
  :summary,
  :synopsis,
  :tagline,
  :title,
  now(),
  :vote_average,
  :vote_count
)` + movieReturningFields + ";"

// language=postgresql
var movieModelCountSql = `
SELECT count(*) as count
FROM public.movies
` + movieAllFieldsWhere + ";"

// language=postgresql
var movieFindAllSql = `
SELECT
  id,
  budget,
  client_id,
  completed_coordinates,
  created_at,
  data_synced_at,
  distance_to_place,
  homepage,
  is_completed,
  keywords,
  keywords_search,
  location_accuracy,
  original_language,
  original_title,
  overview,
  popularity,
  release_date,
  revenue,
  runtime,
  search_vector,
  status,
  summary,
  synopsis,
  tagline,
  title,
  title_search,
  updated_at,
  vote_average,
  vote_count
FROM public.movies
` + movieAllFieldsWhere + ";"

// language=postgresql
var movieFindFirstSql = strings.TrimRight(movieFindAllSql, ";") + `
LIMIT 1;`

// language=postgresql
var movieFindByPkSql = `
SELECT
  id,
  budget,
  client_id,
  completed_coordinates,
  created_at,
  data_synced_at,
  distance_to_place,
  homepage,
  is_completed,
  keywords,
  keywords_search,
  location_accuracy,
  original_language,
  original_title,
  overview,
  popularity,
  release_date,
  revenue,
  runtime,
  search_vector,
  status,
  summary,
  synopsis,
  tagline,
  title,
  title_search,
  updated_at,
  vote_average,
  vote_count
FROM public.movies
` + moviePkFieldsWhere + `
LIMIT 1;`

// language=postgresql
var movieDeleteByPkSql = `
DELETE FROM public.movies
` + moviePkFieldsWhere + ";"

// language=postgresql
var movieDeleteAllSql = `
DELETE FROM public.movies
` + movieAllFieldsWhere + ";"