public capex.data.SQLTableInfo addColumn(capex.data.SQLTableColumnInfo info)
{
if (info == null)
{
return(this);
}
if (columns == null)
{
columns = new System.Collections.Generic.List <capex.data.SQLTableColumnInfo>();
}
columns.Add(info);
return(this);
}
public virtual string columnToCreateString(capex.data.SQLTableColumnInfo cc)
{
var sb = new cape.StringBuilder();
sb.append(cc.getName());
sb.append(' ');
var tt = cc.getType();
if (tt == capex.data.SQLTableColumnInfo.TYPE_INTEGER_KEY)
{
sb.append("INTEGER PRIMARY KEY AUTOINCREMENT");
}
else if (tt == capex.data.SQLTableColumnInfo.TYPE_LONG_KEY)
{
sb.append("BIGINT PRIMARY KEY AUTOINCREMENT");
}
else if (tt == capex.data.SQLTableColumnInfo.TYPE_STRING_KEY)
{
sb.append("TEXT PRIMARY KEY");
}
else if (tt == capex.data.SQLTableColumnInfo.TYPE_INTEGER)
{
sb.append("INTEGER");
}
else if (tt == capex.data.SQLTableColumnInfo.TYPE_LONG)
{
sb.append("BIGINT");
}
else if (tt == capex.data.SQLTableColumnInfo.TYPE_STRING)
{
sb.append("VARCHAR(255)");
}
else if (tt == capex.data.SQLTableColumnInfo.TYPE_TEXT)
{
sb.append("TEXT");
}
else if (tt == capex.data.SQLTableColumnInfo.TYPE_BLOB)
{
sb.append("BLOB");
}
else if (tt == capex.data.SQLTableColumnInfo.TYPE_DOUBLE)
{
sb.append("REAL");
}
else
{
cape.Log.error(getLogger(), "Unknown column type: " + cape.String.forInteger(tt));
sb.append("UNKNOWN");
}
return(sb.toString());
}
