registry / @diia-inhouse/db / 12.3.14

@diia-inhouse/db@12.3.14

Package with database connection

Static Scan Results

scanned 2h ago · by rust-scanner

Static analysis flagged 8 finding(s) at 72.0% confidence. This version is warn-only unless an AI or security-team review confirms malicious behavior.

Static reason

One or more suspicious static signals were detected.

Decision evidence

public snapshot

Behavioral surface

Source

DynamicRequireEnvironmentVarsFilesystem

Supply chain

HighEntropyStrings

Manifest

NoLicense

scanned 26 file(s), 41.0 KB of source

Source & flagged code

2 flagged

dist/services/database.jsView file

Lines 100-140javascript

100 };

101 if (replicaSet) connectionOptions.replicaSet = replicaSet;

102 if (replicaSetNodes) {

103 if (host) {

104 const errMsg = "Must be only `host` and `port` or `replicaSetNodes` config";

105

Source & flagged code

2 flagged · loading source

dist/services/database.jsView file

120patternName = generic_password severity = medium line = 120 matchedText = passwo...

Medium

Secret Pattern

Package contains a possible secret pattern.

dist/services/database.jsView on unpkg · L120

dist/cli/cleanupExpiredData.jsView file

32if (!existsSync(fullSchemaPath)) return; L33: return await import(fullSchemaPath); L34: }

Medium

Dynamic Require

Package source references dynamic require/import behavior.

dist/cli/cleanupExpiredData.jsView on unpkg · L32

Findings

3 Medium5 Low

MediumSecret Patterndist/services/database.js

MediumDynamic Requiredist/cli/cleanupExpiredData.js

MediumEnvironment Vars

LowNon Install Lifecycle Scripts

LowScripts Present

LowFilesystem

LowHigh Entropy Strings

LowNo License

dist/cli/cleanupExpiredData.jsView file

Lines 12-52javascript

12 this.logger = logger;

13 }

14 async run(filePath) {

15 const schema = await this.loadSchema(filePath);

16 if (!schema) {

17 this.logger.info("Pg schemas not found under provided path", { schemasPath: filePath });

18 return;

19 }

20 const db = this.createDbConnection(schema);

21 const expiringTables = this.findExpiringTables(schema);

22 if (expiringTables.length === 0) {

23 this.logger.info("No tables with expiring data found");

24 return;

25 }

26 await this.cleanupTables(db, schema, expiringTables);

27 await db.$client.end();

28 }

29 async loadSchema(filePath) {

30 const schemaPath = `./dist/${filePath}`;

31 const fullSchemaPath = path.resolve(schemaPath);

32 if (!existsSync(fullSchemaPath)) return;

33 return await import(fullSchemaPath);

34 }

Medium

Dynamic Require

Package source references dynamic require/import behavior.

dist/cli/cleanupExpiredData.jsView on unpkg · L32

35 createDbConnection(schema) {

36 return drizzle(process.env.POSTGRES_DATABASE_URL, {

37 schema,

38 casing: "snake_case",

39 logger: true

40 });

41 }

42 async cleanupTables(db, schema, expiringTables) {

43 this.logger.info(`Found ${expiringTables.length} tables with expiring data: ${expiringTables.map(({ name }) => name).join(", ")}`);

44 const startTime = Date.now();

45 try {

46 for (const { name, tableName, expiringColumns } of expiringTables) {

47 this.logger.info(`Starting cleanup expired data from table: ${name}`);

48 const table = schema[tableName];

49 for (const { column, expireAfterSeconds } of expiringColumns) {

50 const result = await db.delete(table).where(lt(sql.raw(`"${name}"."${column.name}" + interval '${expireAfterSeconds} seconds'`), /* @__PURE__ */ new Date()));

51 this.logger.info(`Deleted ${result.rowCount} rows from table ${name} by column ${column.name} with expireAfterSeconds ${expireAfterSeconds}`);

52 }