sqlite database bulk insert time data

Demand is such that every day can be divided into holidays (type code 1), days (type code 2). Holidays for the first 19 weeks of the year, for the first 20 weeks, 23 weeks, four weeks every day. Now I want to generate an automatic one-year sql statement. That date line that you want to automatically generate all the dates this year, the format is YYYY-MM-DD
Find Great God help ah!

Structure of the table below.


Column name: date data type: text primary key
Column name: type of data type integer

An example
date type
2012-01-01 1

2012-01-02 1

sql statement with the unfamiliar, seeking God help you big



Reply:
Well ... alone atop go ~