Class SQLCon<K, T, P, C, X>

constructor

• new SQLCon<
      K extends
          ICoreKernel<any, ICoreAnyModule> = ICoreKernel<any, ICoreAnyModule>,
      T extends
          | IDataBase<
              any,
              any,
              any,
              ICoreKernel<any, ICoreAnyModule>,
              any,
              any,
              any,
              any,
          >
          | null = any,
      P extends ICoreClient
      | null = any,
      C extends
          ICoreCache<ICoreKernel<any, ICoreAnyModule>, any, any, any, any> | null = any,
      X extends
          | ICorePresenter<
              any,
              ICoreKernel<any, ICoreAnyModule>,
              any,
              any,
              any,
              any,
          >
          | null = any,
  >(
      module: ICoreKernelModule<any, any, any, any, any>,
      dbversion: string,
      printLog?: boolean,
  ): SQLCon<K, T, P, C, X>

  Type Parameters

  • K extends ICoreKernel<any, ICoreAnyModule> = ICoreKernel<any, ICoreAnyModule>
  • T extends
        | IDataBase<
            any,
            any,
            any,
            ICoreKernel<any, ICoreAnyModule>,
            any,
            any,
            any,
            any,
        >
        | null = any
  • P extends ICoreClient | null = any
  • C extends ICoreCache<ICoreKernel<any, ICoreAnyModule>, any, any, any, any> | null = any
  • X extends ICorePresenter<any, ICoreKernel<any, ICoreAnyModule>, any, any, any, any> | null = any

  Parameters

  • module: ICoreKernelModule<any, any, any, any, any>
  • dbversion: string
  • printLog: boolean = false

  Returns SQLCon<K, T, P, C, X>

db

printLog

configExist

• configExist(key: string): Promise<boolean>

  Parameters

  • key: string

  Returns Promise<boolean>

connect

• connect(): Promise<boolean>

  Returns Promise<boolean>

countEntity

• countEntity<E extends IEntity>(
      config: EntityConfig<E>,
      search: QInterfaceSearch<E>,
  ): Promise<number>

  Type Parameters

  • E extends IEntity

  Parameters

  • config: EntityConfig<E>
  • search: QInterfaceSearch<E>

  Returns Promise<number>

createEntity

• createEntity<E extends CoreEntity>(
      config: EntityConfig<E>,
      entity: EProperties<E>,
  ): Promise<E>

  Create new Entity object

  Type Parameters

  • E extends CoreEntity

  Parameters

  • config: EntityConfig<E>
  • entity: EProperties<E>

  Returns Promise<E>

deleteEntityBulkById

• deleteEntityBulkById(className: string, e_id: string[]): Promise<boolean>

  Delete Entity objects by ID

  Parameters

  • className: string
  • e_id: string[]

  Returns Promise<boolean>

deleteEntityById

• deleteEntityById(className: string, id: string): Promise<boolean>

  Delete Entity object by ID

  Parameters

  • className: string
  • id: string

  Returns Promise<boolean>

disconnect

• disconnect(): Promise<boolean>

  Returns Promise<boolean>

findEntity

• findEntity<E extends CoreEntity>(
      config: EntityConfig<E>,
      search: QInterfaceSearch<E>,
  ): Promise<E | null>

  Get Entity object list

  Type Parameters

  • E extends CoreEntity

  Parameters

  • config: EntityConfig<E>
  • search: QInterfaceSearch<E>

  Returns Promise<E | null>

getConfig

• getConfig(key: string): Promise<ConfigType>

  Parameters

  • key: string

  Returns Promise<ConfigType>

getEntityBulkById

• getEntityBulkById<E extends CoreEntity>(
      config: EntityConfig<E>,
      e_id: string[],
  ): Promise<E[]>

  Get Entity object by ID

  Type Parameters

  • E extends CoreEntity

  Parameters

  • config: EntityConfig<E>
  • e_id: string[]

  Returns Promise<E[]>

getEntityById

• getEntityById<E extends CoreEntity>(
      config: EntityConfig<E>,
      id: string,
  ): Promise<E | null>

  Get Entity object by ID

  Type Parameters

  • E extends CoreEntity

  Parameters

  • config: EntityConfig<E>
  • id: string

  Returns Promise<E | null>

getEntityList

• getEntityList<E extends CoreEntity>(q: QueryInterface<E>): Promise<E[]>

  Get Entity object list

  Type Parameters

  • E extends CoreEntity

  Parameters

  • q: QueryInterface<E>

  Returns Promise<E[]>

getRawDBObject

• getRawDBObject(): Database | null

  Returns Database | null

initEntity

• initEntity<E extends CoreEntity>(className: string, entity: E): Promise<boolean>

  Init Entity object list

  Type Parameters

  • E extends CoreEntity

  Parameters

  • className: string
  • entity: E

  Returns Promise<boolean>

initNewDB

• initNewDB(): Promise<void>

  Returns Promise<void>

queryScript

• queryScript<E>(query: RawQuery): Promise<RawQueryResult<E, null>>

  Type Parameters

  • E

  Parameters

  • query: RawQuery

  Returns Promise<RawQueryResult<E, null>>

removeConfig

• removeConfig(key: string): Promise<void>

  Parameters

  • key: string

  Returns Promise<void>

runScripts

• runScripts(...list: RawQuery[]): Promise<RunResult[]>

  Parameters

  • ...list: RawQuery[]

  Returns Promise<RunResult[]>

setConfig

• setConfig(key: string, value: string): Promise<boolean>

  Parameters

  • key: string
  • value: string

  Returns Promise<boolean>

transformEntityKeys

• transformEntityKeys<E extends CoreEntity>(entity: E): string

  Type Parameters

  • E extends CoreEntity

  Parameters

  • entity: E

  Returns string

updateBulkEntity

• updateBulkEntity<E extends IEntity>(
      config: EntityConfig<E>,
      e_id: string[],
      entity: EUpDateProperties<E>,
  ): Promise<boolean>

  Update Entity objects

  Type Parameters

  • E extends IEntity

  Parameters

  • config: EntityConfig<E>
  • e_id: string[]
  • entity: EUpDateProperties<E>

  Returns Promise<boolean>

updateEntity

• updateEntity<E extends CoreEntity>(
      config: EntityConfig<E>,
      e_id: string,
      entity: EUpDateProperties<E>,
  ): Promise<boolean>

  Update Entity object

  Type Parameters

  • E extends CoreEntity

  Parameters

  • config: EntityConfig<E>
  • e_id: string
  • entity: EUpDateProperties<E>

  Returns Promise<boolean>