@ff00ff/mammoth
Advanced tools
Comparing version 2.0.0-beta.2 to 2.0.0-beta.3
/// <reference types="node" /> | ||
import { ColumnDefinition } from './column'; | ||
export declare type Int4 = number; | ||
export declare type Int8 = string; | ||
export declare type Float4 = number; | ||
export declare type Float8 = number; | ||
export declare type Numeric = string; | ||
export declare type NullType = undefined | null; | ||
export declare type DbDataType = keyof DbDataTypes; | ||
export interface DbDataTypes { | ||
Int4: any; | ||
Int8: any; | ||
Float4: any; | ||
Float8: any; | ||
Numeric: any; | ||
} | ||
export declare type Int4 = 'Int4'; | ||
export declare type Int8 = 'Int8'; | ||
export declare type Float4 = 'Float4'; | ||
export declare type Float8 = 'Float8'; | ||
export declare type Numeric = 'Numeric'; | ||
export declare type AnyNumber = Int4 | Int8 | Float4 | Float8 | Numeric; | ||
@@ -9,0 +18,0 @@ export declare function dataType<T>(dataType: string): ColumnDefinition<T, false, false>; |
@@ -9,8 +9,17 @@ import * as sqlFunctions from './sql-functions'; | ||
import { Table } from './TableType'; | ||
declare type NullType = 'UNDEFINED' | 'NULL'; | ||
import { DbDataTypes, NullType } from './data-types'; | ||
export interface DbConfiguration { | ||
NullType: NullType; | ||
DataTypes: DbDataTypes; | ||
} | ||
export interface DefaultDbConfiguration extends DbConfiguration { | ||
NullType: 'NULL'; | ||
NullType: null; | ||
DataTypes: { | ||
Int4: number; | ||
Int8: number; | ||
Float4: number; | ||
Float8: number; | ||
Text: string; | ||
Numeric: number; | ||
}; | ||
} | ||
@@ -36,3 +45,3 @@ export declare const setup: <Config extends DbConfiguration>() => { | ||
arrayAgg: <DataType_1>(expression: import("./expression").Expression<DataType_1, boolean, any>) => import("./expression").Expression<DataType_1[], false, "arrayAgg">; | ||
count: (expression?: import("./expression").Expression<any, any, any> | undefined) => import("./expression").Expression<string, true, "count">; | ||
count: (expression?: import("./expression").Expression<any, any, any> | undefined) => import("./expression").Expression<"Int8", true, "count">; | ||
min: <DataType_2>(expression: import("./expression").Expression<DataType_2, boolean, any>) => import("./expression").Expression<DataType_2, false, "min">; | ||
@@ -77,59 +86,2 @@ max: <DataType_3>(expression: import("./expression").Expression<DataType_3, boolean, any>) => import("./expression").Expression<DataType_3, false, "max">; | ||
}; | ||
export declare const makeDefineDb: <Config extends DbConfiguration>() => <TableDefinitions extends { | ||
[key: string]: TableDefinition<any>; | ||
}>(tableDefinitions: TableDefinitions, queryExecutor: QueryExecutorFn) => { | ||
raw<DataType, IsNotNull extends boolean = false, Name extends string = "?column?">(strings: TemplateStringsArray, ...parameters: any[]): import("./expression").Expression<DataType, IsNotNull, Name>; | ||
star(): sqlFunctions.Star; | ||
star<T extends unknown>(table: T): T extends Table<any, infer Columns> ? import("./column").ColumnSet<Columns> : never; | ||
toSql(query: import("./query").Query<any>): { | ||
text: string; | ||
parameters: any[]; | ||
}; | ||
Star: typeof sqlFunctions.Star; | ||
stringAgg: (expression: import("./expression").Expression<string, boolean, any>, delimiter: string, ...orderBy: import("./expression").Expression<any, any, any>[]) => import("./expression").Expression<string, false, "stringAgg">; | ||
bitAnd: <T_1 extends import("./data-types").AnyNumber>(expression: import("./expression").Expression<T_1, boolean, any>) => import("./expression").Expression<T_1, false, "bitAnd">; | ||
bitOr: <T_2 extends import("./data-types").AnyNumber>(expression: import("./expression").Expression<T_2, boolean, any>) => import("./expression").Expression<T_2, false, "bitOr">; | ||
boolAnd: (expression: import("./expression").Expression<boolean, boolean, any>) => import("./expression").Expression<number, false, "boolAnd">; | ||
boolOr: (expression: import("./expression").Expression<boolean, boolean, any>) => import("./expression").Expression<number, false, "boolOr">; | ||
every: (expression: import("./expression").Expression<boolean, boolean, any>) => import("./expression").Expression<number, false, "every">; | ||
arrayAgg: <DataType_1>(expression: import("./expression").Expression<DataType_1, boolean, any>) => import("./expression").Expression<DataType_1[], false, "arrayAgg">; | ||
count: (expression?: import("./expression").Expression<any, any, any> | undefined) => import("./expression").Expression<string, true, "count">; | ||
min: <DataType_2>(expression: import("./expression").Expression<DataType_2, boolean, any>) => import("./expression").Expression<DataType_2, false, "min">; | ||
max: <DataType_3>(expression: import("./expression").Expression<DataType_3, boolean, any>) => import("./expression").Expression<DataType_3, false, "max">; | ||
avg: <T_3 extends import("./data-types").AnyNumber>(expression: import("./expression").Expression<T_3, boolean, any>) => import("./expression").Expression<T_3, false, "avg">; | ||
sum: <T_4 extends import("./data-types").AnyNumber>(expression: import("./expression").Expression<T_4, boolean, any>) => import("./expression").Expression<T_4, false, "sum">; | ||
xmlagg: <DataType_4>(expression: import("./expression").Expression<DataType_4, boolean, any>) => import("./expression").Expression<number, false, "xmlagg">; | ||
not: (expression: import("./expression").Expression<boolean, boolean, string>) => import("./expression").DefaultExpression<boolean, true>; | ||
and: (expression: import("./expression").Expression<boolean, boolean, string>) => import("./expression").DefaultExpression<boolean, true>; | ||
or: (expression: import("./expression").Expression<boolean, boolean, string>) => import("./expression").DefaultExpression<boolean, true>; | ||
group: (expression: import("./expression").Expression<boolean, boolean, string>) => import("./expression").DefaultExpression<boolean, true>; | ||
any: <T_5>(array: T_5[]) => import("./expression").Expression<T_5, true, "?column?">; | ||
now: () => import("./expression").Expression<Date, true, "now">; | ||
exists: (expression: import("./expression").Expression<any, any, any> | import("./query").Query<any>) => import("./expression").DefaultExpression<boolean, true>; | ||
andNotExists: (expression: import("./expression").Expression<any, any, any> | import("./query").Query<any>) => import("./expression").DefaultExpression<boolean, true>; | ||
andExists: (expression: import("./expression").Expression<any, any, any> | import("./query").Query<any>) => import("./expression").DefaultExpression<boolean, true>; | ||
notExists: (expression: import("./expression").Expression<any, any, any> | import("./query").Query<any>) => import("./expression").DefaultExpression<boolean, true>; | ||
coalesce: <DataType_5>(...expressions: (DataType_5 | import("./expression").Expression<DataType_5, boolean, any>)[]) => import("./expression").Expression<DataType_5, true, "coalesce">; | ||
/** @internal */ | ||
getTableDefinitions(): { | ||
name: string; | ||
originalDefinition: any; | ||
columns: (ColumnDefinitionFormat & { | ||
name: string; | ||
})[]; | ||
}[]; | ||
select: SelectFn<Config>; | ||
insertInto: <T_6 extends unknown>(table: T_6, columnNames?: (T_6 extends Table<any, infer Columns_1> ? (keyof Columns_1)[] : never) | undefined) => T_6 extends TableDefinition<any> ? never : InsertIntoResult<Config, T_6, T_6 extends Table<any, infer Columns_2> ? { [K_1 in keyof import("./types").PickByValue<{ [K in keyof Columns_2]: Columns_2[K] extends Column<any, any, any, infer IsNotNull_1, infer HasDefault, any> ? HasDefault extends true ? false : IsNotNull_1 : never; }, true>]: Columns_2[K_1] extends Column<any, any, infer DataType_6, boolean, any, any> ? DataType_6 | import("./expression").Expression<DataType_6, boolean, string> | import("./query").Query<{ | ||
[key: string]: DataType_6 | import("./expression").Expression<DataType_6, boolean, string>; | ||
}> : never; } & { [K_3 in keyof import("./types").PickByValue<{ [K_2 in keyof Columns_2]: Columns_2[K_2] extends Column<any, any, any, infer IsNotNull_2, infer HasDefault_1, any> ? HasDefault_1 extends true ? false : IsNotNull_2 : never; }, false>]?: (Columns_2[K_3] extends Column<any, any, infer DataType_7, boolean, any, any> ? DataType_7 | import("./expression").Expression<DataType_7, boolean, string> | import("./query").Query<{ | ||
[key: string]: DataType_7 | import("./expression").Expression<DataType_7, boolean, string>; | ||
}> | undefined : never) | undefined; } : never>; | ||
deleteFrom: <T_7 extends unknown>(table: T_7) => T_7 extends TableDefinition<any> ? never : import("./delete").DeleteQuery<T_7, number, T_7 extends Table<any, infer Columns_3> ? Columns_3 : never>; | ||
update: <T_8 extends unknown>(table: T_8) => { | ||
set(values: T_8 extends Table<any, infer Columns_4> ? { [K_4 in keyof Columns_4]?: (Columns_4[K_4] extends Column<any, any, infer DataType_8, infer IsNotNull_3, any, any> ? IsNotNull_3 extends true ? DataType_8 | import("./expression").Expression<DataType_8, boolean, any> : DataType_8 | import("./expression").Expression<DataType_8 | undefined, boolean, any> | undefined : never) | undefined; } : never): import("./update").UpdateQuery<T_8, number, T_8 extends Table<any, infer Columns_5> ? Columns_5 : never>; | ||
}; | ||
with: import("./with").WithFn; | ||
truncate: <T_9 extends unknown>(table: T_9) => T_9 extends TableDefinition<any> ? never : import("./truncate").TruncateQuery<T_9, number, T_9 extends Table<any, infer Columns_6> ? Columns_6 : never>; | ||
case: () => CaseStatement<never>; | ||
} & { [TableName in keyof TableDefinitions]: TableDefinitions[TableName] extends TableDefinition<infer ColumnDefinitions> ? Table<TableName, { [K_5 in keyof ColumnDefinitions]: K_5 extends string ? Column<K_5, TableName, ColumnDefinitions[K_5] extends ColumnDefinition<infer DataType_9, any, any> ? DataType_9 : never, ColumnDefinitions[K_5] extends ColumnDefinition<any, infer IsNotNull_4, any> ? IsNotNull_4 : never, ColumnDefinitions[K_5] extends ColumnDefinition<any, any, infer HasDefault_2> ? HasDefault_2 : never, undefined> : never; }> : never; }; | ||
export declare const defineDb: <TableDefinitions extends { | ||
@@ -153,3 +105,3 @@ [key: string]: TableDefinition<any>; | ||
arrayAgg: <DataType_1>(expression: import("./expression").Expression<DataType_1, boolean, any>) => import("./expression").Expression<DataType_1[], false, "arrayAgg">; | ||
count: (expression?: import("./expression").Expression<any, any, any> | undefined) => import("./expression").Expression<string, true, "count">; | ||
count: (expression?: import("./expression").Expression<any, any, any> | undefined) => import("./expression").Expression<"Int8", true, "count">; | ||
min: <DataType_2>(expression: import("./expression").Expression<DataType_2, boolean, any>) => import("./expression").Expression<DataType_2, false, "min">; | ||
@@ -193,2 +145,1 @@ max: <DataType_3>(expression: import("./expression").Expression<DataType_3, boolean, any>) => import("./expression").Expression<DataType_3, false, "max">; | ||
} & { [TableName in keyof TableDefinitions]: TableDefinitions[TableName] extends TableDefinition<infer ColumnDefinitions> ? Table<TableName, { [K_5 in keyof ColumnDefinitions]: K_5 extends string ? Column<K_5, TableName, ColumnDefinitions[K_5] extends ColumnDefinition<infer DataType_9, any, any> ? DataType_9 : never, ColumnDefinitions[K_5] extends ColumnDefinition<any, infer IsNotNull_4, any> ? IsNotNull_4 : never, ColumnDefinitions[K_5] extends ColumnDefinition<any, any, infer HasDefault_2> ? HasDefault_2 : never, undefined> : never; }> : never; }; | ||
export {}; |
@@ -22,3 +22,3 @@ "use strict"; | ||
Object.defineProperty(exports, "__esModule", { value: true }); | ||
exports.defineDb = exports.makeDefineDb = exports.setup = void 0; | ||
exports.defineDb = exports.setup = void 0; | ||
const sqlFunctions = __importStar(require("./sql-functions")); | ||
@@ -43,3 +43,3 @@ const insert_1 = require("./insert"); | ||
return { | ||
defineDb: exports.makeDefineDb(), | ||
defineDb: makeDefineDb(), | ||
}; | ||
@@ -77,3 +77,2 @@ }; | ||
}; | ||
exports.makeDefineDb = makeDefineDb; | ||
exports.defineDb = exports.makeDefineDb(); | ||
exports.defineDb = makeDefineDb(); |
@@ -10,3 +10,5 @@ import type { Column } from './column'; | ||
import type { DbConfiguration, DefaultDbConfiguration } from './db'; | ||
export declare type ResultSetDataType<Config extends DbConfiguration, Type, IsNotNull> = IsNotNull extends true ? Type : Config['NullType'] extends 'NULL' ? Type | null : Type | undefined; | ||
import { DbDataType } from './data-types'; | ||
declare type GetType<Config extends DbConfiguration, T> = T extends DbDataType ? Config['DataTypes'][T] : T; | ||
export declare type ResultSetDataType<Config extends DbConfiguration, Type, IsNotNull> = IsNotNull extends true ? GetType<Config, Type> : Config['NullType'] extends 'NULL' ? GetType<Config, Type> | null : GetType<Config, Type> | undefined; | ||
export declare type ResultSet<T extends Query<any>, Test extends boolean> = T extends SelectQuery<infer Config, infer Returning> ? { | ||
@@ -21,1 +23,2 @@ [K in keyof Returning]: Returning[K] extends Column<any, any, infer D, infer N, any, infer JoinType> ? Extract<JoinType, 'left-join'> extends never ? Extract<JoinType, 'left-side-of-right-join'> extends never ? Extract<JoinType, 'full-join'> extends never ? N extends true ? Test extends true ? GetDataType<D, true> : ResultSetDataType<Config, D, true> : Test extends true ? GetDataType<D, false> : ResultSetDataType<Config, D, false> : Test extends true ? GetDataType<D, false> : ResultSetDataType<Config, D, false> : Test extends true ? GetDataType<D, false> : ResultSetDataType<Config, D, false> : Test extends true ? GetDataType<D, false> : ResultSetDataType<Config, D, false> : Returning[K] extends Expression<infer D, infer IsNotNull, any> ? Test extends true ? GetDataType<D, IsNotNull> : ResultSetDataType<Config, D, IsNotNull> : Returning[K] extends Query<{}> ? ResultSet<Returning[K], Test>[keyof ResultSet<Returning[K], Test>] : never; | ||
} : never; | ||
export {}; |
{ | ||
"name": "@ff00ff/mammoth", | ||
"license": "MIT", | ||
"version": "2.0.0-beta.2", | ||
"version": "2.0.0-beta.3", | ||
"main": "./.build/index.js", | ||
@@ -6,0 +6,0 @@ "types": "./.build/index.d.ts", |
197187
4306