Noam Honig noam-honig
noam-honig
/ cache-data-provider-results.ts
Last active
September 11, 2024 15:11
cache-data-provider-results - see https://github.com/remult/remult/discussions/222
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| dataProvider: async () => { | |
| const result = await createKnexDataProvider({ | |
| client: 'mssql', | |
| //debug: true, | |
| connection: { | |
| server: process.env['DBServer'], | |
| database: process.env['DBDatabase'], | |
| user: process.env['DBUser'], | |
| password: process.env['DBPassword'], | |
| query_timeout: 30000, |
noam-honig
/ bulk-insert.ts
Last active
September 11, 2024 13:02
bulk insert without hooks - just push to sql db
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| async function bulkInsert<entityType extends EntityBase>( | |
| array: entityType[], | |
| db: SqlDatabase, | |
| ) { | |
| if (array.length == 0) return | |
| const chunkSize = 250 | |
| for (let i = 0; i < array.length; i += chunkSize) { | |
| const items = array.slice(i, i + chunkSize) |
noam-honig
/ data-provider-wrapper.ts
Last active
September 11, 2024 12:59
DataProvider wrapper that documents number of returned rows and query duration
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| return new Proxy(db, { | |
| get(target, prop) { | |
| if (prop == 'getEntityDataProvider') { | |
| return (meta: EntityMetadata) => { | |
| return new Proxy(db.getEntityDataProvider(meta), { | |
| get(target, prop) { | |
| if (prop == 'find') { | |
| return async (options: EntityDataProviderFindOptions) => { | |
| const start = performance.now(); | |
| const result = await target.find(options); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import { | |
| Entity, | |
| FieldRef, | |
| Fields, | |
| FieldsRef, | |
| getEntityRef, | |
| IdEntity, | |
| isBackend, | |
| LifecycleEvent, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| body { | |
| font-family: Arial, Helvetica, sans-serif; | |
| background-color: #f5f5f5; | |
| display: flex; | |
| justify-content: center; | |
| font-size:x-large | |
| } | |
| input{ | |
| font-size: x-large; | |
| min-width: 18px; |
noam-honig
/ gist:4621f19e66b3448aff30c0485be985cb
Last active
December 13, 2021 14:53
dynamically load entities
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import glob from 'glob'; | |
| import path from 'path'; | |
| for (const type of ["entity", "controller"]) { | |
| for (const ext of ["js", "ts"]) { | |
| for (const file of glob.sync(`src/**/*.${type}.${ext}`)) { | |
| require(path.resolve(file)) | |
| } | |
| } | |
| } |
noam-honig
/ generate-test-data.sql
Created
November 30, 2021 04:05
Anonymize relational data Sql Scripts
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| create table Person( | |
| social_security_number int, | |
| name varchar(50) | |
| ) | |
| create table transactions( | |
| person_social_security_number int, | |
| month int, | |
| amount decimal | |
| ) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # See http://help.github.com/ignore-files/ for more about ignoring files. | |
| # compiled output | |
| /dist | |
| /tmp | |
| /out-tsc | |
| # Only exists if Bazel was run | |
| /bazel-out | |
| # dependencies |
noam-honig
/ tasks.json
Created
October 7, 2021 14:19
Tasks json to use when developer remult with react
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "version": "2.0.0", | |
| "tasks": [ | |
| { | |
| "type": "npm", | |
| "script": "dev-react", | |
| "problemMatcher": [ | |
| "$tsc-watch" | |
| ], | |
| "label": "npm: dev-react", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| diff --git a/package.json b/package.json | |
| index 3bb8620..f6b1b47 100644 | |
| --- a/package.json | |
| +++ b/package.json | |
| @@ -4,6 +4,8 @@ | |
| "scripts": { | |
| "ng": "ng", | |
| "start": "ng serve", | |
| + "dev-node": "ts-node-dev --project tsconfig.server.json src/server/", | |
| + "dev-ng": "ng serve --proxy-config proxy.conf.json --open", |
NewerOlder