SELECT COUNT(id) FROM content WHERE uploads = FROM_UNIXTIME(<unix timestamp>, '%Y-%m-%d');
SELECT COUNT(id) FROM content WHERE uploads BETWEEN FROM_UNIXTIME(1458472109, '%Y-%m-%d') AND DATE_ADD(FROM_UNIXTIME(1458472109, '%Y-%m-%d'), INTERVAL 1 DAY);
import xlwt
from datetime import datetime
style0 = xlwt.easyxf('font: name Times New Roman, color-index red, bold on',
num_format_str='#,##0.00')
style1 = xlwt.easyxf(num_format_str='D-MMM-YY')
wb = xlwt.Workbook()
ws = wb.add_sheet('A Test Sheet')
ws.write(0, 0, 1234.56, style0)
ws.write(1, 0, datetime.now(), style1)
ws.write(2, 0, 1)
ws.write(2, 1, 1)
ws.write(2, 2, xlwt.Formula("A3+B3"))
wb.save('example.xls')
>>> def get_ip():
... for a in range(226):
... for b in range(1,225):
... ip = '127.0.{a}.{b}'.format(a=a, b=b)
... yield ip
...
>>> get_ip()
<generator object get_ip at 0x101d5ea50>
>>> my_ips = get_ip()
А машины-воркеры бы брали очередной адрес после отработки предыдущего как-то так:
>>> next(my_ips)
'127.0.0.1'
>>> next(my_ips)
'127.0.0.2'
>>> next(my_ips)
'127.0.0.3'
>>> next(my_ips)
'127.0.0.4'
>>> import random
>>> M,N = 5,6
>>> matrix = [[random.randrange(0,10) for y in range(M)] for x in range(N)]
>>> matrix
[[0, 3, 1, 3, 5], [5, 8, 8, 0, 5], [8, 9, 8, 5, 2], [7, 7, 3, 9, 9], [0, 1, 1, 3, 8], [5, 1, 1, 4, 6]]
>>> for im in range(N):
... print matrix[im]
...
[0, 3, 1, 3, 5]
[5, 8, 8, 0, 5]
[8, 9, 8, 5, 2]
[7, 7, 3, 9, 9]
[0, 1, 1, 3, 8]
[5, 1, 1, 4, 6]
>>> def find_max(m):
... max_sum = 0
... index = -1
... for x in range(N):
... if sum(m[x])>max_sum:
... max_sum=sum(m[x])
... index=x
... return max_sum, index
...
>>> find_max(matrix)
(35, 3)
>>> max_value,index = find_max(matrix)
>>> matrix.remove(matrix[index])
>>> for im in range(N):
... print matrix[im]
...
[0, 3, 1, 3, 5]
[5, 8, 8, 0, 5]
[8, 9, 8, 5, 2]
[0, 1, 1, 3, 8]
[5, 1, 1, 4, 6]
; ----------------------------------------------------------------------------
; helloworld.asm
;
; This is a Win32 console program that writes "Hello, World" on one line and
; then exits. It needs to be linked with a C library.
; ----------------------------------------------------------------------------
global _main
extern _printf
section .text
_main:
push message
call _printf
add esp, 4
ret
message:
db 'Hello, World', 10, 0
python скрипт.py &