-
Notifications
You must be signed in to change notification settings - Fork 0
/
psqlex.php
125 lines (120 loc) · 4.14 KB
/
psqlex.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
<?php
//http://localhost/dothanhlong.org/tools/postgresql_tool/psqlex.php?binfol=C%3A%5CProgram+Files+%28x86%29%5CPostgreSQL%5C9.2%5Cbin&port=5433&dbname=thuadat_dongnai_v4&outfol=D%3A%5Ctmp%5Csqlout&submit_dump2sql=
set_time_limit(0);
function convertstr($str){
$laststr=substr($str,(strlen($str)-1),1);
if($laststr!='\\'){
//return str_replace('\\','/',$str).'/';
return $str.'\\';
}else{
return $str;
}
}
if(isset($_GET['submit_dump2sql'])){
$binfol=$_GET['binfol'];
$port=$_GET['port'];
$uname=$_GET['uname'];
$dbname=$_GET['dbname'];
$outfol=convertstr($_GET['outfol']);
//echo $outfol.$dbname;
$batchfile='';
$batchfile.='set path='.$binfol.'
';
$batchfile.='call pg_dump -p '.$port.' -U '.$uname.' "'.$dbname.'" > "'.$outfol.$dbname.'.sql"
';
$batchfile.='pause';
$size = strlen($batchfile);
header('Content-Disposition: attachment; filename="'.$dbname.'2sql.bat"');
//header('Content-Type: BAT MIME TYPE or something like application/octet-stream');
header('Content-Type: BAT MIME TYPE');
header('Content-Lenght: '.$size);
echo $batchfile;
}
if(isset($_GET['submit_dump2backup'])){
$binfol=$_GET['binfol'];
$port=$_GET['port'];
$uname=$_GET['uname'];
$dbname=$_GET['dbname'];
$outfol=convertstr($_GET['outfol']);
//pg_dump -p 5433 -U postgres -f "D:\tmp\sqlout\thuadat_dongnai_v4.backup" "thuadat_dongnai_v4"
$batchfile='';
$batchfile.='set path='.$binfol.'
';
$batchfile.='call pg_dump -p '.$port.' -U '.$uname.' -f "'.$outfol.$dbname.'.backup" "'.$dbname.'"
';
$batchfile.='pause';
$size = strlen($batchfile);
header('Content-Disposition: attachment; filename="'.$dbname.'2backup.bat"');
//header('Content-Type: BAT MIME TYPE or something like application/octet-stream');
header('Content-Type: BAT MIME TYPE');
header('Content-Lenght: '.$size);
echo $batchfile;
}
if(isset($_GET['submit_sql2db'])){
$binfol=$_GET['binfol'];
$port=$_GET['port'];
$uname=$_GET['uname'];
$dbname=$_GET['dbname'];
$fname=$_GET['fname'];
$infol=convertstr($_GET['infol']);
//psql -p 5432 -U postgres -d thuadatq1 -q -f "C:\Users\dtlong\Desktop\thuadatq1.sql"
$batchfile='';
$batchfile.='set path='.$binfol.'
';
$batchfile.='call psql -p '.$port.' -U '.$uname.' -d '.$dbname.' -q -f "'.$infol.$fname.'"
';
$batchfile.='pause';
$size = strlen($batchfile);
header('Content-Disposition: attachment; filename="'.$dbname.'_sql2db.bat"');
//header('Content-Type: BAT MIME TYPE or something like application/octet-stream');
header('Content-Type: BAT MIME TYPE');
header('Content-Lenght: '.$size);
echo $batchfile;
}
if(isset($_GET['submit_backup2db'])){
$binfol=$_GET['binfol'];
$port=$_GET['port'];
$uname=$_GET['uname'];
$dbname=$_GET['dbname'];
$fname=$_GET['fname'];
$infol=convertstr($_GET['infol']);
//pg_restore -p 5432 -U postgres -d thuadatq1 "C:\Users\dtlong\Desktop\thudatq1.backup"
$batchfile='';
$batchfile.='set path='.$binfol.'
';
$batchfile.='call pg_restore -p '.$port.' -U '.$uname.' -d '.$dbname.' "'.$infol.$fname.'"
';
$batchfile.='pause';
$size = strlen($batchfile);
header('Content-Disposition: attachment; filename="'.$dbname.'_backup2db.bat"');
//header('Content-Type: BAT MIME TYPE or something like application/octet-stream');
header('Content-Type: BAT MIME TYPE');
header('Content-Lenght: '.$size);
echo $batchfile;
}
if(isset($_GET['submit_raster2pgsql'])){
$binfol=$_GET['binfol'];
$port=$_GET['port'];
$uname=$_GET['uname'];
$dbname=$_GET['dbname'];
$schema=$_GET['schema'];
$table=$_GET['table'];
$fname=$_GET['fname'];
$srid=$_GET['srid'];
$size=$_GET['size'];
$infol=convertstr($_GET['infol']);
//raster2pgsql.exe -s srid -I -C -M image -F -t size schema.table | psql -d database -U Username -p Port
$batchfile='';
$batchfile.='set path='.$binfol.'
';
$batchfile.='call raster2pgsql -s '.$srid.' -I -C -M '.$infol.$fname.' -F -t '.$size.' '.$schema.'.'.$table.' | psql -d '.$dbname.' -U '.$uname.' -p '.$port.'
';
$batchfile.='pause';
$size = strlen($batchfile);
header('Content-Disposition: attachment; filename="'.$fname.'_sql2db.bat"');
//header('Content-Type: BAT MIME TYPE or something like application/octet-stream');
header('Content-Type: BAT MIME TYPE');
header('Content-Lenght: '.$size);
echo $batchfile;
}
?>