Struct wdinfo::ubuntu::DBinfo

pub struct DBinfo { /* fields omitted */ }

struct with database information

Implementations

impl DBinfo

pub fn init(
    host: String,
    port: String,
    database: String,
    username: String,
    password: String
) -> Result<Self, &'static str>

initialization

pub fn local_clean(&mut self, pathstr: &str) -> Result<(), &'static str>

check local file: delete if exist

pub fn export(
    &mut self,
    skm: &str,
    tbl: &str,
    pathstr: &str
) -> Result<(), &'static str>

export table from database to local file * Greenplum on remote server in docker * Postgresql in remote server

pub fn import(
    &mut self,
    skm: &str,
    tbl: &str,
    pathstr: &str
) -> Result<(), &'static str>

import table from local file * Greenplum on remote server in docker * Postgresql in remote server

pub fn psql_chk_tbl_exist(
    &mut self,
    skm: &str,
    tbl: &str
) -> Result<bool, &'static str>

check table exsitence using psql * Greenplum on remote server in docker * Postgresql in remote server

pub fn psql_tbl_ddl_gen(
    &mut self,
    port: &str,
    skm: &str,
    tbl: &str,
    dllfile: &str
) -> Result<(), &'static str>

create table ddl using psql * Greenplum on remote server in docker * Postgresql in remote server

pub fn tbl_ddl_scp(&mut self, ddlfile: &str) -> Result<(), &'static str>

scp table ddl from remote to local

pub fn create_tbl_use_ddl(&mut self, ddlfile: &str) -> Result<(), &'static str>

create table using local ddl

pub fn psql_truncate_tbl(
    &mut self,
    skm: &str,
    tbl: &str
) -> Result<(), &'static str>

truncate table using psql * Greenplum on remote server in docker * Postgresql in remote server

pub fn tbl_ddl_clean(&mut self, ddlfile: &str) -> Result<(), &'static str>

table ddl clean from both remote and local