Ejemplo n.º 1
0
        public static bool Import(string connectionString, string filename, string username)
        {
            var context = new UserStorageContext(connectionString);
            var user = context.Users.
                Include("ItemTypes.Fields").
                Include("Tags").
                FirstOrDefault(u => u.Name == username);
            if (user == null)
            {
                Console.WriteLine(String.Format("Import: user {0} not found", username));
                return false;
            }

            // get the folders
            List<Folder> folders = context.Folders.
                Include("FolderUsers").
                Include("Items.ItemTags").
                Include("Items.FieldValues").
                Where(f => f.UserID == user.ID && f.ItemTypeID != SystemItemTypes.System).
                ToList();

            var userDataModel = new UserDataModel(context, user);
            try
            {
                User jsonUser = null;
                filename = filename ?? @"userdata.json";

                // read the file and deserialize the data into a User class
                using (var stream = System.IO.File.Open(filename, FileMode.Open, FileAccess.Read))
                using (var reader = new StreamReader(stream))
                {
                    var json = reader.ReadToEnd();
                    jsonUser = JsonSerializer.Deserialize<User>(json);
                }

                // reorder the folders by item type ID - this is to get locations before contacts before tasks
                // this heuristic relies on that order so that a task's location and contact references will be live in the DB before the task is imported
                // likewise, it needs the locations to be live in the DB before a contact (which may point to a location) is imported
                var jsonFolders = new List<Folder>();
                foreach (var jsonFolder in jsonUser.Folders.Where(f => f.ItemTypeID == SystemItemTypes.Location))
                    jsonFolders.Add(jsonFolder);
                foreach (var jsonFolder in jsonUser.Folders.Where(f => f.ItemTypeID == SystemItemTypes.Contact))
                    jsonFolders.Add(jsonFolder);
                foreach (var jsonFolder in jsonUser.Folders.Where(f => f.ItemTypeID == SystemItemTypes.Grocery))
                    jsonFolders.Add(jsonFolder);
                foreach (var jsonFolder in jsonUser.Folders.Where(f => f.ItemTypeID == SystemItemTypes.ListItem))
                    jsonFolders.Add(jsonFolder);
                foreach (var jsonFolder in jsonUser.Folders.Where(f => f.ItemTypeID == SystemItemTypes.Task))
                    jsonFolders.Add(jsonFolder);
                foreach (var jsonFolder in jsonUser.Folders.Where(f => f.ItemTypeID == SystemItemTypes.Appointment))
                    jsonFolders.Add(jsonFolder);

                // process the serialized user folders
                foreach (var jsonFolder in jsonFolders)
                {
                    // skip the $PhoneClient folder (currently import does not support merging $PhoneClient)
                    // the difficulty is in merge semantics for individual items which have substructure (like PhoneSettings),
                    // as well as ListMetadata for lists/folders that have the same names, but different ID's, from the lists in the DB
                    //   (e.g. Tasks, Groceries)
                    if (jsonFolder.Name == SystemEntities.PhoneClient ||
                        jsonFolder.Name == SystemEntities.Client ||
                        jsonFolder.Name == SystemEntities.WebClient)
                        continue;

                    // reset some of the fields in the serialized structure to the database values
                    jsonFolder.UserID = user.ID;

                    // find the folder by name
                    var folder = folders.FirstOrDefault(f => f.Name == jsonFolder.Name);
                    if (folder == null)
                    {
                        // folder not found - add it (including all its children) using a new ID (in case the old one still exists in the DB)
                        jsonFolder.ID = Guid.NewGuid();
                        folder = context.Folders.Add(jsonFolder);
                        context.SaveChanges();
                        Console.WriteLine("Added folder " + folder.Name);
                    }
                    else
                    {
                        // folder found - don't add it, but process all the children and add as appropriate to the found folder
                        Console.WriteLine("Found folder " + folder.Name);
                        var rootChildren = jsonFolder.Items.Where(i => i.ParentID == null).ToList();
                        ImportItems(context, folder, jsonFolder, rootChildren, null, 1);
                    }
                }
                context.SaveChanges();
                Console.WriteLine();
            }
            catch (Exception ex)
            {
                Console.WriteLine("DataImporter: import failed; ex: ", ex.Message);
                return false;
            }
            return true;
        }
Ejemplo n.º 2
0
        public static bool Import(string connectionString, string filename, string username)
        {
            var context = new UserStorageContext(connectionString);
            var user    = context.Users.
                          Include("ItemTypes.Fields").
                          Include("Tags").
                          FirstOrDefault(u => u.Name == username);

            if (user == null)
            {
                Console.WriteLine(String.Format("Import: user {0} not found", username));
                return(false);
            }

            // get the folders
            List <Folder> folders = context.Folders.
                                    Include("FolderUsers").
                                    Include("Items.ItemTags").
                                    Include("Items.FieldValues").
                                    Where(f => f.UserID == user.ID && f.ItemTypeID != SystemItemTypes.System).
                                    ToList();

            var userDataModel = new UserDataModel(context, user);

            try
            {
                User jsonUser = null;
                filename = filename ?? @"userdata.json";

                // read the file and deserialize the data into a User class
                using (var stream = System.IO.File.Open(filename, FileMode.Open, FileAccess.Read))
                    using (var reader = new StreamReader(stream))
                    {
                        var json = reader.ReadToEnd();
                        jsonUser = JsonSerializer.Deserialize <User>(json);
                    }

                // reorder the folders by item type ID - this is to get locations before contacts before tasks
                // this heuristic relies on that order so that a task's location and contact references will be live in the DB before the task is imported
                // likewise, it needs the locations to be live in the DB before a contact (which may point to a location) is imported
                var jsonFolders = new List <Folder>();
                foreach (var jsonFolder in jsonUser.Folders.Where(f => f.ItemTypeID == SystemItemTypes.Location))
                {
                    jsonFolders.Add(jsonFolder);
                }
                foreach (var jsonFolder in jsonUser.Folders.Where(f => f.ItemTypeID == SystemItemTypes.Contact))
                {
                    jsonFolders.Add(jsonFolder);
                }
                foreach (var jsonFolder in jsonUser.Folders.Where(f => f.ItemTypeID == SystemItemTypes.Grocery))
                {
                    jsonFolders.Add(jsonFolder);
                }
                foreach (var jsonFolder in jsonUser.Folders.Where(f => f.ItemTypeID == SystemItemTypes.ListItem))
                {
                    jsonFolders.Add(jsonFolder);
                }
                foreach (var jsonFolder in jsonUser.Folders.Where(f => f.ItemTypeID == SystemItemTypes.Task))
                {
                    jsonFolders.Add(jsonFolder);
                }
                foreach (var jsonFolder in jsonUser.Folders.Where(f => f.ItemTypeID == SystemItemTypes.Appointment))
                {
                    jsonFolders.Add(jsonFolder);
                }

                // process the serialized user folders
                foreach (var jsonFolder in jsonFolders)
                {
                    // skip the $PhoneClient folder (currently import does not support merging $PhoneClient)
                    // the difficulty is in merge semantics for individual items which have substructure (like PhoneSettings),
                    // as well as ListMetadata for lists/folders that have the same names, but different ID's, from the lists in the DB
                    //   (e.g. Tasks, Groceries)
                    if (jsonFolder.Name == SystemEntities.PhoneClient ||
                        jsonFolder.Name == SystemEntities.Client ||
                        jsonFolder.Name == SystemEntities.WebClient)
                    {
                        continue;
                    }

                    // reset some of the fields in the serialized structure to the database values
                    jsonFolder.UserID = user.ID;

                    // find the folder by name
                    var folder = folders.FirstOrDefault(f => f.Name == jsonFolder.Name);
                    if (folder == null)
                    {
                        // folder not found - add it (including all its children) using a new ID (in case the old one still exists in the DB)
                        jsonFolder.ID = Guid.NewGuid();
                        folder        = context.Folders.Add(jsonFolder);
                        context.SaveChanges();
                        Console.WriteLine("Added folder " + folder.Name);
                    }
                    else
                    {
                        // folder found - don't add it, but process all the children and add as appropriate to the found folder
                        Console.WriteLine("Found folder " + folder.Name);
                        var rootChildren = jsonFolder.Items.Where(i => i.ParentID == null).ToList();
                        ImportItems(context, folder, jsonFolder, rootChildren, null, 1);
                    }
                }
                context.SaveChanges();
                Console.WriteLine();
            }
            catch (Exception ex)
            {
                Console.WriteLine("DataImporter: import failed; ex: ", ex.Message);
                return(false);
            }
            return(true);
        }