· 10 years ago · Aug 25, 2016, 07:52 AM
1start connect...
2SQLite.JDBCDriver
3***SQLite.JDBCDriver***
4SQLite.JDBCDriver
52016-08-25 11:43:11,076 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.GoodOfDayEntity with reflection
62016-08-25 11:43:11,077 [INFO] TableUtils creating table 'goodOfDay'
72016-08-25 11:43:11,079 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/0592F5B0-A2A9-4FBD-9090-F915BED30613/tmp/sample.db got #67520696
82016-08-25 11:43:11,081 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `goodOfDay` (`region_code` VARCHAR , `price_old` VARCHAR , `price` VARCHAR , `url_img_big` VARCHAR , `url_img` VARCHAR , `mnn` VARCHAR , `rating` INTEGER , `guid_es` VARCHAR , `name` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
9connection opened
102016-08-25 11:43:11,081 [DEBUG] StatementBuilder built statement SELECT * FROM `goodOfDay`
112016-08-25 11:43:11,082 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `goodOfDay` ' with 0 args
122016-08-25 11:43:11,085 [DEBUG] SelectIterator starting iterator @67574176 for 'SELECT * FROM `goodOfDay` '
132016-08-25 11:43:11,088 [DEBUG] SelectIterator closed iterator @67574176 after 2 rows
142016-08-25 11:43:11,088 [DEBUG] StatementExecutor query of 'SELECT * FROM `goodOfDay` ' returned 2 results
152016-08-25 11:43:11,089 [INFO] TableUtils clearing table 'goodOfDay' with 'DELETE FROM `goodOfDay`
162016-08-25 11:43:11,098 [DEBUG] JdbcConnectionSource closed connection #67520696
17connection closed
18***
19Before sending json content by post: {"pager":{"count":2},"region_code":"vl"} to: http://zdravcity.ru/api/getGoodsOfDay/
20{"status":0,"message":"","data":[{"name":"Бетадин Ñ€-Ñ€ меÑтн и наруж 10% 30мл N1","guid_es":"C921FA45-30D8-4AD1-971C-20B1869B94FB","rating":5,"mnn":"Повидон-йод","url_img":"\/upload\/resize_cache\/iblock\/9ea\/300_300_140cd750bba9870f18aada2478b24840a\/photo_es.jpg","IMAGE_BIG":"\/upload\/iblock\/9ea\/photo_es.jpg","price":"152.00","price_old":"0.00","RECIPE":false},{"name":"Бетадин Ñ€-Ñ€ меÑтн и наруж 10% 120мл N1","guid_es":"EF254B80-3A9B-4DAE-92B6-D0BA5EDEA905","rating":5,"mnn":"Повидон-йод","url_img":"\/upload\/iblock\/4ae\/76e\/photo_es.jpg","IMAGE_BIG":"\/upload\/iblock\/4ae\/76e\/photo_es.jpg","price":"276.90","price_old":"0.00","RECIPE":false}],"debug":"{\"pager\":{\"count\":2},\"region_code\":\"vl\"}"}
21start connect...
22SQLite.JDBCDriver
23***SQLite.JDBCDriver***
24SQLite.JDBCDriver
252016-08-25 11:43:12,983 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.GoodOfDayEntity with reflection
262016-08-25 11:43:12,984 [INFO] TableUtils creating table 'goodOfDay'
272016-08-25 11:43:12,987 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/0592F5B0-A2A9-4FBD-9090-F915BED30613/tmp/sample.db got #67843800
282016-08-25 11:43:13,005 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `goodOfDay` (`region_code` VARCHAR , `price_old` VARCHAR , `price` VARCHAR , `url_img_big` VARCHAR , `url_img` VARCHAR , `mnn` VARCHAR , `rating` INTEGER , `guid_es` VARCHAR , `name` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
29connection opened
302016-08-25 11:43:13,006 [DEBUG] StatementBuilder built statement SELECT * FROM `goodOfDay`
312016-08-25 11:43:13,006 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `goodOfDay` ' with 0 args
322016-08-25 11:43:13,007 [DEBUG] SelectIterator starting iterator @67367304 for 'SELECT * FROM `goodOfDay` '
332016-08-25 11:43:13,008 [DEBUG] SelectIterator closed iterator @67367304 after 0 rows
342016-08-25 11:43:13,008 [DEBUG] StatementExecutor query of 'SELECT * FROM `goodOfDay` ' returned 0 results
352016-08-25 11:43:13,029 [DEBUG] BaseMappedStatement insert data with statement 'INSERT INTO `goodOfDay` (`region_code` ,`price_old` ,`price` ,`url_img_big` ,`url_img` ,`mnn` ,`rating` ,`guid_es` ,`name` ,`id` ) VALUES (?,?,?,?,?,?,?,?,?,?)' and 10 args, changed 1 rows
362016-08-25 11:43:13,039 [DEBUG] BaseMappedStatement insert data with statement 'INSERT INTO `goodOfDay` (`region_code` ,`price_old` ,`price` ,`url_img_big` ,`url_img` ,`mnn` ,`rating` ,`guid_es` ,`name` ,`id` ) VALUES (?,?,?,?,?,?,?,?,?,?)' and 10 args, changed 1 rows
372016-08-25 11:43:13,040 [DEBUG] JdbcConnectionSource closed connection #67843800
38connection closed
39Periodic_GoodsOfDayUpdate_Success{"status":0,"message":"","data":[{"name":"Бетадин Ñ€-Ñ€ меÑтн и наруж 10% 30мл N1","guid_es":"C921FA45-30D8-4AD1-971C-20B1869B94FB","rating":5,"mnn":"Повидон-йод","url_img":"\/upload\/resize_cache\/iblock\/9ea\/300_300_140cd750bba9870f18aada2478b24840a\/photo_es.jpg","IMAGE_BIG":"\/upload\/iblock\/9ea\/photo_es.jpg","price":"152.00","price_old":"0.00","RECIPE":false},{"name":"Бетадин Ñ€-Ñ€ меÑтн и наруж 10% 120мл N1","guid_es":"EF254B80-3A9B-4DAE-92B6-D0BA5EDEA905","rating":5,"mnn":"Повидон-йод","url_img":"\/upload\/iblock\/4ae\/76e\/photo_es.jpg","IMAGE_BIG":"\/upload\/iblock\/4ae\/76e\/photo_es.jpg","price":"276.90","price_old":"0.00","RECIPE":false}],"debug":"{\"pager\":{\"count\":2},\"region_code\":\"vl\"}"}
40start connect...
41SQLite.JDBCDriver
42***SQLite.JDBCDriver***
43SQLite.JDBCDriver
442016-08-25 11:43:13,582 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.GoodOfDayEntity with reflection
452016-08-25 11:43:13,582 [INFO] TableUtils creating table 'goodOfDay'
462016-08-25 11:43:13,585 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/0592F5B0-A2A9-4FBD-9090-F915BED30613/tmp/sample.db got #68007688
472016-08-25 11:43:13,587 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `goodOfDay` (`region_code` VARCHAR , `price_old` VARCHAR , `price` VARCHAR , `url_img_big` VARCHAR , `url_img` VARCHAR , `mnn` VARCHAR , `rating` INTEGER , `guid_es` VARCHAR , `name` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
48connection opened
492016-08-25 11:43:13,595 [DEBUG] BaseMappedStatement insert data with statement 'INSERT INTO `goodOfDay` (`region_code` ,`price_old` ,`price` ,`url_img_big` ,`url_img` ,`mnn` ,`rating` ,`guid_es` ,`name` ,`id` ) VALUES (?,?,?,?,?,?,?,?,?,?)' and 10 args, changed 1 rows
502016-08-25 11:43:13,605 [DEBUG] BaseMappedStatement insert data with statement 'INSERT INTO `goodOfDay` (`region_code` ,`price_old` ,`price` ,`url_img_big` ,`url_img` ,`mnn` ,`rating` ,`guid_es` ,`name` ,`id` ) VALUES (?,?,?,?,?,?,?,?,?,?)' and 10 args, changed 1 rows
512016-08-25 11:43:13,606 [DEBUG] JdbcConnectionSource closed connection #68007688
52connection closed
53start connect...
54SQLite.JDBCDriver
55***SQLite.JDBCDriver***
56SQLite.JDBCDriver
572016-08-25 11:43:15,453 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.SessionEntity with reflection
582016-08-25 11:43:15,454 [INFO] TableUtils creating table 'session'
592016-08-25 11:43:15,456 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/0592F5B0-A2A9-4FBD-9090-F915BED30613/tmp/sample.db got #68299008
602016-08-25 11:43:15,458 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `session` (`password` VARCHAR , `login` VARCHAR , `agent_id` INTEGER , `token` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
61connection opened
622016-08-25 11:43:15,458 [DEBUG] StatementBuilder built statement SELECT * FROM `session`
632016-08-25 11:43:15,459 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `session` ' with 0 args
642016-08-25 11:43:15,460 [DEBUG] SelectIterator starting iterator @68324248 for 'SELECT * FROM `session` '
652016-08-25 11:43:15,461 [DEBUG] SelectIterator closed iterator @68324248 after 0 rows
662016-08-25 11:43:15,461 [DEBUG] StatementExecutor query of 'SELECT * FROM `session` ' returned 0 results
672016-08-25 11:43:15,462 [DEBUG] JdbcConnectionSource closed connection #68299008
68connection closed