public override string TranslateFieldType(DbManager.FIELDTYPE index)
{
if (index == DbManager.FIELDTYPE.INTEGER)
{
return("int");
}
else if (index == DbManager.FIELDTYPE.DOUBLE)
{
return("float");
}
return(base.TranslateFieldType(index));
}
public override string TranslateFieldType(DbManager.FIELDTYPE index)
{
if (index == DbManager.FIELDTYPE.DATETIME)
{
return("DATE");
}
else if (index == DbManager.FIELDTYPE.VARCHAR_256)
{
return("VARCHAR(256)");
}
return(base.TranslateFieldType(index));
}
public override string ToString()
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("CREATE TABLE {0} (", DbMgr.FieldAlias(mTablename));
int counter = 0;
foreach (string fieldname in mFields.Keys)
{
if (counter == 0)
{
counter++;
}
else
{
sb.Append(", ");
}
if (mPrimaryKeys.ContainsKey(fieldname))
{
DbManager.FIELDTYPE fieldtype = mFields[fieldname];
if (fieldtype == DbManager.FIELDTYPE.INTEGER_INDEXED)
{
//INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT
sb.AppendFormat("{0} INT IDENTITY(1, 1) PRIMARY KEY CLUSTERED", mDbMgr.FieldAlias(fieldname));
}
else
{
string fieldtype_name = mDbMgr.TranslateFieldType(fieldtype);
sb.AppendFormat("{0} {1} PRIMARY KEY", mDbMgr.FieldAlias(fieldname), fieldtype_name);
}
}
else
{
if (mReferences.ContainsKey(fieldname))
{
sb.AppendFormat("{0} {1} REFERENCES {2}", mDbMgr.FieldAlias(fieldname), mFields[fieldname], mDbMgr.FieldAlias(mReferences[fieldname]));
}
else
{
sb.AppendFormat("{0} {1}", mDbMgr.FieldAlias(fieldname), mDbMgr.TranslateFieldType(mFields[fieldname]));
}
}
}
sb.Append(");");
return(sb.ToString());
}
public override string TranslateFieldType(DbManager.FIELDTYPE index)
{
if (index == DbManager.FIELDTYPE.DOUBLE)
{
//return "NUMBER";
return("FLOAT(49)");
//return "NUMBER(7,2)";
}
if (index == DbManager.FIELDTYPE.DATETIME)
{
return("DATE");
}
if (index == DbManager.FIELDTYPE.VARCHAR_256)
{
return("VARCHAR(256)");
}
return(base.TranslateFieldType(index));
}
public DbGenerateTableStatement WithField(string fieldname, DbManager.FIELDTYPE fieldtype)
{
mFields[fieldname] = fieldtype;
return(this);
}
