split_database#
- sunpy.database.split_database(source_database, destination_database, *query_string)[source]#
Queries the source database with the query string, and moves the matched entries to the destination database. When this function is called, the
undo
feature is disabled for both databases.- Parameters:
source_database (
Database
) – A SunPyDatabase
object. This is the database on which the queries will be made.destination_database (
Database
) – A SunPyDatabase
object. This is the database to which the matched entries will be moved.*query_string (
list
) – A variable number of attributes that are chained together via the boolean AND operator. The | operator may be used between attributes to express the boolean OR operator.
Examples
The function call in the following example moves those entries from database1 to database2 which have
Instrument
= ‘AIA’ or ‘ERNE’.>>> from sunpy.database import Database, split_database >>> from sunpy.database.tables import display_entries >>> from sunpy.net import vso, attrs as a >>> database1 = Database('sqlite:///:memory:') >>> database2 = Database('sqlite:///:memory:') >>> client = vso.VSOClient() >>> qr = client.search(a.Time('2011-05-08', '2011-05-08 00:00:05'), response_format="legacy") >>> database1.add_from_vso_query_result(qr) >>> database1, database2 = split_database(database1, database2, ... a.Instrument.aia | a.Instrument.erne)