Line data    Source code

       1              : #[cfg(test)]
       2              : mod pg_helpers_tests {
       3              :     use std::fs::File;
       4              : 
       5              :     use compute_api::spec::{ComputeSpec, GenericOption, GenericOptions, PgIdent};
       6              :     use compute_tools::pg_helpers::*;
       7              : 
       8              :     #[test]
       9            1 :     fn params_serialize() {
      10            1 :         let file = File::open("../libs/compute_api/tests/cluster_spec.json").unwrap();
      11            1 :         let spec: ComputeSpec = serde_json::from_reader(file).unwrap();
      12              : 
      13            1 :         assert_eq!(
      14            1 :             spec.cluster.databases.first().unwrap().to_pg_options(),
      15              :             "LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0 OWNER \"alexk\""
      16              :         );
      17            1 :         assert_eq!(
      18            1 :             spec.cluster.roles.first().unwrap().to_pg_options(),
      19              :             " LOGIN PASSWORD 'md56b1d16b78004bbd51fa06af9eda75972'"
      20              :         );
      21            1 :     }
      22              : 
      23              :     #[test]
      24            1 :     fn settings_serialize() {
      25            1 :         let file = File::open("../libs/compute_api/tests/cluster_spec.json").unwrap();
      26            1 :         let spec: ComputeSpec = serde_json::from_reader(file).unwrap();
      27              : 
      28            1 :         assert_eq!(
      29            1 :             spec.cluster.settings.as_pg_settings(),
      30              :             r#"fsync = off
      31              : wal_level = logical
      32              : hot_standby = on
      33              : autoprewarm = off
      34              : offload_lfc_interval_seconds = 20
      35              : neon.safekeepers = '127.0.0.1:6502,127.0.0.1:6503,127.0.0.1:6501'
      36              : wal_log_hints = on
      37              : log_connections = on
      38              : shared_buffers = 32768
      39              : port = 55432
      40              : max_connections = 100
      41              : max_wal_senders = 10
      42              : listen_addresses = '0.0.0.0'
      43              : wal_sender_timeout = 0
      44              : password_encryption = md5
      45              : maintenance_work_mem = 65536
      46              : max_parallel_workers = 8
      47              : max_worker_processes = 8
      48              : neon.tenant_id = 'b0554b632bd4d547a63b86c3630317e8'
      49              : max_replication_slots = 10
      50              : neon.timeline_id = '2414a61ffc94e428f14b5758fe308e13'
      51              : shared_preload_libraries = 'neon'
      52              : synchronous_standby_names = 'walproposer'
      53              : neon.pageserver_connstring = 'host=127.0.0.1 port=6400'
      54              : test.escaping = 'here''s a backslash \\ and a quote '' and a double-quote " hooray'
      55              : "#
      56              :         );
      57            1 :     }
      58              : 
      59              :     #[test]
      60            1 :     fn ident_pg_quote() {
      61            1 :         let ident: PgIdent = PgIdent::from("\"name\";\\n select 1;");
      62              : 
      63            1 :         assert_eq!(ident.pg_quote(), "\"\"\"name\"\";\\n select 1;\"");
      64            1 :     }
      65              : 
      66              :     #[test]
      67            1 :     fn ident_pg_quote_dollar() {
      68            1 :         let test_cases = vec![
      69            1 :             ("name", ("$x$name$x$", "xx")),
      70            1 :             ("name$", ("$x$name$$x$", "xx")),
      71            1 :             ("name$$", ("$x$name$$$x$", "xx")),
      72            1 :             ("name$$$", ("$x$name$$$$x$", "xx")),
      73            1 :             ("name$$$$", ("$x$name$$$$$x$", "xx")),
      74            1 :             ("name$x$", ("$xx$name$x$$xx$", "xxx")),
      75            1 :             ("x", ("$xx$x$xx$", "xxx")),
      76            1 :             ("xx", ("$xxx$xx$xxx$", "xxxx")),
      77            1 :             ("$x", ("$xx$$x$xx$", "xxx")),
      78            1 :             ("x$", ("$xx$x$$xx$", "xxx")),
      79            1 :             ("$x$", ("$xx$$x$$xx$", "xxx")),
      80            1 :             ("xx$", ("$xxx$xx$$xxx$", "xxxx")),
      81            1 :             ("$xx", ("$xxx$$xx$xxx$", "xxxx")),
      82            1 :             ("$xx$", ("$xxx$$xx$$xxx$", "xxxx")),
      83              :         ];
      84              : 
      85           15 :         for (input, expected) in test_cases {
      86           14 :             let (escaped, tag) = PgIdent::from(input).pg_quote_dollar();
      87           14 :             assert_eq!(escaped, expected.0);
      88           14 :             assert_eq!(tag, expected.1);
      89              :         }
      90            1 :     }
      91              : 
      92              :     #[test]
      93            1 :     fn generic_options_search() {
      94            1 :         let generic_options: GenericOptions = Some(vec![
      95            1 :             GenericOption {
      96            1 :                 name: "present_value".into(),
      97            1 :                 value: Some("value".into()),
      98            1 :                 vartype: "string".into(),
      99            1 :             },
     100            1 :             GenericOption {
     101            1 :                 name: "missed_value".into(),
     102            1 :                 value: None,
     103            1 :                 vartype: "int".into(),
     104            1 :             },
     105            1 :         ]);
     106            1 :         assert_eq!(generic_options.find("present_value"), Some("value".into()));
     107            1 :         assert_eq!(generic_options.find("missed_value"), None);
     108            1 :         assert_eq!(generic_options.find("invalid_value"), None);
     109              : 
     110            1 :         let empty_generic_options: GenericOptions = Some(vec![]);
     111            1 :         assert_eq!(empty_generic_options.find("present_value"), None);
     112            1 :         assert_eq!(empty_generic_options.find("missed_value"), None);
     113            1 :         assert_eq!(empty_generic_options.find("invalid_value"), None);
     114              : 
     115            1 :         let none_generic_options: GenericOptions = None;
     116            1 :         assert_eq!(none_generic_options.find("present_value"), None);
     117            1 :         assert_eq!(none_generic_options.find("missed_value"), None);
     118            1 :         assert_eq!(none_generic_options.find("invalid_value"), None);
     119            1 :     }
     120              : 
     121              :     #[test]
     122            1 :     fn test_escape_literal() {
     123            1 :         assert_eq!(escape_literal("test"), "'test'");
     124            1 :         assert_eq!(escape_literal("test'"), "'test'''");
     125            1 :         assert_eq!(escape_literal("test\\'"), "E'test\\\\'''");
     126            1 :         assert_eq!(escape_literal("test\\'\\'"), "E'test\\\\''\\\\'''");
     127            1 :     }
     128              : }