private void GetData(Photo photo)
{
SqliteDataReader reader = Database.Query(new DbCommand("SELECT tag_id, version_id, name "
+ "FROM photo_tags, photo_versions "
+ "WHERE photo_tags.photo_id = photo_versions.photo_id "
+ "AND photo_tags.photo_id = :id", "id", photo.Id));
while (reader.Read())
{
if (reader [0] != null)
{
uint tag_id = Convert.ToUInt32(reader [0]);
Tag tag = Core.Database.Tags.Get(tag_id) as Tag;
photo.AddTagUnsafely(tag);
}
if (reader [1] != null)
{
uint version_id = Convert.ToUInt32(reader [1]);
string name = reader[2].ToString();
photo.AddVersionUnsafely(version_id, name);
}
}
reader.Close();
}
private void GetVersions(Photo photo)
{
SqliteDataReader reader = Database.Query(
new DbCommand("SELECT version_id, name, uri, md5_sum, protected " +
"FROM photo_versions " +
"WHERE photo_id = :id",
"id", photo.Id
)
);
while (reader.Read())
{
uint version_id = Convert.ToUInt32(reader [0]);
string name = reader[1].ToString();
#if MONO_2_0
System.Uri uri = new System.Uri(reader[2].ToString());
#else
System.Uri uri = new System.Uri(reader[2].ToString(), true);
#endif
string md5_sum = reader[3].ToString();
bool is_protected = Convert.ToBoolean(reader[4]);
photo.AddVersionUnsafely(version_id, uri, md5_sum, name, is_protected);
}
reader.Close();
}
private void GetVersions(Photo photo)
{
SqliteDataReader reader = Database.Query(new DbCommand("SELECT version_id, name FROM photo_versions WHERE photo_id = :id", photo.Id));
while (reader.Read())
{
uint version_id = Convert.ToUInt32(reader [0]);
string name = reader[1].ToString();
photo.AddVersionUnsafely(version_id, name);
}
reader.Close();
}
private void GetAllVersions()
{
SqliteDataReader reader = Database.Query("SELECT photo_id, version_id, name, uri, md5_sum, protected FROM photo_versions");
while (reader.Read())
{
uint id = Convert.ToUInt32(reader [0]);
Photo photo = LookupInCache(id) as Photo;
if (photo == null)
{
//Console.WriteLine ("Photo {0} not found", id);
continue;
}
if (photo.Loaded)
{
//Console.WriteLine ("Photo {0} already Loaded", photo);
continue;
}
if (reader [1] != null)
{
uint version_id = Convert.ToUInt32(reader [1]);
string name = reader[2].ToString();
#if MONO_2_0
System.Uri uri = new System.Uri(reader[3].ToString());
#else
System.Uri uri = new System.Uri(reader[3].ToString(), true);
#endif
string md5_sum = reader[4].ToString();
bool is_protected = Convert.ToBoolean(reader[5]);
photo.AddVersionUnsafely(version_id, uri, md5_sum, name, is_protected);
}
/*
* string directory_path = null;
* if (reader [3] != null)
* directory_path = reader [3].ToString ();
* System.Console.WriteLine ("directory_path = {0}", directory_path);
*/
}
reader.Close();
}
private void GetAllData()
{
SqliteDataReader reader = Database.Query("SELECT photo_tags.photo_id, tag_id, version_id, name "
+ "FROM photo_tags, photo_versions "
+ "WHERE photo_tags.photo_id = photo_versions.photo_id");
while (reader.Read())
{
uint id = Convert.ToUInt32(reader [0]);
Photo photo = LookupInCache(id) as Photo;
if (photo == null)
{
//Console.WriteLine ("Photo {0} not found", id);
continue;
}
if (photo.Loaded)
{
//Console.WriteLine ("Photo {0} already Loaded", photo);
continue;
}
if (reader [1] != null)
{
uint tag_id = Convert.ToUInt32(reader [1]);
Tag tag = Core.Database.Tags.Get(tag_id) as Tag;
photo.AddTagUnsafely(tag);
}
if (reader [2] != null)
{
uint version_id = Convert.ToUInt32(reader [2]);
string name = reader[3].ToString();
photo.AddVersionUnsafely(version_id, name);
}
}
reader.Close();
}
private void GetAllVersions()
{
SqliteDataReader reader = Database.Query("SELECT photo_id, version_id, name FROM photo_versions");
while (reader.Read())
{
uint id = Convert.ToUInt32(reader [0]);
Photo photo = LookupInCache(id) as Photo;
if (photo == null)
{
//Console.WriteLine ("Photo {0} not found", id);
continue;
}
if (photo.Loaded)
{
//Console.WriteLine ("Photo {0} already Loaded", photo);
continue;
}
if (reader [1] != null)
{
uint version_id = Convert.ToUInt32(reader [1]);
string name = reader[2].ToString();
photo.AddVersionUnsafely(version_id, name);
}
/*
* string directory_path = null;
* if (reader [3] != null)
* directory_path = reader [3].ToString ();
* System.Console.WriteLine ("directory_path = {0}", directory_path);
*/
}
reader.Close();
}
private void GetVersions (Photo photo)
{
SqliteDataReader reader = Database.Query(
new DbCommand("SELECT version_id, name, uri, md5_sum, protected " +
"FROM photo_versions " +
"WHERE photo_id = :id",
"id", photo.Id
)
);
while (reader.Read ()) {
uint version_id = Convert.ToUInt32 (reader [0]);
string name = reader[1].ToString ();
#if MONO_2_0
System.Uri uri = new System.Uri (reader[2].ToString ());
#else
System.Uri uri = new System.Uri (reader[2].ToString (), true);
#endif
string md5_sum = reader[3].ToString ();
bool is_protected = Convert.ToBoolean (reader[4]);
photo.AddVersionUnsafely (version_id, uri, md5_sum, name, is_protected);
}
reader.Close();
}
private void GetData (Photo photo)
{
SqliteDataReader reader = Database.Query(new DbCommand("SELECT tag_id, version_id, name "
+ "FROM photo_tags, photo_versions "
+ "WHERE photo_tags.photo_id = photo_versions.photo_id "
+ "AND photo_tags.photo_id = :id", "id", photo.Id));
while (reader.Read ()) {
if (reader [0] != null) {
uint tag_id = Convert.ToUInt32 (reader [0]);
Tag tag = Core.Database.Tags.Get (tag_id) as Tag;
photo.AddTagUnsafely (tag);
}
if (reader [1] != null) {
uint version_id = Convert.ToUInt32 (reader [1]);
string name = reader[2].ToString ();
photo.AddVersionUnsafely (version_id, name);
}
}
reader.Close();
}
private void GetVersions (Photo photo)
{
SqliteDataReader reader = Database.Query(new DbCommand("SELECT version_id, name FROM photo_versions WHERE photo_id = :id", photo.Id));
while (reader.Read ()) {
uint version_id = Convert.ToUInt32 (reader [0]);
string name = reader[1].ToString ();
photo.AddVersionUnsafely (version_id, name);
}
reader.Close();
}
