Python XLSSampleLoaderの例

コード例 #1

ファイル: sample_loader.py プロジェクト: ael-noblegas/pychron

class SampleLoaderTestCase(unittest.TestCase):

    # @classmethod
    # def setUpClass(cls):
    #
    def setUp(self):
        self.loader = XLSSampleLoader()
        self.db = db_factory()

    def test_load_samples1(self):
        path = os.path.join(fget_data_dir(), 'sample_import.xls')
        self.loader.do_loading(None,
                               self.db,
                               path,
                               dry=True,
                               use_progress=False,
                               quiet=True)

        dbsam = self.db.get_sample('foo-001')
        self.assertIsNone(dbsam)

    def test_load_samples2(self):
        path = os.path.join(fget_data_dir(), 'sample_import.xls')
        self.loader.do_loading(None,
                               self.db,
                               path,
                               dry=False,
                               use_progress=False,
                               quiet=True)

        dbsam = self.db.get_sample('moo-002')
        self.assertEqual(dbsam.name, 'moo-002')
        self.assertEqual(dbsam.project.name, 'moobar')
        self.assertEqual(dbsam.material.name, 'bat')

コード例 #2

class SampleLoaderTestCase(unittest.TestCase):

    # @classmethod
    # def setUpClass(cls):
    #
    def setUp(self):
        self.loader = XLSSampleLoader()
        self.db = db_factory()

    def test_load_samples1(self):
        path = os.path.join(fget_data_dir(), 'sample_import.xls')
        self.loader.do_loading(None, self.db, path, dry=True, use_progress=False, quiet=True)

        db=self.db
        with db.session_ctx():
            dbsam = db.get_sample('foo-001')
            self.assertIsNone(dbsam)
            # self.assertEqual(dbsam.name, 'foo-001')
            # self.assertEqual(dbsam.project.name, 'bar')
            # self.assertEqual(dbsam.material.name, 'bat')

    def test_load_samples2(self):
        path = os.path.join(fget_data_dir(), 'sample_import.xls')
        self.loader.do_loading(None, self.db, path, dry=False, use_progress=False, quiet=True)

        db=self.db
        with db.session_ctx():
            dbsam = db.get_sample('moo-002')
            self.assertEqual(dbsam.name, 'moo-002')
            self.assertEqual(dbsam.project.name, 'moobar')
            self.assertEqual(dbsam.material.name, 'bat')

コード例 #3

ファイル: task.py プロジェクト: NMGRL/pychron

    def import_sample_from_file(self):
        # path = self.open_file_dialog(default_directory=paths.root_dir,
        # wildcard='*.xls')
        path = '/Users/ross/Desktop/sample_import.xls'
        if path:
            from pychron.entry.loaders.xls_sample_loader import XLSSampleLoader

            sample_loader = XLSSampleLoader()
            sample_loader.do_loading(self.manager, self.manager.db, path)

            spnames = []
            if self.selected_projects:
                spnames = [ni.name for ni in self.selected_projects]

            self.load_projects(include_recent=False)

            if spnames:
                sel = [si for si in self.projects if si.name in spnames]
                self.selected_projects = sel

            self._load_associated_samples()

コード例 #4

ファイル: task.py プロジェクト: stephen-e-cox/pychron

    def import_sample_from_file(self):
        # path = self.open_file_dialog(default_directory=paths.root_dir,
        # wildcard='*.xls')
        path = '/Users/ross/Desktop/sample_import.xls'
        if path:
            from pychron.entry.loaders.xls_sample_loader import XLSSampleLoader

            sample_loader = XLSSampleLoader()
            sample_loader.do_loading(self.manager, self.manager.db, path)

            spnames = []
            if self.selected_projects:
                spnames = [ni.name for ni in self.selected_projects]

            self.load_projects(include_recent=False)

            if spnames:
                sel = [si for si in self.projects if si.name in spnames]
                self.selected_projects = sel

            self._load_associated_samples()

コード例 #5

 def setUp(self):
     self.loader = XLSSampleLoader()
     self.db = db_factory()

コード例 #6

 def setUp(self):
     self.loader = XLSSampleLoader()
     self.db = db_factory()