Fuzz introspector
For issues and ideas: https://github.com/ossf/fuzz-introspector/issues
Project coverage

Table of contents

Project overview: sqlalchemy
High level conclusions
Reachability and coverage overview
Fuzzers overview
Project functions overview
Fuzzer details
Fuzzer: sqlalchemy_fuzzer
Call tree
Fuzz blockers
Runtime coverage analysis
Files reached
Analyses and suggestions
Optimal target analysis
Remaining optimal interesting functions
All functions overview
Fuzz engine guidance
/src/sqlalchemy_fuzzer.py
Dictionary
Fuzzer function priority
Runtime coverage analysis
Complex functions with low coverage
Files and Directories in report
Files in report
Directories in report
Metadata section
Report generation date: 2024-07-27

Project overview: sqlalchemy

High level conclusions

Reachability and coverage overview

Functions statically reachable by fuzzers
0.0%
13 / 6820
Cyclomatic complexity statically reachable by fuzzers
0.0%
55 / 22592
Runtime code coverage of functions
11.0%
757 / 6820

Warning: The number of runtime covered functions are larger than the number of reachable functions. This means that Fuzz Introspector found there are more functions covered at runtime than what is considered reachable based on the static analysis. This is a limitation in the analysis as anything covered at runtime is by definition reachable by the fuzzers.
This is likely due to a limitation in the static analysis. In this case, the count of functions covered at runtime is the true value, which means this is what should be considered "achieved" by the fuzzer.

Use the project functions table below to query all functions that were not covered at runtime.

Fuzzers overview

Fuzzer Fuzzer filename Functions Reached Functions unreached Fuzzer depth Files reached Basic blocks reached Cyclomatic complexity Details
sqlalchemy_fuzzer /src/sqlalchemy_fuzzer.py 48 10117 4 5 44 157 sqlalchemy_fuzzer.py

Project functions overview

The following table shows data about each function in the project. The functions included in this table correspond to all functions that exist in the executables of the fuzzers. As such, there may be functions that are from third-party libraries.

For further technical details on the meaning of columns in the below table, please see the Glossary .

Func name Functions filename Args Function call depth Reached by Fuzzers Fuzzers runtime hit Func lines hit % I Count BB Count Cyclomatic complexity Functions reached Reached by functions Accumulated cyclomatic complexity Undiscovered complexity

Fuzzer details

Fuzzer: sqlalchemy_fuzzer

Call tree

The calltree shows the control flow of the fuzzer. This is overlaid with coverage information to display how much of the potential code a fuzzer can reach is in fact covered at runtime. In the following there is a link to a detailed calltree visualisation as well as a bitmap showing a high-level view of the calltree. For further information about these topics please see the glossary for full calltree and calltree overview

Full calltree

Call tree overview bitmap:

The distribution of callsites in terms of coloring is
Color Runtime hitcount Callsite count Percentage
red 0 60 58.8%
gold [1:9] 0 0.0%
yellow [10:29] 0 0.0%
greenyellow [30:49] 0 0.0%
lawngreen 50+ 42 41.1%
All colors 102 100

Fuzz blockers

The following nodes represent call sites where fuzz blockers occur.

Amount of callsites blocked Calltree index Parent function Callsite Largest blocked function
30 50 sqlalchemy.sql.schema.Column.__init__ call site: 00050 sqlalchemy.sql.schema.ColumnDefault.__init__
17 5 sqlalchemy.sql.schema.MetaData.__init__ call site: 00005 sqlalchemy.sql.schema.MetaData.reflect
7 87 sqlalchemy.sql.schema.Column._extra_kwargs call site: 00087 sqlalchemy.sql.schema.Column.__init__
2 81 sqlalchemy.sql.schema.Column.__init__ call site: 00081 util.raise_
1 23 ...sqlalchemy_fuzzer.TestOneInput call site: 00023 sqlalchemy.sql.schema.Column.__init__
1 48 sqlalchemy.sql.schema.Column.__init__ call site: 00048 kwargs.pop
1 84 sqlalchemy.sql.schema.Column.__init__ call site: 00084 kwargs.pop
1 98 ...sqlalchemy_fuzzer.TestOneInput call site: 00098 sqlalchemy.sql.base._bind_or_error

Runtime coverage analysis

Covered functions
840
Functions that are reachable but not covered
38
Reachable functions
48
Percentage of reachable functions covered
20.83%
NB: The sum of covered functions and functions that are reachable but not covered need not be equal to Reachable functions . This is because the reachability analysis is an approximation and thus at runtime some functions may be covered that are not included in the reachability analysis. This is a limitation of our static analysis capabilities.
Warning: The number of covered functions are larger than the number of reachable functions. This means that there are more functions covered at runtime than are extracted using static analysis. This is likely a result of the static analysis component failing to extract the right call graph or the coverage runtime being compiled with sanitizers in code that the static analysis has not analysed. This can happen if lto/gold is not used in all places that coverage instrumentation is used.
Function name source code lines source lines hit percentage hit

Files reached

filename functions hit
/ 1
...sqlalchemy_fuzzer 8
sqlalchemy.sql.schema 35
sqlalchemy.sql.base 6
sqlalchemy.engine 2

Analyses and suggestions

Optimal target analysis

Remaining optimal interesting functions

The following table shows a list of functions that are optimal targets. Optimal targets are identified by finding the functions that in combination, yield a high code coverage.

Func name Functions filename Arg count Args Function depth hitcount instr count bb count cyclomatic complexity Reachable functions Incoming references total cyclomatic complexity Unreached complexity
sqlalchemy.orm.mapper.Mapper.__init__ sqlalchemy.orm.mapper 31 ['N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A', 'N/A'] 84 0 14 9 7 305 0 1026 981

Implementing fuzzers that target the above functions will improve reachability such that it becomes:

Functions statically reachable by fuzzers
2.0%
164 / 6820
Cyclomatic complexity statically reachable by fuzzers
3.0%
614 / 22592

All functions overview

If you implement fuzzers for these functions, the status of all functions in the project will be:

Func name Functions filename Args Function call depth Reached by Fuzzers Fuzzers runtime hit Func lines hit % I Count BB Count Cyclomatic complexity Functions reached Reached by functions Accumulated cyclomatic complexity Undiscovered complexity

Fuzz engine guidance

This sections provides heuristics that can be used as input to a fuzz engine when running a given fuzz target. The current focus is on providing input that is usable by libFuzzer.

/src/sqlalchemy_fuzzer.py

Dictionary

Use this with the libFuzzer -dict=DICT.file flag


Fuzzer function priority

Use one of these functions as input to libfuzzer with flag: -focus_function name 

-focus_function=['sqlalchemy.sql.schema.Column.__init__', 'sqlalchemy.sql.schema.MetaData.__init__', 'sqlalchemy.sql.schema.Column._extra_kwargs', '...sqlalchemy_fuzzer.TestOneInput']

Runtime coverage analysis

This section shows analysis of runtime coverage data.

For futher technical details on how this section is generated, please see the Glossary .

Complex functions with low coverage

Func name Function total lines Lines covered at runtime percentage covered Reached by fuzzers
sqlalchemy.sql.schema.Table.__new__ 44 23 52.27% []
sqlalchemy.sql.schema.Table.tometadata 33 3 9.090% []
sqlalchemy.sql.schema.PrimaryKeyConstraint._autoincrement_column._validate_autoinc 32 16 50.0% []
sqlalchemy.sql.schema.MetaData.reflect 31 1 3.225% ['sqlalchemy_fuzzer']
sqlalchemy.util.langhelpers.generic_repr 47 3 6.382% []
sqlalchemy.util.langhelpers.as_interface 34 2 5.882% []
sqlalchemy.sql.selectable.Join._joincond_scan_left_right 32 0 0.0% []
sqlalchemy.engine.default.DefaultExecutionContext._expand_in_parameters 32 0 0.0% []
sqlalchemy.engine.default.DefaultExecutionContext.set_input_sizes 40 0 0.0% []
sqlalchemy.sql.compiler.SQLCompiler.visit_cte 57 0 0.0% []
sqlalchemy.sql.compiler.SQLCompiler._transform_select_for_nested_joins.visit 38 0 0.0% []
sqlalchemy.sql.compiler.SQLCompiler.visit_insert 52 0 0.0% []
sqlalchemy.sql.compiler.SQLCompiler.visit_update 44 0 0.0% []
sqlalchemy.sql.compiler.SQLCompiler.visit_delete 33 0 0.0% []
sqlalchemy.sql.ddl.sort_tables_and_constraints 37 10 27.02% []
sqlalchemy.engine.base.Connection._execute_context 66 35 53.03% []
sqlalchemy.pool.base._ConnectionFairy._checkout 40 9 22.5% []

Files and Directories in report

This section shows which files and directories are considered in this report. The main reason for showing this is fuzz introspector may include more code in the reasoning than is desired. This section helps identify if too many files/directories are included, e.g. third party code, which may be irrelevant for the threat model. In the event too much is included, fuzz introspector supports a configuration file that can exclude data from the report. See the following link for more information on how to create a config file: link

Files in report

Source file Reached by Covered by
[] []
sqlalchemy.events [] []
ForeignKeyConstraint [] []
sqlalchemy.util.langhelpers [] []
mock [] []
sqlalchemy.testing.profiling [] []
time [] []
sqlalchemy.ext.hybrid [] []
literal_column [] []
sqlalchemy.dialects.firebird.fdb [] []
sqlalchemy.util.deprecations [] []
sqlalchemy.testing.suite.test_reflection [] []
sqlalchemy.dialects.postgresql.base [] []
Sequence [] []
ForeignKey [] []
sqlalchemy.ext.indexable [] []
sqlalchemy.ext.mutable [] []
sqlalchemy.dialects.oracle.zxjdbc [] []
sqlalchemy.dialects.sybase [] []
func [] []
sqlalchemy.orm.identity [] []
sqlalchemy.testing.provision [] []
sqlalchemy.sql.ddl [] []
os [] []
sqlalchemy.dialects.mysql.gaerdbms [] []
sqlalchemy.engine.util [] []
cProfile [] []
types [] []
pytest [] []
sqlalchemy.testing.util [] []
sqlalchemy.sql [] []
sqlalchemy.orm.collections [] []
Table [] []
Index [] []
sqlalchemy.testing.pickleable [] []
sqlalchemy.testing.assertions [] []
sqlalchemy.ext.baked [] []
operator [] []
exists [] []
_collections [] []
sqlalchemy.dialects.sqlite.json [] []
sqlalchemy.dialects.sybase.mxodbc [] []
sqlalchemy.dialects.mysql.provision [] []
Column [] []
inspect [] []
datetime [] []
array [] []
sqlalchemy.connectors [] []
io [] []
sqlalchemy.connectors.mxodbc [] []
collections [] []
sqlalchemy.ext [] []
sqlalchemy.ext.orderinglist [] []
sqlalchemy.types [] []
[] []
sqlalchemy.ext.associationproxy [] []
sqlalchemy.dialects.postgresql.ext [] []
sqlalchemy.testing.suite.test_sequence [] []
select [] []
sqlalchemy.dialects.postgresql.hstore [] []
sqlalchemy.dialects.postgresql.pg8000 [] []
object_session [] []
String [] []
sqlalchemy.dialects.firebird.kinterbasdb [] []
sqlalchemy.dialects.mysql.mysqlconnector [] []
codecs [] []
sqlalchemy.orm.session [] []
sqlalchemy.sql.functions [] []
sqlalchemy.event.base [] []
uuid [] []
sqlalchemy.dialects.mssql [] []
sqlalchemy.ext.declarative.base [] []
sqlalchemy.sql.visitors [] []
sqla_plugin_base [] []
null [] []
sqlalchemy.testing.suite.test_types [] []
sqlalchemy.ext.declarative.api [] []
sqlalchemy.dialects.sybase.pyodbc [] []
weakref [] []
decimal [] []
sqlalchemy.dialects.mysql.json [] []
sqlalchemy.testing.requirements [] []
sqlalchemy.dialects.mysql.zxjdbc [] []
sqlalchemy.pool.dbapi_proxy [] []
base64 [] []
sqlalchemy.exc [] []
sqlalchemy.event.registry [] []
sqlalchemy.dialects.postgresql.psycopg2cffi [] []
sqlalchemy.orm.descriptor_props [] []
sqlalchemy.ext.serializer [] []
sqlalchemy.testing.plugin.pytestplugin [] []
sqlalchemy.orm [] []
sqlalchemy.testing.plugin.plugin_base [] []
sqlalchemy.event [] []
sqlalchemy.util.topological [] []
sqlalchemy.orm.exc [] []
Numeric [] []
sqlalchemy.sql.sqltypes [] []
sqlalchemy.dialects.sqlite.pysqlcipher [] []
sqlalchemy.testing.suite.test_update_delete [] []
pstats [] []
sqlalchemy.ext.horizontal_shard [] []
sqlalchemy.dialects.sybase.pysybase [] []
importlib [] []
sqlalchemy.orm.strategy_options [] []
sqlalchemy.orm.evaluator [] []
sqlalchemy.orm.sync [] []
sqlalchemy.testing.assertsql [] []
sqlalchemy.sql.elements [] []
sqlalchemy.dialects.mysql.pyodbc [] []
MetaData [] []
sqlalchemy.dialects.postgresql.provision [] []
sqlalchemy.orm.util [] []
sqlalchemy.orm.scoping [] []
cPickle [] []
sqlalchemy.event.attr [] []
UniqueConstraint [] []
cStringIO [] []
sqlalchemy.testing.replay_fixture [] []
sqlalchemy.event.api [] []
sqlalchemy.sql.selectable [] []
sqlalchemy.testing.schema [] []
sqlalchemy.testing.suite [] []
sqlalchemy.cprocessors [] []
sqlalchemy.dialects.postgresql [] []
sqlalchemy.ext.declarative [] []
uses_deprecated [] []
sqlalchemy.sql.operators [] []
sqlalchemy.ext.declarative.clsregistry [] []
cast [] []
sqlalchemy.engine.default [] []
sqlalchemy.orm.base [] []
sqlalchemy.util.compat [] []
sqlalchemy.orm.path_registry [] []
sqlalchemy.sql.naming [] []
sqlalchemy.orm.query [] []
sqlalchemy.schema [] []
Computed [] []
sqlalchemy.dialects.sqlite [] []
sqlalchemy.dialects.mysql.pymysql [] []
sqlalchemy.sql.base ['sqlalchemy_fuzzer'] []
sqlalchemy.orm.persistence [] []
sqlalchemy.dialects.postgresql.dml [] []
false [] []
pkg_resources [] []
traceback [] []
random [] []
sqlalchemy.ext.automap [] []
sqlalchemy.dialects.oracle.cx_oracle [] []
sqlalchemy.testing.exclusions [] []
Float [] []
re [] []
sqlalchemy.engine.base [] []
sqlalchemy.dialects.mssql.pyodbc [] []
sqlalchemy.testing.suite.test_ddl [] []
testing [] []
sqlalchemy.util._collections [] []
sqlalchemy.sql.compiler [] []
sqlalchemy.dialects.mysql.dml [] []
literal [] []
sqlalchemy [] []
sqlalchemy.dialects.postgresql.json [] []
...sqlalchemy_fuzzer ['sqlalchemy_fuzzer'] []
gc [] []
psycopg2 [] []
sqlalchemy.dialects.postgresql.pypostgresql [] []
sqlalchemy.dialects.oracle.base [] []
sqlalchemy.dialects.oracle.provision [] []
configparser [] []
sqlalchemy.sql.dml [] []
sqlalchemy.testing.warnings [] []
true [] []
and_ [] []
sqlalchemy.log [] []
sqlalchemy.orm.properties [] []
com [] []
sqlalchemy.connectors.pyodbc [] []
sqlalchemy.dialects.mssql.adodbapi [] []
sqlalchemy.orm.loading [] []
sqlalchemy.dialects.mssql.provision [] []
sqlalchemy.dialects.mysql.cymysql [] []
sqlalchemy.databases [] []
sqlalchemy.dialects [] []
sqlalchemy.ext.compiler [] []
itertools [] []
class_mapper [] []
sqlalchemy.orm.dependency [] []
sqlalchemy.orm.dynamic [] []
case [] []
sqlalchemy.sql.expression [] []
sqlalchemy.engine ['sqlalchemy_fuzzer'] []
sqlalchemy.sql.type_api [] []
sqlalchemy.util [] []
sqlalchemy.engine.threadlocal [] []
sqlalchemy.dialects.mysql.mysqldb [] []
sqlalchemy.engine.strategies [] []
sqlalchemy.testing.engines [] []
sqlalchemy.orm.strategies [] []
sqlalchemy.dialects.firebird.base [] []
type_coerce [] []
sqlalchemy.dialects.mysql.oursql [] []
platform [] []
create_engine [] []
sqlalchemy.dialects.postgresql.zxjdbc [] []
sqlalchemy.dialects.postgresql.pygresql [] []
sqlalchemy.dialects.mssql.zxjdbc [] []
sqlalchemy.dialects.sybase.base [] []
sqlalchemy.dialects.mssql.information_schema [] []
sqlalchemy.testing.entities [] []
CheckConstraint [] []
textwrap [] []
sqlalchemy.dialects.postgresql.ranges [] []
sqlalchemy.testing.suite.test_select [] []
sqlalchemy.dialects.mysql [] []
threading [] []
sqlalchemy.inspection [] []
tuple_ [] []
dummy_threading [] []
bindparam [] []
sys [] []
object_mapper [] []
sqlalchemy.cutils [] []
sqlalchemy.dialects.sqlite.provision [] []
functools [] []
JSON [] []
sqlalchemy.engine.url [] []
sqlalchemy.dialects.postgresql.array [] []
sqlalchemy.pool [] []
logging [] []
sqlalchemy.engine.result [] []
sqlalchemy.testing.config [] []
sqlalchemy.sql.default_comparator [] []
sqlalchemy.dialects.mysql.types [] []
unittest [] []
sqlalchemy.sql.annotation [] []
sqlalchemy.orm.events [] []
struct [] []
hashlib [] []
sqlalchemy.sql.util [] []
sqlalchemy.cresultproxy [] []
sqlalchemy.testing.suite.test_results [] []
sqlalchemy.orm.deprecated_interfaces [] []
sqlalchemy.testing.suite.test_dialect [] []
sqlalchemy.event.legacy [] []
Integer [] []
copy [] []
sqlalchemy.dialects.mssql.mxodbc [] []
sqlalchemy.dialects.oracle [] []
sqlalchemy.orm.relationships [] []
sqlalchemy.testing.suite.test_insert [] []
pickle [] []
mysql [] []
Unicode [] []
sqlalchemy.testing.suite.test_cte [] []
sqlalchemy.connectors.zxJDBC [] []
sqlalchemy.dialects.sqlite.base [] []
warnings [] []
atheris [] []
union [] []
sqlalchemy.util._preloaded [] []
sqlalchemy.orm.instrumentation [] []
text [] []
sqlalchemy.orm.interfaces [] []
sqlalchemy.orm.unitofwork [] []
sqlalchemy.testing [] []
sqlalchemy.orm.state [] []
imp [] []
sqlalchemy.orm.attributes [] []
sqlalchemy.interfaces [] []
sqlalchemy.engine.interfaces [] []
sqlalchemy.dialects.mysql.base [] []
sqlalchemy.sql.crud [] []
sqlalchemy.dialects.mysql.enumerated [] []
sqlalchemy.orm.mapper [] []
UnicodeText [] []
sqlalchemy.testing.mock [] []
sqlalchemy.engine.reflection [] []
sqlalchemy.sql.schema ['sqlalchemy_fuzzer'] []
sqlalchemy.dialects.mysql.reflection [] []
sqlalchemy.dialects.sqlite.pysqlite [] []
sqlalchemy.dialects.firebird [] []
sqlalchemy.ext.instrumentation [] []
sqlalchemy.testing.plugin [] []
sqlalchemy.testing.plugin.bootstrap [] []
sqlalchemy.pool.impl [] []
sqlalchemy.dialects.mssql.pymssql [] []
sqlalchemy.processors [] []
sqlalchemy.dialects.mssql.base [] []
Boolean [] []
sqlalchemy.util.queue [] []
sqlalchemy.dialects.postgresql.psycopg2 [] []
sqlalchemy.testing.fixtures [] []
sqlalchemy.pool.base [] []
google [] []

Directories in report

Directory

Metadata section

This sections shows the raw data that is used to produce this report. This is mainly used for further processing and developer debugging.

Fuzzer Calltree file Program data file Coverage file
sqlalchemy_fuzzer fuzzerLogFile-sqlalchemy_fuzzer.data fuzzerLogFile-sqlalchemy_fuzzer.data.yaml all_cov.json