The lightweight PHP database framework to accelerate the development.
This report summarizes scanner evidence for catfan/Medoo, a PHP project with 4,953 GitHub stars. SynthScan examined 6,709 lines of code across 29 source files, recording 78 pattern matches distributed across 2 syntactic categories. The legacy adjusted pattern signal is 12.8 (Moderate pattern signal); it is not an authorship estimate.
Use the findings to ask whether maintainers can explain intent, verify dependencies, simplify unnecessary scaffolding, and focus review effort. Risk Payload v1 adds ownership, supply-chain, over-engineering, and review-effort vectors when available. These are prompts for human verification, not probabilities, security findings, or measured maintenance costs.
Use each vector to guide manual verification of the underlying findings.
Can maintainers explain intent, assumptions, and trade-offs? 58 finding(s).
Are imports declared and package/API names verified? 20 finding(s).
Are wrappers, guards, and repeated structures necessary? 58 finding(s).
Which changes need focused human review? 78 finding(s).
This chart tracks the legacy adjusted pattern score across scan runs. Changes can reflect source changes, scan coverage, or detector/scoring versions; they do not measure AI adoption or prove that a team refactored code. Compare runs only when their scoring versions are compatible. The dashed line tracks the raw pattern-hit count.
Groups findings by configured severity weight. Severity is not a confidence estimate, security rating, or proof that a package is missing. Verify imports against the project's manifests and inspect each finding in its local design context.
This horizontal bar chart shows where configured pattern scores accumulate across directories. Treat the bars as locations to inspect, not as evidence of authorship or code quality. Use the file-level findings to decide whether a directory needs a focused ownership, dependency, complexity, or review check.
The scanner identified 78 distinct pattern matches across 2 syntactic categories. Each entry below represents a discrete location in the source code where the engine recorded a detector match to inspect in context. Expand any category row to inspect the individual file paths, line numbers, code snippets, and the lexical context (CODE, COMMENT, or STRING) in which each match was detected.
Reading the findings table: The Severity column indicates the configured finding weight (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — legacy comment-context matches receive a ×1.5 score weight. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier under the legacy scoring model.
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | tests/SelectTest.php | 75 | public function testSelectColumnsWithAlias(string $type): void | CODE |
| LOW | tests/SelectTest.php | 91 | public function testSelectColumnsWithType(string $type): void | CODE |
| LOW | tests/SelectTest.php | 107 | public function testSelectColumnsWithAliasAndType(string $type): void | CODE |
| LOW | tests/SelectTest.php | 255 | public function testSelectWithSameKeysJoin(string $type): void | CODE |
| LOW | tests/SelectTest.php | 351 | public function testSelectWithMultipleConditionJoin(string $type): void | CODE |
| LOW | tests/SelectTest.php | 382 | public function testSelectWithAdditionalConditionJoin(string $type): void | CODE |
| LOW | tests/SelectTest.php | 448 | public function testSelectWithDataMapping(string $type): void | CODE |
| LOW | tests/SelectTest.php | 480 | public function testSelectWithIndexMapping(string $type): void | CODE |
| LOW | tests/SelectTest.php | 520 | public function testSelectWithDistinctDiffOrder(string $type): void | CODE |
| LOW | tests/SelectTest.php | 539 | public function testSelectWithUnicodeCharacter(string $type): void | CODE |
| LOW | tests/SelectTest.php | 558 | public function testSelectWithHyphenCharacter(string $type): void | CODE |
| LOW | tests/SelectTest.php | 576 | public function testSelectWithSingleCharacter(string $type): void | CODE |
| LOW | tests/QueryTest.php | 62 | public function testQueryShowTableWithPrefix(): void | CODE |
| LOW | tests/QueryTest.php | 80 | public function testPreparedStatementQuery(string $type): void | CODE |
| LOW | tests/ConnectionTest.php | 12 | public function testPostgreSQLAppliesValidatedCharsetToInjectedPdo(): void | CODE |
| LOW | tests/ConnectionTest.php | 26 | public function testPostgreSQLRejectsInvalidCharset(mixed $charset): void | CODE |
| LOW | tests/ConnectionTest.php | 41 | public static function invalidEncodingNamesProvider(): array | CODE |
| LOW | tests/ConnectionTest.php | 53 | public function testMySQLRejectsInvalidCollation(): void | CODE |
| LOW⚡ | tests/InsertTest.php | 154 | public function testOracleWithPrimaryKeyInsert(): void | CODE |
| LOW⚡ | tests/InsertTest.php | 173 | public function testPostgreSQLWithPrimaryKeyInsert(): void | CODE |
| LOW | tests/InsertTest.php | 213 | public function testOracleWithLOBsAndIdInsert(): void | CODE |
| LOW | tests/RawTest.php | 29 | public function testRawWithSamePlaceholderName(string $type): void | CODE |
| LOW | tests/CreateTest.php | 61 | public function testCreateWithCustomIdentityColumn(): void | CODE |
| LOW | tests/CreateTest.php | 77 | public function testCreateRejectsInvalidIdentity(string $identity): void | CODE |
| LOW | tests/CreateTest.php | 98 | public function testCreateRejectsMultipleIdentityColumns(): void | CODE |
| LOW⚡ | tests/CreateTest.php | 109 | public function testCreateRejectsIdentityColumnCollision(array $columns): void | CODE |
| LOW⚡ | tests/CreateTest.php | 119 | public static function identityCollisionProvider(): array | CODE |
| LOW⚡ | tests/CreateTest.php | 127 | public function testCreateRejectsIdentityForUnsupportedDatabase(): void | CODE |
| LOW⚡ | tests/CreateTest.php | 136 | public function testSQLiteIdentityExecution(): void | CODE |
| LOW | tests/CreateTest.php | 208 | public function testCreateWithStringDefinition(string $type): void | CODE |
| LOW | tests/CreateTest.php | 240 | public function testCreateWithSingleOption(string $type): void | CODE |
| LOW⚡ | tests/WhereTest.php | 173 | public function testArrayStringValuesWhere(string $type): void | CODE |
| LOW⚡ | tests/WhereTest.php | 193 | public function testEmptyArrayValuesWhere(string $type): void | CODE |
| LOW⚡ | tests/WhereTest.php | 405 | public function testCompoundDuplicatedKeysWhere(string $type): void | CODE |
| LOW | tests/WhereTest.php | 71 | public function testNotBetweenDateTimeWhere(string $type): void | CODE |
| LOW | tests/WhereTest.php | 212 | public function testEmptyNotInArrayValuesWhere(string $type): void | CODE |
| LOW | tests/WhereTest.php | 254 | public function testRawNotInArrayValuesWhere(string $type): void | CODE |
| LOW | tests/WhereTest.php | 309 | public function testBasicAndRelativityWhere(string $type): void | CODE |
| LOW | tests/WhereTest.php | 332 | public function testBasicSingleRelativityWhere(string $type): void | CODE |
| LOW | tests/WhereTest.php | 353 | public function testBasicOrRelativityWhere(string $type): void | CODE |
| LOW | tests/WhereTest.php | 379 | public function testCompoundRelativityWhere(string $type): void | CODE |
| LOW | tests/WhereTest.php | 435 | public function testColumnsRelationshipWhere(string $type): void | CODE |
| LOW | tests/WhereTest.php | 706 | public function testMultipleOrderWhereWithStringValues(string $type): void | CODE |
| LOW | tests/WhereTest.php | 772 | public function testRegularExpressionWhere(string $type): void | CODE |
| LOW | tests/WhereTest.php | 805 | public function testNegativeRegularExpressionWhere(string $type): void | CODE |
| LOW | tests/WhereTest.php | 1016 | public function testHavingWithAggregateRawWhere(string $type): void | CODE |
| LOW | tests/WhereTest.php | 1058 | public function testRawWhereWithJoinClause(string $type): void | CODE |
| LOW | tests/DataMapTest.php | 10 | public function testDataMapKeepsIndexedNestedResultConsistent(): void | CODE |
| LOW⚡ | tests/IdTest.php | 12 | public function testOracleIdReturnsCachedValue(): void | CODE |
| LOW⚡ | tests/IdTest.php | 20 | public function testIdReturnsNullWithoutConnection(): void | CODE |
| LOW⚡ | tests/IdTest.php | 27 | public function testPostgreSQLIdUsesLastvalWithoutSequenceName(): void | CODE |
| LOW | tests/IdTest.php | 38 | public function testPostgreSQLIdUsesCachedReturningValue(): void | CODE |
| LOW | tests/IdTest.php | 50 | public function testPostgreSQLIdReturnsNullBeforeSequenceUse(): void | CODE |
| LOW | tests/IdTest.php | 58 | public function testPostgreSQLIdUsesSequenceName(): void | CODE |
| LOW | tests/IdTest.php | 69 | public function testPostgreSQLIdKeepsZeroValue(): void | CODE |
| LOW | tests/IdTest.php | 88 | public function testDriverFalseIdReturnsNull(): void | CODE |
| LOW | tests/IdTest.php | 96 | public function testDefaultDriverIdUsesPdoLastInsertId(): void | CODE |
| LOW | tests/ColumnMappingTest.php | 10 | public function testColumnHelpersKeepIndexedNestedResultsConsistent(): void | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | README.md | 84 | 'email' => 'foo@bar.com' | CODE |
| LOW | README.md | 99 | // "email" : "foo@bar.com", | COMMENT |
| LOW | tests/InsertTest.php | 17 | "email" => "foo@bar.com" | CODE |
| LOW | tests/InsertTest.php | 23 | VALUES ('foo', 'foo@bar.com') | CODE |
| LOW | tests/InsertTest.php | 137 | "email" => "foo@bar.com" | CODE |
| LOW⚡ | tests/InsertTest.php | 148 | VALUES ('foo', 'foo@bar.com'), ('bar', 'bar@foo.com') | CODE |
| LOW⚡ | tests/InsertTest.php | 160 | "EMAIL" => "foo@bar.com" | CODE |
| LOW⚡ | tests/InsertTest.php | 166 | VALUES ('foo', 'foo@bar.com') | CODE |
| LOW⚡ | tests/InsertTest.php | 179 | "email" => "foo@bar.com" | CODE |
| LOW⚡ | tests/InsertTest.php | 185 | VALUES ('foo', 'foo@bar.com') | CODE |
| LOW⚡ | tests/WhereTest.php | 178 | "email" => ["foo@bar.com", "cat@dog.com", "admin@medoo.in"] | CODE |
| LOW⚡ | tests/WhereTest.php | 186 | "email" IN ('foo@bar.com', 'cat@dog.com', 'admin@medoo.in') | CODE |
| LOW⚡ | tests/WhereTest.php | 398 | (("user_name" = 'foo' OR "email" = 'foo@bar.com') AND "password" = '12345') | CODE |
| LOW⚡ | tests/WhereTest.php | 413 | "email" => "foo@bar.com" | CODE |
| LOW | tests/WhereTest.php | 16 | "email" => "foo@bar.com", | CODE |
| LOW | tests/WhereTest.php | 34 | "email" = 'foo@bar.com' AND | CODE |
| LOW | tests/WhereTest.php | 285 | "email[!]" => ["foo@bar.com", "admin@medoo.in"], | CODE |
| LOW | tests/WhereTest.php | 299 | "email" NOT IN ('foo@bar.com', 'admin@medoo.in') AND | CODE |
| LOW | tests/WhereTest.php | 387 | "email" => "foo@bar.com" | CODE |
| LOW | tests/WhereTest.php | 427 | (("user_name" = 'foo' OR "email" = 'foo@bar.com') AND | CODE |