bigdata

var (
	ErrNoCTRecords     = errors.New("no ct records found")
	ErrETLDInvalid     = errors.New("etld was empty or did not match")
	ErrCopyCount       = errors.New("count of records copied did not match expected")
	ErrEmptyCommonName = errors.New("common name was empty")
)

var (
	// Subdomain table data
	AddCTSubDomainTempTableKey     = "cert_subdomain_temp"
	AddCTSubDomainTempTableColumns = []string{"inserted_timestamp", "etld_id", "common_name"}
	AddCTSubDomainTempTable        = `` /* 142-byte string literal not displayed */

	AddTempSubDomainToCTSubDomain = `` /* 233-byte string literal not displayed */

	// Full CT data
	AddCTTempTableKey     = "cert_add_temp"
	AddCTTempTableColumns = []string{"inserted_timestamp", "server_name", "server_index", "etld", "cert_hash", "serial_number",
		"not_before", "not_after", "country", "organization", "organizational_unit", "common_name",
		"verified_dns_names", "unverified_dns_names", "ip_addresses", "email_addresses"}

	AddCTTempTable = `` /* 514-byte string literal not displayed */

	AddTempToCT = fmt.Sprintf(`insert into am.certificates as cert (
			%s
		)
		select
			temp.inserted_timestamp,
			temp.server_name,
			temp.server_index,
			temp.etld,
			temp.cert_hash,
			temp.serial_number,
			temp.not_before,
			temp.not_after,
			temp.country,
			temp.organization,
			temp.organizational_unit,
			temp.common_name,
			temp.verified_dns_names,
			temp.unverified_dns_names,
			temp.ip_addresses, 
			temp.email_addresses
		from cert_add_temp as temp on conflict do nothing`, commonColumns)
)