sqlbuilder.SQLFrame Class Reference

SQL Frame class. More...

Public Member Functions
def	__init__
def	OnUniqueValues
	Get unique values.
def	OnSampleValues
	Get sample values.
def	OnAddColumn
	Add column name to the query.
def	OnAddValue
	Add value.
def	OnAddMark
	Add mark.
def	GetSQLStatement
	Return SQL statement.
def	CloseOnApply
	Return True if the dialog will be close on apply.
def	OnText
def	OnApply
def	OnVerify
	Verify button pressed.
def	OnClear
	Clear button pressed.
def	OnClose
	Close button pressed.
Data Fields
	parent
	evtHeader
	vectmap
	mapset
	layer
	dbInfo
	tablename
	database
	qtype
	colvalues
	panel
	statusbar
	text_sql
	btn_clear
	btn_verify
	btn_apply
	btn_close
	btn_lv
	list_columns
	radio_cv
	list_values
	btn_unique
	btn_uniquesample
	close_onapply

---

Detailed Description

SQL Frame class.

Definition at line 37 of file sqlbuilder.py.

---

Constructor & Destructor Documentation

def sqlbuilder.SQLFrame.__init__	(		self,
			parent,
			title,
			vectmap,
			id = wx.ID_ANY,
			layer = 1,
			qtype = "select",
			evtheader = None
	)

Definition at line 40 of file sqlbuilder.py.

---

Member Function Documentation

def sqlbuilder.SQLFrame.CloseOnApply

(

self

)

Return True if the dialog will be close on apply.

Definition at line 395 of file sqlbuilder.py.

def sqlbuilder.SQLFrame.GetSQLStatement

(

self

)

Return SQL statement.

Definition at line 391 of file sqlbuilder.py.

def sqlbuilder.SQLFrame.OnAddColumn	(		self,
			event
	)

Add column name to the query.

Definition at line 311 of file sqlbuilder.py.

References sqlbuilder.SQLFrame._add().

def sqlbuilder.SQLFrame.OnAddMark	(		self,
			event
	)

Add mark.

Definition at line 341 of file sqlbuilder.py.

References sqlbuilder.SQLFrame._add().

def sqlbuilder.SQLFrame.OnAddValue	(		self,
			event
	)

Add value.

Definition at line 322 of file sqlbuilder.py.

References sqlbuilder.SQLFrame._add(), sqlbuilder.SQLFrame.layer, manager.VirtualAttributeList.layer, and manager.AttributeManager.layer.

def sqlbuilder.SQLFrame.OnApply	(		self,
			event
	)

Apply button pressed

Definition at line 406 of file sqlbuilder.py.

References sqlbuilder.SQLFrame.evtHeader.

Referenced by dialogs.VDigitCategoryDialog.OnOK(), colorrules.ColorTable.OnOK(), forms.TaskFrame.OnOK(), and preferences.NvizPreferencesDialog.OnSave().

def sqlbuilder.SQLFrame.OnClear	(		self,
			event
	)

Clear button pressed.

Definition at line 433 of file sqlbuilder.py.

References sqlbuilder.SQLFrame.tablename.

def sqlbuilder.SQLFrame.OnClose	(		self,
			event
	)

Close button pressed.

Definition at line 440 of file sqlbuilder.py.

References sqlbuilder.SQLFrame.evtHeader.

Referenced by dialogs.GroupDialog.OnOk().

def sqlbuilder.SQLFrame.OnSampleValues	(		self,
			event
	)

Get sample values.

Definition at line 307 of file sqlbuilder.py.

References sqlbuilder.SQLFrame.OnUniqueValues().

def sqlbuilder.SQLFrame.OnText	(		self,
			event
	)

Query string changed

Definition at line 399 of file sqlbuilder.py.

Referenced by widgets.BaseValidator.__init__().

def sqlbuilder.SQLFrame.OnUniqueValues	(		self,
			event,
			justsample = False
	)

Get unique values.

Definition at line 273 of file sqlbuilder.py.

References sqlbuilder.SQLFrame.database, DATA.driver, sqlbuilder.SQLFrame.layer, manager.VirtualAttributeList.layer, manager.AttributeManager.layer, and sqlbuilder.SQLFrame.tablename.

Referenced by sqlbuilder.SQLFrame.OnSampleValues().

def sqlbuilder.SQLFrame.OnVerify	(		self,
			event
	)

Verify button pressed.

Definition at line 416 of file sqlbuilder.py.

References sqlbuilder.SQLFrame.database, DATA.driver, gcmd.RunCommand(), and sqlbuilder.SQLFrame.tablename.

---

Field Documentation

sqlbuilder.SQLFrame.btn_apply

Definition at line 121 of file sqlbuilder.py.

sqlbuilder.SQLFrame.btn_clear

Definition at line 116 of file sqlbuilder.py.

sqlbuilder.SQLFrame.btn_close

Definition at line 123 of file sqlbuilder.py.

sqlbuilder.SQLFrame.btn_lv

Definition at line 126 of file sqlbuilder.py.

sqlbuilder.SQLFrame.btn_unique

Definition at line 203 of file sqlbuilder.py.

sqlbuilder.SQLFrame.btn_uniquesample

Definition at line 206 of file sqlbuilder.py.

sqlbuilder.SQLFrame.btn_verify

Definition at line 118 of file sqlbuilder.py.

sqlbuilder.SQLFrame.close_onapply

Definition at line 226 of file sqlbuilder.py.

sqlbuilder.SQLFrame.colvalues

Definition at line 65 of file sqlbuilder.py.

sqlbuilder.SQLFrame.database

Definition at line 62 of file sqlbuilder.py.

Referenced by sqlbuilder.SQLFrame.OnUniqueValues(), and sqlbuilder.SQLFrame.OnVerify().

sqlbuilder.SQLFrame.dbInfo

Definition at line 60 of file sqlbuilder.py.

Referenced by colorrules.VectorColorTable.OnLayerSelection().

sqlbuilder.SQLFrame.evtHeader

Definition at line 48 of file sqlbuilder.py.

Referenced by sqlbuilder.SQLFrame.OnApply(), and sqlbuilder.SQLFrame.OnClose().

sqlbuilder.SQLFrame.layer

Definition at line 59 of file sqlbuilder.py.

Referenced by colorrules.ColorTable.DoPreview(), sqlbuilder.SQLFrame.OnAddValue(), forms.TaskFrame.OnApply(), forms.TaskFrame.OnCancel(), sqlbuilder.SQLFrame.OnUniqueValues(), and histogram.HistogramFrame.SetHistLayer().

sqlbuilder.SQLFrame.list_columns

Definition at line 175 of file sqlbuilder.py.

sqlbuilder.SQLFrame.list_values

Definition at line 197 of file sqlbuilder.py.

sqlbuilder.SQLFrame.mapset

Definition at line 56 of file sqlbuilder.py.

sqlbuilder.SQLFrame.panel

Definition at line 71 of file sqlbuilder.py.

Referenced by prompt.GPromptPopUp.__init__(), prompt.GPromptSTC.__init__(), dialogs.ImportDialog.doLayout(), dialogs.ModelSearchDialog.GetPanel(), prompt.GPrompt.GetPanel(), and dialogs.NewVectorDialog.OnTable().

sqlbuilder.SQLFrame.parent

Definition at line 47 of file sqlbuilder.py.

Referenced by model.ModelLoop.__init__(), wxdigit.VDigitError.Database(), wxdigit.VDigitError.DbExecute(), wxdigit.VDigitError.DbLink(), wxdigit.VDigitError.DeadLine(), wxdigit.VDigitError.Driver(), wxdigit.VDigitError.FeatureType(), colorrules.RulesPanel.LoadRules(), wxdigit.VDigitError.NoMap(), forms.TaskFrame.OnCancel(), forms.TaskFrame.OnDone(), frame.ModelFrame.OnHelp(), frame.PsMapBufferedWindow.OnLeftUp(), dialogs.DecorationDialog.OnOptions(), forms.TaskFrame.OnRun(), toolbars.VDigitToolbar.OnSelectMap(), gselect.GdalSelect.OnSetDsn(), toolbars.LMNvizToolbar.OnSettings(), toolbars.VDigitToolbar.OnSettings(), toolbars.BaseToolbar.OnTool(), forms.CmdPanel.OnUpdateSelection(), toolbars.VDigitToolbar.OnZBulk(), wxdigit.VDigitError.ReadLine(), goutput.CmdThread.run(), forms.UpdateQThread.run(), goutput.GMConsole.RunCmd(), toolbars.VDigitToolbar.StopEditing(), colorrules.VectorColorTable.UpdateColorColumn(), mapwindow.BufferedWindow.UpdateMap(), and wxdigit.VDigitError.WriteLine().

sqlbuilder.SQLFrame.qtype

Definition at line 64 of file sqlbuilder.py.

sqlbuilder.SQLFrame.radio_cv

Definition at line 182 of file sqlbuilder.py.

sqlbuilder.SQLFrame.statusbar

Definition at line 74 of file sqlbuilder.py.

Referenced by goutput.PyStc.OnKeyPressed().

sqlbuilder.SQLFrame.tablename

Definition at line 61 of file sqlbuilder.py.

Referenced by sqlbuilder.SQLFrame.OnClear(), sqlbuilder.SQLFrame.OnUniqueValues(), and sqlbuilder.SQLFrame.OnVerify().

sqlbuilder.SQLFrame.text_sql

Definition at line 102 of file sqlbuilder.py.

sqlbuilder.SQLFrame.vectmap

Definition at line 53 of file sqlbuilder.py.

---

The documentation for this class was generated from the following file:

• sqlbuilder.py