CatalogsDB::SqlStatements

CatalogsDB
SqlStatements

Functions
QString	all_catalog_view_body (const QString &fields, const QString &cat_prefix, int id)

const QString	create_catalog_registry (const QString &name)

QString	create_catalog_table (int id)

template<typename input_iterator >
QString	create_field_list (input_iterator begin, input_iterator end)

template<typename input_iterator >
QString	create_field_list (input_iterator begin, input_iterator end, const QString &prefix)

template<typename input_iterator >
QString	create_update_list (input_iterator begin, input_iterator end)

const QString	drop_catalog (int id)

const QString	dso_by_catalog (int catalog_id)

const QString	dso_by_name_and_catalog (const int id)

const QString	dso_by_oid_and_catalog (const int id)

const QString	dso_by_wildcard ()

const QString	dso_count_by_type (int catalog_id)

const QString	dso_general_query (const QString &where, const QString &order_by="")

const QString	dso_in_catalog_by_maglim (const int id)

template<typename input_iterator >
QStringList	from_it (input_iterator begin, input_iterator end)

const QString	insert_dso (int catalog_id)

const QString	insert_into_catalog_registry (const QString &name)

const QString	move_objects (const int id_1, const int id_2)

const QString	remove_dso (const int id)

const QString	set_catalog_all_objects (const int id)

Variables
const QString	_all_catalog_view_body

constexpr std::array< const char *, 8 >	_catalog_meta_fields

const QString	_create_catalog_list_table

const QString	_create_catalog_table

const QString	_create_master

const QString	_drop_catalog = "DROP TABLE cat_%1"

const QString	_dso_by_catalog = QString("SELECT %1 FROM cat_%2").arg(catalog_fields)

const QString	_dso_by_lim

const QString	_dso_by_maglim

const QString	_dso_by_maglim_and_type

const QString	_dso_by_name

const QString	_dso_by_name_exact = "SELECT %1 FROM master WHERE name = :name LIMIT 1"

const QString	_dso_by_oid = "SELECT %1 FROM master WHERE oid = :id LIMIT 1"

const QString	_dso_by_trixel

const QString	_dso_by_trixel_no_nulls

const QString	_dso_by_trixel_null_mag

const QString	_dso_by_wildcard

const QString	_dso_count_by_type = "SELECT type, COUNT(*) FROM %1 GROUP BY type"

const QString	_insert_catalog

const QString	_insert_dso

const QString	_insert_dso_template = "INSERT OR REPLACE INTO cat_%3 (%1) VALUES (%2)"

const QString	_remove_dso { "DELETE FROM cat_%1 WHERE oid = :oid" }

const QString	all_catalog_view = "all_catalogs"

constexpr std::array< const char *, 15 >	catalog_collumns

const auto	catalog_fields

const QString	catalog_prefix = "cat_"

const QString	colors_table = "catalog_colors"

const QString	create_catalog_list_table = create_catalog_registry("catalogs")

const QString	create_colors_table

const QString	create_master = QString(_create_master).arg(master_catalog_fields)

const QString	create_master_mag_index

const QString	create_master_name_index

const QString	create_master_trixel_index

const QString	create_master_type_index

const QString	create_meta_table

constexpr int	current_db_version = 3

constexpr int	default_htmesh_level = 3

const QString	drop_master = "DROP TABLE IF EXISTS master"

const QString	dso_by_lim = QString(_dso_by_lim).arg(object_fields).arg(mag_asc)

const QString	dso_by_maglim = QString(_dso_by_maglim).arg(object_fields).arg(mag_asc)

const QString	dso_by_maglim_and_type

const QString	dso_by_name = QString(_dso_by_name).arg(object_fields).arg(mag_asc)

const QString	dso_by_name_exact = QString(_dso_by_name_exact).arg(object_fields)

const QString	dso_by_oid = QString(_dso_by_oid).arg(object_fields)

const QString	dso_by_trixel = QString(_dso_by_trixel).arg(object_fields).arg(mag_desc)

const QString	dso_by_trixel_no_nulls = QString(_dso_by_trixel_no_nulls).arg(object_fields)

const QString	dso_by_trixel_null_mag = QString(_dso_by_trixel_null_mag).arg(object_fields)

const QString	dso_count_by_type_master = _dso_count_by_type.arg("master")

constexpr std::array< const char *, 13 >	dso_query_fields

const QString	empty_view = "SELECT NULL WHERE FALSE"

const QString	enable_disable_catalog

const QString	exists_catalog_by_id = "SELECT 1 FROM catalogs WHERE id = :id"

const QString	exists_master

const QString	get_all_catalog_ids = "SELECT id FROM catalogs ORDER BY id ASC"

const QString	get_catalog_by_id

const QString	get_catalog_ids

const QString	get_colors

const QString	get_first_catalog

const QString	get_meta = "SELECT version, htmesh_level, init FROM meta LIMIT 1"

const QString	insert_catalog = insert_into_catalog_registry("catalogs")

const QString	insert_color

const QString	mag_asc = "magnitude IS NOT NULL, magnitude ASC"

const QString	mag_desc = "magnitude IS NULL, magnitude DESC"

const QString	master_catalog = "master"

constexpr std::array< const char *, 14 >	master_catalog_collumns

const auto	master_catalog_fields

const auto	object_fields

const QString	remove_catalog = "DELETE FROM catalogs WHERE id = :id"

const QString	set_meta

const QString	update_catalog_meta

const QString	update_version = "UPDATE meta SET version = :version"

constexpr int	user_catalog_id = 0

const QString	user_catalog_name = "user"

Detailed Description

Holds a collection of hardcoded sql statements.

Function Documentation

◆ all_catalog_view_body()

QString CatalogsDB::SqlStatements::all_catalog_view_body	(	const QString &	fields,
		const QString &	cat_prefix,
		int	id )

inline

Definition at line 173 of file catalogsdb/sqlstatements.cpp.

◆ create_catalog_registry()

const QString CatalogsDB::SqlStatements::create_catalog_registry ( const QString & name )

inline

Definition at line 197 of file catalogsdb/sqlstatements.cpp.

◆ create_catalog_table()

QString CatalogsDB::SqlStatements::create_catalog_table ( int id )

inline

Definition at line 273 of file catalogsdb/sqlstatements.cpp.

◆ create_field_list() [1/2]

template<typename input_iterator >

QString CatalogsDB::SqlStatements::create_field_list	(	input_iterator	begin,
		input_iterator	end )

Definition at line 76 of file catalogsdb/sqlstatements.cpp.

◆ create_field_list() [2/2]

template<typename input_iterator >

QString CatalogsDB::SqlStatements::create_field_list	(	input_iterator	begin,
		input_iterator	end,
		const QString &	prefix )

Definition at line 84 of file catalogsdb/sqlstatements.cpp.

◆ create_update_list()

template<typename input_iterator >

QString CatalogsDB::SqlStatements::create_update_list	(	input_iterator	begin,
		input_iterator	end )

inline

Definition at line 216 of file catalogsdb/sqlstatements.cpp.

◆ drop_catalog()

const QString CatalogsDB::SqlStatements::drop_catalog ( int id )

inline

Definition at line 244 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_catalog()

const QString CatalogsDB::SqlStatements::dso_by_catalog ( int catalog_id )

inline

Definition at line 317 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_name_and_catalog()

const QString CatalogsDB::SqlStatements::dso_by_name_and_catalog ( const int id )

inline

Definition at line 361 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_oid_and_catalog()

const QString CatalogsDB::SqlStatements::dso_by_oid_and_catalog ( const int id )

inline

Definition at line 342 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_wildcard()

const QString CatalogsDB::SqlStatements::dso_by_wildcard ( )

inline

Definition at line 374 of file catalogsdb/sqlstatements.cpp.

◆ dso_count_by_type()

const QString CatalogsDB::SqlStatements::dso_count_by_type ( int catalog_id )

inline

Definition at line 420 of file catalogsdb/sqlstatements.cpp.

◆ dso_general_query()

const QString CatalogsDB::SqlStatements::dso_general_query	(	const QString &	where,
		const QString &	order_by = "" )

inline

Definition at line 379 of file catalogsdb/sqlstatements.cpp.

◆ dso_in_catalog_by_maglim()

const QString CatalogsDB::SqlStatements::dso_in_catalog_by_maglim ( const int id )

inline

Definition at line 401 of file catalogsdb/sqlstatements.cpp.

◆ from_it()

template<typename input_iterator >

QStringList CatalogsDB::SqlStatements::from_it	(	input_iterator	begin,
		input_iterator	end )

Definition at line 65 of file catalogsdb/sqlstatements.cpp.

◆ insert_dso()

const QString CatalogsDB::SqlStatements::insert_dso ( int catalog_id )

inline

Definition at line 431 of file catalogsdb/sqlstatements.cpp.

◆ insert_into_catalog_registry()

const QString CatalogsDB::SqlStatements::insert_into_catalog_registry ( const QString & name )

inline

Definition at line 210 of file catalogsdb/sqlstatements.cpp.

◆ move_objects()

const QString CatalogsDB::SqlStatements::move_objects	(	const int	id_1,
		const int	id_2 )

inline

Definition at line 158 of file catalogsdb/sqlstatements.cpp.

◆ remove_dso()

const QString CatalogsDB::SqlStatements::remove_dso ( const int id )

inline

Definition at line 437 of file catalogsdb/sqlstatements.cpp.

◆ set_catalog_all_objects()

const QString CatalogsDB::SqlStatements::set_catalog_all_objects ( const int id )

inline

Definition at line 163 of file catalogsdb/sqlstatements.cpp.

Variable Documentation

◆ _all_catalog_view_body

const QString CatalogsDB::SqlStatements::_all_catalog_view_body

Initial value:

=
    "SELECT %1, cl.precedence FROM %2%3 c INNER JOIN catalogs cl ON cl.id = "
    "c.catalog"

Definition at line 169 of file catalogsdb/sqlstatements.cpp.

◆ _catalog_meta_fields

constexpr std::array< const char *, 8 > CatalogsDB::SqlStatements::_catalog_meta_fields

constexpr

Initial value:

=
{
    "name",  "author",  "source",     "description",
    "color", "license", "maintainer", "timestamp"
}

Definition at line 230 of file catalogsdb/sqlstatements.cpp.

◆ _create_catalog_list_table

const QString CatalogsDB::SqlStatements::_create_catalog_list_table

Initial value:

= "CREATE TABLE IF NOT EXISTS %1 ("
        "id INTEGER PRIMARY KEY,"
        "name TEXT NOT NULL,"
        "precedence REAL NOT NULL,"
        "author TEXT DEFAULT NULL,"
        "source TEXT DEFAULT NULL,"
        "description TEXT DEFAULT NULL,"
        "mut INTEGER DEFAULT 0,"
        "version INTEGER DEFAULT -1,"
        "enabled INTEGER DEFAULT 1,"
        "color TEXT DEFAULT NULL,"
        "license TEXT DEFAULT NULL,"
        "maintainer TEXT DEFAULT NULL,"
        "timestamp DATETIME DEFAULT NULL)"

Definition at line 182 of file catalogsdb/sqlstatements.cpp.

◆ _create_catalog_table

const QString CatalogsDB::SqlStatements::_create_catalog_table

Initial value:

= "CREATE TABLE IF NOT EXISTS %1 ("
                                      "hash BLOB PRIMARY KEY,"
                                      "oid BLOB NOT NULL,"
                                      "type INTEGER NOT NULL,"
                                      "ra REAL NOT NULL,"
                                      "dec REAL NOT NULL,"
                                      "magnitude REAL DEFAULT NULL,"
                                      "name TEXT NOT NULL,"
                                      "long_name TEXT DEFAULT NULL,"
                                      "catalog_identifier TEXT DEFAULT NULL,"
                                      "major_axis REAL DEFAULT NULL,"
                                      "minor_axis REAL DEFAULT NULL,"
                                      "position_angle REAL DEFAULT NULL,"
                                      "flux REAL DEFAULT NULL,"
                                      "trixel INTEGER DEFAULT -1,"
                                      "res_1 BLOB DEFAULT NULL,"
                                      "res_2 BLOB DEFAULT NULL,"
                                      "res_3 BLOB DEFAULT NULL,"
                                      "res_4 BLOB DEFAULT NULL,"
                                      "catalog INTEGER NOT NULL,"
                                      "FOREIGN KEY (catalog) REFERENCES catalogs (id) "
                                      "ON DELETE CASCADE "
                                      "ON UPDATE CASCADE)"

Definition at line 249 of file catalogsdb/sqlstatements.cpp.

◆ _create_master

const QString CatalogsDB::SqlStatements::_create_master

Initial value:

= "CREATE TABLE master AS "
                               "SELECT %1 FROM "
                               "all_catalogs "
                               "GROUP BY oid "
                               "ORDER BY MAX(precedence)"

Definition at line 281 of file catalogsdb/sqlstatements.cpp.

◆ _drop_catalog

const QString CatalogsDB::SqlStatements::_drop_catalog = "DROP TABLE cat_%1"

Definition at line 243 of file catalogsdb/sqlstatements.cpp.

◆ _dso_by_catalog

const QString CatalogsDB::SqlStatements::_dso_by_catalog = QString("SELECT %1 FROM cat_%2").arg(catalog_fields)

Definition at line 316 of file catalogsdb/sqlstatements.cpp.

◆ _dso_by_lim

const QString CatalogsDB::SqlStatements::_dso_by_lim

Initial value:

= "SELECT %1 FROM master "

"ORDER BY %2 LIMIT :limit"

Definition at line 396 of file catalogsdb/sqlstatements.cpp.

◆ _dso_by_maglim

const QString CatalogsDB::SqlStatements::_dso_by_maglim

Initial value:

= "SELECT %1 FROM master WHERE magnitude < :maglim "

"ORDER BY %2 LIMIT :limit"

Definition at line 391 of file catalogsdb/sqlstatements.cpp.

◆ _dso_by_maglim_and_type

const QString CatalogsDB::SqlStatements::_dso_by_maglim_and_type

Initial value:

=
    "SELECT %1 FROM master WHERE type = :type AND magnitude < :maglim "
    "ORDER BY %2 LIMIT :limit"

Definition at line 410 of file catalogsdb/sqlstatements.cpp.

◆ _dso_by_name

const QString CatalogsDB::SqlStatements::_dso_by_name

Initial value:

=
    "SELECT %1, name like \"%\" || :name || \"%\" AS in_name, long_name like "
    "\"%\" || :name || \"%\" AS in_lname FROM master WHERE in_name "
    "OR in_lname "
    "ORDER BY name, long_name, "
    "%2 LIMIT :limit"

Definition at line 349 of file catalogsdb/sqlstatements.cpp.

◆ _dso_by_name_exact

const QString CatalogsDB::SqlStatements::_dso_by_name_exact = "SELECT %1 FROM master WHERE name = :name LIMIT 1"

Definition at line 356 of file catalogsdb/sqlstatements.cpp.

◆ _dso_by_oid

const QString CatalogsDB::SqlStatements::_dso_by_oid = "SELECT %1 FROM master WHERE oid = :id LIMIT 1"

Definition at line 338 of file catalogsdb/sqlstatements.cpp.

◆ _dso_by_trixel

const QString CatalogsDB::SqlStatements::_dso_by_trixel

Initial value:

= "SELECT %1 FROM master WHERE trixel = "

":trixel ORDER BY %2"

Definition at line 324 of file catalogsdb/sqlstatements.cpp.

◆ _dso_by_trixel_no_nulls

const QString CatalogsDB::SqlStatements::_dso_by_trixel_no_nulls

Initial value:

= "SELECT %1 FROM master WHERE trixel = "
                                        ":trixel AND magnitude IS NOT NULL ORDER"
                                        " BY magnitude DESC"

Definition at line 333 of file catalogsdb/sqlstatements.cpp.

◆ _dso_by_trixel_null_mag

const QString CatalogsDB::SqlStatements::_dso_by_trixel_null_mag

Initial value:

= "SELECT %1 FROM master WHERE trixel = "

":trixel AND magnitude IS NULL"

Definition at line 329 of file catalogsdb/sqlstatements.cpp.

◆ _dso_by_wildcard

const QString CatalogsDB::SqlStatements::_dso_by_wildcard

Initial value:

= "SELECT %1 FROM master WHERE name LIKE :wildcard LIMIT "

":limit ORDER BY CAST(name AS INTEGER)"

Definition at line 371 of file catalogsdb/sqlstatements.cpp.

◆ _dso_count_by_type

const QString CatalogsDB::SqlStatements::_dso_count_by_type = "SELECT type, COUNT(*) FROM %1 GROUP BY type"

Definition at line 417 of file catalogsdb/sqlstatements.cpp.

◆ _insert_catalog

const QString CatalogsDB::SqlStatements::_insert_catalog

Initial value:

=
    "INSERT OR IGNORE INTO %1 (id, name, mut, enabled, precedence, author, source, "
    "description, version, color, license, maintainer, timestamp) "
    "VALUES (:id, :name, :mut, :enabled, :precedence, :author, :source, :description, "
    ":version, :color, :license, :maintainer, :timestamp)"

Definition at line 204 of file catalogsdb/sqlstatements.cpp.

◆ _insert_dso

const QString CatalogsDB::SqlStatements::_insert_dso

Initial value:

=
    QString(_insert_dso_template)
    .arg(catalog_fields)
    .arg(create_field_list(catalog_collumns.begin(), catalog_collumns.end(), ":"))

Definition at line 426 of file catalogsdb/sqlstatements.cpp.

◆ _insert_dso_template

const QString CatalogsDB::SqlStatements::_insert_dso_template = "INSERT OR REPLACE INTO cat_%3 (%1) VALUES (%2)"

Definition at line 425 of file catalogsdb/sqlstatements.cpp.

◆ _remove_dso

const QString CatalogsDB::SqlStatements::_remove_dso { "DELETE FROM cat_%1 WHERE oid = :oid" }

Definition at line 436 of file catalogsdb/sqlstatements.cpp.

◆ all_catalog_view

const QString CatalogsDB::SqlStatements::all_catalog_view = "all_catalogs"

Definition at line 35 of file catalogsdb/sqlstatements.cpp.

◆ catalog_collumns

constexpr std::array< const char *, 15 > CatalogsDB::SqlStatements::catalog_collumns

constexpr

Initial value:

=
{
    "hash",       "oid",        "type",
    "ra",         "dec",        "magnitude",
    "name",       "long_name",  "catalog_identifier",
    "major_axis", "minor_axis", "position_angle",
    "flux",       "trixel",     "catalog"
}

Definition at line 98 of file catalogsdb/sqlstatements.cpp.

◆ catalog_fields

const auto CatalogsDB::SqlStatements::catalog_fields

Initial value:

create_field_list(catalog_collumns.begin(), catalog_collumns.end())

Definition at line 107 of file catalogsdb/sqlstatements.cpp.

◆ catalog_prefix

const QString CatalogsDB::SqlStatements::catalog_prefix = "cat_"

Definition at line 29 of file catalogsdb/sqlstatements.cpp.

◆ colors_table

const QString CatalogsDB::SqlStatements::colors_table = "catalog_colors"

Definition at line 36 of file catalogsdb/sqlstatements.cpp.

◆ create_catalog_list_table

const QString CatalogsDB::SqlStatements::create_catalog_list_table = create_catalog_registry("catalogs")

Definition at line 202 of file catalogsdb/sqlstatements.cpp.

◆ create_colors_table

const QString CatalogsDB::SqlStatements::create_colors_table

Initial value:

=
    QString("CREATE TABLE IF NOT EXISTS %1 (catalog INTEGER NOT "
            "NULL, scheme TEXT NOT NULL, color TEXT NOT NULL, UNIQUE(catalog, scheme, "
            "color))")
    .arg(colors_table)

Definition at line 49 of file catalogsdb/sqlstatements.cpp.

◆ create_master

const QString CatalogsDB::SqlStatements::create_master = QString(_create_master).arg(master_catalog_fields)

Definition at line 287 of file catalogsdb/sqlstatements.cpp.

◆ create_master_mag_index

const QString CatalogsDB::SqlStatements::create_master_mag_index

Initial value:

"CREATE INDEX master_mag ON master(magnitude ASC)"

Definition at line 293 of file catalogsdb/sqlstatements.cpp.

◆ create_master_name_index

const QString CatalogsDB::SqlStatements::create_master_name_index

Initial value:

=
    "CREATE INDEX master_name ON master(name "
    "COLLATE NOCASE ASC, long_name COLLATE NOCASE ASC, "
    "magnitude ASC)"

Definition at line 297 of file catalogsdb/sqlstatements.cpp.

◆ create_master_trixel_index

const QString CatalogsDB::SqlStatements::create_master_trixel_index

Initial value:

=
    "CREATE INDEX master_trixel_mag ON master(trixel ASC, magnitude DESC, major_axis "
    "ASC)"

Definition at line 289 of file catalogsdb/sqlstatements.cpp.

◆ create_master_type_index

const QString CatalogsDB::SqlStatements::create_master_type_index

Initial value:

"CREATE INDEX master_mag_type ON master(type, magnitude ASC)"

Definition at line 295 of file catalogsdb/sqlstatements.cpp.

◆ create_meta_table

const QString CatalogsDB::SqlStatements::create_meta_table

Initial value:

=
    "CREATE TABLE IF NOT EXISTS meta (version INTEGER NOT "
    "NULL, htmesh_level INTEGER NOT NULL, init INTEGER NOT NULL)"

Definition at line 39 of file catalogsdb/sqlstatements.cpp.

◆ current_db_version

constexpr int CatalogsDB::SqlStatements::current_db_version = 3

constexpr

Definition at line 30 of file catalogsdb/sqlstatements.cpp.

◆ default_htmesh_level

constexpr int CatalogsDB::SqlStatements::default_htmesh_level = 3

constexpr

Definition at line 31 of file catalogsdb/sqlstatements.cpp.

◆ drop_master

const QString CatalogsDB::SqlStatements::drop_master = "DROP TABLE IF EXISTS master"

Definition at line 279 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_lim

const QString CatalogsDB::SqlStatements::dso_by_lim = QString(_dso_by_lim).arg(object_fields).arg(mag_asc)

Definition at line 399 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_maglim

const QString CatalogsDB::SqlStatements::dso_by_maglim = QString(_dso_by_maglim).arg(object_fields).arg(mag_asc)

Definition at line 394 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_maglim_and_type

const QString CatalogsDB::SqlStatements::dso_by_maglim_and_type

Initial value:

QString(_dso_by_maglim_and_type).arg(object_fields).arg(mag_asc)

Definition at line 414 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_name

const QString CatalogsDB::SqlStatements::dso_by_name = QString(_dso_by_name).arg(object_fields).arg(mag_asc)

Definition at line 358 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_name_exact

const QString CatalogsDB::SqlStatements::dso_by_name_exact = QString(_dso_by_name_exact).arg(object_fields)

Definition at line 359 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_oid

const QString CatalogsDB::SqlStatements::dso_by_oid = QString(_dso_by_oid).arg(object_fields)

Definition at line 340 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_trixel

const QString CatalogsDB::SqlStatements::dso_by_trixel = QString(_dso_by_trixel).arg(object_fields).arg(mag_desc)

Definition at line 327 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_trixel_no_nulls

const QString CatalogsDB::SqlStatements::dso_by_trixel_no_nulls = QString(_dso_by_trixel_no_nulls).arg(object_fields)

Definition at line 336 of file catalogsdb/sqlstatements.cpp.

◆ dso_by_trixel_null_mag

const QString CatalogsDB::SqlStatements::dso_by_trixel_null_mag = QString(_dso_by_trixel_null_mag).arg(object_fields)

Definition at line 331 of file catalogsdb/sqlstatements.cpp.

◆ dso_count_by_type_master

const QString CatalogsDB::SqlStatements::dso_count_by_type_master = _dso_count_by_type.arg("master")

Definition at line 418 of file catalogsdb/sqlstatements.cpp.

◆ dso_query_fields

constexpr std::array< const char *, 13 > CatalogsDB::SqlStatements::dso_query_fields

constexpr

Initial value:

= { "oid",
    "type",
    "ra",
    "dec",
    "magnitude",
    "name",
    "long_name",
    "catalog_identifier",
    "major_axis",
    "minor_axis",
    "position_angle",
    "flux",
    "catalog"
}

The standard fields to query when loading objects from the db into kstars.

Definition at line 133 of file catalogsdb/sqlstatements.cpp.

◆ empty_view

const QString CatalogsDB::SqlStatements::empty_view = "SELECT NULL WHERE FALSE"

Definition at line 179 of file catalogsdb/sqlstatements.cpp.

◆ enable_disable_catalog

const QString CatalogsDB::SqlStatements::enable_disable_catalog

Initial value:

"UPDATE catalogs SET enabled = :enabled WHERE id = :id"

Definition at line 155 of file catalogsdb/sqlstatements.cpp.

◆ exists_catalog_by_id

const QString CatalogsDB::SqlStatements::exists_catalog_by_id = "SELECT 1 FROM catalogs WHERE id = :id"

Definition at line 310 of file catalogsdb/sqlstatements.cpp.

◆ exists_master

const QString CatalogsDB::SqlStatements::exists_master

Initial value:

"SELECT name FROM sqlite_master WHERE type='table' AND name='master';"

Definition at line 312 of file catalogsdb/sqlstatements.cpp.

◆ get_all_catalog_ids

const QString CatalogsDB::SqlStatements::get_all_catalog_ids = "SELECT id FROM catalogs ORDER BY id ASC"

Definition at line 154 of file catalogsdb/sqlstatements.cpp.

◆ get_catalog_by_id

const QString CatalogsDB::SqlStatements::get_catalog_by_id

Initial value:

= "SELECT id, name, precedence, author, source, "
                                  "description, mut, enabled, version, color, license, "
                                  "maintainer, timestamp FROM catalogs WHERE id = :id"

Definition at line 306 of file catalogsdb/sqlstatements.cpp.

◆ get_catalog_ids

const QString CatalogsDB::SqlStatements::get_catalog_ids

Initial value:

"SELECT id FROM catalogs WHERE enabled = 1 ORDER BY id ASC"

Definition at line 152 of file catalogsdb/sqlstatements.cpp.

◆ get_colors

const QString CatalogsDB::SqlStatements::get_colors

Initial value:

QString("SELECT catalog, scheme, color FROM %1").arg(colors_table)

Definition at line 55 of file catalogsdb/sqlstatements.cpp.

◆ get_first_catalog

const QString CatalogsDB::SqlStatements::get_first_catalog

Initial value:

= "SELECT id, name, precedence, author, source, "
                                  "description, mut, enabled, version, color, license, "
                                  "maintainer, timestamp FROM catalogs LIMIT 1"

Definition at line 302 of file catalogsdb/sqlstatements.cpp.

◆ get_meta

const QString CatalogsDB::SqlStatements::get_meta = "SELECT version, htmesh_level, init FROM meta LIMIT 1"

Definition at line 44 of file catalogsdb/sqlstatements.cpp.

◆ insert_catalog

const QString CatalogsDB::SqlStatements::insert_catalog = insert_into_catalog_registry("catalogs")

Definition at line 241 of file catalogsdb/sqlstatements.cpp.

◆ insert_color

const QString CatalogsDB::SqlStatements::insert_color

Initial value:

=
    QString("INSERT INTO %1 (catalog, scheme, color) VALUES (:catalog, :scheme, :color) "
            "ON CONFLICT(catalog, scheme, color) DO UPDATE SET color = :color")
    .arg(colors_table)

Definition at line 58 of file catalogsdb/sqlstatements.cpp.

◆ mag_asc

const QString CatalogsDB::SqlStatements::mag_asc = "magnitude IS NOT NULL, magnitude ASC"

Definition at line 21 of file catalogsdb/sqlstatements.cpp.

◆ mag_desc

const QString CatalogsDB::SqlStatements::mag_desc = "magnitude IS NULL, magnitude DESC"

Definition at line 22 of file catalogsdb/sqlstatements.cpp.

◆ master_catalog

const QString CatalogsDB::SqlStatements::master_catalog = "master"

Definition at line 34 of file catalogsdb/sqlstatements.cpp.

◆ master_catalog_collumns

constexpr std::array< const char *, 14 > CatalogsDB::SqlStatements::master_catalog_collumns

constexpr

Initial value:

= { "oid",
    "type",
    "ra",
    "dec",
    "magnitude",
    "name",
    "long_name",
    "catalog_identifier",
    "major_axis",
    "minor_axis",
    "position_angle",
    "flux",
    "trixel",
    "catalog"
}

Definition at line 110 of file catalogsdb/sqlstatements.cpp.

◆ master_catalog_fields

const auto CatalogsDB::SqlStatements::master_catalog_fields

Initial value:

create_field_list(master_catalog_collumns.begin(), master_catalog_collumns.end())

Definition at line 126 of file catalogsdb/sqlstatements.cpp.

◆ object_fields

const auto CatalogsDB::SqlStatements::object_fields

Initial value:

create_field_list(dso_query_fields.begin(), dso_query_fields.end())

CatalogsDB::SqlStatements::dso_query_fields

constexpr std::array< const char *, 13 > dso_query_fields

The standard fields to query when loading objects from the db into kstars.

Definition catalogsdb/sqlstatements.cpp:133

Definition at line 148 of file catalogsdb/sqlstatements.cpp.

◆ remove_catalog

const QString CatalogsDB::SqlStatements::remove_catalog = "DELETE FROM catalogs WHERE id = :id"

Definition at line 242 of file catalogsdb/sqlstatements.cpp.

◆ set_meta

const QString CatalogsDB::SqlStatements::set_meta

Initial value:

= "INSERT INTO meta (version, htmesh_level, init) VALUES "

"(:version, :htmesh_level, :init)"

Definition at line 45 of file catalogsdb/sqlstatements.cpp.

◆ update_catalog_meta

const QString CatalogsDB::SqlStatements::update_catalog_meta

Initial value:

=
    QString("UPDATE catalogs SET %1 WHERE id = :id")
    .arg(create_update_list(_catalog_meta_fields.cbegin(),
                            _catalog_meta_fields.cend()))

Definition at line 236 of file catalogsdb/sqlstatements.cpp.

◆ update_version

const QString CatalogsDB::SqlStatements::update_version = "UPDATE meta SET version = :version"

Definition at line 43 of file catalogsdb/sqlstatements.cpp.

◆ user_catalog_id

constexpr int CatalogsDB::SqlStatements::user_catalog_id = 0

constexpr

Definition at line 32 of file catalogsdb/sqlstatements.cpp.

◆ user_catalog_name

const QString CatalogsDB::SqlStatements::user_catalog_name = "user"

Definition at line 33 of file catalogsdb/sqlstatements.cpp.

KDE's Doxygen guidelines are available online.

Class Picker

Quick Links

About Kstars

CatalogsDB::SqlStatements

Functions

Variables

Detailed Description

Function Documentation

◆ all_catalog_view_body()

◆ create_catalog_registry()

◆ create_catalog_table()

◆ create_field_list() [1/2]

◆ create_field_list() [2/2]

◆ create_update_list()

◆ drop_catalog()

◆ dso_by_catalog()

◆ dso_by_name_and_catalog()

◆ dso_by_oid_and_catalog()

◆ dso_by_wildcard()

◆ dso_count_by_type()

◆ dso_general_query()

◆ dso_in_catalog_by_maglim()

◆ from_it()

◆ insert_dso()

◆ insert_into_catalog_registry()

◆ move_objects()

◆ remove_dso()

◆ set_catalog_all_objects()

Variable Documentation

◆ _all_catalog_view_body

◆ _catalog_meta_fields

◆ _create_catalog_list_table

◆ _create_catalog_table

◆ _create_master

◆ _drop_catalog

◆ _dso_by_catalog

◆ _dso_by_lim

◆ _dso_by_maglim

◆ _dso_by_maglim_and_type

◆ _dso_by_name

◆ _dso_by_name_exact

◆ _dso_by_oid

◆ _dso_by_trixel

◆ _dso_by_trixel_no_nulls

◆ _dso_by_trixel_null_mag

◆ _dso_by_wildcard

◆ _dso_count_by_type

◆ _insert_catalog

◆ _insert_dso

◆ _insert_dso_template

◆ _remove_dso

◆ all_catalog_view

◆ catalog_collumns

◆ catalog_fields

◆ catalog_prefix

◆ colors_table

◆ create_catalog_list_table

◆ create_colors_table

◆ create_master

◆ create_master_mag_index

◆ create_master_name_index

◆ create_master_trixel_index

◆ create_master_type_index

◆ create_meta_table

◆ current_db_version

◆ default_htmesh_level

◆ drop_master

◆ dso_by_lim

◆ dso_by_maglim

◆ dso_by_maglim_and_type

◆ dso_by_name

◆ dso_by_name_exact

◆ dso_by_oid

◆ dso_by_trixel

◆ dso_by_trixel_no_nulls

◆ dso_by_trixel_null_mag

◆ dso_count_by_type_master

◆ dso_query_fields

◆ empty_view

◆ enable_disable_catalog