wiz_framework/wiz_sql_query.class.php
Properties
Classes
wiz_sql_query
Descripcion
Metodos
TABLEchekField, TABLEchekTable, TABLEcreateNewFields, TABLEcreateTable, TABLEcreateTableStructFields, TABLEcreateTableStructFieldsConvert, alterCommentField, alterCommentFieldArray, coneccion, createSequencePostgres, extracDatosForm, findToCreateOrUpdate, get_where, info_table, insertLog, insert_log, printErrorSQL, query_delete, query_insert, query_query, query_query_void, query_todos, query_todosMASIVO, query_uno, query_update, tableCheckMysql, tableCheckPostgres, timequery, typeUnionWhere, verifyTable,public TABLEchekField( $v_table, $v_field, ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $v_table | n/a | ||
| $v_field | n/a |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public TABLEchekTable( $v_var, ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $v_var | n/a |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public TABLEcreateNewFields( $struct, ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $struct | n/a |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public TABLEcreateTable( $struct_po, ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $struct_po | n/a |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public TABLEcreateTableStructFields( $a_array ='', $idf, ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $a_array | n/a | '' | |
| $idf | n/a |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public TABLEcreateTableStructFieldsConvert( $v_type ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $v_type | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public alterCommentField( $v_table_name, $v_field, $v_comment, ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $v_table_name | n/a | ||
| $v_field | n/a | ||
| $v_comment | n/a |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public alterCommentFieldArray( $v_table_name, $a_det_field, ){ : \[type]
Descripcion
function alter only to anything database
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $v_table_name | n/a | ||
| $a_det_field | n/a |
Return value
| Type | Description |
|---|---|
| \[type] | [description] |
public coneccion( $type_db, ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $type_db | n/a |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public createSequencePostgres( $v_table, $v_field, ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $v_table | n/a | ||
| $v_field | n/a |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public extracDatosForm( $a_array, $table, ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $a_array | n/a | ||
| $table | n/a |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public findToCreateOrUpdate( $obj_orm_2, $data_insert, $data_where, ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $obj_orm_2 | n/a | ||
| $data_insert | n/a | ||
| $data_where | n/a |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public get_where(\[type] $v_sql, $eliminado ='', ){ : \[type]
Descripcion
obtener
Para ver hacer union en el where array( 'igual' => array( 'OR::DF_CAMPO' => '' ) )
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $v_sql | \[type] | [description] |
|
| $eliminado | n/a | '' |
Return value
| Type | Description |
|---|---|
| \[type] | [description] |
public info_table( $tb_name, ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $tb_name | n/a |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public insertLog( $JSON_data ='', $A_ARRAY_INSERT, ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $JSON_data | n/a | '' | |
| $A_ARRAY_INSERT | n/a |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public insert_log( $post, $tabla, $script_sql, $where ='', $v_action ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $post | n/a | ||
| $tabla | n/a | ||
| $script_sql | n/a | ||
| $where | n/a | '' | |
| $v_action | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public printErrorSQL( $rc_sql, $v_ErrorMsg, $v_comment ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $rc_sql | n/a | ||
| $v_ErrorMsg | n/a | ||
| $v_comment | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public query_delete( $tabla, $donde, $view_sql ='', $v_comment ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $tabla | n/a | ||
| $donde | n/a | ||
| $view_sql | n/a | '' | |
| $v_comment | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public query_insert( $post, $tabla, $v_comment ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $post | n/a | ||
| $tabla | n/a | ||
| $v_comment | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public query_query( $v_sql, $print ='', $v_comment ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $v_sql | n/a | ||
| n/a | '' | ||
| $v_comment | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public query_query_void(\[type] $v_sql, string $print ='', ){ : \[type]
Descripcion
function de query libre sin devolucion
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $v_sql | \[type] | [description] |
|
| string | [description] |
'' |
Return value
| Type | Description |
|---|---|
| \[type] | [description] |
public query_todos( $a_vec, $print ='', $v_comment ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $a_vec | n/a | ||
| n/a | '' | ||
| $v_comment | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public query_todosMASIVO( $a_vec, $print ='', $v_comment ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $a_vec | n/a | ||
| n/a | '' | ||
| $v_comment | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public query_uno( $a_vec, $ver_query ='', $v_comment ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $a_vec | n/a | ||
| $ver_query | n/a | '' | |
| $v_comment | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public query_update( $post, $tabla, $donde, $view_sql, $v_comment ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $post | n/a | ||
| $tabla | n/a | ||
| $donde | n/a | ||
| $view_sql | n/a | ||
| $v_comment | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public tableCheckMysql( $v_server_db ='', $v_table ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $v_server_db | n/a | '' | |
| $v_table | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public tableCheckPostgres( $v_table ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $v_table | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
public timequery( $type ='', ){ : n/a
Argumentos
| Name | Type | Description | Default |
|---|---|---|---|
| $type | n/a | '' |
Return value
| Type | Description |
|---|---|
| n/a | n/a |
