YERITH_QVGE : A Framework for Verifying SQL Correctness Temporal Properties of GUI Software at Runtime

Software correctness properties are essential to maintain quality by continuous and regressive inte-
gration testing, as well as runtime monitoring the program after customer deployment. This paper
presents an effective and lightweight C ++ program verification framework: YR_DB_RUNTIME_VERIF,
to check SQL (Structure Query Language) [1] software correctness properties specified as temporal
safety properties [2]. A temporal safety property specifies what behavior shall not occur, in a software,
as sequence of program events. YR_DB_RUNTIME_VERIF allows specification of a SQL temporal safety
property by means of a very small state diagram mealy machine [3]. In YR_DB_RUNTIME_VERIF, a spec-
ification characterizes effects of program events (via SQL statements) on database table columns by
means of set interface operations (∈, ∈), and, enable to check these characteristics hold or not at
runtime. Integration testing is achieved for instance by expressing a state diagram that encompasses
both Graphical User Interface (GUI) states and MySQL [4] databases queries that glue them. For
example, a simple specification would encompass states between ’Department administration’ and
’Stock listing’ GUI interfaces, and transitions between them by means of MySQL databases oper-
ations. YR_DB_RUNTIME_VERIF doesn’t generate false warnings; YR_DB_RUNTIME_VERIF specifications
are not desirable (forbidden) specifications (fail traces). This paper focuses its examples on MySQL
database specifications, labeled as states diagrams events, for the newly developed and FOSS (Free
and Open Source Software) Enterprise Resource Planing Software YEROTH–ERP–3.0 [5].