/*
 * MIT License
 *
 * Copyright (c) 2018-2020 Ardalan Amini
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
 * SOFTWARE.
 */

import * as Odin from "..";
import Base from "../Base";
import { Operator, JoinQuery, FilterQuery, Order, Callback, Iterator, Id } from "../DB";
import Filter from "../DB/Filter";
import Query from "./Query";
declare class QueryBuilder<T extends Record<string, unknown> = any> extends Base<T> {
    protected static query<T extends Record<string, unknown>>(relations?: Query.Rel[]): Query<T>;
    /******************************* With Trashed *******************************/
    static withTrashed<T extends Record<string, unknown>>(): Query<T>;
    /*********************************** Lean ***********************************/
    static lean<T extends Record<string, unknown>>(): Query<T>;
    /****************************** Has & WhereHas ******************************/
    static has<T extends Record<string, unknown> = any>(relation: string, count?: number): Query<T>;
    static has<T extends Record<string, unknown> = any>(relation: string, operator: Operator, count?: number): Query<T>;
    static whereHas<T extends Record<string, unknown> = any>(relation: string, filter: (q: Filter) => Filter, count?: number): Query<T>;
    static whereHas<T extends Record<string, unknown> = any>(relation: string, filter: (q: Filter) => Filter, operator: Operator, count?: number): Query<T>;
    /****************************** With Relations ******************************/
    static with<T extends Record<string, unknown>>(...relations: string[]): Query<T>;
    /*********************************** Joins **********************************/
    static join<T extends Record<string, unknown>>(collection: string | typeof Odin, query?: JoinQuery<T>, as?: string): Query<T>;
    /******************************* Where Clauses ******************************/
    static where<T extends Record<string, unknown>>(query: FilterQuery): Query<T>;
    static where<T extends Record<string, unknown>>(field: string, value: any): Query<T>;
    static where<T extends Record<string, unknown>>(field: string, operator: Operator, value: any): Query<T>;
    static whereLike<T extends Record<string, unknown>>(field: string, values: any): Query<T>;
    static whereNotLike<T extends Record<string, unknown>>(field: string, values: any): Query<T>;
    static whereIn<T extends Record<string, unknown>>(field: string, values: any[]): Query<T>;
    static whereNotIn<T extends Record<string, unknown>>(field: string, values: any[]): Query<T>;
    static whereBetween<T extends Record<string, unknown>>(field: string, start: any, end: any): Query<T>;
    static whereNotBetween<T extends Record<string, unknown>>(field: string, start: any, end: any): Query<T>;
    static whereNull<T extends Record<string, unknown>>(field: string): Query<T>;
    static whereNotNull<T extends Record<string, unknown>>(field: string): Query<T>;
    /********* Mapping, Ordering, Grouping, Limit, Offset & Pagination *********/
    static orderBy<T extends Record<string, unknown>>(field: string, order?: Order): Query<T>;
    static skip<T extends Record<string, unknown>>(offset: number): Query<T>;
    static offset<T extends Record<string, unknown>>(offset: number): Query<T>;
    static limit<T extends Record<string, unknown>>(limit: number): Query<T>;
    static take<T extends Record<string, unknown>>(limit: number): Query<T>;
    static paginate<T extends Record<string, unknown>>(page?: number, limit?: number): Query<T>;
    /*********************************** Read ***********************************/
    static exists<T>(): Promise<boolean>;
    static exists<T>(callback: Callback<boolean>): void;
    static count(): Promise<number>;
    static count(callback: Callback<number>): void;
    static iterate<T extends Record<string, unknown>>(): Iterator<T>;
    static get<T extends Record<string, unknown>>(): Promise<T[]>;
    static get<T extends Record<string, unknown>>(callback: Callback<T[]>): void;
    static first<T extends Record<string, unknown>>(): Promise<ThisType<T>>;
    static first<T extends Record<string, unknown>>(callback: Callback<ThisType<T>>): void;
    static find<T extends Record<string, unknown>>(ids: Id | Id[]): Promise<Odin<T>>;
    static find<T extends Record<string, unknown>>(ids: Id | Id[], callback: Callback<Odin<T>>): void;
    static findBy<T extends Record<string, unknown>>(field: string, values: any | any[]): Promise<Odin<T>>;
    static findBy<T extends Record<string, unknown>>(field: string, values: any | any[], callback: Callback<Odin<T>>): void;
    static value<T>(field: string): Promise<any>;
    static value<T>(field: string, callback: Callback<any>): void;
    static pluck<T>(field: string): Promise<any>;
    static pluck<T>(field: string, callback: Callback<any>): void;
    static max<T>(field: string): Promise<any>;
    static max<T>(field: string, callback: Callback<any>): void;
    static min<T>(field: string): Promise<any>;
    static min<T>(field: string, callback: Callback<any>): void;
    /********************************** Inserts *********************************/
    static insert<T>(items: T[]): Promise<number>;
    static insert<T>(items: T[], callback: Callback<number>): void;
    static create<T extends Record<string, unknown>>(item: T): Promise<Odin<T>>;
    static create<T extends Record<string, unknown>>(item: T, callback: Callback<Odin<T>>): void;
    /********************************** Updates *********************************/
    save(): Promise<this>;
    save(callback: Callback<this>): void;
    /********************************** Deletes *********************************/
    static delete(): Promise<number>;
    static delete(callback: Callback<number>): void;
    static destroy(ids: Id | Id[], force?: boolean): Promise<number>;
    static destroy(ids: Id | Id[], callback: Callback<number>): void;
    static destroy(ids: Id | Id[], force: boolean, callback: Callback<number>): void;
    delete(force?: boolean): Promise<number>;
    delete(callback: Callback<number>): void;
    delete(force: boolean, callback: Callback<number>): void;
    /********************************* Restoring ********************************/
    restore(): Promise<number>;
    restore(callback: Callback<number>): void;
}
export default QueryBuilder;