Functions — github.com/NobleMajo/al-sql

hub / github.com/NobleMajo/al-sql / functions

Functions91 in github.com/NobleMajo/al-sql

⨍ Functions 91 ◇ Types & classes 27

↓ 21 callersFunctionstyleText

(text: string, font: Font | undefined)

src/index.ts:742

↓ 20 callersMethodshiftQuery

()

src/index.ts:149

↓ 12 callersFunctionpaint

(text: string, font?: Font)

src/index.ts:832

↓ 12 callersMethodselect

( select?: SqlResultColumnSelector, where?: SqlCondition, limit?: number | undefined,

src/index.ts:365

↓ 10 callersMethodinsert

( set: SqlSetValueMap, returning?: SqlResultColumnSelector | undefined, )

src/index.ts:333

↓ 9 callersFunctionremoveSpaces

(query: string)

src/index.ts:413

↓ 8 callersMethodexecute

(query: ExecutableSqlQuery)

src/index.ts:133

↓ 6 callersFunctioncreateFillerString

(value: string, size: number)

src/index.ts:463

↓ 6 callersFunctionrequestFriendship

( friendshipTable: SqlTable, senderId: number, receiverId: number )

src/test/friendship.ts:133

↓ 5 callersMethodconnect

()

src/index.ts:136

↓ 5 callersMethodcreateTable

()

src/index.ts:317

↓ 4 callersFunctionacceptFriendship

( friendshipTable: SqlTable, senderId: number, receiverId: number )

src/test/friendship.ts:146

↓ 4 callersMethodclose

()

src/index.ts:137

↓ 4 callersFunctioncreateAccount

( accountTable: SqlTable, name: string, email: string )

src/test/friendship.ts:115

↓ 4 callersMethodcreateSelectQuery

( select: SqlResultColumnSelector, )

src/pg.ts:267

↓ 4 callersFunctiongetFriends

( friendshipTable: SqlTable, user: number )

src/test/friendship.ts:163

↓ 4 callersMethodgetTable

( name: string, columns?: Column[], foreignKey?: ForeignKey[], )

src/index.ts:261

↓ 4 callersFunctionuseFakeClient

()

src/fakeClient.ts:6

↓ 3 callersMethodclearQuerys

()

src/index.ts:153

↓ 3 callersMethodcreateSqlWhereCondition

( currentTable: string, condition: SqlCondition, valueCounter: [number] )

src/pg.ts:239

↓ 3 callersMethodisConnected

()

src/index.ts:135

↓ 3 callersMethodselectOne

( select?: SqlResultColumnSelector | undefined, where?: SqlCondition, ...joins: SqlJoi

src/index.ts:385

↓ 3 callersMethodupdate

( set: SqlSetValueMap, where?: SqlCondition, returning?: SqlResultColumnSelector | und

src/index.ts:348

↓ 2 callersFunctioncreateFriendshipTables

( client: SqlClient )

src/test/friendship.ts:8

↓ 2 callersMethodcreateSqlCondition

( currentTable: string, condition: SqlCondition, valueCounter: [number] )

src/pg.ts:200

↓ 2 callersMethoddropAllTables

()

src/index.ts:242

↓ 2 callersMethodgetStructure

()

src/index.ts:296

↓ 2 callersFunctionmixFonts

(main: Font, seconds: Font, mixStyles: boolean = true)

src/index.ts:762

↓ 1 callersMethodclose

()

src/index.ts:215

↓ 1 callersMethodconnect

()

src/index.ts:189

↓ 1 callersMethodcreateAllTables

()

src/index.ts:235

↓ 1 callersMethodcreateColumnQuery

( column: Column )

src/pg.ts:289

↓ 1 callersMethodcreateSqlConditionMerge

( currentTable: string, condition: SqlConditionMerge, valueCounter: [number] )

src/pg.ts:166

↓ 1 callersMethodcreateSqlFieldCondition

( currentTable: string, condition: SqlFieldCondition, valueCounter: [number] )

src/pg.ts:68

↓ 1 callersMethodcreateSqlRawCondition

( currentTable: string, condition: SqlRawCondition, valueCounter: [number] )

src/pg.ts:147

↓ 1 callersMethodcreateTableQuery

( table: SqlTable )

src/index.ts:98

↓ 1 callersMethoddelete

( where?: SqlCondition, returning?: SqlResultColumnSelector | undefined, )

src/index.ts:397

↓ 1 callersMethoddeleteQuery

( table: SqlTable, where?: SqlCondition, returning?: SqlResultColumnSelector | undefin

src/index.ts:123

↓ 1 callersMethoddropTable

()

src/index.ts:325

↓ 1 callersMethoddropTableQuery

↓ 1 callersMethodexecute

(query: ExecutableSqlQuery)

src/index.ts:170

↓ 1 callersFunctiongenerateResultString

( title: string, result: SqlQueryResultRow[], maxValueSize: number = 16, defaultFont: Font = [

src/index.ts:817

↓ 1 callersMethodgetDialect

()

src/index.ts:131

↓ 1 callersMethodgetTableStructure

( table: SqlTable )

src/index.ts:94

↓ 1 callersMethodgetTables

()

src/index.ts:276

↓ 1 callersMethodgetTablesQuery

( client: SqlClient )

src/index.ts:90

↓ 1 callersMethodinsertQuery

( table: SqlTable, set: SqlSetValueMap, returning?: SqlResultColumnSelector | undefine

src/index.ts:105

↓ 1 callersMethodquery

(query: string, parameter: any[])

src/fakeClient.ts:28

↓ 1 callersFunctionremoveFriendship

( friendshipTable: SqlTable, user1: number, user2: number )

src/test/friendship.ts:184

↓ 1 callersMethodselectQuery

( table: SqlTable, select?: SqlResultColumnSelector, where?: SqlCondition, joi

src/index.ts:116

↓ 1 callersFunctiontoPrettyString

( obj: any, options?: PrettyStringOptions, )

src/index.ts:508

↓ 1 callersMethodupdateQuery

( table: SqlTable, set: SqlSetValueMap, where?: SqlCondition, returning?: SqlR

src/index.ts:110

FunctionasyncMap

( arr: I[], cb: (value: I) => undefined | Promise<undefined | T> )

( public readonly host: string, public readonly port: number, public readonly username

src/pg.ts:458

Methodconstructor

( public readonly connection: AbstractSqlConnection, public connectionTime: number = 1000 * 45

src/index.ts:161

Methodconstructor

( public readonly database: SqlClient, public readonly name: string, public readonly c

MethodcreateTableQuery

( table: SqlTable )

src/pg.ts:324

MethoddeleteQuery

( table: SqlTable, where?: SqlCondition, returning?: SqlResultColumnSelector | undefin

(query: ExecutableSqlQuery)

FunctiongetAccountByEmail

( accountTable: SqlTable, email: string )

src/test/friendship.ts:100

FunctiongetAccountByName

( accountTable: SqlTable, name: string )

src/test/friendship.ts:85

MethodgetDatabasesQuery

FunctiongetPostgresType

MethodgetStructureHash

()

src/index.ts:306

MethodgetTableStructure

( table: SqlTable, set: SqlSetValueMap, returning?: SqlResultColumnSelector | undefine

FunctionjsTypeToPostgresType

(type: string, length: number = -1)

src/index.ts:649

FunctionmapToObject

( arr: T[], cb: (value: T, index: number) => string | undefined )

src/index.ts:705

FunctionpostgresTypeToJsType

(type: string, length: number = -1)

src/index.ts:666

MethodremoveTableByName

( table: SqlTable, select: SqlResultColumnSelector = null, where?: SqlCondition,

( table: SqlTable, maxValueSize: number = 16, defaultFont: Font = ["white", "bgBlack"], titleF

src/index.ts:785

FunctiontoPrettyQuery

( query: string, queryKeywords: string[] = [ "SELECT", "DELETE", "UPDATE",

src/index.ts:423

MethodupdateQuery

( table: SqlTable, set: SqlSetValueMap, where?: SqlCondition, returning?: SqlR

src/pg.ts:371