Class: QObject

Inherits:
Gtk::HBox
  • Object
show all
Includes:
ManqodCommon
Defined in:
lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb

Overview

this file is part of manqod manqod is distributed under the CDDL licence the author of manqod is Dobai-Pataky Balint([email protected])

Constant Summary

Constants included from ManqodCommon

ManqodCommon::CRITICAL, ManqodCommon::DEBUG, ManqodCommon::ERROR, ManqodCommon::INFO, ManqodCommon::NORMAL, ManqodCommon::WARNING

Constants included from Eprint

Eprint::DOMAIN, Eprint::LEVEL

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from ManqodCommon

#add_where, #admin, #admin_cache, #admin_qrow, #admin_rows, #backtrace_to_debug, #cache, #changed_ids_of_base, #client, #client_fields, #client_image_of_id, #client_qrow, #client_query, #client_rows, #eeval, #escape_string, #getBinding, #guess_base, #guess_table, #image_of_id, #lzero, #manqod_db, #measure, #myexec, #nick, #nick_id, #number_format, #qrow, #query, #reconnect_manqod_db, #rows, #run_events, #send_message, #sendmail, #set_manqod_db_uri, #set_nick

Methods included from Eprint

#ecode, #edebug, #eerror, #einfo, #enormal, #eprint, #ewarn, #gtk_set_edebug, #set_edebug, #tell_exception

Constructor Details

#initialize(q, link_or_fields = nil) ⇒ QObject

q - the QueryBuilder link_or_fields - link: an object from the RelationBuilder - fields: the fields from the table ‘qobjects`



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
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 12

def initialize(q,link_or_fields=nil)
	whsv=false
	begin
		whsv=Gtk::SourceView::BUILD_VERSION
		rescue => err
		einfo("no Gtk::SourceView, falling back")
	end
	super() #("initializing")
	pack_start(Gtk::ScrolledWindow.new.set_policy(Gtk::PolicyType::AUTOMATIC,Gtk::PolicyType::NEVER).set_shadow_type(Gtk::ShadowType::NONE).add(@widget=whsv ? Gtk::SourceView.new : Gtk::TextView.new))
	@rel_reverted=false
	@q=q
	@custom="false"
	case link_or_fields.class.name
		when "Hash" then
			#load
			@my_id=link_or_fields["id"]
			@obj_type=link_or_fields["obj_type"]
			@obj_id=link_or_fields["obj_id"]
			@field=link_or_fields["field"]
			@custom=link_or_fields["custom"]
			@rel_reverted=!@field.nil? && @field.include?("reverted")
			set_link_from_data
		when "RField" then
			@link=link_or_fields
			@my_id=nil
			@obj_type="f"
			@field=link.field_name
			@obj_id=link.table.table_id
			store
		when "RTable" then
			@link=link_or_fields
			@my_id=nil
			@obj_type="b"
			@obj_id=link.table_id
			store
		when "Relation" then
			@link=link_or_fields
			@my_id=nil
			@obj_type="r"
			@obj_id=link.relation_id.to_i
			store
		else edebug("unknown link: #{@link}(#{link_or_fields.class.name})","relation-builder",WARNING)
	end

	if whsv
		@widget.buffer.set_language(Gtk::SourceLanguageManager.new.get_language("sql"))
		@widget.set_auto_indent(true).
		set_highlight_current_line(true).
		set_indent_on_tab(true).
		set_indent_on_tab(true).
		set_indent_width(4)
	end
	@widget.set_editable(is_custom?)
	@widget.modify_base(Gtk::StateType::NORMAL,Gdk::Color.parse("yellow")) if is_custom?
	@widget.signal_connect("focus-out-event"){|me,ev|
		@field=text
		store
		@q.update(@q)
		false
		}
	@q.qobjects.push(self)
	case @obj_type
		when "b" then @q.from.pack_start(self,false,false)
		when "f" then
			@q.select.pack_start(self,false,false)
			pack_start(rmbutton=Gtk::Button.new.set_image(Gtk::Image.new(Gtk::Stock::CANCEL,Gtk::IconSize::MENU)).set_relief(Gtk::ReliefStyle::NONE),false)
			rmbutton.signal_connect("clicked"){|me| self.delete}
		when "r" then
			@q.from.pack_start(self,false,false)
			pack_start(rotbutton=Gtk::ToggleButton.new.set_image(Gtk::Image.new(Gtk::Stock::REFRESH,Gtk::IconSize::MENU)).set_relief(Gtk::ReliefStyle::NONE),false)
			pack_start(rmbutton=Gtk::Button.new,false)
			rmbutton.set_image(Gtk::Image.new(Gtk::Stock::CANCEL,Gtk::IconSize::MENU)).set_relief(Gtk::ReliefStyle::NONE).signal_connect("clicked"){|me| self.delete}
			rotbutton.set_active(@rel_reverted)
			rotbutton.signal_connect("toggled"){|me| 
				@rel_reverted=me.active?
				store
				@q.update(@q)
			}
	end
	show_all
	case @link.class.name
		when "RField","Relation" then @link.set_active(true)
	end
end

Instance Attribute Details

Returns the value of attribute link.



96
97
98
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 96

def link
  @link
end

#obj_id ⇒ Object (readonly)

Returns the value of attribute obj_id.



96
97
98
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 96

def obj_id
  @obj_id
end

#obj_type ⇒ Object (readonly)

Returns the value of attribute obj_type.



96
97
98
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 96

def obj_type
  @obj_type
end

Instance Method Details



264
265
266
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 264

def center_on_link
	link.center_on_me unless link.nil?
end

#delete ⇒ Object 



221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 221

def delete
	query("delete from `qobjects` where id='#{@my_id}'") if @my_id
	@q.qobjects.delete(self)
	self.destroy
	if is_custom?
		#so all qobjects get updated
		@q.update(@q)
	else
		#update the link, that will also update all qobjects
		case @link.class.name
			when "RField" then @link.set_active(false)
			when "Relation" then @link.set_active(false)
		end
	end
end

#find_base_dir(rel, been_there = nil) ⇒ Object 



103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 103

def find_base_dir(rel,been_there=nil)
	if been_there.nil?
		been_there=Array.new
	end
	been_there.push(rel.relation_id)
	ret=nil
	ret=rel.rfield1 if rel.rfield1.table.table_id.to_i == @q.base_object.obj_id.to_i
	ret=rel.rfield2 if rel.rfield2.table.table_id.to_i == @q.base_object.obj_id.to_i
	unless ret
		@q.rb.relations.each_pair{|rel_id,r|
			unless been_there.include?(r.relation_id)
				if r.rfield1.table.table_id == rel.rfield1.table.table_id or r.rfield2.table.table_id == rel.rfield1.table.table_id 
					if other_dir=find_base_dir(r,been_there)
						ret=rel.rfield1
					end
				end
				if r.rfield1.table.table_id == rel.rfield2.table.table_id or r.rfield2.table.table_id == rel.rfield2.table.table_id 
					if other_dir=find_base_dir(r,been_there)
						ret=rel.rfield2
					end
				end
				break if ret
			end
		}
	end
	ret
end

#gen_text ⇒ Object 



131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 131

def gen_text
	ret=""
	if is_custom?
		ret=@field || ""
	else
		begin
			case @obj_type
				when "f" then ret="`#{@link.table.table}`.`#{@link.field_name}`#{"," unless last_field?}"
				when "r" then
					dir=find_base_dir(@link)
					dir=@link.other_field(dir) if @rel_reverted #reverted path
					edebug("field to base: #{dir}","relation-builder",INFO)
					if dir
						other_field=@link.other_field(dir)
						edebug("field to base other_field: #{other_field}","relation-builder",INFO)
						if @link.rel_name == ""
							ret="left join `#{other_field.table.table}` on `#{other_field.table.table}`.`#{other_field.field_name}` = `#{dir.table.table}`.`#{dir.field_name}`"
						else
							ret="left join `#{other_field.table.table}` as #{@link.rel_name} on `#{@link.rel_name}`.`#{other_field.field_name}` = `#{dir.table.table}`.`#{dir.field_name}`"
						end
						unless @link.rel_custom == ""
							ret="#{ret} and #{@link.rel_custom}"
						end
					else
						ret="can't reach base"
					end
				when "b" then
					ret="`#{@link.table}`"
				else ret="unknown object type"
			end
		rescue =>err
			edebug("#{err}, #{backtrace_to_debug(err)}\n","relation-builder","warning")
			ret="unavailable object"
		end
	end
	ret
end

#inspect ⇒ Object 



256
257
258
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 256

def inspect
	"QObject of #{@link}(#{@obj_type} id:#{@my_id})"
end

#is_custom? ⇒ Boolean

Returns:

  • (Boolean) 


98
99
100
101
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 98

def is_custom?
	return false if @custom.nil?
	@custom == "true"
end

#last_field? ⇒ Boolean

Returns:

  • (Boolean) 


237
238
239
240
241
242
243
244
245
246
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 237

def last_field?
	last_field=nil
	@q.qobjects.reverse_each{|qobject|
		if qobject.obj_type == "f"
			last_field = qobject
			break
		end
	}
	last_field == self
end

#set_link(new_link) ⇒ Object 



187
188
189
190
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 187

def set_link(new_link)
	@link=new_link
	self
end

#set_link_from_data ⇒ Object 



169
170
171
172
173
174
175
176
177
178
179
180
181
182
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 169

def set_link_from_data
	#if any data changed this should be called. it'll try to link to another object
	unless is_custom?
		@link=case @obj_type
			when "b" then @q.rb.table_by_id(@obj_id)
			when "f" then if table=@q.rb.table_by_id(@obj_id) then table.fields[@field]; end
			when "r" then @q.rb.relations[@obj_id]
			else 
				edebug("unknown type: #{@obj_type}","relation-builder",WARNING)
				nil
		end
	end
	update
end

#set_obj_id(new_obj_id) ⇒ Object 



191
192
193
194
195
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 191

def set_obj_id(new_obj_id)
	@obj_id=new_obj_id
	set_link_from_data
	store
end

#set_text(new_text) ⇒ Object 



248
249
250
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 248

def set_text(new_text)
	@widget.buffer.set_text(new_text)
end

#store ⇒ Object 



197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 197

def store
	edebug("storing(#{@my_id})","relation-builder")
	if is_custom?
		isql="`obj_id`='#{@obj_id}', `obj_type`='#{@obj_type}', `field`='#{escape_string(@field)}', `custom`='#{@custom}', `query_id`='#{@q.query_id}'"
	else
		isql=nil
		case @link.class.name
			when "RField" then isql="`obj_id`='#{@obj_id}', `field`='#{@link.field_name}', `obj_type`='#{@obj_type}', `query_id`='#{@q.query_id}'"
			when "RTable" then isql="`obj_id`='#{@obj_id}', `obj_type`='#{@obj_type}', `query_id`='#{@q.query_id}'"
			when "Relation" then isql="`obj_id`='#{@obj_id}', `obj_type`='#{@obj_type}', `query_id`='#{@q.query_id}', `field`='#{"reverted" if @rel_reverted}'"
			else edebug("don't store: #{link.class.name}","relation-builder",INFO)
		end
	end
	if isql
		if @my_id
			sql="update `qobjects` set #{isql} where `id`='#{@my_id}'"
			else
			sql="insert into `qobjects` set #{isql}"
		end
		query(sql)
		@my_id=qrow("select id from `qobjects` order by id desc limit 1")["id"] unless @my_id
	end
end

#text ⇒ Object 



252
253
254
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 252

def text
	@widget.buffer.text
end

#to_s ⇒ Object 



260
261
262
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 260

def to_s
	inspect
end

#update ⇒ Object 



184
185
186
 
# File 'lib/FormHolder/Form/InputHolder/QBuilder/QObject.rb', line 184

def update
	@widget.buffer.set_text(gen_text)
end