from labkey.utils import create_server_context
from labkey.query import select_rows, QueryFilter

print("Create a server context")
server_context = create_server_context('idri.labkey.com', 'Formulations')

ssr = select_rows(server_context, 'Samples', 'Formulations')
print("select_rows: There are " + str(len(ssr['rows'])) + " rows.")

ssr = select_rows(server_context, 'Samples', 'Formulations', filter_array=[
    QueryFilter('Batch', 'QF', filter_type=QueryFilter.Types.CONTAINS)
])
print("select_rows: There are " + str(len(ssr['rows'])) + " filtered rows.")
        # validate call is made as expected
        expected_args = expected_kwargs.pop('expected_args')
        mock_post.assert_called_once_with(*expected_args, **expected_kwargs)


configs = {
    'protocol': 'https://'
    , 'server': 'my_testServer:8080'
    , 'context_path': 'testPath'
    , 'project_path': 'testProject/subfolder'
}

schema = 'testSchema'
query = 'testQuery'
server_context = create_server_context(configs['server'], configs['project_path'], configs['context_path'])


class TestDeleteRows(unittest.TestCase):

    def setUp(self):
        self.configs = configs.copy()
        self.service = MockDeleteRows(**self.configs)
        self.expected_kwargs = {
            'expected_args': [self.service.get_server_url()]
            , 'data': '{"queryName": "' + query + '", "rows": "{id:1234}", "schemaName": "' + schema + '"}'
            , 'headers': {u'Content-Type': u'application/json'}
            , 'timeout': 30
        }

        rows = '{id:1234}'
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
# Sample to get a batch

from labkey.utils import create_server_context
from labkey.experiment import load_batch

print("Create a server context")
project_name = 'ModuleAssayTest'  # Project folder name
server_context = create_server_context('localhost:8080', project_name, 'labkey', use_ssl=False)

print("Load an Assay batch from the server")
assay_id = 2809  # provide one from your server
batch_id = 120  # provide one from your server
run_group = load_batch(server_context, assay_id, batch_id)

if run_group is not None:
    print("Batch Id: " + str(run_group.id))
    print("Created By: " + run_group.created_by)


from __future__ import unicode_literals
from labkey.utils import create_server_context
from labkey.exceptions import RequestError, QueryNotFoundError, ServerContextError, ServerNotFoundError
from labkey.query import select_rows, update_rows, Pagination, QueryFilter, \
    insert_rows, delete_rows, execute_sql
from requests.exceptions import Timeout

import copy

print("Create a server context")
labkey_server = 'localhost:8080'
project_name = 'moduleAssayTest'  # Project folder name
contextPath = 'labkey'
server_context = create_server_context(labkey_server, project_name, contextPath, use_ssl=False)

schema = 'lists'
table = 'Demographics'
column1 = 'Group Assignment'
column2 = 'Participant ID'


###################
# Test basic select_rows
###################
result = select_rows(server_context, schema, table)
if result is not None:
    print(result['rows'][0])
    print("select_rows: There are " + str(result['rowCount']) + " rows.")
else:
Exemple #5
0
from __future__ import unicode_literals

from labkey.utils import create_server_context
from labkey.exceptions import RequestError, QueryNotFoundError, ServerContextError, ServerNotFoundError
from labkey.query import select_rows, update_rows, Pagination, QueryFilter, \
    insert_rows, delete_rows, truncate_table, execute_sql
from requests.exceptions import Timeout

import copy

print("Create a server context")
labkey_server = 'localhost:8080'
project_name = 'ModuleAssayTest'  # Project folder name
context_path = 'labkey'
server_context = create_server_context(labkey_server,
                                       project_name,
                                       context_path,
                                       use_ssl=False)

schema = 'lists'
table = 'Demographics'
column1 = 'Group Assignment'
column2 = 'Participant ID'

###################
# Test basic select_rows
###################
result = select_rows(server_context, schema, table)
if result is not None:
    print(result['rows'][0])
    print("select_rows: There are " + str(result['rowCount']) + " rows.")
else:
Exemple #6
0
"""
Examples using the Experiment.py API

Sample code to submit a single batch of Assay data containing a run with three rows of data

"""

from labkey.utils import create_server_context
from labkey.experiment import save_batch, Batch, Run

assay_id = 2809  # provide one from your server. rowid from the URL query parameters

print("Create a server context")
project_name = 'ModuleAssayTest'
server_context = create_server_context('localhost:8080',
                                       project_name,
                                       'labkey',
                                       use_ssl=False)

# Run data rows
dataRows = [
    {
        # ColumnName : Value
        "SampleId": "Monkey 1",
        "TimePoint": "2008/11/02 11:22:33",
        "DoubleData": 4.5,
        "HiddenData": "another data point"
    },
    {
        "SampleId": "Monkey 2",
        "TimePoint": "2008/11/02 14:00:01",
        "DoubleData": 3.1,
context = SSL.Context(SSL.SSLv23_METHOD)
# Get REDCap params from config file
rc_api_url = config.rcparams['rc_api_url']
rc_base_url = config.rcparams['rc_base_url']
rc_refer_pid = config.rcparams['ndd_rc_refer_pid']
rc_refer_apikey = config.rcparams['ndd_rc_refer_apikey']
rc_data_pid = config.rcparams['ndd_rc_data_pid']
rc_data_apikey = config.rcparams['ndd_rc_data_apikey']
rc_sample_pid = config.rcparams['ndd_rc_sample_pid']
rc_sample_apikey = config.rcparams['ndd_rc_sample_apikey']
# Initialize LK properties from config file and create server context where queries will be executed
labkey_server = config.lkparams['labkey_server']
project_name = config.lkparams['project_name']
context_path = config.lkparams['context_path']
use_ssl = config.lkparams['use_ssl']
server_context = create_server_context(labkey_server, project_name, context_path, use_ssl)

app = Flask(__name__)
app.config['SERVER_NAME']=config.flaskparams['servname']
app.config['PREFERRRED_URL_SCHEME']='https'
cors = CORS(app, resources={r'/*': {'origins': originspermitted}})

# Pull RedCap metadata that will be used in various routes
dd_refer = NDDdb.getMetaData(rc_api_url, rc_refer_apikey, 'family_members')
dd_data = NDDdb.getMetaData(rc_api_url, rc_data_apikey, 'family_members')
dd_refer.set_index(keys='field_name', drop = False, inplace = True, verify_integrity = True)
dd_data.set_index(keys='field_name', drop = False, inplace = True, verify_integrity = True)

# Relation map for LabKey updates
reln_map = NDDdb.parseChoiceMap(dd_data.loc['demo_relation','select_choices_or_calculations'], CHOICEPATTERN, ALTPATTERN)