技术面试必备基础知识、Leetcode、计算机操作系统、计算机网络、系统设计

<h2>Full example</h2> <pre><code>#!/usr/bin/env qore # database test script # databases users must be able to create and destroy tables and procedures, etc # in order to execute all tests %require-our %enable-all-warnings our ($o, $errors, $test_count); const opts = ( "help" : "h,help", "host" : "H,host=s", "pass" : "p,pass=s", "db" : "d,db=s", "user" : "u,user=s", "type" : "t,type=s", "enc" : "e,encoding=s", "verbose" : "v,verbose:i+", "leave" : "l,leave" ); sub usage() { printf("usage: %s [options] -h,--help this help text -u,--user=ARG set username -p,--pass=ARG set password -d,--db=ARG set database name -e,--encoding=ARG set database character set encoding (i.e. \"utf8\") -H,--host=ARG set hostname (for MySQL and PostgreSQL connections) -t,--type set database driver (default mysql) -v,--verbose more v's = more information -l,--leave leave test tables in schema at end\n", basename($ENV."_")); exit(); } const object_map = ( "oracle" : ( "tables" : ora_tables ), "mysql" : ( "tables" : mysql_tables ), "pgsql" : ( "tables" : pgsql_tables ), "sybase" : ( "tables" : syb_tables, "procs" : sybase_procs ), "freetds" : ( "tables" : freetds_sybase_tables, "procs" : sybase_procs ) ); const ora_tables = ( "family" : "create table family ( family_id int not null, name varchar2(80) not null )", "people" : "create table people ( person_id int not null, family_id int not null, name varchar2(250) not null, dob date not null )", "attributes" : "create table attributes ( person_id int not null, attribute varchar2(80) not null, value varchar2(160) not null )" ); const mysql_tables = ( "family" : "create table family ( family_id int not null, name varchar(80) not null ) type = innodb", "people" : "create table people ( person_id int not null, family_id int not null, name varchar(250) not null, dob date not null ) type = innodb", "attributes" : "create table attributes ( person_id int not null, attribute varchar(80) not null, value varchar(160) not null ) type = innodb" ); const pgsql_tables = ( "family" : "create table family ( family_id int not null, name varchar(80) not null )", "people" : "create table people ( person_id int not null, family_id int not null, name varchar(250) not null, dob date not null )", "attributes" : "create table attributes ( person_id int not null, attribute varchar(80) not null, value varchar(160) not null)", "data_test" : "create table data_test ( int2_f smallint not null, int4_f integer not null, int8_f int8 not null, bool_f boolean not null, float4_f real not null, float8_f double precision not null, number_f numeric(16,3) not null, money_f money not null, text_f text not null, varchar_f varchar(40) not null, char_f char(40) not null, name_f name not null, date_f date not null, abstime_f abstime not null, reltime_f reltime not null, interval_f interval not null, time_f time not null, timetz_f time with time zone not null, timestamp_f timestamp not null, timestamptz_f timestamp with time zone not null, tinterval_f tinterval not null, bytea_f bytea not null --bit_f bit(11) not null, --varbit_f bit varying(11) not null )" ); const syb_tables = ( "family" : "create table family ( family_id int not null, name varchar(80) not null )", "people" : "create table people ( person_id int not null, family_id int not null, name varchar(250) not null, dob date not null )", "attributes" : "create table attributes ( person_id int not null, attribute varchar(80) not null, value varchar(160) not null )", "data_test" : "create table data_test ( null_f char(1) null, varchar_f varchar(40) not null, char_f char(40) not null, unichar_f unichar(40) not null, univarchar_f univarchar(40) not null, text_f text not null, unitext_f unitext not null, -- note that unitext is stored as 'image' bit_f bit not null, tinyint_f tinyint not null, smallint_f smallint not null, int_f int not null, int_f2 int not null, decimal_f decimal(10,4) not null, float_f float not null, -- 8-bytes real_f real not null, -- 4-bytes money_f money not null, smallmoney_f smallmoney not null, date_f date not null, time_f time not null, datetime_f datetime not null, smalldatetime_f smalldatetime not null, binary_f binary(4) not null, varbinary_f varbinary(4) not null, image_f image not null )" ); const sybase_procs = ( "find_family" : "create procedure find_family @name varchar(80) as select * from family where name = @name commit -- to maintain transaction count ", "get_values" : "create procedure get_values @string varchar(80) output, @int int output as select @string = 'hello there' select @int = 150 commit -- to maintain transaction count ", "get_values_and_select" : "create procedure get_values_and_select @string varchar(80) output, @int int output as select @string = 'hello there' select @int = 150 select * from family where family_id = 1 commit -- to maintain transaction count ", "get_values_and_multiple_select" : "create procedure get_values_and_multiple_select @string varchar(80) output, @int int output as select @string = 'hello there' select @int = 150 select * from family where family_id = 1 select * from people where person_id = 1 commit -- to maintain transaction count ", "just_select" : "create procedure just_select as select * from family where family_id = 1 commit -- to maintain transaction count ", "multiple_select" : "create procedure multiple_select as select * from family where family_id = 1 select * from people where person_id = 1 commit -- to maintain transaction count " ); const freetds_sybase_tables = ( "family" : "create table family ( family_id int not null, name varchar(80) not null )", "people" : "create table people ( person_id int not null, family_id int not null, name varchar(250) not null, dob date not null )", "attributes" : "create table attributes ( person_id int not null, attribute varchar(80) not null, value varchar(160) not null )", "data_test" : "create table data_test ( null_f char(1) null, varchar_f varchar(40) not null, char_f char(40) not null, text_f text not null, unitext_f unitext not null, -- note that unitext is stored as 'image' bit_f bit not null, tinyint_f tinyint not null, smallint_f smallint not null, int_f int not null, int_f2 int not null, decimal_f decimal(10,4) not null, float_f float not null, -- 8-bytes real_f real not null, -- 4-bytes money_f money not null, smallmoney_f smallmoney not null, date_f date not null, time_f time not null, datetime_f datetime not null, smalldatetime_f smalldatetime not null, binary_f binary(4) not null, varbinary_f varbinary(4) not null, image_f image not null )" ); const freetds_mssql_tables = ( "family" : "create table family ( family_id int not null, name varchar(80) not null )", "people" : "create table people ( person_id int not null, family_id int not null, name varchar(250) not null, dob datetime not null )", "attributes" : "create table attributes ( person_id int not null, attribute varchar(80) not null, value varchar(160) not null )", "data_test" : "create table data_test ( null_f char(1) null, varchar_f varchar(40) not null, char_f char(40) not null, text_f text not null, bit_f bit not null, tinyint_f tinyint not null, smallint_f smallint not null, int_f int not null, int_f2 int not null, decimal_f decimal(10,4) not null, float_f float not null, -- 8-bytes real_f real not null, -- 4-bytes money_f money not null, smallmoney_f smallmoney not null, datetime_f datetime not null, smalldatetime_f smalldatetime not null, binary_f binary(4) not null, varbinary_f varbinary(4) not nul