• Home
• STELLAR
• Data
• API

C# Class STELLAR.Data.API

Mostra file Open project: cbinding/stellar

Public Methods

Method	Description
DBColumnSplit ( string dbName, string tableName, string columnName, string keyColumnName, char delimiter ) : int	New 04/07/11 - split field values containing nested delimiters into a new table (named as tableName_columnName_split)
DBColumns ( String dbName, String tableName ) : String[]	List the columns in a SQLITE database table
DBNames ( String path ) : String[]	List the SQLITE database names for a given directory path
DBRowCount ( String dbName, String tableName ) : int	Count the rows in a SQLITE database table
DBTables ( String dbName ) : String[]	List the tables in a SQLITE database
DT2DB ( String dbName, DataTable table, bool append ) : int
DT2Delimited ( DataTable table, String fileName, char delimiter ) : int	Write the contents of a DataTable to a delimited file
DT2STG ( DataTable table, String stgFileName, String outFileName ) : int	Convert a System.Data.DataTable using a StringTemplateGroup file
DT2STG ( DataTable table, String stgFileName, String outFileName, String optFileName ) : int
DT2XML ( DataTable table, String xmlFileName ) : int
Delimited2DB ( string dbName, string fileName ) : int
Delimited2DB ( string dbName, string fileName, bool hasHeader ) : int
Delimited2DB ( string dbName, string fileName, char delimiter ) : int
Delimited2DB ( string dbName, string fileName, char delimiter, bool hasHeader ) : int
Delimited2DB ( string dbName, string fileName, string tableName ) : int
Delimited2DB ( string dbName, string fileName, string tableName, bool hasHeader ) : int
Delimited2DB ( string dbName, string fileName, string tableName, bool hasHeader, bool append ) : int
Delimited2DB ( string dbName, string fileName, string tableName, char delimiter, bool hasHeader, bool append ) : int
Delimited2DT ( string fileName ) : DataTable
Delimited2DT ( string fileName, bool hasHeader ) : DataTable
Delimited2DT ( string fileName, bool hasHeader, int maxRows ) : DataTable
Delimited2DT ( string fileName, char delimiter ) : DataTable
Delimited2DT ( string fileName, char delimiter, bool hasHeader ) : DataTable
Delimited2DT ( string fileName, char delimiter, bool hasHeader, int maxRows ) : DataTable	Read a delimited data file to a DataTable
Delimited2DT ( string fileName, char delimiter, int maxRows ) : DataTable
Delimited2DT ( string fileName, int maxRows ) : DataTable
Delimited2RDF ( string fileName, string templateName ) : int
Delimited2RDF ( string fileName, string templateName, string rdfFileName ) : int
Delimited2RDF ( string fileName, string templateName, string rdfFileName, bool hasHeader ) : int
Delimited2RDF ( string fileName, string templateName, string rdfFileName, string namespaceURI ) : int
Delimited2RDF ( string fileName, string templateName, string rdfFileName, string namespaceURI, bool hasHeader ) : int
Delimited2RDF ( string fileName, string templateName, string rdfFileName, string namespaceURI, char delimiter, bool hasHeader ) : int
Delimited2STG ( string fileName, string stgFileName, string outFileName, char delimiter ) : int	Convert a delimited file using a StringTemplateGroup file
Delimited2STG ( string fileName, string stgFileName, string outFileName, string optFileName, bool hasHeader, char delimiter ) : int
Delimited2STG ( string fileName, string stgFileName, string outFileName, string optFileName, char delimiter ) : int
Delimited2XML ( string fileName ) : int
Delimited2XML ( string fileName, bool hasHeader ) : int
Delimited2XML ( string fileName, char delimiter ) : int
Delimited2XML ( string fileName, char delimiter, bool hasHeader ) : int
Delimited2XML ( string fileName, string xmlFileName ) : int
Delimited2XML ( string fileName, string xmlFileName, bool hasHeader ) : int
Delimited2XML ( string fileName, string xmlFileName, char delimiter ) : int
Delimited2XML ( string fileName, string xmlFileName, char delimiter, bool hasHeader ) : int
EscapeUnicode ( string input ) : string
SQL2DT ( string dbName, string sqlFileName ) : DataTable
SQL2Delimited ( string dbName, string sqlFileName ) : int
SQL2Delimited ( string dbName, string sqlFileName, char delimiter ) : int
SQL2Delimited ( string dbName, string sqlFileName, string outFileName ) : int
SQL2Delimited ( string dbName, string sqlFileName, string outFileName, char delimiter ) : int
SQL2RDF ( string dbName, string sqlFileName, string templateName ) : int
SQL2RDF ( string dbName, string sqlFileName, string templateName, string rdfFileName ) : int
SQL2RDF ( string dbName, string sqlFileName, string templateName, string rdfFileName, string namespaceURI ) : int
SQL2STG ( string dbName, string sqlFileName, string stgFileName, string outFileName ) : int	Run a SQL query against the specified database, convert the output using a StringTemplateGroup file
SQL2STG ( string dbName, string sqlFileName, string stgFileName, string outFileName, string optFileName ) : int
SQL2XML ( string dbName, string sqlFileName ) : int
SQL2XML ( string dbName, string sqlFileName, string xmlFileName ) : int
SQLExecute ( string dbName, string sqlFileName ) : int
XML2RDF ( string xmlFileName, string templateName ) : bool
XML2RDF ( string xmlFileName, string templateName, string rdfFileName ) : bool
XML2RDF ( string xmlFileName, string templateName, string rdfFileName, string namespaceURI ) : bool
templateNames ( ) : String[]	List possible template names (compiled within STELLAR.Xsl.dll)

Private Methods

Method	Description
getNextColumnName ( DataTable table ) : String	used in CSV2DT to generate next column name when no column header row exists
getValidColumnName ( String colName ) : String	used in CSV2DT to ensure table/column names are valid - punctuation and spaces replaced with underscores
getValidName ( String name ) : String
getValidTableName ( String tblName ) : String
trimQuotes ( String quotedString ) : String

Method Details