/*
* Apache License
* Version 2.0, January 2004
* http://www.apache.org/licenses/
*
* TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION
*
* 1. Definitions.
*
* "License" shall mean the terms and conditions for use, reproduction,
* and distribution as defined by Sections 1 through 9 of this document.
*
* "Licensor" shall mean the copyright owner or entity authorized by
* the copyright owner that is granting the License.
*
* "Legal Entity" shall mean the union of the acting entity and all
* other entities that control, are controlled by, or are under common
* control with that entity. For the purposes of this definition,
* "control" means (i) the power, direct or indirect, to cause the
* direction or management of such entity, whether by contract or
* otherwise, or (ii) ownership of fifty percent (50%) or more of the
* outstanding shares, or (iii) beneficial ownership of such entity.
*
* "You" (or "Your") shall mean an individual or Legal Entity
* exercising permissions granted by this License.
*
* "Source" form shall mean the preferred form for making modifications,
* including but not limited to software source code, documentation
* source, and configuration files.
*
* "Object" form shall mean any form resulting from mechanical
* transformation or translation of a Source form, including but
* not limited to compiled object code, generated documentation,
* and conversions to other media types.
*
* "Work" shall mean the work of authorship, whether in Source or
* Object form, made available under the License, as indicated by a
* copyright notice that is included in or attached to the work
* (an example is provided in the Appendix below).
*
* "Derivative Works" shall mean any work, whether in Source or Object
* form, that is based on (or derived from) the Work and for which the
* editorial revisions, annotations, elaborations, or other modifications
* represent, as a whole, an original work of authorship. For the purposes
* of this License, Derivative Works shall not include works that remain
* separable from, or merely link (or bind by name) to the interfaces of,
* the Work and Derivative Works thereof.
*
* "Contribution" shall mean any work of authorship, including
* the original version of the Work and any modifications or additions
* to that Work or Derivative Works thereof, that is intentionally
* submitted to Licensor for inclusion in the Work by the copyright owner
* or by an individual or Legal Entity authorized to submit on behalf of
* the copyright owner. For the purposes of this definition, "submitted"
* means any form of electronic, verbal, or written communication sent
* to the Licensor or its representatives, including but not limited to
* communication on electronic mailing lists, source code control systems,
* and issue tracking systems that are managed by, or on behalf of, the
* Licensor for the purpose of discussing and improving the Work, but
* excluding communication that is conspicuously marked or otherwise
* designated in writing by the copyright owner as "Not a Contribution."
*
* "Contributor" shall mean Licensor and any individual or Legal Entity
* on behalf of whom a Contribution has been received by Licensor and
* subsequently incorporated within the Work.
*
* 2. Grant of Copyright License. Subject to the terms and conditions of
* this License, each Contributor hereby grants to You a perpetual,
* worldwide, non-exclusive, no-charge, royalty-free, irrevocable
* copyright license to reproduce, prepare Derivative Works of,
* publicly display, publicly perform, sublicense, and distribute the
* Work and such Derivative Works in Source or Object form.
*
* 3. Grant of Patent License. Subject to the terms and conditions of
* this License, each Contributor hereby grants to You a perpetual,
* worldwide, non-exclusive, no-charge, royalty-free, irrevocable
* (except as stated in this section) patent license to make, have made,
* use, offer to sell, sell, import, and otherwise transfer the Work,
* where such license applies only to those patent claims licensable
* by such Contributor that are necessarily infringed by their
* Contribution(s) alone or by combination of their Contribution(s)
* with the Work to which such Contribution(s) was submitted. If You
* institute patent litigation against any entity (including a
* cross-claim or counterclaim in a lawsuit) alleging that the Work
* or a Contribution incorporated within the Work constitutes direct
* or contributory patent infringement, then any patent licenses
* granted to You under this License for that Work shall terminate
* as of the date such litigation is filed.
*
* 4. Redistribution. You may reproduce and distribute copies of the
* Work or Derivative Works thereof in any medium, with or without
* modifications, and in Source or Object form, provided that You
* meet the following conditions:
*
* (a) You must give any other recipients of the Work or
* Derivative Works a copy of this License; and
*
* (b) You must cause any modified files to carry prominent notices
* stating that You changed the files; and
*
* (c) You must retain, in the Source form of any Derivative Works
* that You distribute, all copyright, patent, trademark, and
* attribution notices from the Source form of the Work,
* excluding those notices that do not pertain to any part of
* the Derivative Works; and
*
* (d) If the Work includes a "NOTICE" text file as part of its
* distribution, then any Derivative Works that You distribute must
* include a readable copy of the attribution notices contained
* within such NOTICE file, excluding those notices that do not
* pertain to any part of the Derivative Works, in at least one
* of the following places: within a NOTICE text file distributed
* as part of the Derivative Works; within the Source form or
* documentation, if provided along with the Derivative Works; or,
* within a display generated by the Derivative Works, if and
* wherever such third-party notices normally appear. The contents
* of the NOTICE file are for informational purposes only and
* do not modify the License. You may add Your own attribution
* notices within Derivative Works that You distribute, alongside
* or as an addendum to the NOTICE text from the Work, provided
* that such additional attribution notices cannot be construed
* as modifying the License.
*
* You may add Your own copyright statement to Your modifications and
* may provide additional or different license terms and conditions
* for use, reproduction, or distribution of Your modifications, or
* for any such Derivative Works as a whole, provided Your use,
* reproduction, and distribution of the Work otherwise complies with
* the conditions stated in this License.
*
* 5. Submission of Contributions. Unless You explicitly state otherwise,
* any Contribution intentionally submitted for inclusion in the Work
* by You to the Licensor shall be under the terms and conditions of
* this License, without any additional terms or conditions.
* Notwithstanding the above, nothing herein shall supersede or modify
* the terms of any separate license agreement you may have executed
* with Licensor regarding such Contributions.
*
* 6. Trademarks. This License does not grant permission to use the trade
* names, trademarks, service marks, or product names of the Licensor,
* except as required for reasonable and customary use in describing the
* origin of the Work and reproducing the content of the NOTICE file.
*
* 7. Disclaimer of Warranty. Unless required by applicable law or
* agreed to in writing, Licensor provides the Work (and each
* Contributor provides its Contributions) on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
* implied, including, without limitation, any warranties or conditions
* of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A
* PARTICULAR PURPOSE. You are solely responsible for determining the
* appropriateness of using or redistributing the Work and assume any
* risks associated with Your exercise of permissions under this License.
*
* 8. Limitation of Liability. In no event and under no legal theory,
* whether in tort (including negligence), contract, or otherwise,
* unless required by applicable law (such as deliberate and grossly
* negligent acts) or agreed to in writing, shall any Contributor be
* liable to You for damages, including any direct, indirect, special,
* incidental, or consequential damages of any character arising as a
* result of this License or out of the use or inability to use the
* Work (including but not limited to damages for loss of goodwill,
* work stoppage, computer failure or malfunction, or any and all
* other commercial damages or losses), even if such Contributor
* has been advised of the possibility of such damages.
*
* 9. Accepting Warranty or Additional Liability. While redistributing
* the Work or Derivative Works thereof, You may choose to offer,
* and charge a fee for, acceptance of support, warranty, indemnity,
* or other liability obligations and/or rights consistent with this
* License. However, in accepting such obligations, You may act only
* on Your own behalf and on Your sole responsibility, not on behalf
* of any other Contributor, and only if You agree to indemnify,
* defend, and hold each Contributor harmless for any liability
* incurred by, or claims asserted against, such Contributor by reason
* of your accepting any such warranty or additional liability.
*
* END OF TERMS AND CONDITIONS
*
* APPENDIX: How to apply the Apache License to your work.
*
* To apply the Apache License to your work, attach the following
* boilerplate notice, with the fields enclosed by brackets "[]"
* replaced with your own identifying information. (Don't include
* the brackets!) The text should be enclosed in the appropriate
* comment syntax for the file format. We also recommend that a
* file or class name and description of purpose be included on the
* same "printed page" as the copyright notice for easier
* identification within third-party archives.
*
* Copyright [2022] [pg-sync author(s)]
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
#[cfg(test)]
use test_env_helpers::*;
#[cfg(test)]
#[before_all]
mod tests {
use log::{debug, info};
use sqlparser::ast::{ColumnDef, HiveDistributionStyle, HiveFormat, Ident, ObjectName};
use sqlparser::ast::DataType::Text;
use sqlparser::ast::Statement::CreateTable;
use pg_sync;
use pg_sync::plan::{Error, Plan};
use pg_sync::settings::{Files, Settings};
fn before_all() {
pg_sync::setup_logger(log::LevelFilter::Debug).expect("Setting up logger failed with panic!.");
}
// #[test]
fn dummy_test_case() {
let mut settings = pg_sync::make_settings(&"pg-sync".to_string());
let mut client = pg_sync::db_connection::make_connection(&settings.postgresql);
if let is_schema_exist = client.query_one("SELECT EXISTS(SELECT 1 FROM information_schema.schemata WHERE schema_name = $1)", &[&"dummy_test_case"]).unwrap() {
let schema_status: bool = is_schema_exist.get(0);
debug!("schema_status; {}",schema_status);
}
let _ = client.execute(format!("CREATE SCHEMA {} AUTHORIZATION postgres", "dummy_test_case").as_str(), &[]);
let _ = client.execute(format!("SET search_path TO {}", "dummy_test_case").as_str(), &[]);
let _ = client.execute("create table test_table_1()", &[]);
}
#[test]
fn test_1_new_table() {
debug!("test_1_new_table");
let (settings, result) = extract_plan_from_schema_definition("data/schema.1.sql", "test_1".to_string());
info!("{:?}",result);
let mut client = pg_sync::db_connection::make_connection(&settings.postgresql);
let plan = correct_plan_for_schema_1();
assert_eq!(format!("{:?}", plan), format!("{:?}", result.as_ref().unwrap()));
info!("######################################################");
result.as_ref().unwrap().apply_plan_up(&mut client);
result.as_ref().unwrap().apply_plan_down(&mut client);
}
#[test]
fn test_2_add_new_table() {
debug!("test_2_add_new_table");
let (settings1, result1) = extract_plan_from_schema_definition("data/schema.2.1.sql", "test_2".to_string());
info!("result1: {:?}",result1);
let mut client = pg_sync::db_connection::make_connection(&settings1.postgresql);
info!("######################################################");
result1.as_ref().unwrap().apply_plan_up(&mut client);
info!("######################################################");
let (settings2, result2) = extract_plan_from_schema_definition("data/schema.2.2.sql", "test_2".to_string());
info!("result2: {:?}",result2);
let plan = correct_plan_for_schema_2_2();
assert_eq!(format!("{:?}", plan), format!("{:?}", result2.as_ref().unwrap()));
// info!("######################################################");
result2.as_ref().unwrap().apply_plan_up(&mut client);
result2.as_ref().unwrap().apply_plan_down(&mut client);
result1.as_ref().unwrap().apply_plan_down(&mut client);
}
// #[test]
fn test_3_drop_table() {
debug!("test_3_drop_table");
let (settings1, result1) = extract_plan_from_schema_definition("data/schema.3.1.sql", "public".to_string());
let mut client = pg_sync::db_connection::make_connection(&settings1.postgresql);
info!("######################################################");
result1.as_ref().unwrap().apply_plan_up(&mut client);
info!("######################################################");
let (settings2, result2) = extract_plan_from_schema_definition("data/schema.3.2.sql", "public".to_string());
info!("{:?}",result2);
// let mut client = pg_sync::db_connection::make_connection(&settings.postgresql);
info!("######################################################");
result2.as_ref().unwrap().apply_plan_up(&mut client);
result2.as_ref().unwrap().apply_plan_down(&mut client);
result1.as_ref().unwrap().apply_plan_down(&mut client);
// let plan = correct_plan_for_schema_2_2();
// assert_eq!(format!("{:?}", plan), format!("{:?}", result2.unwrap()))
}
fn extract_plan_from_schema_definition(file: &str, schema_name: String) -> (Settings, Result<Plan, Error>) {
let mut settings = pg_sync::make_settings(&"pg-sync".to_string());
settings.postgresql.schema = Some(schema_name);
settings.files = Some(Files {
file: Some(file.to_string()),
files: None,
folder: None,
});
let result = pg_sync::apply_file(&settings, pg_sync::db_connection::make_connection(&settings.postgresql));
(settings, result)
}
fn correct_plan_for_schema_1() -> Plan {
let mut plan = pg_sync::plan::Plan::new();
plan.schema_name = "test_1".to_string();
plan.schema_does_not_exist = true;
plan.table_names_all_from_file.push("table1".to_string());
plan.table_names_unique_from_file.push("table1".to_string());
plan.table_names_new.push("table1".to_string());
plan.table_statements_new.push(
CreateTable { or_replace: false, temporary: false, external: false, global: None, if_not_exists: false, name: ObjectName(vec![Ident { value: "table1".to_string(), quote_style: None }]), columns: vec![ColumnDef { name: Ident { value: "column11".to_string(), quote_style: None }, data_type: Text, collation: None, options: vec![] }], constraints: vec![], hive_distribution: HiveDistributionStyle::NONE, hive_formats: Some(HiveFormat { row_format: None, storage: None, location: None }), table_properties: vec![], with_options: vec![], file_format: None, location: None, query: None, without_rowid: false, like: None, engine: None, default_charset: None, collation: None, on_commit: None }
);
plan.sql_statements_for_step_up.push("CREATE TABLE table1 (column11 TEXT)".to_string());
plan.sql_statements_for_step_down.push("DROP TABLE table1".to_string());
plan
}
fn correct_plan_for_schema_2_2() -> Plan {
let mut plan = pg_sync::plan::Plan::new();
plan.schema_name = "test_2".to_string();
plan.schema_does_not_exist = false;
plan.table_names_all_from_file.push("table21".to_string());
plan.table_names_all_from_file.push("table22".to_string());
plan.table_names_all_from_db.push("table21".to_string());
plan.table_names_unique_from_file.push("table21".to_string());
plan.table_names_unique_from_file.push("table22".to_string());
plan.table_names_existing.push("table21".to_string());
plan.table_names_unchanged.push("table21".to_string());
plan.table_names_new.push("table22".to_string());
plan.table_statements_new.push(
CreateTable { or_replace: false, temporary: false, external: false, global: None, if_not_exists: false, name: ObjectName(vec![Ident { value: "table22".to_string(), quote_style: None }]), columns: vec![ColumnDef { name: Ident { value: "column221".to_string(), quote_style: None }, data_type: Text, collation: None, options: vec![] }], constraints: vec![], hive_distribution: HiveDistributionStyle::NONE, hive_formats: Some(HiveFormat { row_format: None, storage: None, location: None }), table_properties: vec![], with_options: vec![], file_format: None, location: None, query: None, without_rowid: false, like: None, engine: None, default_charset: None, collation: None, on_commit: None }
);
plan.sql_statements_for_step_up.push("CREATE TABLE table22 (column221 TEXT)".to_string());
plan.sql_statements_for_step_down.push("DROP TABLE table22".to_string());
plan
}
}