org.mmbase.module.database.support
Class MMPostgres42Node

java.lang.Object
  |
  +--org.mmbase.module.database.support.MMSQL92Node
        |
        +--org.mmbase.module.database.support.MMPostgres42Node

All Implemented Interfaces:

MMJdbc2NodeInterface

public class MMPostgres42Node

extends MMSQL92Node

implements MMJdbc2NodeInterface

MMPostgres42Node implements the MMJdbc2NodeInterface for mysql this is the class used to abstact the query's needed for mmbase for each database.

Version:

6 Mar 2000

Author:

Carlo E. Prelz

Fields inherited from class org.mmbase.module.database.support.MMSQL92Node

name

Constructor Summary

MMPostgres42Node()

Method Summary

boolean	create(MMObjectBuilder bul, java.lang.String tableName)
boolean	created(java.lang.String tableName) return the number of relation types in this mmbase and table
MMObjectNode	decodeDBnodeField(MMObjectNode node, java.lang.String fieldtype, java.lang.String fieldname, java.sql.ResultSet rs, int i)
MMObjectNode	decodeDBnodeField(MMObjectNode node, java.lang.String fieldtype, java.lang.String fieldname, java.sql.ResultSet rs, int i, java.lang.String prefix)
int	fielddefInsert(java.lang.String baseName, int oType, java.lang.String owner, MMObjectNode node) insert a new object, normally not used (only subtables are used)
int	getDBKey() Gives an unique number This method will work with multiple mmbases
java.lang.String	getDBText(java.sql.ResultSet rs, int idx) get text of a database blob
byte[]	getShortedByte(java.lang.String tableName, java.lang.String fieldname, int number) get byte of a database blob
java.lang.String	getShortedText(java.lang.String tableName, java.lang.String fieldname, int number) get text from blob
int	insertRootNode(MMObjectBuilder bul) Insert: This method inserts a new object, normally not used (only subtables are used) Only fields with DBState value = DBSTATE_PERSISTENT or DBSTATE_SYSTEM are inserted.
java.lang.String	parseFieldPart(java.lang.String fieldname, java.lang.String dbtype, java.lang.String part)
void	removeNode(MMObjectBuilder bul, MMObjectNode node) removeNode
void	setDBText(int i, java.sql.PreparedStatement stmt, java.lang.String body) set text array in database
int	size(java.lang.String tableName) return the number of relation types in this mmbase and table

Methods inherited from class org.mmbase.module.database.support.MMSQL92Node

addField, changeField, commit, convertXMLType, create_real, create, createObjectTable, decodeDBnodeField, decodeDBnodeField, drop_real, drop, getAllowedField, getConnection, getDBByte, getDBKeyOld, getDisallowedField, getMatchCREATE, getMMNodeSearch2SQL, getNumberString, getOTypeString, getOwnerString, getReverseHash, init, insert_real, insert, parseFieldPart, removeField, setDBByte, tableSizeProtection, updateTable

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.mmbase.module.database.support.MMJdbc2NodeInterface

addField, changeField, commit, create, createObjectTable, decodeDBnodeField, decodeDBnodeField, drop, getAllowedField, getConnection, getDBByte, getDisallowedField, getMMNodeSearch2SQL, getNumberString, getOTypeString, getOwnerString, init, insert, removeField, setDBByte, updateTable

Constructor Detail

MMPostgres42Node

public MMPostgres42Node()

Method Detail

create

public boolean create(MMObjectBuilder bul,
                      java.lang.String tableName)

decodeDBnodeField

public MMObjectNode decodeDBnodeField(MMObjectNode node,
                                      java.lang.String fieldtype,
                                      java.lang.String fieldname,
                                      java.sql.ResultSet rs,
                                      int i)

decodeDBnodeField

public MMObjectNode decodeDBnodeField(MMObjectNode node,
                                      java.lang.String fieldtype,
                                      java.lang.String fieldname,
                                      java.sql.ResultSet rs,
                                      int i,
                                      java.lang.String prefix)

parseFieldPart

public java.lang.String parseFieldPart(java.lang.String fieldname,
                                       java.lang.String dbtype,
                                       java.lang.String part)

getShortedText

public java.lang.String getShortedText(java.lang.String tableName,
                                       java.lang.String fieldname,
                                       int number)

get text from blob

Specified by:

getShortedText in interface MMJdbc2NodeInterface

Overrides:

getShortedText in class MMSQL92Node

getShortedByte

public byte[] getShortedByte(java.lang.String tableName,
                             java.lang.String fieldname,
                             int number)

get byte of a database blob

Specified by:

getShortedByte in interface MMJdbc2NodeInterface

Overrides:

getShortedByte in class MMSQL92Node

getDBText

public java.lang.String getDBText(java.sql.ResultSet rs,
                                  int idx)

get text of a database blob

Specified by:

getDBText in interface MMJdbc2NodeInterface

Overrides:

getDBText in class MMSQL92Node

insertRootNode

public int insertRootNode(MMObjectBuilder bul)

Insert: This method inserts a new object, normally not used (only subtables are used) Only fields with DBState value = DBSTATE_PERSISTENT or DBSTATE_SYSTEM are inserted. Fields with DBstate values = DBSTATE_VIRTUAL or any other value are skipped.

Parameters:

bul - The MMObjectBuilder.

owner - The nodes' owner.

node - The current node that's to be inserted.

Returns:

The DBKey number for this node, or -1 if an error occurs.

setDBText

public void setDBText(int i,
                      java.sql.PreparedStatement stmt,
                      java.lang.String body)

set text array in database

Overrides:

setDBText in class MMSQL92Node

removeNode

public void removeNode(MMObjectBuilder bul,
                       MMObjectNode node)

removeNode

Specified by:

removeNode in interface MMJdbc2NodeInterface

Overrides:

removeNode in class MMSQL92Node

getDBKey

public int getDBKey()

Description copied from class: MMSQL92Node

Gives an unique number This method will work with multiple mmbases

Specified by:

getDBKey in interface MMJdbc2NodeInterface

Overrides:

getDBKey in class MMSQL92Node

Following copied from class: org.mmbase.module.database.support.MMSQL92Node

Returns:

unique number

created

public boolean created(java.lang.String tableName)

return the number of relation types in this mmbase and table

Specified by:

created in interface MMJdbc2NodeInterface

Overrides:

created in class MMSQL92Node

Following copied from class: org.mmbase.module.database.support.MMSQL92Node

Returns:

true if table exists, false if table doesn't exists

size

public int size(java.lang.String tableName)

return the number of relation types in this mmbase and table

Overrides:

size in class MMSQL92Node

Following copied from class: org.mmbase.module.database.support.MMSQL92Node

Parameters:

tableName - the table that has to be counted

Returns:

the number of items the table has

fielddefInsert

public int fielddefInsert(java.lang.String baseName,
                          int oType,
                          java.lang.String owner,
                          MMObjectNode node)

insert a new object, normally not used (only subtables are used)