def create_flat_table():
"""
The C{flat} table keeps track of which images have been flat fielded and
where the names of the resulting images.
"""
create_table("flat",
[pk_field("image_id", "INT"),
str_field("flatfile", 25),
str_field("outputfile", 50),
fk_field("image_id", "image(id)")])
def create_unzip_table():
"""
The C{unzip} table keeps track of which images have been unzipped and the
resulting filenames.
"""
create_table("unzip",
[pk_field("image_id", "INT"),
type_field("success", "TINYINT"),
str_field("outputfile", 50, True),
fk_field("image_id", "image(id)")])
def create_imstat_table():
"""
The C{imstat} table stores the result of running C{imstat} on each image.
"""
create_table("imstat",
[pk_field("image_id", "INT"),
int_field("min"),
int_field("max"),
int_field("mean"),
int_field("stddev"),
fk_field("image_id", "image(id)")])
def create_flat_table():
"""
The C{flat} table keeps track of which images have been flat fielded and
where the names of the resulting images.
"""
create_table("flat", [
pk_field("image_id", "INT"),
str_field("flatfile", 25),
str_field("outputfile", 50),
fk_field("image_id", "image(id)")
])
def create_unzip_table():
"""
The C{unzip} table keeps track of which images have been unzipped and the
resulting filenames.
"""
create_table("unzip", [
pk_field("image_id", "INT"),
type_field("success", "TINYINT"),
str_field("outputfile", 50, True),
fk_field("image_id", "image(id)")
])
def create_astrom_table():
"""
The C{astrom} table records the results of running C{AptAstrom} on each
image.
"""
create_table("astrom",
[pk_field("image_id", "INT"),
type_field("success", "TINYINT"),
float_field("smag"),
float_field("zmag"),
float_field("sky"),
fk_field("image_id", "image(id)")])
def create_imstat_table():
"""
The C{imstat} table stores the result of running C{imstat} on each image.
"""
create_table("imstat", [
pk_field("image_id", "INT"),
int_field("min"),
int_field("max"),
int_field("mean"),
int_field("stddev"),
fk_field("image_id", "image(id)")
])
def create_astrom_table():
"""
The C{astrom} table records the results of running C{AptAstrom} on each
image.
"""
create_table("astrom", [
pk_field("image_id", "INT"),
type_field("success", "TINYINT"),
float_field("smag"),
float_field("zmag"),
float_field("sky"),
fk_field("image_id", "image(id)")
])
def create_header_table():
"""
The C{header} table stores a selection of FITS header fields from each image.
"""
create_table("header",
[pk_field("image_id", "INT"),
float_field("temp"),
float_field("exposure"),
type_field("time", "DATETIME"),
float_field("sunzd"),
float_field("moonzd"),
float_field("moondist"),
float_field("moonphase"),
float_field("moonmag"),
float_field("ra"),
float_field("decl"),
float_field("lst"),
float_field("jd"),
float_field("crval1"),
float_field("crval2"),
fk_field("image_id", "image(id)")])
def create_header_table():
"""
The C{header} table stores a selection of FITS header fields from each image.
"""
create_table("header", [
pk_field("image_id", "INT"),
float_field("temp"),
float_field("exposure"),
type_field("time", "DATETIME"),
float_field("sunzd"),
float_field("moonzd"),
float_field("moondist"),
float_field("moonphase"),
float_field("moonmag"),
float_field("ra"),
float_field("decl"),
float_field("lst"),
float_field("jd"),
float_field("crval1"),
float_field("crval2"),
fk_field("image_id", "image(id)")
])
