Class CsvTorgDataSource

java.lang.Object

neqsim.process.mechanicaldesign.torg.CsvTorgDataSource

All Implemented Interfaces:

TorgDataSource

public class CsvTorgDataSource
extends Object
implements TorgDataSource

CSV-based data source for loading Technical Requirements Documents (TORG).

This implementation supports two CSV file formats:

Format 1: Standards-focused (standards.csv)

PROJECT_ID,PROJECT_NAME,COMPANY,DESIGN_CATEGORY,STANDARD_CODE,VERSION,PRIORITY
PROJ-001,Offshore Platform,Equinor,pressure vessel design code,ASME-VIII-Div1,2021,1
PROJ-001,Offshore Platform,Equinor,separator process design,API-12J,8th Ed,1
PROJ-001,Offshore Platform,Equinor,pipeline design codes,NORSOK-L-001,Rev 6,1

Format 2: Full TORG (torg_master.csv)

PROJECT_ID,PROJECT_NAME,COMPANY,REVISION,ISSUE_DATE,MIN_AMBIENT_TEMP,MAX_AMBIENT_TEMP,...
PROJ-001,Offshore Platform,Equinor,2,-40,45,...

When using Format 1, the data source automatically combines rows with the same PROJECT_ID into a single TechnicalRequirementsDocument.

Version:

1.0

Author:

esol

Field Summary

Fields

Modifier and Type	Field	Description
private Map<String, TechnicalRequirementsDocument>	cache
private static final String	COL_COMPANY
private static final String	COL_CORROSION_ALLOWANCE
private static final String	COL_DESIGN_CATEGORY
private static final String	COL_ISSUE_DATE
private static final String	COL_MAX_AMBIENT_TEMP
private static final String	COL_MIN_AMBIENT_TEMP
private static final String	COL_PIPE_MATERIAL
private static final String	COL_PLATE_MATERIAL
private static final String	COL_PRESSURE_SF
private static final String	COL_PROJECT_ID	CSV column names for standards format.
private static final String	COL_PROJECT_NAME
private static final String	COL_REVISION
private static final String	COL_SEAWATER_TEMP
private static final String	COL_SEISMIC_ZONE
private static final String	COL_STANDARD_CODE
private static final String	COL_VERSION
private final Path	csvPath
private boolean	isLoaded
private static final org.apache.logging.log4j.Logger	logger

Constructor Summary

Constructors

Constructor	Description
CsvTorgDataSource(Path csvPath)	Create a CsvTorgDataSource from a file path.

Method Summary

Modifier and Type	Method	Description
static CsvTorgDataSource	fromResource(String resourcePath)	Create a CsvTorgDataSource from a classpath resource.
List<String>	getAvailableCompanies()	Get a list of available companies.
List<String>	getAvailableProjectIds()	Get a list of available project identifiers.
private String	getField(String[] values, Map<String,Integer> headerIndex, String column)
private String	getFieldOrDefault(String[] values, Map<String,Integer> headerIndex, String column, String defaultValue)
protected BufferedReader	getReader()	Get a BufferedReader for the CSV data.
Optional<TechnicalRequirementsDocument>	loadByCompanyAndProject(String companyIdentifier, String projectName)	Load a TORG document by company and project name.
Optional<TechnicalRequirementsDocument>	loadByProjectId(String projectId)	Load a TORG document by project identifier.
private void	loadData()	Load and parse the CSV file.
private void	loadMasterFormat(BufferedReader reader, Map<String,Integer> headerIndex)	Load master format where each row is a complete TORG (less common).
private void	loadStandardsFormat(BufferedReader reader, Map<String,Integer> headerIndex)	Load standards-focused CSV format where each row is a standard assignment.
private String[]	parseCSVLine(String line)
private double	parseDouble(String value, double defaultValue)

Methods inherited from class Object

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

Methods inherited from interface TorgDataSource

hasProject, isWritable, store, update

Field Details

logger

private static final org.apache.logging.log4j.Logger logger

COL_PROJECT_ID

private static final String COL_PROJECT_ID

CSV column names for standards format.

See Also:

• Constant Field Values

COL_PROJECT_NAME

private static final String COL_PROJECT_NAME

See Also:

• Constant Field Values

COL_COMPANY

private static final String COL_COMPANY

See Also:

• Constant Field Values

COL_REVISION

private static final String COL_REVISION

See Also:

• Constant Field Values

COL_ISSUE_DATE

private static final String COL_ISSUE_DATE

See Also:

• Constant Field Values

COL_DESIGN_CATEGORY

private static final String COL_DESIGN_CATEGORY

See Also:

• Constant Field Values

COL_STANDARD_CODE

private static final String COL_STANDARD_CODE

See Also:

• Constant Field Values

COL_VERSION

private static final String COL_VERSION

See Also:

• Constant Field Values

COL_MIN_AMBIENT_TEMP

private static final String COL_MIN_AMBIENT_TEMP

See Also:

• Constant Field Values

COL_MAX_AMBIENT_TEMP

private static final String COL_MAX_AMBIENT_TEMP

See Also:

• Constant Field Values

COL_SEAWATER_TEMP

private static final String COL_SEAWATER_TEMP

See Also:

• Constant Field Values

COL_SEISMIC_ZONE

private static final String COL_SEISMIC_ZONE

See Also:

• Constant Field Values

COL_CORROSION_ALLOWANCE

private static final String COL_CORROSION_ALLOWANCE

See Also:

• Constant Field Values

COL_PRESSURE_SF

private static final String COL_PRESSURE_SF

See Also:

• Constant Field Values

COL_PLATE_MATERIAL

private static final String COL_PLATE_MATERIAL

See Also:

• Constant Field Values

COL_PIPE_MATERIAL

private static final String COL_PIPE_MATERIAL

See Also:

• Constant Field Values

csvPath

private final Path csvPath

cache

private Map<String, TechnicalRequirementsDocument> cache

isLoaded

private boolean isLoaded

Constructor Details

CsvTorgDataSource

public CsvTorgDataSource(Path csvPath)

Create a CsvTorgDataSource from a file path.

Parameters:

csvPath - path to the CSV file

Method Details

fromResource

public static CsvTorgDataSource fromResource(String resourcePath)

Create a CsvTorgDataSource from a classpath resource.

Parameters:

resourcePath - path relative to classpath (e.g., "designdata/torg/projects.csv")

Returns:

new data source instance

getReader

protected BufferedReader getReader()
                            throws IOException

Get a BufferedReader for the CSV data.

Returns:

reader for CSV content

Throws:

IOException - if the file cannot be read

loadData

private void loadData()

Load and parse the CSV file.

loadStandardsFormat

private void loadStandardsFormat(BufferedReader reader,
 Map<String,Integer> headerIndex)
                          throws IOException

Load standards-focused CSV format where each row is a standard assignment.

Throws:

IOException

loadMasterFormat

private void loadMasterFormat(BufferedReader reader,
 Map<String,Integer> headerIndex)
                       throws IOException

Load master format where each row is a complete TORG (less common).

Throws:

IOException

loadByProjectId

public Optional<TechnicalRequirementsDocument> loadByProjectId(String projectId)

Description copied from interface: TorgDataSource

Load a TORG document by project identifier.

Specified by:

loadByProjectId in interface TorgDataSource

Parameters:

projectId - the project identifier

Returns:

optional containing the TORG if found

loadByCompanyAndProject

public Optional<TechnicalRequirementsDocument> loadByCompanyAndProject(String companyIdentifier,
 String projectName)

Description copied from interface: TorgDataSource

Load a TORG document by company and project name.

Specified by:

loadByCompanyAndProject in interface TorgDataSource

Parameters:

companyIdentifier - the company identifier

projectName - the project name

Returns:

optional containing the TORG if found

getAvailableProjectIds

public List<String> getAvailableProjectIds()

Description copied from interface: TorgDataSource

Get a list of available project identifiers.

Specified by:

getAvailableProjectIds in interface TorgDataSource

Returns:

list of project IDs available in this data source

getAvailableCompanies

public List<String> getAvailableCompanies()

Description copied from interface: TorgDataSource

Get a list of available companies.

Specified by:

getAvailableCompanies in interface TorgDataSource

Returns:

list of company identifiers

parseCSVLine

private String[] parseCSVLine(String line)

getField

private String getField(String[] values,
 Map<String,Integer> headerIndex,
 String column)

getFieldOrDefault

private String getFieldOrDefault(String[] values,
 Map<String,Integer> headerIndex,
 String column,
 String defaultValue)

parseDouble

private double parseDouble(String value,
 double defaultValue)