Package org.bgerp.plugin.ai.aixflow.model

Class AixFlowResultDAO

java.lang.Object

org.bgerp.plugin.ai.aixflow.model.AixFlowResultDAO

public class AixFlowResultDAO
extends Object

DAO for AixFlowResult operations

Constructor Summary

Constructors

Constructor	Description
AixFlowResultDAO()

Method Summary

Modifier and Type	Method	Description
static void	createTable(Connection con)	Create table if not exists
static void	deleteByFilename(Connection con, String filename)	Delete results by filename
static List<AixFlowResult>	getAll(Connection con)	Get all results
static List<AixFlowResult>	getByFilename(Connection con, String filename)	Get results by filename
static AixFlowResult	getByHash(Connection con, String hash)	Get result by hash
static void	saveDiarizationResult(Connection con, String filename, String diarizationHash, String diarizationStatus, String diarizationResult, String diarizationRawResponse)	Save or update diarization result
static void	saveResult(Connection con, AixFlowResult result)	Save or update n8n result

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

AixFlowResultDAO

public AixFlowResultDAO()

Method Details

createTable

public static void createTable(Connection con)
                        throws SQLException

Create table if not exists

Throws:

SQLException

saveDiarizationResult

public static void saveDiarizationResult(Connection con,
 String filename,
 String diarizationHash,
 String diarizationStatus,
 String diarizationResult,
 String diarizationRawResponse)
                                  throws SQLException

Save or update diarization result

Throws:

SQLException

saveResult

public static void saveResult(Connection con,
 AixFlowResult result)
                       throws SQLException

Save or update n8n result

Throws:

SQLException

getByHash

public static AixFlowResult getByHash(Connection con,
 String hash)
                               throws SQLException

Get result by hash

Throws:

SQLException

getByFilename

public static List<AixFlowResult> getByFilename(Connection con,
 String filename)
                                         throws SQLException

Get results by filename

Throws:

SQLException

getAll

public static List<AixFlowResult> getAll(Connection con)
                                  throws SQLException

Get all results

Throws:

SQLException

deleteByFilename

public static void deleteByFilename(Connection con,
 String filename)
                             throws SQLException

Delete results by filename

Throws:

SQLException