[00:16:15] Сволота is now online [00:34:58] levsha is now online
[00:37:41] gigimon is now online
[00:37:45] Сволота is now away
[00:40:52] Сволота is now online
[00:41:45] levsha is now offline
[00:43:44] tranq is now offline
[00:44:27] slav0nic is now away
[00:45:19] slav0nic is now online
[01:15:28] : Используемый вами псевдоним не зарегистрирован
[01:15:28] Сволота is now online
[01:15:28] Tony is now xa
[01:15:28] slav0nic is now online
[01:15:28] gigimon is now online
[01:15:28] fuzzy is now online
[01:15:28] AlexZenon is now xa
[01:15:28] : slav0nic установил(а) тему: python.su | Сначала поищи ответ на docs.python.org | Теперь поищи в google.com | Код постить в dumpz.org | Хочешь задать вопрос - просто *задай* его! | Правила написания хорошего кода: http://➡.ws/pep8 | Логи: http://logs.python.su
[01:15:28] madmercen is now online
[01:15:28] magic_pony is now online
[01:17:10] levsha is now online
[01:23:11] levsha is now offline
[01:24:05] levsha is now online
[01:37:55] levsha is now away
[01:38:23] levsha is now offline
[01:39:15] levsha is now away
[01:39:18] levsha is now online
[01:45:51] levsha is now offline
[01:46:45] levsha is now online
[01:51:24] levsha is now offline
[01:55:07] levsha is now online
[02:04:43] fuzzy is now online
[02:20:47] levsha is now offline
[02:21:27] gigimon is now online
[02:21:52] gigimon is now online
[02:21:56] gigimon is now offline
[02:31:26] Сволота is now away
[02:36:26] Сволота is now online
[02:36:53] levsha is now online
[02:40:19] levsha is now offline
[02:41:26] Сволота is now away
[02:42:04] Сволота is now online
[02:44:48] slav0nic is now offline
[03:11:18] fuzzy is now away
[03:21:04] fuzzy is now away
[03:36:09] fuzzy is now away
[03:36:10] fuzzy is now away
[03:36:20] Сволота is now away
[03:37:04] Сволота is now online
[04:07:06] : Используемый вами псевдоним не зарегистрирован
[04:07:06] Сволота is now online
[04:07:06] Tony is now xa
[04:07:06] madmercen is now online
[04:07:06] fuzzy is now away
[04:07:06] AlexZenon is now xa
[04:07:06] magic_pony is now online
[04:07:06] : slav0nic установил(а) тему: python.su | Сначала поищи ответ на docs.python.org | Теперь поищи в google.com | Код постить в dumpz.org | Хочешь задать вопрос - просто *задай* его! | Правила написания хорошего кода: http://➡.ws/pep8 | Логи: http://logs.python.su
[04:24:06] fuzzy is now away
[04:27:30] fuzzy is now away
[04:35:30] fuzzy is now away
[04:37:40] fuzzy is now away
[04:49:31] fuzzy is now away
[04:50:02] fuzzy is now away
[05:20:10] : Используемый вами псевдоним не зарегистрирован
[05:20:10] Tony is now xa
[05:20:10] Сволота is now online
[05:20:10] madmercen is now online
[05:20:10] : slav0nic установил(а) тему: python.su | Сначала поищи ответ на docs.python.org | Теперь поищи в google.com | Код постить в dumpz.org | Хочешь задать вопрос - просто *задай* его! | Правила написания хорошего кода: http://➡.ws/pep8 | Логи: http://logs.python.su
[05:20:10] fuzzy is now away
[05:20:10] AlexZenon is now xa
[05:20:10] magic_pony is now online
[05:50:21] : Используемый вами псевдоним не зарегистрирован
[05:50:21] Сволота is now online
[05:50:21] Tony is now xa
[05:50:21] madmercen is now online
[05:50:21] fuzzy is now away
[05:50:21] AlexZenon is now xa
[05:50:21] magic_pony is now online
[05:50:21] : slav0nic установил(а) тему: python.su | Сначала поищи ответ на docs.python.org | Теперь поищи в google.com | Код постить в dumpz.org | Хочешь задать вопрос - просто *задай* его! | Правила написания хорошего кода: http://➡.ws/pep8 | Логи: http://logs.python.su
[06:20:32] : Используемый вами псевдоним не зарегистрирован
[06:20:32] Сволота is now online
[06:20:32] Tony is now xa
[06:20:32] fuzzy is now away
[06:20:32] magic_pony is now online
[06:20:32] madmercen is now online
[06:20:32] AlexZenon is now xa
[06:20:32] : slav0nic установил(а) тему: python.su | Сначала поищи ответ на docs.python.org | Теперь поищи в google.com | Код постить в dumpz.org | Хочешь задать вопрос - просто *задай* его! | Правила написания хорошего кода: http://➡.ws/pep8 | Логи: http://logs.python.su
[06:50:44] : Используемый вами псевдоним не зарегистрирован
[06:50:44] Сволота is now online
[06:50:44] Tony is now xa
[06:50:44] madmercen is now online
[06:50:44] fuzzy is now away
[06:50:44] AlexZenon is now xa
[06:50:44] magic_pony is now online
[06:50:44] : slav0nic установил(а) тему: python.su | Сначала поищи ответ на docs.python.org | Теперь поищи в google.com | Код постить в dumpz.org | Хочешь задать вопрос - просто *задай* его! | Правила написания хорошего кода: http://➡.ws/pep8 | Логи: http://logs.python.su
[07:20:55] : Используемый вами псевдоним не зарегистрирован
[07:20:55] Сволота is now online
[07:20:55] Tony is now xa
[07:20:55] madmercen is now online
[07:20:55] fuzzy is now away
[07:20:55] AlexZenon is now xa
[07:20:55] magic_pony is now online
[07:20:55] : slav0nic установил(а) тему: python.su | Сначала поищи ответ на docs.python.org | Теперь поищи в google.com | Код постить в dumpz.org | Хочешь задать вопрос - просто *задай* его! | Правила написания хорошего кода: http://➡.ws/pep8 | Логи: http://logs.python.su
[07:31:38] Сволота is now away
[07:32:12] Сволота is now online
[07:38:49] Сволота is now away
[07:48:50] Сволота is now xa
[08:18:58] : Используемый вами псевдоним не зарегистрирован
[08:18:58] Сволота is now xa
[08:18:58] Tony is now xa
[08:18:58] madmercen is now online
[08:18:58] fuzzy is now away
[08:18:58] magic_pony is now online
[08:18:58] AlexZenon is now xa
[08:18:58] : slav0nic установил(а) тему: python.su | Сначала поищи ответ на docs.python.org | Теперь поищи в google.com | Код постить в dumpz.org | Хочешь задать вопрос - просто *задай* его! | Правила написания хорошего кода: http://➡.ws/pep8 | Логи: http://logs.python.su
[08:21:04] mrDoctorWho is now online
[08:21:29] mrDoctorWho is now offline
[08:38:42] Сволота is now online
[08:46:59] Сволота is now away
[08:56:59] Сволота is now xa
[08:58:01] fuzzy is now away
[08:59:32] tranq is now online
[09:04:19] Сволота is now online
[09:12:31] Сволота is now away
[09:18:33] огыешсук is now online
[09:22:31] Сволота is now xa
[09:24:33] Tony is now online
[09:29:47] fuzzy is now away
[09:35:12] fuzzy is now away
[09:36:54] огыешсук is now online
[09:38:34] Сволота is now online
[09:43:54] огыешсук is now online
[09:46:06] fuzzy is now away
[09:53:51] Сволота is now away
[09:56:00] AlexZenon is now offline
[09:56:10] AlexZenon is now xa
[09:59:33] Tony is now away
[10:02:01] Сволота is now online
[10:07:07] Сволота is now away
[10:12:32] огыешсук is now online
[10:17:07] Сволота is now xa
[10:17:21] огыешсук is now online
[10:24:33] Tony is now xa
[10:27:56] SystemV is now online
[10:31:53] Сволота is now online
[10:32:28] огыешсук is now online
[10:34:30] огыешсук is now online
[10:37:36] AlexZenon is now online
[10:41:17] Tony is now online
[10:42:35] Сволота is now away
[10:45:13] огыешсук is now online
[10:49:11] Сволота is now online
[10:54:11] Сволота is now away
[10:54:18] огыешсук is now offline
[10:54:22] огыешсук is now online
[10:55:19] SystemV is now away
[10:59:51] Сволота is now online
[11:04:53] Сволота is now away
[11:06:25] огыешсук is now online
[11:06:41] Сволота is now online
[11:11:41] Сволота is now away
[11:13:21] Сволота is now online
[11:15:19] SystemV is now xa
[11:18:24] levsha is now online
[11:21:33] SystemV is now online
[11:25:19] Сволота is now away
[11:30:02] огыешсук is now online
[11:32:59] Tony is now away
[11:35:19] Сволота is now xa
[11:36:25] levsha is now offline
[11:36:34] levsha is now online
[11:38:40] levsha is now offline
[11:40:31] levsha is now online
[11:43:13] levsha is now offline
[11:44:00] levsha is now online
[11:44:36] SystemV is now away
[11:45:33] Сволота is now online
[11:46:11] SystemV is now online
[11:48:58] огыешсук is now online
[11:53:03] remo is now online
[11:56:16] fuzzy is now away
[11:56:18] fuzzy is now away
[11:56:25] Сволота is now away
[11:57:59] Tony is now xa
[11:59:06] огыешсук is now online
[11:59:59] огыешсук is now online
[12:02:27] огыешсук is now offline
[12:02:29] огыешсук is now online
[12:03:09] SystemV is now away
[12:04:32] remo is now away
[12:06:25] Сволота is now xa
[12:09:25] Сволота is now online
[12:14:29] Сволота is now away
[12:15:35] Сволота is now online
[12:17:49] огыешсук is now online
[12:18:02] огыешсук is now online
[12:18:46] tranq is now away
[12:18:46] tranq is now away
[12:20:37] Сволота is now away
[12:23:10] SystemV is now xa
[12:25:27] slav0nic is now online
[12:26:13] Сволота is now online
[12:27:53] levsha is now offline
[12:30:23] levsha is now online
[12:33:13] SystemV is now online
[12:34:28] levsha is now offline
[12:35:56] levsha is now online
[12:36:06] slav0nic is now away
[12:36:46] slav0nic is now online
[12:38:49] tranq is now away
[12:38:49] tranq is now online
[12:43:09] levsha is now away
[12:45:22] slav0nic is now away
[12:46:31] levsha is now online
[12:47:15] Сволота is now away
[12:48:16] tranq is now away
[12:48:16] tranq is now away
[12:52:51] Сволота is now online
[12:53:18] slav0nic is now online
[12:55:46] tranq is now away
[12:55:46] tranq is now online
[12:56:26] alebul is now online
[12:58:20] SystemV is now away
[12:58:35] SystemV is now online
[12:58:51] Сволота is now away
[12:59:03] огыешсук is now online
[13:00:47] tranq is now away
[13:00:47] tranq is now away
[13:01:38] tranq is now away
[13:01:38] tranq is now online
[13:06:39] tranq is now away
[13:06:39] tranq is now away
[13:08:51] Сволота is now xa
[13:10:13] tranq is now away
[13:11:02] slav0nic is now away
[13:11:33] tranq is now online
[13:12:21] fuzzy is now away
[13:12:34] огыешсук is now online
[13:15:37] Сволота is now online
[13:17:19] fuzzy is now away
[13:19:03] levsha is now away
[13:19:10] levsha is now online
[13:19:43] tranq is now away
[13:19:43] tranq is now away
[13:21:02] slav0nic is now xa
[13:24:28] slav0nic is now online
[13:26:40] tranq is now away
[13:26:40] tranq is now online
[13:27:54] fuzzy is now away
[13:27:56] fuzzy is now away
[13:33:07] SystemV is now away
[13:36:25] tranq is now away
[13:36:25] tranq is now away
[13:37:32] slav0nic is now away
[13:38:19] fuzzy is now away
[13:39:02] SystemV is now online
[13:42:31] fuzzy is now away
[13:42:43] tranq is now away
[13:42:43] tranq is now online
[13:47:33] slav0nic is now xa
[13:48:30] fuzzy is now online
[13:50:28] tranq is now online
[13:51:27] alebul is now offline
[13:54:08] fuzzy is now away
[13:54:20] fuzzy is now online
[13:56:34] fuzzy is now online
[13:56:54] slav0nic is now online
[13:59:30] tranq is now away
[13:59:30] tranq is now away
[14:01:35] fuzzy is now online
[14:02:54] tranq is now away
[14:02:54] tranq is now online
[14:08:03] tranq is now away
[14:08:03] tranq is now away
[14:08:23] levsha is now offline
[14:09:48] levsha is now online
[14:10:03] tranq is now away
[14:10:03] tranq is now online
[14:12:51] levsha is now offline
[14:12:54] levsha is now online
[14:13:35] Сволота is now away
[14:15:22] levsha is now offline
[14:18:36] Сволота is now online
[14:20:28] tranq is now away
[14:20:28] tranq is now away
[14:24:57] SystemV is now away
[14:26:36] opka is now online
[14:26:49] opka: шалом
[14:27:41] opka: есть питон, пиви и мускуль. Хочу получить из мускуля все записи (20k) но не рсазу, а по 2000 за раз. Как вообще организовать такое? Какой-то хитрый запрос имеется?
[14:27:54] opka: первые 2000 прочитать, потом еще 2000, потом еще :)
[14:29:47] opka: levsha прийди :)))
[14:30:05] Tony is now online
[14:31:39] Сволота is now away
[14:32:07] opka: думал, как-то к id привязаться
[14:33:36] opka: а хотя есть какой-то limitm,n
[14:34:10] tranq is now away
[14:34:10] tranq is now online
[14:34:15] Сволота is now online
[14:34:18] opka: о точняк :)
[14:36:47] огыешсук is now offline
[14:36:49] огыешсук is now online
[14:36:56] SystemV is now online
[14:42:33] opka: если кому-то надо будет, смотрите в peewee limit и offset ;)
[14:45:55] огыешсук is now online
[14:54:46] slav0nic is now away
[14:57:02] slav0nic is now online
[14:57:11] SystemV is now away
[14:58:06] fuzzy: использовать offset - дурной тон
[14:58:43] fuzzy: т.к. если у тебя записи добавляются/удаляются между запросами, то выйдет фигня
[15:05:18] tranq is now away
[15:05:18] tranq is now away
[15:06:30] tranq is now away
[15:06:30] tranq is now online
[15:07:52] opka: fuzzy: и шо таки делать?
[15:08:34] fuzzy: выбирать первых 2000, сортировать по ID. Смотреть на последний ID и второй батч выбирать WHERE ID > "Last_id" LIMIT 2000
[15:14:37] opka: ну ведь id могут идти не подряд, т.е. 148, 152,153,155 и не будет у нас 2000, а будет 1500 например
[15:14:51] opka: а, или нет
[15:15:23] opka: я примерно так и хотел делать вначале :)
[15:17:11] SystemV is now xa
[15:41:21] slav0nic is now away
[15:51:20] slav0nic is now xa
[15:55:30] remo is now online
[15:55:42] remo: sshpass -p "password" ssh -t -l root 192.168.1.1 "hostname;top -bn1 | grep 'Cpu(s)' | sed 's/.*, *\([0-9.]*\)%* id.*/\1/' | awk '{print 100 - $1}';
[15:55:43] opka is now offline
[15:55:47] Сволота is now away
[15:56:03] SystemV is now online
[15:56:05] remo: локально выполняется, а на удаленной - нет
[15:56:28] remo: awk: cmd. line:1: {print 100 - }
awk: cmd. line:1: ^ syntax error
[15:56:43] remo: не ясно, что ей собственно говоря не нравится ?
[15:58:55] Сволота is now online
[16:06:44] remo is now away
[16:10:08] fuzzy: видимо, не нравится, что после "-" ничего нет
[16:12:01] SystemV is now away
[16:17:06] SystemV is now online
[16:21:55] огыешсук is now online
[16:28:29] SystemV is now away
[16:41:35] slav0nic is now online
[16:46:50] fuzzy is now online
[16:47:12] fuzzy is now away
[16:48:30] SystemV is now xa
[16:56:37] fuzzy is now away
[17:07:35] SystemV is now online
[17:08:33] огыешсук is now online
[17:17:47] Tony is now away
[17:18:35] Tony is now online
[17:19:13] fuzzy is now away
[17:23:09] remo is now offline
[17:35:15] Сволота is now away
[17:36:08] Сволота is now online
[17:36:39] fuzzy is now away
[17:42:13] огыешсук is now online
[18:00:32] огыешсук is now online
[18:01:56] Сволота is now away
[18:03:24] Сволота is now online
[18:08:46] slav0nic is now away
[18:18:46] slav0nic is now xa
[18:30:03] Сволота is now away
[18:31:07] Сволота is now online
[18:36:10] Сволота is now away
[18:39:33] огыешсук is now online
[18:45:43] Tony is now away
[18:46:09] Сволота is now xa
[18:46:20] slav0nic is now online
[18:55:32] slav0nic is now away
[18:59:10] огыешсук is now online
[19:01:54] slav0nic is now online
[19:09:48] slav0nic is now away
[19:10:43] Tony is now xa
[19:19:48] slav0nic is now xa
[19:20:18] slav0nic is now online
[19:25:51] Сволота is now online
[19:30:17] dicos is now online
[19:30:53] Сволота is now away
[19:34:57] SystemV is now away
[19:35:22] SystemV is now online
[19:37:45] огыешсук is now online
[19:40:53] Сволота is now xa
[19:46:41] SystemV is now away
[19:52:57] Сволота is now online
[19:53:20] огыешсук is now online
[19:57:59] Сволота is now away
[19:59:35] Сволота is now online
[19:59:46] SystemV is now online
[20:00:52] dicos is now offline
[20:08:25] slav0nic is now away
[20:08:47] Сволота is now away
[20:09:03] огыешсук is now offline
[20:09:04] огыешсук is now online
[20:11:46] slav0nic is now online
[20:12:19] SystemV is now away
[20:15:13] Сволота is now online
[20:17:10] огыешсук is now online
[20:18:46] slav0nic is now away
[20:21:27] огыешсук is now online
[20:21:39] огыешсук is now offline
[20:25:21] SystemV is now online
[20:25:32] slav0nic is now online
[20:31:20] slav0nic is now away
[20:41:21] slav0nic is now xa
[20:41:26] slav0nic is now online
[20:49:42] slav0nic is now away
[20:59:42] slav0nic is now xa
[21:03:00] SystemV is now away
[21:04:34] slav0nic is now online
[21:04:59] SystemV is now online
[21:08:01] tranq is now away
[21:08:01] tranq is now away
[21:15:55] tranq is now away
[21:15:55] tranq is now online
[21:15:56] SystemV is now away
[21:17:03] SystemV is now online
[21:27:51] Сволота is now away
[21:30:55] SystemV is now away
[21:32:52] Сволота is now online
[21:34:50] slav0nic is now away
[21:36:12] slav0nic is now online
[21:37:56] remo is now online
[21:38:23] remo: \$
[21:38:40] remo is now offline
[21:41:44] Сволота is now away
[21:42:05] Сволота is now online
[21:49:37] SystemV is now online
[21:54:17] Сволота is now away
[21:55:19] fuzzy is now away
[21:56:29] Сволота is now online
[22:06:14] slav0nic is now away
[22:09:08] slav0nic is now online
[22:38:48] SystemV is now away
[22:39:08] tranq is now away
[22:39:08] tranq is now away
[22:52:05] tranq is now away
[22:52:05] tranq is now online
[22:54:26] SystemV is now online
[23:04:58] Сволота is now away
[23:06:52] slav0nic is now away
[23:13:05] Сволота is now online
[23:15:16] tranq is now away
[23:15:16] tranq is now away
[23:15:19] tranq is now away
[23:15:19] tranq is now online
[23:16:53] slav0nic is now xa
[23:25:52] slav0nic is now online
[23:27:54] tranq is now offline
[23:33:51] SystemV is now offline
[23:33:59] fuzzy is now away
[23:36:21] Сволота is now away
[23:38:04] Сволота is now online
[23:38:59] levsha is now online
[23:44:08] fuzzy is now away
[23:44:13] levsha is now away
[23:44:45] levsha is now online
[23:45:53] fuzzy is now away
[23:45:56] fuzzy is now away
[23:53:14] slav0nic is now away
[23:53:21] levsha is now offline
[23:53:41] levsha is now online
[23:58:53] Сволота is now away