[Koha-bugs] [Bug 17005] REST API: add routes to list checkouts history

Sun Mar 12 21:37:22 CET 2017

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17005

--- Comment #15 from Jiri Kozlovsky <mail at jkozlovsky.cz> ---
Someone please help me, I'm stuck in writing unit tests in kohadevbox.

This is what I got returned from sample API partons.t:

kohadev-koha at kohadevbox:/home/vagrant/kohaclone$ prove
t/db_dependent/api/v1/patrons.t 
t/db_dependent/api/v1/patrons.t .. DBD::mysql::st execute failed: Unknown
column 'overdrive_auth_token' in 'field list' [for Statement "INSERT INTO
`borrowers` ( `B_address`, `B_address2`, `B_city`, `B_country`, `B_email`,
`B_phone`, `B_state`, `B_streetnumber`, `B_streettype`, `B_zipcode`, `address`,
`address2`, `altcontactaddress1`, `altcontactaddress2`, `altcontactaddress3`,
`altcontactcountry`, `altcontactfirstname`, `altcontactphone`,
`altcontactstate`, `altcontactsurname`, `altcontactzipcode`, `borrowernotes`,
`branchcode`, `cardnumber`, `categorycode`, `checkprevcheckout`, `city`,
`contactfirstname`, `contactname`, `contactnote`, `contacttitle`, `country`,
`dateenrolled`, `dateexpiry`, `dateofbirth`, `debarred`, `debarredcomment`,
`email`, `emailpro`, `fax`, `firstname`, `flags`, `gonenoaddress`,
`guarantorid`, `initials`, `lastseen`, `lost`, `mobile`, `opacnote`,
`othernames`, `overdrive_auth_token`, `password`, `phone`, `phonepro`,
`privacy`, `privacy_guarantor_checkouts`, `relationship`, `sex`,
`sms_provider_id`, `smsalertnumber`, `sort1`, `sort2`, `state`, `streetnumber`,
`streettype`, `surname`, `title`, `updated_on`, `userid`, `zipcode`) VALUES (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues:
0='VjklbDmEmoWudPhpCWvz7rJAfEEmrCSjbnCf6S4v8DtGZjkCI7jaHoADwHWOGYysHLuBeMzYorwm3992o_UDF3YKUpGYgoPJ',
1='GZgOWb', 2='tSVrqQ8', 3='wk', 4='bNj', 5='BI2aSjf', 6='pTkX6zIVE',
7='BmMDX', 8='Df9lTEgMW770zsj6qMmgo90AcPmCZ2f5yxR2tHtd2W1', 9='NiPDa3Is5',
10='aMIrS', 11='o2fw2mw_gx',
12='QJ96zi10BKHjf45i7UI5qhWEwYcYH4iXBfH8pDeqlMV5xWg2eSyeXiBd0OIboV3mNVJffAKQ0u75wDpIY05H7Iqe3TIbHMUPQ5CoevT1eg87PlkSp6CxoZLKyEzRTNbZS88WKtrzDV6T3NJnn1yDEBfoQdM8zl7n9BYWS6oSacsGTXXJ1fFwiVuNN0GiiulwCC7nhzw5vCmF3eNNxVDj2LF92S22PbUi5pTEiClTLuTqa4zABSs2',
13='a9RpXJAOZTH81_8QUy0ufD0qF_dMHStD3yzzQIr9fcV4KCVRYT_GRsLp4O6iyMI2vHk2LARICmB3crQiA9HjJA4wM4LHfrKDfcUpRurK4R4sH4GS_LxvX',
14='w6f9XgdIm4fUDi1LAlxHlnv0k6bAWvnX_NA7OhYNeInF24CbCzLyOWcX0iyUWwYo1rjUOK4X5DC8zuqiWZdxLveQVOQWCTb0TwFP5bYXCvX0Y20eePvWShnkw3BVm8dnoo8pSvENIIBPsEcbj49uUtuxt_tgye45oX2vYGS75ICIWtjZB6fP8RN6e33SCtoIE4c0wiB68iG6Njs',
15='N',
16='L6xkGcRxTqabsrPIv296A_YUr_TYIn4k4U_p0ESh3iNPfxR2iAh2hVGHQLc8snQXsvjeKQ7Pca0gcp_k9DVhTPcXi3JvdErJ9UBI6SkvmYXxDI7RRI2rm2R4mOuMuf8PbcfAQdWjTbWFnCag',
17='xIn07_7bog', 18='t',
19='d25sJFVrJ6sqNW6o4jw0E76EZkC6w6zmX95Ixsa1yNqZ58zSrN63q1fqCpzTO4HDx0bGCxGXOXVpOTL9cvbaepJ6d_JjBDKUkGsJtfNd7bMlpAx0ypzNE9a3zmIQKw8_ZBeB4M0uk6RONs2t0Pe_MLGTTMP7',
20='Gm1Mgmb4dr5tTD30kXY0y', 21='F3wl', 22='Y6PWhl_UhS', 23='wkINA3tkWfTGo',
24='cR4nYYRnj', 25='ii9I', 26='xlZTwq8', 27='ThXks0vXrW', 28='jImAGNe',
29='YFQrtDRDCCQCLeYC7c_dErxY2Ol5F7InDZk3oEn41zMl2sN_AQxoNYZjqtOugdmSJzUx9HXmdutL45Js8ZUWvfelGTPvCfLdPDIZziX_hNBbVnmwHyXUIoZboIWusA7CZllwzA0TvC2zJ4gKx09v_p5Zu2_42msD0KskMdg4iFzCRl09e6IufqZvS9CJ4uRAA1x4hyUbdy',
30='Z_Fqh', 31='Oba', 32='2017-03-12', 33='2017-03-12', 34='2017-03-12',
35='2017-03-12',
36='Mwf1IB5_qAvR4Fm1Fg2JdqZ2YWofYwVcC5l4dwcnIit4fba2Yopjh5rxZh__Dqhz3yNiWRVzG0M90V2kVFZ0pNRVGpt6DqVqVuJpZrKz0PArDdo5Aept70lMR9mbRHLo6ydPMHVMJcf8NYSajFO1DtQ4JYaT_bRjtdj5Q6ftsOM2yZEME',
37='lHLdEMU', 38='szanHw_MI3q', 39='iXZmy', 40='hlQ0BFbYzW5', 41=0, 42=54,
43=1365868268, 44='uW', 45='2017-03-12 20:34:07', 46=108, 47='gUpy',
48='cfPPJnisWoT', 49='KJSvZZdrF', 50='qm8Xqtvkp', 51='CuaSVbZHRgPLRSM8o5kj',
52='RJJf2lN_m7y', 53='XgyQAVDu', 54=1483959990, 55=1,
56='DkqBG8ZnY3UdRnqDJhvuuW6nnxkFa7Ynp6le', 57='w', 58='4',
59='BpAvEd8VoHTlNcxMHobD',
60='y_7ohFg3sH2tV7LPRQHXZ2x39fdcflRNl_y9UFROZFwAg2stPmeolaYYEY8',
61='eqNIYiKKN0zqJWW_HXk3WZmTAiNjrdRFfiTRsli8X4hkhUkXxH1hcVj5gLV3dSIkX9uAp4l_pS89W63',
62='DWqrDgqkQW', 63='mKq', 64='z9apII7dgaGVu9', 65='Sqj', 66='WXReDMh',
67='2017-03-12 20:34:07', 68='zrG1UCYaWyq7Aq3eSUT8R6MW12jWL0',
69='IcdAqkr_KCQl_wJIErkLSP'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line
1832.
DBIx::Class::Storage::DBI::_execute(): DBD::mysql::st execute failed: Unknown
column 'overdrive_auth_token' in 'field list' [for Statement "INSERT INTO
`borrowers` ( `B_address`, `B_address2`, `B_city`, `B_country`, `B_email`,
`B_phone`, `B_state`, `B_streetnumber`, `B_streettype`, `B_zipcode`, `address`,
`address2`, `altcontactaddress1`, `altcontactaddress2`, `altcontactaddress3`,
`altcontactcountry`, `altcontactfirstname`, `altcontactphone`,
`altcontactstate`, `altcontactsurname`, `altcontactzipcode`, `borrowernotes`,
`branchcode`, `cardnumber`, `categorycode`, `checkprevcheckout`, `city`,
`contactfirstname`, `contactname`, `contactnote`, `contacttitle`, `country`,
`dateenrolled`, `dateexpiry`, `dateofbirth`, `debarred`, `debarredcomment`,
`email`, `emailpro`, `fax`, `firstname`, `flags`, `gonenoaddress`,
`guarantorid`, `initials`, `lastseen`, `lost`, `mobile`, `opacnote`,
`othernames`, `overdrive_auth_token`, `password`, `phone`, `phonepro`,
`privacy`, `privacy_guarantor_checkouts`, `relationship`, `sex`,
`sms_provider_id`, `smsalertnumber`, `sort1`, `sort2`, `state`, `streetnumber`,
`streettype`, `surname`, `title`, `updated_on`, `userid`, `zipcode`) VALUES (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues:
0='VjklbDmEmoWudPhpCWvz7rJAfEEmrCSjbnCf6S4v8DtGZjkCI7jaHoADwHWOGYysHLuBeMzYorwm3992o_UDF3YKUpGYgoPJ',
1='GZgOWb', 2='tSVrqQ8', 3='wk', 4='bNj', 5='BI2aSjf', 6='pTkX6zIVE',
7='BmMDX', 8='Df9lTEgMW770zsj6qMmgo90AcPmCZ2f5yxR2tHtd2W1', 9='NiPDa3Is5',
10='aMIrS', 11='o2fw2mw_gx',
12='QJ96zi10BKHjf45i7UI5qhWEwYcYH4iXBfH8pDeqlMV5xWg2eSyeXiBd0OIboV3mNVJffAKQ0u75wDpIY05H7Iqe3TIbHMUPQ5CoevT1eg87PlkSp6CxoZLKyEzRTNbZS88WKtrzDV6T3NJnn1yDEBfoQdM8zl7n9BYWS6oSacsGTXXJ1fFwiVuNN0GiiulwCC7nhzw5vCmF3eNNxVDj2LF92S22PbUi5pTEiClTLuTqa4zABSs2',
13='a9RpXJAOZTH81_8QUy0ufD0qF_dMHStD3yzzQIr9fcV4KCVRYT_GRsLp4O6iyMI2vHk2LARICmB3crQiA9HjJA4wM4LHfrKDfcUpRurK4R4sH4GS_LxvX',
14='w6f9XgdIm4fUDi1LAlxHlnv0k6bAWvnX_NA7OhYNeInF24CbCzLyOWcX0iyUWwYo1rjUOK4X5DC8zuqiWZdxLveQVOQWCTb0TwFP5bYXCvX0Y20eePvWShnkw3BVm8dnoo8pSvENIIBPsEcbj49uUtuxt_tgye45oX2vYGS75ICIWtjZB6fP8RN6e33SCtoIE4c0wiB68iG6Njs',
15='N',
16='L6xkGcRxTqabsrPIv296A_YUr_TYIn4k4U_p0ESh3iNPfxR2iAh2hVGHQLc8snQXsvjeKQ7Pca0gcp_k9DVhTPcXi3JvdErJ9UBI6SkvmYXxDI7RRI2rm2R4mOuMuf8PbcfAQdWjTbWFnCag',
17='xIn07_7bog', 18='t',
19='d25sJFVrJ6sqNW6o4jw0E76EZkC6w6zmX95Ixsa1yNqZ58zSrN63q1fqCpzTO4HDx0bGCxGXOXVpOTL9cvbaepJ6d_JjBDKUkGsJtfNd7bMlpAx0ypzNE9a3zmIQKw8_ZBeB4M0uk6RONs2t0Pe_MLGTTMP7',
20='Gm1Mgmb4dr5tTD30kXY0y', 21='F3wl', 22='Y6PWhl_UhS', 23='wkINA3tkWfTGo',
24='cR4nYYRnj', 25='ii9I', 26='xlZTwq8', 27='ThXks0vXrW', 28='jImAGNe',
29='YFQrtDRDCCQCLeYC7c_dErxY2Ol5F7InDZk3oEn41zMl2sN_AQxoNYZjqtOugdmSJzUx9HXmdutL45Js8ZUWvfelGTPvCfLdPDIZziX_hNBbVnmwHyXUIoZboIWusA7CZllwzA0TvC2zJ4gKx09v_p5Zu2_42msD0KskMdg4iFzCRl09e6IufqZvS9CJ4uRAA1x4hyUbdy',
30='Z_Fqh', 31='Oba', 32='2017-03-12', 33='2017-03-12', 34='2017-03-12',
35='2017-03-12',
36='Mwf1IB5_qAvR4Fm1Fg2JdqZ2YWofYwVcC5l4dwcnIit4fba2Yopjh5rxZh__Dqhz3yNiWRVzG0M90V2kVFZ0pNRVGpt6DqVqVuJpZrKz0PArDdo5Aept70lMR9mbRHLo6ydPMHVMJcf8NYSajFO1DtQ4JYaT_bRjtdj5Q6ftsOM2yZEME',
37='lHLdEMU', 38='szanHw_MI3q', 39='iXZmy', 40='hlQ0BFbYzW5', 41=0, 42=54,
43=1365868268, 44='uW', 45='2017-03-12 20:34:07', 46=108, 47='gUpy',
48='cfPPJnisWoT', 49='KJSvZZdrF', 50='qm8Xqtvkp', 51='CuaSVbZHRgPLRSM8o5kj',
52='RJJf2lN_m7y', 53='XgyQAVDu', 54=1483959990, 55=1,
56='DkqBG8ZnY3UdRnqDJhvuuW6nnxkFa7Ynp6le', 57='w', 58='4',
59='BpAvEd8VoHTlNcxMHobD',
60='y_7ohFg3sH2tV7LPRQHXZ2x39fdcflRNl_y9UFROZFwAg2stPmeolaYYEY8',
61='eqNIYiKKN0zqJWW_HXk3WZmTAiNjrdRFfiTRsli8X4hkhUkXxH1hcVj5gLV3dSIkX9uAp4l_pS89W63',
62='DWqrDgqkQW', 63='mKq', 64='z9apII7dgaGVu9', 65='Sqj', 66='WXReDMh',
67='2017-03-12 20:34:07', 68='zrG1UCYaWyq7Aq3eSUT8R6MW12jWL0',
69='IcdAqkr_KCQl_wJIErkLSP'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line
1832. at /home/vagrant/kohaclone/t/lib/TestBuilder.pm line 249
# Looks like your test exited with 255 before it could output anything.
t/db_dependent/api/v1/patrons.t .. Dubious, test returned 255 (wstat 65280,
0xff00)
Failed 21/21 subtests 

Test Summary Report
-------------------
t/db_dependent/api/v1/patrons.t (Wstat: 65280 Tests: 0 Failed: 0)
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 21 tests but ran 0.
Files=1, Tests=0,  2 wallclock secs ( 0.02 usr  0.01 sys +  1.44 cusr  0.16
csys =  1.63 CPU)
Result: FAIL

I think it's obvious there is some problem with DB, but I have no idea what it
could be about :(

It's also obvious I cannot write any unit tests for this API because they would
eventually fail from similar reason so I wouldn't see if they pass or no.

-- 
You are receiving this mail because:
You are watching all bug changes.