Exemplo n.º 1
0
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)")])
Exemplo n.º 2
0
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)")])
Exemplo n.º 3
0
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)")])
Exemplo n.º 4
0
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)")
    ])
Exemplo n.º 5
0
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)")
    ])
Exemplo n.º 6
0
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)")])
Exemplo n.º 7
0
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)")
    ])
Exemplo n.º 8
0
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)")
    ])
Exemplo n.º 9
0
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)")])
Exemplo n.º 10
0
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)")
    ])