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); }