org.rcsb.openmms.meta
Class SqlWriter

java.lang.Object
  |
  +--org.rcsb.openmms.meta.TransVisitor
        |
        +--org.rcsb.openmms.meta.SqlWriter

All Implemented Interfaces:

TypeNamesSql

Direct Known Subclasses:

InitSqlWriter, InsertWriter, SelectWriter, TableWriter

public class SqlWriter

extends TransVisitor

implements TypeNamesSql

Common Base class for metamodel Visitors that generate SQL code

Version:

1.6

Author:

Douglas S. Greer

Field Summary

Fields inherited from class org.rcsb.openmms.meta.TransVisitor

indent

Fields inherited from interface org.rcsb.openmms.util.TypeNamesSql

bigBinaryType, bigTextType, CATEGORY_TABLE_CIF_ID_NAME, CATEGORY_TABLE_DESC_NAME, CATEGORY_TABLE_KEY_NAME, CATEGORY_TABLE_MAND_NAME, CATEGORY_TABLE_NAME, CATEGORY_TABLE_NEXT_RECORD_NAME, CATEGORY_TABLE_TABLE_NAME, dbTypeNames, ENTRY_CATS_CATEGORY_NAME, ENTRY_CATS_ENTRY_NAME, ENTRY_CATS_FIRST_KEY_NAME, ENTRY_CATS_LEN_NAME, ENTRY_CATS_TABLE_NAME, ENTRY_TABLE_DEP_DATE_NAME, ENTRY_TABLE_FLAG_BASE_NAME, ENTRY_TABLE_ID_NAME, ENTRY_TABLE_KEY_NAME, ENTRY_TABLE_LOAD_DATE_NAME, ENTRY_TABLE_LOAD_STATUS_NAME, ENTRY_TABLE_NAME, hugeTextType, IBM_DB2_FLAVOR, ITEM_TABLE_CAT_INDX_NAME, ITEM_TABLE_CIF_ID_NAME, ITEM_TABLE_COLUMN_NAME, ITEM_TABLE_DESC_NAME, ITEM_TABLE_KEY_NAME, ITEM_TABLE_MAND_NAME, ITEM_TABLE_NAME, KEY_ID_SUFFIX, largeTableQualifier, MICROSOFT_ACCESS_FLAVOR, MYSQL_FLAVOR, NUMBER_OF_FLAVORS, ORACLE_FLAVOR, SCHEMA_PREFIX, smallBinaryType, STD_DATE_TYPE, STD_KEY_TYPE, STD_LINE_TYPE, STD_NAME_TYPE, SYBASE_FLAVOR, SYSTEM_DATA_BANK_NAME, SYSTEM_MODEL_ID_NAME, SYSTEM_REVISION_NUMBER_NAME, SYSTEM_TABLE_NAME, SYSTEM_VERSION_NAME, TYPE_FIELD_LEN

Constructor Summary

SqlWriter(CifDictionary d, java.lang.String dir, java.lang.String oBase)

Method Summary

protected void	buffer(StringStruct sst, java.lang.String s)
protected void	buffer(StringStruct sst, java.lang.String s1, java.lang.String[] sa, java.lang.String s2)
java.lang.String	categoryNameToTableName(CategoryTrans ct)
java.lang.String	cifToSqlGetMethod(FieldTrans ft)
java.lang.String	cifToSqlSetMethod(FieldTrans ft)
java.lang.String	cifToSqlType(java.lang.String ct, int min)
java.lang.String	clearIllegalChars(java.lang.String s)
protected void	flush(StringStruct sst, boolean last)
java.lang.String	itemNameToAttributeName(FieldTrans ft)
java.lang.String	literal(java.lang.String s)
java.lang.String	padString(java.lang.String s)
java.lang.String	padString(java.lang.String s, int min)
protected void	writeIntro(StringStruct sst, java.lang.String desc)
protected void	writeSysSpecific(StringStruct sst)

Methods inherited from class org.rcsb.openmms.meta.TransVisitor

close, closeCategory, closeException, closeField, closeFile, closeGetListMethod, closeInterface, closeMatrix, closeMethod, closeModule, closeRoot, closeStructure, closeSubfield, closeValuetype, closeVector, createConstant, createDirective, createExceptionField, createList, createSequence, createTypeDef, open, openCategory, openException, openField, openFile, openGetListMethod, openInterface, openMatrix, openMethod, openModule, openRoot, openStructure, openSubfield, openValuetype, openVector, setIndentString, writeBuffer, writeCopyright, writeCopyright, writeStr, writeStr, writeStr, writeStr

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlWriter

public SqlWriter(CifDictionary d,
                 java.lang.String dir,
                 java.lang.String oBase)

Method Detail

writeIntro

protected void writeIntro(StringStruct sst,
                          java.lang.String desc)

writeSysSpecific

protected void writeSysSpecific(StringStruct sst)

categoryNameToTableName

public java.lang.String categoryNameToTableName(CategoryTrans ct)

itemNameToAttributeName

public java.lang.String itemNameToAttributeName(FieldTrans ft)

literal

public java.lang.String literal(java.lang.String s)

clearIllegalChars

public java.lang.String clearIllegalChars(java.lang.String s)

cifToSqlType

public java.lang.String cifToSqlType(java.lang.String ct,
                                     int min)
                              throws TransGenException

TransGenException

cifToSqlSetMethod

public java.lang.String cifToSqlSetMethod(FieldTrans ft)
                                   throws TransGenException

TransGenException

cifToSqlGetMethod

public java.lang.String cifToSqlGetMethod(FieldTrans ft)
                                   throws TransGenException

TransGenException

padString

public java.lang.String padString(java.lang.String s)

padString

public java.lang.String padString(java.lang.String s,
                                  int min)

buffer

protected void buffer(StringStruct sst,
                      java.lang.String s1,
                      java.lang.String[] sa,
                      java.lang.String s2)

buffer

protected void buffer(StringStruct sst,
                      java.lang.String s)

flush

protected void flush(StringStruct sst,
                     boolean last)