· 9 years ago · Oct 28, 2016, 10:26 AM
1start connect...
2SQLite.JDBCDriver
3***SQLite.JDBCDriver***
4SQLite.JDBCDriver
52016-10-28 13:52:45,640 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.reminders.DoseEntity with reflection
62016-10-28 13:52:45,640 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.reminders.DrugReminderEntity with reflection
72016-10-28 13:52:45,641 [INFO] TableUtils creating table 'remindDrugReminder'
82016-10-28 13:52:45,643 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #121642416
92016-10-28 13:52:45,644 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `remindDrugReminder` (`isStopped` BOOLEAN , `duration` INTEGER , `startDate` BIGINT , `daysOfMedication` BLOB , `daysOfMedicationType` VARCHAR , `drugName` VARCHAR , `reminderId` INTEGER , PRIMARY KEY (`reminderId`) )
10connection opened
11start connect...
12SQLite.JDBCDriver
13***SQLite.JDBCDriver***
14SQLite.JDBCDriver
152016-10-28 13:52:45,646 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.reminders.DrugReminderEntity with reflection
162016-10-28 13:52:45,646 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.reminders.DoseEntity with reflection
172016-10-28 13:52:45,646 [INFO] TableUtils creating table 'remindDose'
182016-10-28 13:52:45,649 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #121702848
192016-10-28 13:52:45,650 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `remindDose` (`doseType` VARCHAR , `dose` INTEGER , `time` BIGINT , `drugReminderEntity_id` INTEGER NOT NULL , `doseId` INTEGER , PRIMARY KEY (`doseId`) )
20connection opened
21start connect...
22SQLite.JDBCDriver
23***SQLite.JDBCDriver***
24SQLite.JDBCDriver
252016-10-28 13:52:45,651 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.reminders.IntakeEntity with reflection
262016-10-28 13:52:45,654 [INFO] TableUtils creating table 'remindIntake'
272016-10-28 13:52:45,655 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #121743136
282016-10-28 13:52:45,656 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `remindIntake` (`isDeleted` BOOLEAN , `isMissed` BOOLEAN , `doseType` VARCHAR , `dose` INTEGER , `date` BIGINT , `doseId` INTEGER , `intakeId` INTEGER , PRIMARY KEY (`intakeId`) )
29connection opened
302016-10-28 13:52:45,657 [DEBUG] StatementBuilder built statement SELECT * FROM `remindDrugReminder` ORDER BY `reminderId` DESC LIMIT 1
312016-10-28 13:52:45,657 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `remindDrugReminder` ORDER BY `reminderId` DESC LIMIT 1 ' with 0 args
322016-10-28 13:52:45,657 [DEBUG] StatementExecutor query-for-first of 'SELECT * FROM `remindDrugReminder` ORDER BY `reminderId` DESC LIMIT 1 ' returned at 0 results
332016-10-28 13:52:45,672 [DEBUG] BaseMappedStatement insert data with statement 'INSERT INTO `remindDrugReminder` (`isStopped` ,`duration` ,`startDate` ,`daysOfMedication` ,`daysOfMedicationType` ,`drugName` ,`reminderId` ) VALUES (?,?,?,?,?,?,?)' and 7 args, changed 1 rows
342016-10-28 13:52:45,672 [DEBUG] StatementBuilder built statement SELECT * FROM `remindDose` ORDER BY `doseId` DESC LIMIT 1
352016-10-28 13:52:45,673 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `remindDose` ORDER BY `doseId` DESC LIMIT 1 ' with 0 args
362016-10-28 13:52:45,673 [DEBUG] StatementExecutor query-for-first of 'SELECT * FROM `remindDose` ORDER BY `doseId` DESC LIMIT 1 ' returned at 0 results
372016-10-28 13:52:45,682 [DEBUG] BaseMappedStatement insert data with statement 'INSERT INTO `remindDose` (`doseType` ,`dose` ,`time` ,`drugReminderEntity_id` ,`doseId` ) VALUES (?,?,?,?,?)' and 5 args, changed 1 rows
382016-10-28 13:52:45,683 [DEBUG] JdbcConnectionSource closed connection #121743136
39connection closed
402016-10-28 13:52:45,683 [DEBUG] JdbcConnectionSource closed connection #121702848
41connection closed
422016-10-28 13:52:45,684 [DEBUG] JdbcConnectionSource closed connection #121642416
43connection closed
44start connect...
45SQLite.JDBCDriver
46***SQLite.JDBCDriver***
47SQLite.JDBCDriver
482016-10-28 13:52:48,481 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.reminders.DoseEntity with reflection
492016-10-28 13:52:48,482 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.reminders.DrugReminderEntity with reflection
502016-10-28 13:52:48,482 [INFO] TableUtils creating table 'remindDrugReminder'
512016-10-28 13:52:48,484 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #121850688
522016-10-28 13:52:48,485 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `remindDrugReminder` (`isStopped` BOOLEAN , `duration` INTEGER , `startDate` BIGINT , `daysOfMedication` BLOB , `daysOfMedicationType` VARCHAR , `drugName` VARCHAR , `reminderId` INTEGER , PRIMARY KEY (`reminderId`) )
53connection opened
54start connect...
55SQLite.JDBCDriver
56***SQLite.JDBCDriver***
57SQLite.JDBCDriver
582016-10-28 13:52:48,487 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.reminders.DrugReminderEntity with reflection
592016-10-28 13:52:48,487 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.reminders.DoseEntity with reflection
602016-10-28 13:52:48,487 [INFO] TableUtils creating table 'remindDose'
612016-10-28 13:52:48,489 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #121923408
622016-10-28 13:52:48,490 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `remindDose` (`doseType` VARCHAR , `dose` INTEGER , `time` BIGINT , `drugReminderEntity_id` INTEGER NOT NULL , `doseId` INTEGER , PRIMARY KEY (`doseId`) )
63connection opened
64start connect...
65SQLite.JDBCDriver
66***SQLite.JDBCDriver***
67SQLite.JDBCDriver
682016-10-28 13:52:48,491 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.reminders.IntakeEntity with reflection
692016-10-28 13:52:48,494 [INFO] TableUtils creating table 'remindIntake'
702016-10-28 13:52:48,495 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #121963696
712016-10-28 13:52:48,497 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `remindIntake` (`isDeleted` BOOLEAN , `isMissed` BOOLEAN , `doseType` VARCHAR , `dose` INTEGER , `date` BIGINT , `doseId` INTEGER , `intakeId` INTEGER , PRIMARY KEY (`intakeId`) )
72connection opened
732016-10-28 13:52:48,497 [DEBUG] StatementBuilder built statement SELECT * FROM `remindDrugReminder`
742016-10-28 13:52:48,497 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `remindDrugReminder` ' with 0 args
752016-10-28 13:52:48,497 [DEBUG] SelectIterator starting iterator @121835968 for 'SELECT * FROM `remindDrugReminder` '
762016-10-28 13:52:48,500 [DEBUG] SelectIterator closed iterator @121835968 after 0 rows
77java.sql.SQLException: not supported
78 at SQLite.JDBC2z.JDBCResultSet.getByte(JDBCResultSet.java:599)
79 at com.j256.ormlite.jdbc.JdbcDatabaseResults.getByte(JdbcDatabaseResults.java:120)
80 at com.j256.ormlite.db.BaseDatabaseType$BooleanNumberFieldConverter.resultToSqlArg(BaseDatabaseType.java:564)
81 at com.j256.ormlite.field.BaseFieldConverter.resultToJava(BaseFieldConverter.java:24)
82 at com.j256.ormlite.field.FieldType.resultToJava(FieldType.java:794)
83 at com.j256.ormlite.stmt.mapped.BaseMappedQuery.mapRow(BaseMappedQuery.java:60)
84 at com.j256.ormlite.stmt.SelectIterator.getCurrent(SelectIterator.java:272)
85 at com.j256.ormlite.stmt.SelectIterator.nextThrow(SelectIterator.java:163)
86 at com.j256.ormlite.stmt.StatementExecutor.query(StatementExecutor.java:202)
87 at com.j256.ormlite.dao.BaseDaoImpl.query(BaseDaoImpl.java:269)
88 at ru.agima.mobile.bl.db.DAO.reminders.DrugReminderDAO.readAll(DrugReminderDAO.java:134)
89 at ru.agima.mobile.bl.logic.reminders.GetRemindersWorker.doWork(GetRemindersWorker.java:24)
90 at ru.agima.mobile.bl.logic.reminders.GetRemindersWorker.doWork(GetRemindersWorker.java:16)
91 at ru.agima.mobile.bl.logic.BaseWorker.Execute(BaseWorker.java:37)
922016-10-28 13:52:48,503 [DEBUG] JdbcConnectionSource closed connection #121963696
93connection closed
942016-10-28 13:52:48,504 [DEBUG] JdbcConnectionSource closed connection #121923408
95connection closed
962016-10-28 13:52:48,504 [DEBUG] JdbcConnectionSource closed connection #121850688
97connection closed
98connection closed
99connection closed
100connection closed
101start connect...
102SQLite.JDBCDriver
103***SQLite.JDBCDriver***
104SQLite.JDBCDriver
1052016-10-28 14:20:17,255 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.BasketGoodEntity with reflection
1062016-10-28 14:20:17,256 [INFO] TableUtils creating table 'basketItem'
1072016-10-28 14:20:17,259 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #122076256
1082016-10-28 14:20:17,261 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `basketItem` (`price` VARCHAR , `order_id` VARCHAR , `count` INTEGER , `xml_id` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
109connection opened
1102016-10-28 14:20:17,261 [DEBUG] StatementBuilder built statement SELECT COUNT(*) FROM `basketItem` WHERE `order_id` = ''
1112016-10-28 14:20:17,261 [DEBUG] BaseMappedStatement prepared statement 'SELECT COUNT(*) FROM `basketItem` WHERE `order_id` = '' ' with 0 args
1122016-10-28 14:20:17,263 [DEBUG] JdbcConnectionSource closed connection #122076256
113connection closed
1142016-10-28 14:20:17.271756 Zdravcity-iOS[2577:468159] *** -[NSKeyedUnarchiver initForReadingWithData:]: data is NULL
1152016-10-28 14:20:17.321312 Zdravcity-iOS[2577:468159] Warning: Attempt to present <UISearchController: 0x1027ac870> on <ZDCDashboardViewController: 0x10267fdd0> whose view is not in the window hierarchy!
116start connect...
117SQLite.JDBCDriver
118***SQLite.JDBCDriver***
119SQLite.JDBCDriver
1202016-10-28 14:20:17,323 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.BasketGoodEntity with reflection
1212016-10-28 14:20:17,323 [INFO] TableUtils creating table 'basketItem'
1222016-10-28 14:20:17,325 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #122110288
1232016-10-28 14:20:17,325 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `basketItem` (`price` VARCHAR , `order_id` VARCHAR , `count` INTEGER , `xml_id` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
124connection opened
1252016-10-28 14:20:17,325 [DEBUG] StatementBuilder built statement SELECT COUNT(*) FROM `basketItem` WHERE `order_id` = ''
1262016-10-28 14:20:17,326 [DEBUG] BaseMappedStatement prepared statement 'SELECT COUNT(*) FROM `basketItem` WHERE `order_id` = '' ' with 0 args
1272016-10-28 14:20:17,326 [DEBUG] JdbcConnectionSource closed connection #122110288
128connection closed
129start connect...
130SQLite.JDBCDriver
131***SQLite.JDBCDriver***
132SQLite.JDBCDriver
1332016-10-28 14:20:17,330 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.ImageEntity with reflection
1342016-10-28 14:20:17,330 [INFO] TableUtils creating table 'imageBytes'
1352016-10-28 14:20:17,331 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #122178464
1362016-10-28 14:20:17,332 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `imageBytes` (`bytes` BLOB , `url` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
137connection opened
1382016-10-28 14:20:17,332 [DEBUG] StatementBuilder built statement SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/a30/f12/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg'
1392016-10-28 14:20:17,332 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/a30/f12/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' ' with 0 args
1402016-10-28 14:20:17,335 [DEBUG] SelectIterator starting iterator @122157584 for 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/a30/f12/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' '
1412016-10-28 14:20:17,340 [DEBUG] SelectIterator closed iterator @122157584 after 1 rows
1422016-10-28 14:20:17,340 [DEBUG] StatementExecutor query of 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/a30/f12/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' ' returned 1 results
1432016-10-28 14:20:17,341 [DEBUG] JdbcConnectionSource closed connection #122178464
144connection closed
145start connect...
146SQLite.JDBCDriver
147***SQLite.JDBCDriver***
148SQLite.JDBCDriver
1492016-10-28 14:20:17,343 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.ImageEntity with reflection
1502016-10-28 14:20:17,343 [INFO] TableUtils creating table 'imageBytes'
1512016-10-28 14:20:17,344 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #122753216
1522016-10-28 14:20:17,345 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `imageBytes` (`bytes` BLOB , `url` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
153connection opened
1542016-10-28 14:20:17,345 [DEBUG] StatementBuilder built statement SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/024/84a/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg'
1552016-10-28 14:20:17,345 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/024/84a/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' ' with 0 args
1562016-10-28 14:20:17,346 [DEBUG] SelectIterator starting iterator @122155904 for 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/024/84a/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' '
1572016-10-28 14:20:17,351 [DEBUG] SelectIterator closed iterator @122155904 after 1 rows
1582016-10-28 14:20:17,351 [DEBUG] StatementExecutor query of 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/024/84a/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' ' returned 1 results
1592016-10-28 14:20:17,351 [DEBUG] JdbcConnectionSource closed connection #122753216
160connection closed
161start connect...
162SQLite.JDBCDriver
163***SQLite.JDBCDriver***
164SQLite.JDBCDriver
1652016-10-28 14:20:17,357 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.GoodOfDayEntity with reflection
1662016-10-28 14:20:17,357 [INFO] TableUtils creating table 'goodOfDay'
1672016-10-28 14:20:17,358 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #123360672
1682016-10-28 14:20:17,359 [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`) )
169connection opened
1702016-10-28 14:20:17,359 [DEBUG] StatementBuilder built statement SELECT * FROM `goodOfDay`
1712016-10-28 14:20:17,359 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `goodOfDay` ' with 0 args
1722016-10-28 14:20:17,360 [DEBUG] SelectIterator starting iterator @123329152 for 'SELECT * FROM `goodOfDay` '
1732016-10-28 14:20:17,360 [DEBUG] SelectIterator closed iterator @123329152 after 2 rows
1742016-10-28 14:20:17,360 [DEBUG] StatementExecutor query of 'SELECT * FROM `goodOfDay` ' returned 2 results
1752016-10-28 14:20:17,361 [DEBUG] JdbcConnectionSource closed connection #123360672
176connection closed
177start connect...
178SQLite.JDBCDriver
179***SQLite.JDBCDriver***
180SQLite.JDBCDriver
1812016-10-28 14:20:17,488 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.ImageEntity with reflection
1822016-10-28 14:20:17,488 [INFO] TableUtils creating table 'imageBytes'
1832016-10-28 14:20:17,489 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #123460512
1842016-10-28 14:20:17,489 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `imageBytes` (`bytes` BLOB , `url` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
185connection opened
1862016-10-28 14:20:17,489 [DEBUG] StatementBuilder built statement SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/a30/f12/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg'
1872016-10-28 14:20:17,489 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/a30/f12/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' ' with 0 args
1882016-10-28 14:20:17,494 [DEBUG] SelectIterator starting iterator @123326688 for 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/a30/f12/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' '
1892016-10-28 14:20:17,501 [DEBUG] SelectIterator closed iterator @123326688 after 1 rows
1902016-10-28 14:20:17,501 [DEBUG] StatementExecutor query of 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/a30/f12/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' ' returned 1 results
1912016-10-28 14:20:17,502 [DEBUG] JdbcConnectionSource closed connection #123460512
192connection closed
193start connect...
194SQLite.JDBCDriver
195***SQLite.JDBCDriver***
196SQLite.JDBCDriver
1972016-10-28 14:20:17,506 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.ImageEntity with reflection
1982016-10-28 14:20:17,506 [INFO] TableUtils creating table 'imageBytes'
1992016-10-28 14:20:17,507 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #124039264
2002016-10-28 14:20:17,508 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `imageBytes` (`bytes` BLOB , `url` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
201connection opened
2022016-10-28 14:20:17,508 [DEBUG] StatementBuilder built statement SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/024/84a/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg'
2032016-10-28 14:20:17,508 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/024/84a/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' ' with 0 args
2042016-10-28 14:20:17,516 [DEBUG] SelectIterator starting iterator @124021264 for 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/024/84a/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' '
2052016-10-28 14:20:17,521 [DEBUG] SelectIterator closed iterator @124021264 after 1 rows
2062016-10-28 14:20:17,521 [DEBUG] StatementExecutor query of 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/024/84a/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' ' returned 1 results
2072016-10-28 14:20:17,521 [DEBUG] JdbcConnectionSource closed connection #124039264
208connection closed
209start connect...
210SQLite.JDBCDriver
211***SQLite.JDBCDriver***
212SQLite.JDBCDriver
2132016-10-28 14:20:18,481 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.BasketGoodEntity with reflection
2142016-10-28 14:20:18,481 [INFO] TableUtils creating table 'basketItem'
2152016-10-28 14:20:18,484 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #124576560
2162016-10-28 14:20:18,485 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `basketItem` (`price` VARCHAR , `order_id` VARCHAR , `count` INTEGER , `xml_id` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
217connection opened
2182016-10-28 14:20:18,486 [DEBUG] StatementBuilder built statement SELECT COUNT(*) FROM `basketItem` WHERE `order_id` = ''
2192016-10-28 14:20:18,486 [DEBUG] BaseMappedStatement prepared statement 'SELECT COUNT(*) FROM `basketItem` WHERE `order_id` = '' ' with 0 args
2202016-10-28 14:20:18,487 [DEBUG] JdbcConnectionSource closed connection #124576560
221connection closed
222start connect...
223SQLite.JDBCDriver
224***SQLite.JDBCDriver***
225SQLite.JDBCDriver
2262016-10-28 14:20:18,503 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.BasketGoodEntity with reflection
2272016-10-28 14:20:18,504 [INFO] TableUtils creating table 'basketItem'
2282016-10-28 14:20:18,505 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #124627872
2292016-10-28 14:20:18,506 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `basketItem` (`price` VARCHAR , `order_id` VARCHAR , `count` INTEGER , `xml_id` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
230connection opened
2312016-10-28 14:20:18,506 [DEBUG] StatementBuilder built statement SELECT COUNT(*) FROM `basketItem` WHERE `order_id` = ''
2322016-10-28 14:20:18,506 [DEBUG] BaseMappedStatement prepared statement 'SELECT COUNT(*) FROM `basketItem` WHERE `order_id` = '' ' with 0 args
2332016-10-28 14:20:18,508 [DEBUG] JdbcConnectionSource closed connection #124627872
234connection closed
235start connect...
236SQLite.JDBCDriver
237***SQLite.JDBCDriver***
238SQLite.JDBCDriver
2392016-10-28 14:20:18,514 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.models.common.ImageRespEntity with reflection
2402016-10-28 14:20:18,515 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.models.common.InstructionEntity with reflection
2412016-10-28 14:20:18,516 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.models.common.ProducerEntity with reflection
2422016-10-28 14:20:18,517 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.GoodDetailsEntity with reflection
2432016-10-28 14:20:18,517 [INFO] TableUtils creating table 'goodDetails'
2442016-10-28 14:20:18,518 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #124815376
2452016-10-28 14:20:18,528 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `goodDetails` (`rating` VARCHAR , `available_cnt` VARCHAR , `price` VARCHAR , `image` INTEGER , `instruction` INTEGER , `producer` INTEGER , `rate` VARCHAR , `rateMarketing` INTEGER , `storingCondition` VARCHAR , `prPkkn` BOOLEAN , `prBad` BOOLEAN , `pr0a` BOOLEAN , `prNotRecept` BOOLEAN , `prLgota` BOOLEAN , `prJnvls` BOOLEAN , `innNameLat` VARCHAR , `innNameRus` VARCHAR , `nameTRn` VARCHAR , `nameCureform` VARCHAR , `namePack` VARCHAR , `itemShortDesc` VARCHAR , `itemName` VARCHAR , `xml_id` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
246connection opened
2472016-10-28 14:20:18,530 [DEBUG] StatementBuilder built statement SELECT * FROM `goodDetails` WHERE `xml_id` = 'B50E6959-3B30-402A-AAC5-9979F9CCC25C'
2482016-10-28 14:20:18,530 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `goodDetails` WHERE `xml_id` = 'B50E6959-3B30-402A-AAC5-9979F9CCC25C' ' with 0 args
2492016-10-28 14:20:18,531 [DEBUG] SelectIterator starting iterator @124687120 for 'SELECT * FROM `goodDetails` WHERE `xml_id` = 'B50E6959-3B30-402A-AAC5-9979F9CCC25C' '
2502016-10-28 14:20:18,532 [DEBUG] SelectIterator closed iterator @124687120 after 0 rows
2512016-10-28 14:20:18,532 [DEBUG] StatementExecutor query of 'SELECT * FROM `goodDetails` WHERE `xml_id` = 'B50E6959-3B30-402A-AAC5-9979F9CCC25C' ' returned 0 results
252***
253Before sending json content by post: {"xml_id":"B50E6959-3B30-402A-AAC5-9979F9CCC25C","region_code":"ulyanovsk"} to: http://zdravcity.ru/api/getGoodDetail/
2542016-10-28 14:20:18.535352 Zdravcity-iOS[2577:472801] dnssd_clientstub write_all(33) DEFUNCT
2552016-10-28 14:20:18.535556 Zdravcity-iOS[2577:472801] dnssd_clientstub deliver_request ERROR: write_all(33, 53 bytes) failed
2562016-10-28 14:20:18.535767 Zdravcity-iOS[2577:472801] dnssd_clientstub write_all(33) DEFUNCT
2572016-10-28 14:20:18.967414 Zdravcity-iOS[2577:469477] [Client] Failure to deallocate CLLocationManager on the same runloop as its creation may result in a crash
258start connect...
259SQLite.JDBCDriver
260***SQLite.JDBCDriver***
261SQLite.JDBCDriver
2622016-10-28 14:20:18,973 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.SessionEntity with reflection
2632016-10-28 14:20:18,973 [INFO] TableUtils creating table 'session'
2642016-10-28 14:20:18,977 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #125036992
2652016-10-28 14:20:18,979 [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`) )
266connection opened
2672016-10-28 14:20:18,979 [DEBUG] StatementBuilder built statement SELECT * FROM `session`
2682016-10-28 14:20:18,979 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `session` ' with 0 args
2692016-10-28 14:20:18,991 [DEBUG] SelectIterator starting iterator @124991904 for 'SELECT * FROM `session` '
2702016-10-28 14:20:18,991 [DEBUG] SelectIterator closed iterator @124991904 after 0 rows
2712016-10-28 14:20:18,991 [DEBUG] StatementExecutor query of 'SELECT * FROM `session` ' returned 0 results
2722016-10-28 14:20:18,991 [DEBUG] JdbcConnectionSource closed connection #125036992
273connection closed
274start connect...
275SQLite.JDBCDriver
276***SQLite.JDBCDriver***
277SQLite.JDBCDriver
2782016-10-28 14:20:18,992 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.SessionEntity with reflection
2792016-10-28 14:20:18,992 [INFO] TableUtils creating table 'session'
2802016-10-28 14:20:18,994 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #125091056
2812016-10-28 14:20:18,995 [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`) )
282connection opened
2832016-10-28 14:20:18,995 [DEBUG] StatementBuilder built statement SELECT * FROM `session`
2842016-10-28 14:20:18,995 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `session` ' with 0 args
2852016-10-28 14:20:18,995 [DEBUG] SelectIterator starting iterator @124990336 for 'SELECT * FROM `session` '
2862016-10-28 14:20:18,995 [DEBUG] SelectIterator closed iterator @124990336 after 0 rows
2872016-10-28 14:20:18,996 [DEBUG] StatementExecutor query of 'SELECT * FROM `session` ' returned 0 results
2882016-10-28 14:20:18,996 [DEBUG] JdbcConnectionSource closed connection #125091056
289connection closed
290***
291Before sending json content by post: {"pager":{"count":2},"lon":48.4,"lat":54.33,"region_code":"ulyanovsk"} to: http://zdravcity.ru/api/getPharmacyList/
292{"status":0,"message":"","data":{"pharms":[{"ID":"14348","NAME":"ВикториÑ","EMAIL":"","PHONE":["+7 (8422) 67-28-73"],"CITY":"УЛЬЯÐОВСК","REGION":"73","ADDRESS":"ОÑтровÑкого, д. 17, а","GPS_LAT":"54.330502","GPS_LONG":"48.392828","WORKING_PRICE":"2","RATING":"0","METRO":[""],"DISTRICT":"NULL","OPEN24":false,"OPTIC":false,"SOCIAL":false,"CASH":"1","NON-CASH":"0","DELIVERY":false,"DISTANCE":"0.4683645025222672","IS_FAVORITE":false},{"ID":"14346","NAME":"Виком","EMAIL":"","PHONE":["+7 (951) 095-14-90"],"CITY":"УЛЬЯÐОВСК","REGION":"73","ADDRESS":"Гагарина, д. 20","GPS_LAT":"54.328444","GPS_LONG":"48.38857","WORKING_PRICE":"2","RATING":"0","METRO":[""],"DISTRICT":"NULL","OPEN24":false,"OPTIC":false,"SOCIAL":false,"CASH":"1","NON-CASH":"0","DELIVERY":false,"DISTANCE":"0.7610579278559598","IS_FAVORITE":false}],"favorite_pharms":null},"debug":"{\"pager\":{\"count\":2},\"lon\":48.4,\"lat\":54.33,\"region_code\":\"ulyanovsk\"}"}
293start connect...
294SQLite.JDBCDriver
295***SQLite.JDBCDriver***
296SQLite.JDBCDriver
2972016-10-28 14:20:19,122 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.ImageEntity with reflection
2982016-10-28 14:20:19,123 [INFO] TableUtils creating table 'imageBytes'
2992016-10-28 14:20:19,124 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #121924320
3002016-10-28 14:20:19,124 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `imageBytes` (`bytes` BLOB , `url` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
301connection opened
3022016-10-28 14:20:19,124 [DEBUG] StatementBuilder built statement SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/a30/f12/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg'
3032016-10-28 14:20:19,125 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/a30/f12/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' ' with 0 args
3042016-10-28 14:20:19,126 [DEBUG] SelectIterator starting iterator @125133136 for 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/a30/f12/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' '
3052016-10-28 14:20:19,129 [DEBUG] SelectIterator closed iterator @125133136 after 1 rows
3062016-10-28 14:20:19,130 [DEBUG] StatementExecutor query of 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/a30/f12/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' ' returned 1 results
3072016-10-28 14:20:19,130 [DEBUG] JdbcConnectionSource closed connection #121924320
308connection closed
309start connect...
310SQLite.JDBCDriver
311***SQLite.JDBCDriver***
312SQLite.JDBCDriver
3132016-10-28 14:20:19,132 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.ImageEntity with reflection
3142016-10-28 14:20:19,132 [INFO] TableUtils creating table 'imageBytes'
3152016-10-28 14:20:19,133 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #121994000
3162016-10-28 14:20:19,134 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `imageBytes` (`bytes` BLOB , `url` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
317connection opened
3182016-10-28 14:20:19,134 [DEBUG] StatementBuilder built statement SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/024/84a/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg'
3192016-10-28 14:20:19,134 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/024/84a/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' ' with 0 args
3202016-10-28 14:20:19,135 [DEBUG] SelectIterator starting iterator @121694400 for 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/024/84a/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' '
3212016-10-28 14:20:19,138 [DEBUG] SelectIterator closed iterator @121694400 after 1 rows
3222016-10-28 14:20:19,138 [DEBUG] StatementExecutor query of 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/resize_cache/iblock/024/84a/300_300_140cd750bba9870f18aada2478b24840a/photo_es.jpg' ' returned 1 results
3232016-10-28 14:20:19,138 [DEBUG] JdbcConnectionSource closed connection #121994000
324connection closed
325{"status":0,"message":"","data":{"itemName":"Ð—Ð¾Ð»Ð¾Ñ‚Ð°Ñ Ð·Ð²ÐµÐ·Ð´Ð° бальзам 4г","itemShortDesc":"Оказывает меÑтнораздражающее, отвлекающее и антиÑептичеÑкое дейÑтвие. ПоказаниÑ:Грипп, головокружение, Ð³Ð¾Ð»Ð¾Ð²Ð½Ð°Ñ Ð±Ð¾Ð»ÑŒ, проÑтудные заболеваниÑ, наÑморк (как ÑимптоматичеÑкое ÑредÑтво в комплекÑной терапии), укуÑÑ‹ наÑекомых.","namePack":"бан. жеÑÑ‚.","nameCureform":"БÐЛЬЗÐМ","nameTrn":"Ð—Ð¾Ð»Ð¾Ñ‚Ð°Ñ Ð·Ð²ÐµÐ·Ð´Ð°","innNameRus":"Гвоздики маÑло+Камфора+МÑты перечной маÑло","innNameLat":"Caryophylli floridis oleum+Camphor+Menthae piperitae foliorum oleum","prJnvls":false,"prLgota":false,"prNotRecept":true,"prOa":false,"prBad":false,"prPkkn":false,"storingCondition":"Хранить в Ñухом, защищенном от Ñвета, недоÑтупном Ð´Ð»Ñ Ð´ÐµÑ‚ÐµÐ¹ меÑте, при комнатной температуре не выше 25°С.","rateMarketing":5,"rate":3,"producer":{"producerCountry":"Вьетнам","producerName":"Данафа Фарма Джойнт Сток Ко"},"instruction":{"indication":"Ринит (в ÑоÑтаве комбинированной терапии).","contraIndication":"1. гиперчувÑтвительноÑть; <br>\n2. детÑкий возраÑÑ‚ (до 2 лет).","specialInstruction":"При возникновении аллергичеÑких реакций при применении бальзама препарат необходимо отменить, а оÑтатки Ñмыть Ñ ÐºÐ¾Ð¶Ð¸ теплой водой. <br>\nИзбегать Ð¿Ð¾Ð¿Ð°Ð´Ð°Ð½Ð¸Ñ Ð½Ð° ÑлизиÑтые оболочки глаз и ноÑа.","pharmAction":"Комбинированный препарат, в ÑоÑтав которого входÑÑ‚: Гвоздики цветков маÑло, камфора, Коричника китайÑкого маÑло, МÑты перечной лиÑтьев маÑло, Ðвкалипта прутовидного лиÑтьев маÑло, рацементол. <br>\nОказывает меÑтнораздражающее, отвлекающее и антиÑептичеÑкое дейÑтвие.","dosage":"Бальзам Ð´Ð»Ñ Ð½Ð°Ñ€ÑƒÐ¶Ð½Ð¾Ð³Ð¾ применениÑ: небольшое количеÑтво препарата наноÑÑÑ‚ на отдельные учаÑтки и втирают к кожу: при головной боли — в облаÑть виÑков и затылка; при наÑморке — под ноздрÑми; при проÑтудных заболеваниÑÑ… — в облаÑть груди, Ñпины, живота; при укуÑах наÑекомых — на меÑто укуÑа.\nКарандаш Ð´Ð»Ñ Ð¸Ð½Ð³Ð°Ð»Ñций: вдыхают в каждый ноÑовой ход 5–10 раз в Ñутки.","interaction":"ВзаимодейÑтвие Ñ Ð´Ñ€ÑƒÐ³Ð¸Ð¼Ð¸ лекарÑтвенными ÑредÑтвами не опиÑано.","overDosage":"До наÑтоÑщего времени Ñлучаев передозировки отмечено не было.","sideEffect":"ÐллергичеÑкие реакции."},"xml_id":"B50E6959-3B30-402A-AAC5-9979F9CCC25C","image":{"src":"\/upload\/iblock\/a30\/f12\/photo_es.jpg","width":"400","height":"387"},"price":80.9,"available_cnt":1779,"rating":"5"},"debug":"{\"xml_id\":\"B50E6959-3B30-402A-AAC5-9979F9CCC25C\",\"region_code\":\"ulyanovsk\"}"}
326start connect...
327SQLite.JDBCDriver
328***SQLite.JDBCDriver***
329SQLite.JDBCDriver
3302016-10-28 14:20:19,376 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.models.common.ProducerEntity with reflection
3312016-10-28 14:20:19,377 [INFO] TableUtils creating table 'producer'
3322016-10-28 14:20:19,379 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #122769792
3332016-10-28 14:20:19,395 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `producer` (`producerName` VARCHAR , `producerCountry` VARCHAR , `goodXml_id` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
334connection opened
3352016-10-28 14:20:19,403 [DEBUG] BaseMappedStatement insert data with statement 'INSERT INTO `producer` (`producerName` ,`producerCountry` ,`goodXml_id` ,`id` ) VALUES (?,?,?,?)' and 4 args, changed 1 rows
3362016-10-28 14:20:19,404 [DEBUG] JdbcConnectionSource closed connection #122769792
337connection closed
338start connect...
339SQLite.JDBCDriver
340***SQLite.JDBCDriver***
341SQLite.JDBCDriver
3422016-10-28 14:20:19,406 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.models.common.ImageRespEntity with reflection
3432016-10-28 14:20:19,406 [INFO] TableUtils creating table 'imageResp'
3442016-10-28 14:20:19,409 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #123360144
3452016-10-28 14:20:19,419 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `imageResp` (`height` VARCHAR , `width` VARCHAR , `goodXml_id` VARCHAR , `src` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
346connection opened
3472016-10-28 14:20:19,428 [DEBUG] BaseMappedStatement insert data with statement 'INSERT INTO `imageResp` (`height` ,`width` ,`goodXml_id` ,`src` ,`id` ) VALUES (?,?,?,?,?)' and 5 args, changed 1 rows
3482016-10-28 14:20:19,429 [DEBUG] JdbcConnectionSource closed connection #123360144
349connection closed
350start connect...
351SQLite.JDBCDriver
352***SQLite.JDBCDriver***
353SQLite.JDBCDriver
3542016-10-28 14:20:19,433 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.models.common.InstructionEntity with reflection
3552016-10-28 14:20:19,433 [INFO] TableUtils creating table 'instruction'
3562016-10-28 14:20:19,435 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #123416272
3572016-10-28 14:20:19,442 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `instruction` (`goodXml_id` VARCHAR , `dosage` VARCHAR , `pharmAction` VARCHAR , `specialInstruction` VARCHAR , `contraIndication` VARCHAR , `indication` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
358connection opened
3592016-10-28 14:20:19,450 [DEBUG] BaseMappedStatement insert data with statement 'INSERT INTO `instruction` (`goodXml_id` ,`dosage` ,`pharmAction` ,`specialInstruction` ,`contraIndication` ,`indication` ,`id` ) VALUES (?,?,?,?,?,?,?)' and 7 args, changed 1 rows
3602016-10-28 14:20:19,451 [DEBUG] JdbcConnectionSource closed connection #123416272
361connection closed
3622016-10-28 14:20:19,458 [DEBUG] BaseMappedStatement insert data with statement 'INSERT INTO `goodDetails` (`rating` ,`available_cnt` ,`price` ,`image` ,`instruction` ,`producer` ,`rate` ,`rateMarketing` ,`storingCondition` ,`prPkkn` ,`prBad` ,`pr0a` ,`prNotRecept` ,`prLgota` ,`prJnvls` ,`innNameLat` ,`innNameRus` ,`nameTRn` ,`nameCureform` ,`namePack` ,`itemShortDesc` ,`itemName` ,`xml_id` ,`id` ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)' and 24 args, changed 1 rows
3632016-10-28 14:20:19,459 [DEBUG] JdbcConnectionSource closed connection #124815376
364connection closed
365start connect...
366SQLite.JDBCDriver
367***SQLite.JDBCDriver***
368SQLite.JDBCDriver
3692016-10-28 14:20:19,464 [DEBUG] DaoManager created dao for class class ru.agima.mobile.bl.db.Entities.ImageEntity with reflection
3702016-10-28 14:20:19,464 [INFO] TableUtils creating table 'imageBytes'
3712016-10-28 14:20:19,465 [DEBUG] JdbcConnectionSource opened connection to jdbc:sqlite:/private/var/mobile/Containers/Data/Application/F4F01F8F-E4A8-4817-B4C5-B1DB92D5677F/tmp/sample.db got #124024032
3722016-10-28 14:20:19,466 [INFO] TableUtils executed create table statement changed 0 rows: CREATE TABLE IF NOT EXISTS `imageBytes` (`bytes` BLOB , `url` VARCHAR , `id` INTEGER , PRIMARY KEY (`id`) )
373connection opened
3742016-10-28 14:20:19,466 [DEBUG] StatementBuilder built statement SELECT * FROM `imageBytes` WHERE `url` = '/upload/iblock/a30/f12/photo_es.jpg'
3752016-10-28 14:20:19,466 [DEBUG] BaseMappedStatement prepared statement 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/iblock/a30/f12/photo_es.jpg' ' with 0 args
3762016-10-28 14:20:19,466 [DEBUG] SelectIterator starting iterator @124568112 for 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/iblock/a30/f12/photo_es.jpg' '
3772016-10-28 14:20:19,466 [DEBUG] SelectIterator closed iterator @124568112 after 0 rows
3782016-10-28 14:20:19,466 [DEBUG] StatementExecutor query of 'SELECT * FROM `imageBytes` WHERE `url` = '/upload/iblock/a30/f12/photo_es.jpg' ' returned 0 results
3792016-10-28 14:20:19,467 [DEBUG] JdbcConnectionSource closed connection #124024032
380connection closed