tkp.db.model – SQLAlchemy model definitions

The SQLAlchemy model definition.

revision history:

40 - Move image data to seperate table for speed 39 - Remove SQL insert functions, add dataset row to frequencyband table. Add image data. 38 - add varmetric table 37 - add forcedfits_count column to runningcatalog 36 - switch to SQLAlchemy schema initialisation

class tkp.db.model.Assocskyrgn(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

distance_deg

id

runcat

runcat_id

skyrgn

skyrgn_id

class tkp.db.model.Assocxtrsource(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

distance_arcsec

eta_int

f_datapoints

id

loglr

r

runcat

runcat_id

type

v_int

xtrsrc

xtrsrc_id

class tkp.db.model.Config(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

dataset

dataset_id

id

key

section

type

value

class tkp.db.model.Dataset(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

analysis_threshold

assoc_radius

backsize_x

backsize_y

configs

description

detection_threshold

frequencybands

id

images

margin_width

node

nodes

process_end_ts

process_start_ts

rerun

skyregions

type

class tkp.db.model.Extractedsource(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

chisq

decl

decl_err

decl_fit_err

det_sigma

error_radius

ew_sys_err

extract_type

extractedsources

f_int

f_int_err

f_peak

f_peak_err

ff_monitor

ff_monitor_id

ff_runcat

ff_runcat_id

fit_type

id

image

image_id

margin

node

nodes

ns_sys_err

pa

ra

ra_err

ra_fit_err

racosdecl

reduced_chisq

runningcatalogs

semimajor

semiminor

uncertainty_ew

uncertainty_ns

x

y

z

zone

class tkp.db.model.Frequencyband(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

dataset

dataset_id

freq_central

freq_high

freq_low

id

class tkp.db.model.Image(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

analysis_thresh

band

band_id

data

dataset

dataset_id

deltax

deltay

detection_thresh

extractedsources

fov_degrees

freq_bw

freq_eff

fwhm_arcsec

id

node

nodes

rb_pa

rb_smaj

rb_smin

rms_max

rms_min

rms_qc

skyrgn

skyrgn_id

stokes

tau

tau_time

taustart_ts

url

class tkp.db.model.ImageData(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

fits_data

fits_header

id

image

image_id

class tkp.db.model.Monitor(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

dataset

dataset_id

decl

id

name

ra

runcat

runcat_id

class tkp.db.model.Newsource(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

id

newsource_type

previous_limits_image

previous_limits_image_id

runcat

runcat_id

trigger_xtrsrc

trigger_xtrsrc_id

class tkp.db.model.Node(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

id

node

nodes

zone

zone_max

zone_max_incl

zone_min

zone_min_incl

zoneheight

class tkp.db.model.Rejection(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

comment

id

image

image_id

rejectreason

rejectreason_id

class tkp.db.model.Rejectreason(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

description

id

class tkp.db.model.Runningcatalog(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

assocskyrgns

avg_decl_err

avg_ra_err

avg_wdecl

avg_weight_decl

avg_weight_ra

avg_wra

datapoints

dataset

dataset_id

extractedsources

forcedfits_count

id

inactive

mon_src

newsources

runningcatalogfluxs

varmetric

wm_decl

wm_ra

wm_uncertainty_ew

wm_uncertainty_ns

x

xtrsrc

xtrsrc_id

y

z

zone

class tkp.db.model.RunningcatalogFlux(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

avg_f_int

avg_f_int_sq

avg_f_int_weight

avg_f_peak

avg_f_peak_sq

avg_f_peak_weight

avg_weighted_f_int

avg_weighted_f_int_sq

avg_weighted_f_peak

avg_weighted_f_peak_sq

band

band_id

f_datapoints

id

runcat

runcat_id

stokes

class tkp.db.model.Skyregion(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

centre_decl

centre_ra

dataset

dataset_id

id

images

x

xtr_radius

y

z

class tkp.db.model.Temprunningcatalog(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

avg_decl_err

avg_f_int

avg_f_int_sq

avg_f_int_weight

avg_f_peak

avg_f_peak_sq

avg_f_peak_weight

avg_ra_err

avg_wdecl

avg_weight_decl

avg_weight_ra

avg_weighted_f_int

avg_weighted_f_int_sq

avg_weighted_f_peak

avg_weighted_f_peak_sq

avg_wra

band

band_id

beam_pa

beam_semimaj

beam_semimin

datapoints

dataset

dataset_id

distance_arcsec

f_datapoints

id

inactive

margin

r

runcat

runcat_id

stokes

wm_decl

wm_ra

wm_uncertainty_ew

wm_uncertainty_ns

x

xtrsrc

xtrsrc_id

y

z

zone

class tkp.db.model.Varmetric(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

band

band_id

eta_int

id

lightcurve_avg

lightcurve_max

lightcurve_median

newsource

runcat

runcat_id

sigma_rms_max

sigma_rms_min

v_int

class tkp.db.model.Version(**kwargs)

A simple constructor that allows initialization from kwargs.

Sets attributes on the constructed instance using the names and values in kwargs.

Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.

name

value