SDSS: sdssdb
0.11.2
Site
Installation
Getting started with sdssdb
Making a simple query with
sdssdb
Available databases
Connecting to a Database
A note about passwords
Supported Profiles
Accessing the model classes
SQLAlchemy specifics
The case of
operationsdb
Where to go from here?
How to use sdssdb for target selection
The Galactic Genesis Survey
Using SQLAlchemy
Cone searches
Contributing to sdssdb
Contributing a new database or schema
Testing Your New Database
Should I use Peewee or SQLAlchemy?
API
Database connections
Peewee
SQLAlchemy
Utils
Changelog
Index
A
|
B
|
C
|
D
|
F
|
G
|
I
|
L
|
M
|
P
|
R
|
S
|
T
|
V
A
add_base() (sdssdb.connection.SQLADatabaseConnection method)
auto_reflect (sdssdb.connection.DatabaseConnection attribute)
B
BaseModel (class in sdssdb.peewee)
(class in sdssdb.sqlalchemy)
become() (sdssdb.connection.DatabaseConnection method)
become_admin() (sdssdb.connection.DatabaseConnection method)
become_user() (sdssdb.connection.DatabaseConnection method)
bulk_insert() (in module sdssdb.utils.ingest)
C
change_version() (sdssdb.connection.DatabaseConnection method)
cone_search() (sdssdb.peewee.BaseModel method)
(sdssdb.sqlalchemy.BaseModel method)
connect() (sdssdb.connection.DatabaseConnection method)
connect_from_parameters() (sdssdb.connection.DatabaseConnection method)
connected (sdssdb.connection.PeeweeDatabaseConnection property)
(sdssdb.connection.SQLADatabaseConnection attribute)
connection_params (sdssdb.connection.DatabaseConnection property)
(sdssdb.connection.PeeweeDatabaseConnection property)
(sdssdb.connection.SQLADatabaseConnection property)
copy_data() (in module sdssdb.utils.ingest)
create_adhoc_database() (in module sdssdb.utils.ingest)
create_engine() (sdssdb.connection.SQLADatabaseConnection method)
create_model_from_table() (in module sdssdb.utils.ingest)
create_schema_graph() (in module sdssdb.utils.schemadisplay)
D
DatabaseConnection (class in sdssdb.connection)
dbname (sdssdb.connection.DatabaseConnection attribute)
dbversion (sdssdb.connection.DatabaseConnection attribute)
display_table() (in module sdssdb.utils.registry)
DoesNotExist (sdssdb.peewee.BaseModel attribute)
drop_table() (in module sdssdb.utils.ingest)
F
file_to_db() (in module sdssdb.utils.ingest)
G
get_cluster_index() (in module sdssdb.utils.internals)
get_database_columns() (in module sdssdb.utils.internals)
get_fields() (sdssdb.connection.PeeweeDatabaseConnection method)
get_id() (sdssdb.sqlalchemy.BaseModel method)
get_introspector() (sdssdb.connection.PeeweeDatabaseConnection method)
get_model() (sdssdb.connection.PeeweeDatabaseConnection method)
get_primary_keys() (sdssdb.connection.PeeweeDatabaseConnection method)
get_row_count() (in module sdssdb.utils.internals)
get_unclustered_tables() (in module sdssdb.utils.internals)
I
is_table_locked() (in module sdssdb.utils.internals)
L
list_databases() (in module sdssdb.utils.registry)
list_profiles() (sdssdb.connection.DatabaseConnection static method)
M
module
sdssdb.connection
sdssdb.utils.ingest
sdssdb.utils.internals
sdssdb.utils.registry
P
PeeweeDatabaseConnection (class in sdssdb.connection)
post_connect() (sdssdb.connection.DatabaseConnection method)
prepare_bases() (sdssdb.connection.SQLADatabaseConnection method)
print_fields (sdssdb.sqlalchemy.BaseModel attribute)
R
reflect() (sdssdb.peewee.ReflectMeta method)
ReflectMeta (class in sdssdb.peewee)
reset_engine() (sdssdb.connection.SQLADatabaseConnection method)
S
sdssdb.connection
module
sdssdb.utils.ingest
module
sdssdb.utils.internals
module
sdssdb.utils.registry
module
set_profile() (sdssdb.connection.DatabaseConnection method)
SQLADatabaseConnection (class in sdssdb.connection)
T
to_csv() (in module sdssdb.utils.ingest)
V
vacuum() (in module sdssdb.utils.internals)
vacuum_all() (in module sdssdb.utils.internals)