import {
  IControl,
  Crypto,
  SourceCode,
  ITableDefinition,
  ComponentControl,
  ControlType,
  ITableQueryPager,
  Util
} from '@datahu/core'
import {I18n} from '../i18n'
import {BaseDataSource, BaseDataSourceOption} from '../base'
import {PostgresqlHelper} from './PostgresqlHelper'

export class PostgresqlDataSourceOption extends BaseDataSourceOption {
  static controls: Array<IControl> = []

  @ComponentControl({
    type: ControlType.text,
    title: '服务器',
    required: true
  })
  host: string = 'localhost'

  @ComponentControl({
    type: ControlType.number,
    title: '端口',
    required: true
  })
  port: number = 5432

  @ComponentControl({
    type: ControlType.text,
    title: '用户名'
  })
  user: string = ''

  @ComponentControl({
    type: ControlType.password,
    title: '密码'
  })
  password: string = ''

  @ComponentControl({
    type: ControlType.text,
    title: '默认数据库',
    required: true
  })
  database: string = ''

  @ComponentControl({
    type: ControlType.boolean,
    title: '使用SSL'
  })
  ssl: boolean = false

  @ComponentControl({
    type: ControlType.file,
    title: 'CA证书',
    show: `(data) => {
      return data.ssl
    }`
  })
  sslCa: string = ''
  @ComponentControl({
    type: ControlType.file,
    title: '客户端密钥',
    show: `(data) => {
      return data.ssl
    }`
  })
  sslKey: string = ''
  @ComponentControl({
    type: ControlType.file,
    title: '客户端证书',
    show: `(data) => {
      return data.ssl
    }`
  })
  sslCert: string = ''
  @ComponentControl({
    type: ControlType.boolean,
    title: '不验证证书',
    show: `(data) => {
      return data.ssl
    }`
  })
  sslRejectUnauthorized: boolean = false
}

export class PostgresqlDataSource extends BaseDataSource {
  helper?: PostgresqlHelper
  constructor(language: string, config?: PostgresqlDataSourceOption) {
    super(language, config)
    this.title = 'PostgreSQL'
    this.description = 'Postgresql数据库'
    if (config) {
      this.helper = new PostgresqlHelper(config)
    }
  }

  // 数据源默认配置值
  config: PostgresqlDataSourceOption = new PostgresqlDataSourceOption()

  icon: string =
    '<svg t="1632724633812" class="icon" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="1960"><path d="M930.56415839 579.12956914c-14.30569336-12.26202276-32.69872793-14.30569336-51.09176337-8.17468154-14.30569336 4.08734121-30.65505732 6.13101182-44.96075156 6.13101094 40.87341035-67.44112734 71.52846768-141.01326563 91.96517373-218.67274424 10.21835214-34.74239854 16.34936396-71.52846768 16.34936396-110.35820831 4.08734121-30.65505732-4.08734121-61.31011552-22.48037578-85.83416102-51.0917625-65.39745674-130.7949126-102.18352588-212.5417333-100.13985528h-6.13101181c-34.74239854 0-69.48479707 6.13101182-102.18352588 14.30569336h-2.04367061c-20.43670518-4.08734121-42.91708096-6.13101182-63.35378525-6.13101182-38.82973974-2.0436706-79.7031501 8.17468242-114.44554864 28.6113876-49.04809277-18.39303457-104.22719648-26.567717-157.36262959-24.52404639-49.04809277 0-98.09618467 20.43670518-132.83858408 55.17910371-36.78606914 38.82973974-55.17910371 98.09618467-53.13543311 181.88667598 4.08734121 36.78606914 10.21835214 73.57213828 18.39303458 108.31453681 12.26202276 53.1354331 26.567717 104.22719648 44.96075156 155.31895898 14.30569336 47.00442217 38.82973974 91.96517286 71.52846767 128.75124288 16.34936396 16.34936396 38.82973974 26.567717 63.35378614 28.61138672 18.39303457 0 34.74239854-8.17468242 49.04809189-20.4367043 12.26202276 14.30569336 28.6113876 22.48037578 47.00442217 26.56771612 24.52404638 6.13101182 49.04809277 8.17468242 73.57213828 4.08734121 12.26202276-2.0436706 22.48037578-6.13101182 32.69872881-10.21835303 0 12.26202276 0 24.52404638 2.0436706 36.78607002-2.0436706 36.78606914 4.08734121 71.52846768 14.30569336 106.27086621 4.08734121 20.43670518 14.30569336 38.82973974 28.61138672 55.17910372 28.6113876 26.567717 67.44112734 36.78606914 104.22719648 28.61138759 38.82973974-6.13101182 75.61580888-26.567717 98.09618468-57.22277431 26.567717-36.78606914 38.82973974-91.96517286 40.87341034-179.84300538 0-4.08734121 2.0436706-8.17468242 2.04367061-12.26202275h6.13101182c34.74239854 2.0436706 69.48479707-4.08734121 100.13985439-16.34936484 24.52404638-10.21835214 47.00442217-26.567717 63.35378613-49.0480919 4.08734121-8.17468242 8.17468242-16.34936396 10.21835304-24.52404639 2.0436706-16.34936396-4.08734121-30.65505732-16.34936397-40.87341035z m-12.26202362 47.00442217c-14.30569336 18.39303457-30.65505732 30.65505732-53.13543311 38.82973975-24.52404638 10.21835214-51.0917625 14.30569336-77.65947949 14.30569336-12.26202276 0-24.52404638-2.0436706-36.78606914-4.08734122-6.13101182 51.0917625-10.21835214 102.18352588-20.43670517 153.27528926-2.0436706 24.52404638-14.30569336 49.04809277-30.65505821 69.48479707-20.43670518 18.39303457-44.96075156 30.65505732-71.52846767 32.69872793-30.65505732 8.17468242-61.31011552 2.0436706-85.83416192-16.34936397-14.30569336-12.26202276-24.52404638-30.65505732-32.69872793-49.04809189-4.08734121-12.26202276-6.13101182-22.48037578-8.17468242-34.74239941-2.0436706-18.39303457-4.08734121-36.78606914-4.08734033-53.13543311-2.0436706-32.69872793-2.0436706-63.35378614-2.04367061-94.00884345-16.34936396 14.30569336-36.78606914 24.52404638-57.22277432 28.6113876-20.43670518 4.08734121-42.91708096 2.0436706-63.35378612-4.08734122-6.13101182-2.0436706-12.26202276-4.08734121-18.39303458-8.17468242-8.17468242-2.0436706-12.26202276-8.17468242-16.34936396-14.30569336-2.0436706-4.08734121-4.08734121-10.21835214-2.04367061-14.30569336 2.0436706-4.08734121 4.08734121-10.21835214 8.17468155-12.26202363 10.21835214-6.13101182 20.43670518-10.21835214 32.6987288-12.26202276 14.30569336-2.0436706 28.6113876-6.13101182 42.91708008-12.26202363 8.17468242-6.13101182 14.30569336-14.30569336 20.43670518-22.4803749v-2.04367061c-18.39303457 0-34.74239854-6.13101182-51.0917625-12.26202363-6.13101182 6.13101182-32.69872793 34.74239854-69.48479708 77.65947949-12.26202276 16.34936396-28.6113876 26.567717-49.04809277 28.6113876-18.39303457 0-34.74239854-8.17468242-47.00442216-20.43670517-30.65505732-34.74239854-51.0917625-75.61580888-65.39745586-118.53288985-16.34936396-53.1354331-30.65505732-104.22719648-40.87341036-155.31895898-8.17468242-34.74239854-14.30569336-67.44112734-18.39303456-102.18352588-4.08734121-77.65947949 14.30569336-128.751242 44.96075068-161.44997081 30.65505732-30.65505732 71.52846768-47.00442217 116.48922011-49.04809188 55.17910371-2.0436706 110.35820742 8.17468242 161.44996992 28.61138671 32.69872793-20.43670518 69.48479707-30.65505732 108.3145377-30.65505733 20.43670518 0 42.91708096 4.08734121 63.35378613 8.17468242 8.17468242-4.08734121 18.39303457-6.13101182 28.61138672-8.17468242 26.567717-6.13101182 51.0917625-8.17468242 77.6594795-10.21835302 77.65947949-2.0436706 151.23161777 30.65505732 200.27971054 91.96517373 12.26202276 20.43670518 18.39303457 47.00442217 16.34936397 71.52846767-2.0436706 34.74239854-8.17468242 69.48479707-16.34936397 104.22719649-22.48037578 85.83416191-59.26644492 167.58098174-108.3145377 243.19679062 2.0436706 2.0436706 4.08734121 2.0436706 6.13101182 4.08734122 28.6113876 6.13101182 57.22277432 6.13101182 85.83416192-2.04367061 10.21835214-4.08734121 22.48037578-2.0436706 32.69872793 2.04367061 4.08734121 4.08734121 8.17468242 10.21835214 8.17468242 16.34936396-6.13101182 0-6.13101182 6.13101182-8.17468242 10.21835303z" p-id="1961"></path><path d="M703.71673086 111.12902158h-6.13101182c-20.43670518 0-42.91708096 2.0436706-63.35378525 8.17468243 40.87341035 18.39303457 77.65947949 49.04809277 106.27086621 83.79049042 16.34936396 22.48037578 30.65505732 44.96075156 42.91708096 71.52846856 4.08734121 10.21835214 8.17468242 18.39303457 10.21835214 24.52404638 0 4.08734121 2.0436706 6.13101182 2.04367061 10.21835216v6.13101181c2.0436706 32.69872793-8.17468242 53.1354331-8.17468154 85.83416103 0 22.48037578 6.13101182 49.04809277 6.13101093 77.6594795 4.08734121 30.65505732-4.08734121 61.31011552-20.43670429 85.83416191 2.0436706 2.0436706 4.08734121 4.08734121 4.08734033 6.13101182 42.91708096-69.48479707 77.65947949-145.10060683 98.09618467-224.80375693 8.17468242-32.69872793 14.30569336-65.39745674 14.30569424-98.09618468 2.0436706-18.39303457-2.0436706-36.78606914-10.21835303-55.1791037-40.87341035-55.17910371-106.27086709-83.79049131-175.75566416-81.74682071z" fill="#306092" p-id="1962"></path><path d="M527.9610667 119.30370401c-36.78606914-2.0436706-71.52846768 10.21835214-98.09618467 32.69872792-24.52404638 20.43670518-40.87341035 49.04809277-53.1354331 77.6594795-10.21835214 28.6113876-16.34936396 59.26644492-18.39303458 89.92150312 16.34936396-8.17468242 32.69872793-14.30569336 51.0917625-18.39303545 18.39303457-4.08734121 38.82973974-4.08734121 57.22277432 2.04367061 20.43670518 8.17468242 34.74239854 26.567717 38.82973975 49.04809277 26.567717 120.57656045-8.17468242 165.53731201-20.43670517 202.32338115-6.13101182 12.26202276-10.21835214 24.52404638-12.26202276 36.78606914 2.0436706 0 4.08734121 0 6.13101182-2.0436706 6.13101182 0 14.30569336 2.0436706 20.4367043 4.08734121 12.26202276 6.13101182 22.48037578 16.34936396 26.56771698 30.65505732 2.0436706 4.08734121 2.0436706 8.17468242 2.04367061 10.21835215v6.13101182c-2.0436706 47.00442217-2.0436706 94.00884346 0 141.01326562 0 18.39303457 2.0436706 34.74239854 4.08734121 53.1354331 0 10.21835214 2.0436706 18.39303457 6.13101094 28.6113876 4.08734121 14.30569336 12.26202276 26.567717 24.52404638 36.78606914s30.65505732 16.34936396 63.35378614 10.21835216c20.43670518-2.0436706 40.87341035-12.26202276 57.22277431-26.56771612 12.26202276-16.34936396 20.43670518-34.74239854 22.48037578-55.17910371 8.17468242-38.82973974 20.43670518-153.27528838 22.48037578-173.71199444 0-12.26202276 2.0436706-26.567717 8.17468155-36.78606914 4.08734121-8.17468242 12.26202276-14.30569336 20.43670517-18.39303456 4.08734121-2.0436706 6.13101182-2.0436706 10.21835304-4.08734122-4.08734121-4.08734121-6.13101182-8.17468242-10.21835304-12.26202275-10.21835214-12.26202276-18.39303457-26.567717-24.5240455-40.87341035-4.08734121-6.13101182-6.13101182-12.26202276-10.21835303-18.39303458-6.13101182-10.21835214-10.21835214-20.43670518-18.39303457-32.69872792-14.30569336-26.567717-26.567717-55.17910371-34.74239854-85.83416192-8.17468242-30.65505732-10.21835214-59.26644492 10.21835216-81.7468207 16.34936396-18.39303457 47.00442217-28.6113876 91.96517372-22.48037578-2.0436706-4.08734121-2.0436706-8.17468242-4.0873412-12.26202275-8.17468242-24.52404638-22.48037578-47.00442217-38.82973976-65.39745674-44.96075156-61.31011552-116.48921924-96.05251406-192.10502812-98.09618467l-8.17468242-6.13101093z" fill="#306092" p-id="1963"></path><path d="M278.63326426 121.34737461h-14.30569424c-36.78606914 0-73.57213828 14.30569336-98.09618466 40.87341035-26.567717 26.567717-44.96075156 71.52846768-40.87340948 147.14427656 4.08734121 32.69872793 10.21835214 65.39745674 16.34936396 98.09618467 10.21835214 51.0917625 24.52404638 100.13985528 42.91708096 149.18794717 12.26202276 40.87341035 32.69872793 77.65947949 59.26644404 110.3582083 6.13101182 8.17468242 16.34936396 12.26202276 28.6113876 12.26202276 12.26202276-2.0436706 22.48037578-8.17468242 30.65505733-18.39303458 22.48037578-26.567717 44.96075156-53.1354331 67.44112734-75.61580888-34.74239854-28.6113876-51.0917625-73.57213828-42.91708096-118.53288984 2.0436706-24.52404638 4.08734121-49.04809277 4.08734122-75.61580889 0-20.43670518-2.0436706-32.69872793-2.04367061-40.87341036V348.19480127c0-42.91708096 8.17468242-85.83416191 22.48037578-126.70757139 10.21835214-28.6113876 26.567717-55.17910371 49.04809189-77.65948037-34.74239854-12.26202276-71.52846768-18.39303457-108.31453681-20.43670518-6.13101182-2.0436706-10.21835214-2.0436706-14.30569336-2.04366972zM760.93950518 399.28656377c2.0436706-32.69872793 8.17468242-53.1354331 8.17468242-75.61580888-10.21835214-2.0436706-18.39303457-2.0436706-28.6113876-2.04367062-16.34936396-2.0436706-32.69872793 4.08734121-47.00442128 14.30569425-10.21835214 10.21835214-10.21835214 32.69872793-6.13101182 59.26644492 8.17468242 28.6113876 18.39303457 55.17910371 32.69872792 79.7031501 6.13101182 12.26202276 12.26202276 22.48037578 16.34936397 32.69872792 4.08734121 6.13101182 8.17468242 14.30569336 10.21835303 20.43670518 2.0436706 4.08734121 4.08734121 10.21835214 8.17468154 12.26202276 8.17468242-20.43670518 12.26202276-40.87341035 10.21835302-61.31011553 2.0436706-24.52404638-4.08734121-53.1354331-4.0873412-79.7031501z m-14.30569336-61.31011465c0 2.0436706 0 4.08734121-2.0436706 6.13101094-2.0436706 2.0436706-2.0436706 4.08734121-4.08734122 6.13101181-4.08734121 4.08734121-10.21835214 6.13101182-14.30569336 8.17468243-6.13101182 0-10.21835214 0-14.30569336-4.08734121-2.0436706-2.0436706-4.08734121-2.0436706-6.13101182-4.08734122-2.0436706 0-2.0436706-2.0436706-2.0436706-4.0873412s0-4.08734121 2.0436706-6.13101182l4.08734122-4.08734033c6.13101182-4.08734121 14.30569336-6.13101182 20.43670518-6.13101182h10.21835214c2.0436706 0 4.08734121 2.0436706 6.13101182 2.04367061v6.13101181z" fill="#306092" p-id="1964"></path><path d="M478.9129748 356.36948369c-2.0436706-14.30569336-10.21835214-26.567717-24.52404638-32.69872881-6.13101182-2.0436706-12.26202276-2.0436706-18.39303457-2.04367061-8.17468242 0-14.30569336 2.0436706-22.48037578 2.04367061-14.30569336 4.08734121-28.6113876 10.21835214-42.91708096 16.34936397-4.08734121 2.0436706-8.17468242 6.13101182-12.26202276 10.21835302 0 6.13101182 2.0436706 18.39303457 2.04367062 36.78606915 0 26.567717 0 53.1354331-4.08734122 77.65947948-10.21835214 55.17910371 26.567717 106.27086709 81.7468207 116.48921924 4.08734121 0 6.13101182 0 10.21835215 2.04367062 4.08734121-12.26202276 10.21835214-26.567717 12.26202275-40.87341036 12.26202276-36.78606914 42.91708096-67.44112734 18.39303545-185.97401631z m-14.30569423 2.04367061l-6.13101094 6.13101093c-4.08734121 4.08734121-10.21835214 6.13101182-16.34936484 4.08734121-6.13101182-2.0436706-10.21835214-4.08734121-14.30569336-10.21835214-2.0436706-2.0436706-4.08734121-4.08734121-4.08734122-6.13101182-4.08734121-4.08734121-4.08734121-6.13101182-4.08734033-8.17468242 0-4.08734121 4.08734121-6.13101182 8.17468155-8.17468154 4.08734121-2.0436706 8.17468242-2.0436706 10.21835302-2.04367061h6.13101094c6.13101182 0 10.21835214 2.0436706 14.30569424 6.13101094 2.0436706 2.0436706 4.08734121 2.0436706 6.13101094 4.08734121s2.0436706 4.08734121 2.0436706 8.17468242c-2.0436706 2.0436706-2.0436706 4.08734121-2.0436706 6.13101182zM777.28886914 611.82829795c-4.08734121 2.0436706-8.17468242 2.0436706-12.26202276 2.04367061-4.08734121 2.0436706-6.13101182 4.08734121-10.21835302 8.17468154-2.0436706 8.17468242-4.08734121 16.34936396-4.08734033 24.52404638 2.0436706 2.0436706 4.08734121 2.0436706 6.13101093 2.04367061 8.17468242 2.0436706 18.39303457 4.08734121 28.6113876 4.08734121 24.52404638 0 47.00442217-4.08734121 69.48479707-12.26202363 12.26202276-6.13101182 24.52404638-12.26202276 34.74239942-22.48037579-53.1354331 10.21835214-79.7031501 8.17468242-98.09618467 0-6.13101182-2.0436706-10.21835214-4.08734121-14.30569424-6.13101093zM476.8693042 615.91563828c-2.0436706 0-6.13101182 0-10.21835303 8.17468242-12.26202276 14.30569336-16.34936396 24.52404638-28.61138672 32.69872794-16.34936396 10.21835214-32.69872793 16.34936396-53.13543398 18.39303456-6.13101182 0-12.26202276 2.0436706-16.34936396 6.13101182l2.0436706 2.04367061c4.08734121 2.0436706 10.21835214 4.08734121 12.26202276 6.13101181 16.34936396 4.08734121 34.74239854 6.13101182 53.13543398 4.08734034 24.52404638-4.08734121 47.00442217-18.39303457 59.26644492-38.82973975 4.08734121-6.13101182 4.08734121-12.26202276 0-18.39303457-2.0436706-6.13101182-8.17468242-12.26202276-12.26202364-14.30569336 0-6.13101182-4.08734121-6.13101182-6.13101093-6.13101182z" fill="#306092" p-id="1965"></path></svg>'
  sourceCode: SourceCode = SourceCode.Javascript
  supportPager: boolean = true
  getTables(pager: ITableQueryPager | null): Promise<any> {
    return this.helper!.getTables(pager!)
  }
  getData(tables: Array<ITableDefinition>): Promise<Array<object>> {
    return this.helper!.getData(tables)
  }
}