public static CloudEnv GetDefaultEnv()
{
var list = select("select * from DBCONF order by updateDate desc");
if (list.Count <= 0)
{
return(CloudEnv.GetDefault());
}
return(CloudEnv.FromDict(list[0]));
}
public static void Save(CloudEnv env)
{
var id = env.dbType.ToString() + env.dbHost + env.dbPort + env.dbName;
var list = select("select * from DBCONF where id='" + id + "'");
var dict = env.ToDictionary();
dict.Add("id", id);
dict.Add("updateDate", DateTime.Now);
dict.Remove("envPath");
if (list.Count > 0)
{
var cond = new Dictionary <string, object>();
cond.Add("id", id);
db.Update("DBCONF", dict, cond);
}
else
{
db.Insert("DBCONF", dict);
}
}
public static CloudEnv GetEnvByHostAndDbType(String host, int dbtype, ref int index)
{
var list = select("select * from DBCONF where dbHost='" + host + "' and dbType='" + dbtype + "' order by updateDate desc");
if (list.Count <= 0 && index == 0)
{
return(null);
}
if (list.Count <= 0)
{
index++;
return(GetEnvByHostAndDbType(host, dbtype, ref index));
}
if (index >= list.Count)
{
index = 0;
var env = CloudEnv.FromDict(list[index]);
index = -1;
return(env);
}
return(CloudEnv.FromDict(list[index]));
}
public static void DeleteEnv(CloudEnv env)
{
var id = env.dbType.ToString() + env.dbHost + env.dbPort + env.dbName;
ExecuteNoneQuery("delete from DBCONF where id='" + id + "'");
}