IDbType* MySqlDbAdapter::GetDbTypeByUniversalName(IDbType::UNIVERSAL_TYPE type)
{
IDbType* newType = NULL;
switch (type) {
case IDbType::dbtTYPE_INT:
newType = GetDbTypeByName(wxT("INT"));
break;
case IDbType::dbtTYPE_BOOLEAN:
newType = GetDbTypeByName(wxT("BOOL"));
break;
case IDbType::dbtTYPE_DATE_TIME:
newType = GetDbTypeByName(wxT("DATETIME"));
break;
case IDbType::dbtTYPE_DECIMAL:
newType = GetDbTypeByName(wxT("DECIMAL"));
break;
case IDbType::dbtTYPE_FLOAT:
newType = GetDbTypeByName(wxT("FLOAT"));
break;
case IDbType::dbtTYPE_TEXT:
newType = GetDbTypeByName(wxT("TEXT"));
break;
case IDbType::dbtTYPE_OTHER:
newType = GetDbTypeByName(wxT("BLOB"));
break;
}
return newType;
}
IDbType* PostgreSqlDbAdapter::GetDbTypeByUniversalName(IDbType::UNIVERSAL_TYPE type) {
IDbType* newType = NULL;
switch (type) {
case IDbType::dbtTYPE_INT:
newType = GetDbTypeByName(wxT("INTEGER"));
break;
case IDbType::dbtTYPE_BOOLEAN:
newType = GetDbTypeByName(wxT("BOOLEAN"));
break;
case IDbType::dbtTYPE_DATE_TIME:
newType = GetDbTypeByName(wxT("DATE"));
break;
case IDbType::dbtTYPE_DECIMAL:
newType = GetDbTypeByName(wxT("DECIMAL"));
break;
case IDbType::dbtTYPE_FLOAT:
newType = GetDbTypeByName(wxT("DOUBLE PRECISION"));
break;
case IDbType::dbtTYPE_TEXT:
newType = GetDbTypeByName(wxT("TEXT"));
break;
case IDbType::dbtTYPE_OTHER:
newType = GetDbTypeByName(wxT("BYTEA"));
break;
}
return newType;
}
