create alias if not exists fs_list_roots as $$
import java.io.*;
import java.sql.*;
import org.h2.tools.*;
@CODE
ResultSet fs_list_roots()
{
SimpleResultSet rs = new SimpleResultSet();
rs.addColumn("NAME", Types.VARCHAR, 255, 0);
File files[] = File.listRoots();
for(int fi=0;fi<files.length;fi++){
rs.addRow(files[fi].getAbsolutePath());
}
return rs;
}
$$
call fs_list_roots();
create alias if not exists fs_list as $$
import java.io.*;
import java.sql.*;
import org.h2.tools.*;
@CODE
ResultSet fs_list(String path)
{
if( path == null )return null;
File file = new File(path);
SimpleResultSet rs = new SimpleResultSet();
rs.addColumn("NAME", Types.VARCHAR, 255, 0);
String files[] = file.list();
for(int fi=0;fi<files.length;fi++){
rs.addRow(files[fi]);
}
return rs;
}
$$
call fs_list('c:\');create alias if not exists fs_length as $$
import java.io.*;
@CODE
Long fs_length(String path)
{
if( path == null )return null;
File file = new File(path);
return new Long(file.length());
}
$$
select fs_length('c:\share\test.txt');create alias if not exists fs_last_modified as $$
import java.io.*;
import java.sql.*;
@CODE
Timestamp fs_last_modified(String path)
{
if( path == null )return null;
File file = new File(path);
return new Timestamp(file.lastModified());
}
$$
select fs_last_modified('c:\share\test.txt');create alias if not exists fs_get_parent as $$
import java.io.*;
@CODE
String fs_get_parent(String path)
{
if( path == null )return null;
File file = new File(path);
return file.getParent();
}
$$
select fs_get_parent('c:\share\test.txt');create alias if not exists fs_get_name as $$
import java.io.*;
@CODE
String fs_get_name(String path)
{
if( path == null )return null;
File file = new File(path);
return file.getName();
}
$$
select fs_get_name('c:\share\test.txt');create alias if not exists fs_exists as $$
import java.io.*;
@CODE
Boolean fs_exists(String path)
{
if( path == null )return null;
File file = new File(path);
return new Boolean(file.exists());
}
$$
select
fs_exists('c:\'),
fs_exists('c:\notexist.txt')
;
create alias if not exists fs_is_hidden as $$
import java.io.*;
@CODE
Boolean fs_is_hidden(String path)
{
if( path == null )return null;
File file = new File(path);
return new Boolean(file.isHidden());
}
$$
select
fs_is_hidden('c:\hiddenfile.txt'),
fs_is_hidden('c:\normalfile.txt')
;
create alias if not exists fs_is_file as $$
import java.io.*;
@CODE
Boolean fs_is_file(String path)
{
if( path == null )return null;
File file = new File(path);
return new Boolean(file.isFile());
}
$$
select
fs_is_file('c:\windows'),
fs_is_file('c:\windows\win.ini')
;
create alias if not exists fs_is_directory as $$
import java.io.*;
@CODE
Boolean fs_is_directory(String path)
{
if( path == null )return null;
File file = new File(path);
return new Boolean(file.isDirectory());
}
$$
select
fs_is_directory('c:\windows'),
fs_is_directory('c:\windows\win.ini')
;
create alias if not exists fs_is_absolute as $$
import java.io.*;
@CODE
Boolean fs_is_absolute(String path)
{
if( path == null )return null;
File file = new File(path);
return new Boolean(file.isAbsolute());
}
$$
select
fs_is_absolute('c:\'),
fs_is_absolute('.\data')
;
create alias if not exists fs_get_total_space as $$
import java.io.*;
@CODE
Long fs_get_total_space(String path)
{
if( path == null )return null;
File file = new File(path);
return new Long(file.getTotalSpace());
}
$$
select fs_get_total_space('c:\');create alias if not exists fs_get_free_space as $$
import java.io.*;
@CODE
Long fs_get_free_space(String path)
{
if( path == null )return null;
File file = new File(path);
return new Long(file.getFreeSpace());
}
$$
select fs_get_free_space('c:\');