class: Table

public class: Table
Author:
Project: Phase: 1.0; Status: Proposed; Version: 1.0; Complexity: 1
Dates: Created: 6.12.2005 14:43:34; Modified: 6.12.2005 14:47:57;
Flags: Active: false; IsRoot: false; IsLeaf: false;
Extension Points:
UUID: {6A67C99D-5641-45fe-948E-0054902D2130}
Information about one table in specific database.

 

Goto: Fields, Methods

See also: ColumnsInfo, ColumnsInfo, DBDataAdmin, DatabaseInfo, TableInstance

Appears in: Tables

Connections
 
Table Attributes
Attribute Details
private string
  tableName
Notes: Name of table

private int
  whichDb
Notes: Id to connection

private string
  shortDescr
Notes: Short description

private DBDataAdmin
  dbAdmin
Notes: DB Admin

private ColumnsInfo
  colsInfo
Notes: Columns info

private bool
  updatable
Notes: If add/remove column is permitted.

private DatabaseInfo
  dbInfo
 
Table Methods
Operation Details
public
Table(
   DBDataAdmin dbAdmin,
   string tableName,
   int whichDb,
   string shortDescr):
Notes: Constructor - fill all parameters.
public
Table(
   DBDataAdmin dbAdmin,
   string tableName,
   int whichDb):
Notes: Constructor.

@param ="whichDB" ID determining connection to DB
public
CopyTable(
   Table tableTo):bool
Notes: Copy from table to other table.

@param ="tableFrom" table from
public
ToString():string
Tags: override=true
Notes: Override ToString()

@returns Table name and description of connection
public
ConvertColumnTypeTo(
   string columnName,
   string simpleTypeTo):bool
Notes: Convert column to other type
public
FindNewTableName():bool
Notes: Find new tmp_ table name in work database

@returns table name
private
GetRandomTableName():string
Notes: returns random name with prefix "tmp_"

@returns random table name with prefix "tmp_"
public
TableName():string
<<property>>
Notes: Table name property
public
WhichDb():int
<<property>>
Notes: ID specific connection to DB
public
Drop():bool
Notes: Delete table if session is marked as Delete all

@returns
public
Exists():bool
public
UpdateColsInfo():bool
Notes: Read informations about columns

@returns
public
InsertValues(
   OdbcCommand myComm):bool
public
ColsInfo():ColumnsInfo
<<property>>
Notes: Informations about columns
public
AddColumn(
   ColumnInfo ci):ColumnInfo
Notes: Add column to table

@returns
public
RemoveColumn(
   ColumnInfo ci):bool
Notes: Remove column from table

@returns
public
CreateTable(
   ColumnsInfo ci):bool
Notes: Create table according columns info

@returns true if succeed
public
Updatable():bool
<<property>>
public
DBInfo():DatabaseInfo
<<property>>