US 12,169,482 B2
Code packager with SQL parser
Peter James Pickerill, Austin, TX (US); and Nathan Owen Voxland, Moorhead, MN (US)
Assigned to LIQUIBASE INC., Austin, TX (US)
Filed by LIQUIBASE INC., Austin, TX (US)
Filed on Sep. 23, 2022, as Appl. No. 17/951,211.
Application 17/951,211 is a continuation of application No. 16/953,411, filed on Nov. 20, 2020, granted, now 11,494,349.
Claims priority of provisional application 62/939,395, filed on Nov. 22, 2019.
Prior Publication US 2023/0090874 A1, Mar. 23, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/21 (2019.01); G06F 8/60 (2018.01); G06F 8/76 (2018.01); G06F 8/77 (2018.01)
CPC G06F 16/213 (2019.01) [G06F 8/60 (2013.01); G06F 8/76 (2013.01); G06F 8/77 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A system, comprising:
a database change management system coupled to a database server maintaining a database according to a database schema, the database change management system including a processor and a non-transitory computer readable medium storing computer executable instructions executable to provide a set of services comprising:
a packaging service configured to:
retrieve Structured Query Language (SQL) scripts from a source code manager repository;
package the SQL scripts, wherein packaging the SQL scripts comprises generating changesets pointing to the SQL scripts;
process the changesets to generate change objects that model changes to be applied to the database, wherein generating the change objects comprises parsing the SQL scripts and identifying, from the SQL scripts, the changes to be applied to the database;
apply the changes in the change objects to a virtual model of the database to simulate changing the database;
generate a forecast report based on simulating changing the database, wherein the forecast report is indicative of a prediction of a failure or success of an implementation of the changes to the database; and
responsive to a predicted implementation success, deploy the changes to the database.