Lines Matching full:date
20 # Format Appears as: [Date] [Time] - [Msg Level] - [Message]
27 WHERE %(table)s.%(time_column)s <= "%(date)s"
33 WHERE %(related_table)s.%(time_column)s <= "%(date)s"
43 WHERE %(related_table)s.%(time_column)s <= "%(date)s"
131 date, foreign_key=None,
150 @param related_table: Table with the date information we are selecting by.
154 @param date: End date of the information we are trying to delete.
155 @param time_column: Column that we want to use to compare the date to.
157 delete with the table with the date information.
162 to the table with the date information.
170 time_column=time_column, date=date)
173 # Deleting using a single JOIN to get the date information.
177 time_column=time_column, date=date)
189 time_column=time_column, date=date)
214 def _subtract_days(date, days_to_subtract): argument
216 Return a date (string) that is 'days' before 'date'
218 @param date: date (string) we are subtracting from.
221 date_obj = datetime.datetime.strptime(date, '%Y-%m-%d')
226 def _delete_all_data_before_date(date): argument
228 Delete all the database data before a given date.
234 days before date. Then we do the queries using tko_jobs and these
240 @param date: End date of the information we are trying to delete.
243 # First cleanup all afe_job related data (prior to 2 days before date).
245 afe_date = _subtract_days(date, 2)
285 # date.
287 date)
290 date, foreign_key=TEST_IDX)
293 date, foreign_key= 'test_id')
296 date)
299 date)
302 date)
305 date, foreign_key='job_id')
308 'tko_jobs', AFE_JOB_ID, date,
315 date, foreign_key='queue_entry_id',
321 date, foreign_key='job_id')
324 date, foreign_key='job_id')
327 date, foreign_key='job_id')
330 date, foreign_key='id')
333 date, foreign_key=JOB_IDX)
335 None, None, date)
348 parser.add_argument('date', help='Keep results newer than')
370 if not re.match(DATE_FORMAT_REGEX, args.date):
371 print 'DATE must be in yyyy-mm-dd format!'
379 _delete_all_data_before_date(args.date)