import mysql
import mysql.connector
import command
import datetime

def findarbs(startdate, enddate):
      con = mysql.connector.connect(user='root', password='root',
host='localhost',port='3306',database='testdb')
      cur = con.cursor()
      command = ("SELECT DISTINCT id, date FROM babyrop", WHERE 'date1'
      > ('%s') AND 'date2' < ('%s'), ORDER BY date asc % (startdate,
enddate))
print ('command')
cursor.execute(command)
result = cur.fetchone()
print (result)
while result is not None:
print (result[1])
result = cursor.fetchone()
cur = con.cursor()
cur.execute('select id, date weight from babyrop')

data = cursor.fetchall()
cur.close()
con.close()