CompiledStatement returns a library-independent prepared statement.

Seb35 · Seb35 · commit 0a37bec277f0 · 2021-12-12T10:39:29.000+01:00
diff --git a/src/CompiledStatement.php b/src/CompiledStatement.php
@@ -53,6 +53,36 @@ public function addToken( string $repr ) : void {
 		$this->tpl .= ' ';
 	}
 
+	/**
+	 * Get a (compiled) prepared statement.
+	 *
+	 * The prepared statement was compiled from AST with one string and two arrays:
+	 *   - string query: the template SQL query with ? as parameters,
+	 *   - array args: the parameters of the template SQL query,
+	 *   - array types: the types of the parameters.
+	 *
+	 * The returned array has two keys:
+	 *   - template: a string representing the template SQL query,
+	 *   - parameters: an array whose each value is [ (string) $type, (string) $arg ]:
+	 *       - type: is a letter in [ 's', 'i', 'd', 'b' ] for the type of the parameter,
+	 *       - arg: is a string for the parameter.
+	 *
+	 * @return array
+	 */
+	public function getPreparedStatement() : array {
+
+		$n = count( $this->args );
+		$parameters = [];
+		for( $i = 0; $i < $n; $i++ ) {
+			$parameters[] = [ $this->types[$i], $this->args[$i] ];
+		}
+
+		return [
+			'template' => $this->getTpl(),
+			'parameters' => $parameters,
+		];
+	}
+
 	/**
 	 * Get a (compiled) prepared statement.
 	 *
