public Column(Column c)
{
obj = SetObject(c.obj);
nulltype = c.nulltype;
Style = c.Style;
flags = c.flags;
IsIdentity = c.IsIdentity;
ownerTable = c.ownerTable;
Name = c.Name;
// Value = c.Value;
//SetType = c.SetType;
if (c.fKey != null)
{
fKey = new ForeignKey(c.fKey);
}
Name_in_language = c.Name_in_language;
//Name_in_language = new ltext();
//int iCount = c.Name_in_language.sText.Length;
//for (int i = 0; i < iCount; i++)
//{
// Name_in_language.sText(i) = c.Name_in_language.sText(i);
//}
}
public ForeignKey(ForeignKey srcfKey)
{
ID_ForeignKey = srcfKey.ID_ForeignKey;
ReferenceTable = srcfKey.ReferenceTable;
brefTableID = srcfKey.brefTableID;
refInListOfTables = srcfKey.refInListOfTables;
if (srcfKey.refInListOfTables != null)
{
fTable = new SQLTable(srcfKey.refInListOfTables);
}
ReferenceTable_Column = srcfKey.ReferenceTable_Column;
}
public ForeignKey(ForeignKey srcfKey, SQLTable DBm_owner_Tabel,List<SQLTable> lTable)
{
ID_ForeignKey = srcfKey.ID_ForeignKey;
ReferenceTable = srcfKey.ReferenceTable;
brefTableID = srcfKey.brefTableID;
refInListOfTables = srcfKey.refInListOfTables;
if (srcfKey.refInListOfTables != null)
{
fTable = new SQLTable(srcfKey.refInListOfTables, DBm_owner_Tabel, lTable);
lTable.Add(fTable);
}
ReferenceTable_Column = srcfKey.ReferenceTable_Column;
}
public string GetColumnSQLiteDefinitionLine(DBTableControl dbTables, ref List<ForeignKey> m_Fkey, List<string> UniqueConstraintNameList, ref string sql_DBm, SQLTable DBm_owner_Table)
{
SQLTable refTable = null;
SQLTable new_ref_Table = null;
if (obj != null)
{
string columnName = StaticLib.Func.GetNameFromObjectType(obj);
this.Name = columnName;
string sBasicType = null;
// complex types
string strNull;
if (nulltype == nullTYPE.NOT_NULL)
{
strNull = " NOT NULL";
}
else
{
strNull = " NULL";
}
string strUNIQUE;
if ((this.flags & Flags.UNIQUE)!=0)
{
strUNIQUE = " UNIQUE ";
}
else
{
strUNIQUE = "";
}
if (obj.GetType() == typeof(ID))
{
ID ID = (ID)obj;
return Globals.LeftMargin + "'" + columnName + "' INTEGER PRIMARY KEY AUTOINCREMENT";
}
else if (dbTables.IsMyTable(out refTable, obj.GetType()))
{
if (DBtypesFunc.Is_DBm_Type(refTable.objTable))
{
if (DBm_owner_Table == null)
{
DBm_owner_Table = this.ownerTable;
}
new_ref_Table = new SQLTable(refTable, DBm_owner_Table, dbTables.items);
dbTables.items.Add(new_ref_Table);
string new_sql_DBm = new_ref_Table.SQLitecmd_CreateTable(dbTables, UniqueConstraintNameList, ref sql_DBm, DBm_owner_Table);
sql_DBm += new_sql_DBm;
refTable = new_ref_Table;
this.Name = refTable.TableName;
int iCount = this.Name_in_language.sText_Length;
for (int i = 0; i < iCount; i++)
{
this.Name_in_language.sText(i,refTable.lngTableName.sText(i) + ":" + this.Name_in_language.sText(i));
}
}
this.Name = this.Name + "_ID";
string str;
ForeignKey fk = new ForeignKey();
str = Globals.LeftMargin + AddForeignKeySQLite(ref m_Fkey, refTable, ref fk) + " INTEGER " + strNull + " REFERENCES " + refTable.TableName + "(ID)" + strUNIQUE;
fKey = fk;
return str;
}
else
{
sBasicType = DBTypes.DBtypesFunc.GetBasicTypeSQLite(obj) + strUNIQUE;
}
return Globals.LeftMargin + "'" + columnName + "' " + sBasicType + strNull + strUNIQUE;
}
else
{
return "!!!Object Is Null!!!";
}
}
public string GetColumnMySQLDefinitionLine(DBTableControl dbTables, ref List<ForeignKey> m_Fkey, List<string> UniqueConstraintNameList, ref string sql_DBm, SQLTable DBm_owner_Table)
{
SQLTable refTable = null;
SQLTable new_ref_Table = null;
if (obj != null)
{
string columnName = StaticLib.Func.GetNameFromObjectType(obj);
this.Name = columnName;
string sBasicType = null;
// complex types
string strNull;
if (nulltype == nullTYPE.NOT_NULL)
{
strNull = " NOT NULL";
}
else
{
strNull = " NULL";
}
if (obj.GetType() == typeof(ID))
{
ID ID = (ID)obj;
return Globals.LeftMargin + "`" + columnName + "` " + DBtypesFunc.GetBasicTypeMySQL(obj) +" unsigned NOT NULL AUTO_INCREMENT";
}
else if (dbTables.IsMyTable(out refTable, obj.GetType()))
{
if (DBtypesFunc.Is_DBm_Type(refTable.objTable))
{
if (DBm_owner_Table == null)
{
DBm_owner_Table = this.ownerTable;
}
new_ref_Table = new SQLTable(refTable, DBm_owner_Table, dbTables.items);
dbTables.items.Add(new_ref_Table);
string new_sql_DBm = new_ref_Table.MySQLcmd_CreateTable(dbTables, UniqueConstraintNameList, ref sql_DBm, DBm_owner_Table);
sql_DBm += new_sql_DBm;
refTable = new_ref_Table;
this.Name = refTable.TableName;
int iCount = this.Name_in_language.sText_Length;
for (int i = 0; i < iCount; i++)
{
this.Name_in_language.sText(i,refTable.lngTableName.sText(i) + "_" + this.Name_in_language.sText(i));
}
}
this.Name = this.Name + "_ID";
string str;
ForeignKey fk = new ForeignKey();
object obj_reftable_id = refTable.FindIdentityObject();
string sIdentityType;
if (obj_reftable_id != null)
{
sIdentityType = " " + DBtypesFunc.GetBasicTypeMySQL(obj_reftable_id) + " ";
}
else
{
sIdentityType = " [" + Globals.m_IdentityIndexTYPE + "]";
}
str = Globals.LeftMargin + AddForeignKeyMySQL(ref m_Fkey, refTable, ref fk) + " " + sIdentityType + " unsigned " + strNull;
fKey = fk;
return str;
}
else
{
sBasicType = DBTypes.DBtypesFunc.GetBasicTypeMySQL(obj);
}
return Globals.LeftMargin + "`" + columnName + "` " + sBasicType + strNull;
}
else
{
return "!!!Object Is Null!!!";
}
}
public string AddForeignKeySQLite(ref List<ForeignKey> m_Fkey, SQLTable fTbl, ref ForeignKey fk)
{
string columnName = this.Name; //Func.GetNameFromObjectType(obj);
fk.ID_ForeignKey = columnName;
Name = columnName;
fk.ReferenceTable = columnName;
fk.ReferenceTable_Column = "ID";
fk.refInListOfTables = fTbl;
m_Fkey.Add(fk);
return " " + fk.ID_ForeignKey + " ";
}
public Column(SQLTable owner,Object xObj, nullTYPE xType, Flags xflags, eStyle styl, ltext Name_in_lang)
{
Style = styl;
fKey = null;
obj = xObj;
nulltype = xType;
flags = xflags;
// int i = 0;
int iCount = Name_in_lang.sText_Length;
this.ownerTable = owner;
Name = StaticLib.Func.GetNameFromObjectType(obj);
if (obj.GetType() == typeof(ID))
{
IsIdentity = true;
}
Name_in_language = Name_in_lang;
//Name_in_language = new ltext();
//for (i = 0; i < iCount; i++)
//{
// Name_in_language.sText(i)=Name_in_lang.sText(i);
//}
}