indexing
description: "Database Manager using database structure description."
legal: "See notice at end of class."
status: "See notice at end of class."
date: "$Date: 2006-01-22 18:25:44 -0800 (Sun, 22 Jan 2006) $"
revision: "$Revision: 56675 $"
class interface
DB_TABLE_MANAGER
create
make (dbm: DATABASE_MANAGER [DATABASE])
`dbm'
require
database_manager_not_void: dbm /= Void
feature
make (dbm: DATABASE_MANAGER [DATABASE])
`dbm'
require
database_manager_not_void: dbm /= Void
feature
case_insensitive: BOOLEAN is False
ABSTRACT_DB_TABLE_MANAGER
case_sensitive: BOOLEAN is True
ABSTRACT_DB_TABLE_MANAGER
contains_type: INTEGER_32 is 5
ABSTRACT_DB_TABLE_MANAGER
database_result: DB_TABLE
require
no_error: not has_error
is_id_selection: is_id_selection
database_result_list: ARRAYED_LIST [DB_TABLE]
require ABSTRACT_DB_TABLE_MANAGER
no_error: not has_error
ensure ABSTRACT_DB_TABLE_MANAGER
result_not_void: Result /= Void
equals_type: INTEGER_32 is 0
ABSTRACT_DB_TABLE_MANAGER
generating_type: STRING_8
ANY
generator: STRING_8
ANY
greater_type: INTEGER_32 is 1
ABSTRACT_DB_TABLE_MANAGER
lower_type: INTEGER_32 is 2
ABSTRACT_DB_TABLE_MANAGER
max_type: INTEGER_32 is 5
ABSTRACT_DB_TABLE_MANAGER
prefix_type: INTEGER_32 is 3
ABSTRACT_DB_TABLE_MANAGER
select_qualifiers: STRING_8
select_query: STRING_8
`load_result_list'
require
select_query_prepared: select_query_prepared
select_table_descr: DB_TABLE_DESCRIPTION
`load_result_list'
suffix_type: INTEGER_32 is 4
ABSTRACT_DB_TABLE_MANAGER
feature
frozen deep_equal (some: ANY; other: like arg #1): BOOLEAN
`some'`other'
ANY
ensure ANY
shallow_implies_deep: standard_equal (some, other) implies Result
both_or_none_void: (some = Void) implies (Result = (other = Void))
same_type: (Result and (some /= Void)) implies some.same_type (other)
symmetric: Result implies deep_equal (other, some)
frozen equal (some: ANY; other: like arg #1): BOOLEAN
`some'`other'
ANY
ensure ANY
definition: Result = (some = Void and other = Void) or else ((some /= Void and other /= Void) and then some.is_equal (other))
is_equal (other: like Current): BOOLEAN
`other'
ANY
require ANY
other_not_void: other /= Void
ensure ANY
symmetric: Result implies other.is_equal (Current)
consistent: standard_is_equal (other) implies Result
frozen standard_equal (some: ANY; other: like arg #1): BOOLEAN
`some'`other'
ANY
ensure ANY
definition: Result = (some = Void and other = Void) or else ((some /= Void and other /= Void) and then some.standard_is_equal (other))
frozen standard_is_equal (other: like Current): BOOLEAN
`other'
ANY
require ANY
other_not_void: other /= Void
ensure ANY
same_type: Result implies same_type (other)
symmetric: Result implies other.standard_is_equal (Current)
feature
conforms_to (other: ANY): BOOLEAN
`other'
ANY
require ANY
other_not_void: other /= Void
error_message: STRING_8
has_error: BOOLEAN
has_id (tablerow: DB_TABLE): BOOLEAN
`tablerow'
is_connected: BOOLEAN
is_id_selection: BOOLEAN
is_valid_code (code: INTEGER_32): BOOLEAN
`code'
DB_TABLES_ACCESS_USE
like_type (type: INTEGER_32): BOOLEAN
`type'
same_type (other: ANY): BOOLEAN
`other'
ANY
require ANY
other_not_void: other /= Void
ensure ANY
definition: Result = (conforms_to (other) and other.conforms_to (Current))
select_query_prepared: BOOLEAN
tables_set: BOOLEAN
DB_TABLES_ACCESS_USE
valid_type (type: INTEGER_32): BOOLEAN
`type'
ABSTRACT_DB_TABLE_MANAGER
feature
copy (other: like Current)
`other'
ANY
require ANY
other_not_void: other /= Void
type_identity: same_type (other)
ensure ANY
is_equal: is_equal (other)
frozen deep_copy (other: like Current)
copy`other'deep_twin
ANY
require ANY
other_not_void: other /= Void
ensure ANY
deep_equal: deep_equal (Current, other)
frozen deep_twin: like Current
ANY
ensure ANY
deep_equal: deep_equal (Current, Result)
frozen standard_copy (other: like Current)
`other'
ANY
require ANY
other_not_void: other /= Void
type_identity: same_type (other)
ensure ANY
is_standard_equal: standard_is_equal (other)
frozen standard_twin: like Current
`other'
ANY
ensure ANY
standard_twin_not_void: Result /= Void
equal: standard_equal (Result, Current)
frozen twin: like Current
`Current'
twincopycopy
ANY
ensure ANY
twin_not_void: Result /= Void
is_equal: Result.is_equal (Current)
feature
add_qualifier (value: STRING_8)
`value'
require
select_query_prepared: select_query_prepared
value_not_void: value /= Void
add_specific_qualifier (column: INTEGER_32; value: STRING_8; type: INTEGER_32; case_sens: BOOLEAN)
`column'`value'`type'`case'
require ABSTRACT_DB_TABLE_MANAGER
select_query_prepared: select_query_prepared
not_void: value /= Void
valid_type: valid_type (type)
add_value_qualifier (column: INTEGER_32; value: STRING_8)
`column'`value'
require ABSTRACT_DB_TABLE_MANAGER
select_query_prepared: select_query_prepared
not_void: value /= Void
frozen default: like Current
ANY
frozen default_pointer: POINTER
`POINTER'
`p'default
`p'`POINTER'
ANY
default_rescue
ANY
frozen do_nothing
ANY
load_result
has_error
database_resultdatabase_result_list
require ABSTRACT_DB_TABLE_MANAGER
select_query_prepared: select_query_prepared
prepare_select_with_table (tablecode: INTEGER_32)
`tablecode'
`load_result_list'
require ABSTRACT_DB_TABLE_MANAGER
is_valid_tablecode: is_valid_code (tablecode)
remove_order_by
require
select_query_prepared: select_query_prepared
remove_qualifiers
require
select_query_prepared: select_query_prepared
ensure
is_not_id_selection: not is_id_selection
set_all_columns
require
select_query_prepared: select_query_prepared
set_columns (cols: ARRAYED_LIST [INTEGER_32])
`cols'
require
select_query_prepared: select_query_prepared
set_id_qualifier (id_value: STRING_8)
`id_value'
require
has_id: select_table_descr.id_code /= select_table_descr.no_id
ensure
is_id_selection: is_id_selection
set_multiple_order_by (column_list: ARRAYED_LIST [INTEGER_32])
`column'
require
select_query_prepared: select_query_prepared
column_list_not_void: column_list /= Void
set_order_by (column: INTEGER_32)
`column'
require
select_query_prepared: select_query_prepared
set_table (tablecode: INTEGER_32)
`tablecode'
require
select_query_prepared: select_query_prepared
is_valid_code: is_valid_code (tablecode)
feature
commit
feature
disconnect
require
is_connected: is_connected
establish_connection
ensure
not_void: session_control /= Void
set_connection_information (user_name, password, data_source: STRING_8)
`user_name'`password'
`data_source'
require
not_void: user_name /= Void and password /= Void and data_source /= Void
feature
create_item (an_obj: DB_TABLE)
`an_obj'
create_item_with_id (an_obj: DB_TABLE)
`an_obj'
DB_TABLE_MANAGERset_id_and_create_tablerow
new_id_for_tablerow (table_descr: DB_TABLE_DESCRIPTION): ANY
`table_descr'
require
not_void: table_descr /= Void
has_id: table_descr.id_code /= table_descr.no_id
set_id_and_create_tablerow (an_obj: DB_TABLE)
`an_obj'
DB_TABLE_MANAGERcreate_item_with_id
require ABSTRACT_DB_TABLE_MANAGER
not_void: an_obj /= Void
has_id: has_id (an_obj)
feature
delete_item (an_obj: DB_TABLE)
`an_obj'
`an_obj'`an_obj'
delete_tablerow (an_obj: DB_TABLE)
`an_obj'
`an_obj'`an_obj'
require ABSTRACT_DB_TABLE_MANAGER
not_void: an_obj /= Void
has_id: has_id (an_obj)
feature
execute_query (query: STRING_8)
`query'
require
not_void: query /= Void
feature
io: STD_FILES
ANY
out: STRING_8
ANYtagged_out
ANY
print (some: ANY)
`some'
ANY
frozen tagged_out: STRING_8
ANYout
ANY
feature
operating_environment: OPERATING_ENVIRONMENT
ANY
feature
load_data_with_select (s: STRING_8): ANY
require
meaningful_select: s /= Void
load_list_with_query_and_tablecode (query: STRING_8; tablecode: INTEGER_32): ARRAYED_LIST [DB_TABLE]
`query'
`tablecode'
require
is_valid_code: is_valid_code (tablecode)
feature
update_tablerow (tablerow: DB_TABLE)
`description'
require ABSTRACT_DB_TABLE_MANAGER
not_void: tablerow /= Void
has_id: has_id (tablerow)
invariant
ANY
reflexive_equality: standard_is_equal (Current)
reflexive_conformance: conforms_to (Current)
indexing
copyright: "Copyright (c) 1984-2006, Eiffel Software and others"
license: "Eiffel Forum License v2 (see http://www.eiffel.com/licensing/forum.txt)"
source: "[
Eiffel Software
356 Storke Road, Goleta, CA 93117 USA
Telephone 805-685-1006, Fax 805-685-6869
Website http://www.eiffel.com
Customer support http://support.eiffel.com
]"
end DB_TABLE_MANAGER