Aestate
Public Member Functions | Static Public Member Functions | List of all members
aestate.dbs._mssql.ParseUtil Class Reference
Collaboration diagram for aestate.dbs._mssql.ParseUtil:
Collaboration graph

Public Member Functions

def parse_main (self, *args, to_str=False, symbol='%s', left='[', right=']', **kwargs)
 
def parse_key (self, *args, **kwargs)
 
def parse_value (self, *args, **kwargs)
 
def parse_insert (self, keys, values, __table_name__, insert_str, values_str, symbol='%s', sql_format='%s %s(%s)%s(%s)')
 
def parse_insert_pojo (self, pojo, __table_name__, insert_str, values_str)
 
def get_pojo_sql (self, instance)
 

Static Public Member Functions

Tuple[list, list] parse_pojo (pojo)
 
object parse_obj (dict data, object instance)
 
def find_last_id (**kwargs)
 
def find_print_sql (**kwargs)
 
def case_name (text, rep_text='_', lower=True, upper=False)
 
def is_default (__val)
 
def set_field (obj, key, value)
 
None set_field_compulsory (obj, str key, dict data, object val)
 
object fieldExist (object obj, str field, el=None, raise_exception=False)
 
List[tuple] parse_pojo_many (list pojo_many)
 
def insert_to_obj (obj, kwargs)
 

Detailed Description

Definition at line 13 of file __init__.py.

Member Function Documentation

◆ case_name()

def aestate.dbs._mssql.ParseUtil.case_name (   text,
  rep_text = '_',
  lower = True,
  upper = False 
)
static 
将驼峰文本改为使用指定符号分割的字符串表达形式并全部小写
:param text:需要替换的文本
:param rep_text:在大写文本后面追加的字符串
:param lower:是否需要全部小写
:param upper:是否需要全部大写

Definition at line 216 of file __init__.py.

◆ fieldExist()

object aestate.dbs._mssql.ParseUtil.fieldExist ( object  obj,
str  field,
  el = None,
  raise_exception = False 
)
static 
在对象中获取一个字段的值,如果这个字段不存在,则将值设置为`el`

Definition at line 273 of file __init__.py.

◆ find_last_id()

def aestate.dbs._mssql.ParseUtil.find_last_id ( **  kwargs)
static 
作者:CACode 最后编辑于2021/4/12

遵循规则：

    内部>配置文件

是否包含返回最后一行ID的配置

只存在于更新操做的方法内，如：

    insert,

    update,

    delete

 Attributes:

     conf_obj:配置类

Definition at line 163 of file __init__.py.

◆ find_print_sql()

def aestate.dbs._mssql.ParseUtil.find_print_sql ( **  kwargs)
static 
遵循规则：
    内部>配置文件

是否包含打印sql的配置

存在于所有数据库操做

Attributes:
     conf_obj:配置类

Definition at line 194 of file __init__.py.

◆ get_pojo_sql()

def aestate.dbs._mssql.ParseUtil.get_pojo_sql (   self,
  instance 
) 
获取创建pojo对象的sql语句

Definition at line 315 of file __init__.py.

◆ insert_to_obj()

def aestate.dbs._mssql.ParseUtil.insert_to_obj (   obj,
  kwargs 
)
static

Definition at line 311 of file __init__.py.

◆ is_default()

def aestate.dbs._mssql.ParseUtil.is_default (   __val)
static 
是否等于默认值

Definition at line 238 of file __init__.py.

◆ parse_insert()

def aestate.dbs._mssql.ParseUtil.parse_insert (   self,
  keys,
  values,
  __table_name__,
  insert_str,
  values_str,
  symbol = '%s',
  sql_format = '%s %s (%s)%s(%s)' 
) 
实现此方法可自定义sql生成模式

keys:包含了所有需要解析的字段名
values:包含了所有需要用到的字段的值
__table_name__:表名称
insert_str:insert的字符串
values_str:values字符串
symbol:格式化方式，以`%s`作为匿名符号

Definition at line 73 of file __init__.py.

Here is the call graph for this function:
Here is the caller graph for this function:

◆ parse_insert_pojo()

def aestate.dbs._mssql.ParseUtil.parse_insert_pojo (   self,
  pojo,
  __table_name__,
  insert_str,
  values_str 
) 
解析插入语句

INSERT INTO `__table_name__`(`title`,'selects') VALUE ('','')

:param pojo:POJO对象
:param __table_name__:表名
:param insert_str:insert的sql方言
:param values_str:values的sql方言
:return:

Definition at line 105 of file __init__.py.

Here is the call graph for this function:

◆ parse_key()

def aestate.dbs._mssql.ParseUtil.parse_key (   self,
*  args,
**  kwargs 
) 
解析键格式,如:
    INSERT INTO `demo` (这里的就是键) VALUES ('','','','');
:param args:
:return:

Definition at line 51 of file __init__.py.

Here is the call graph for this function:
Here is the caller graph for this function:

◆ parse_main()

def aestate.dbs._mssql.ParseUtil.parse_main (   self,
*  args,
  to_str = False,
  symbol = '%s',
  left = '[',
  right = ']',
**  kwargs 
) 
    解析属性:
将属性格式设置为:['`a`,','`b`,','`c`']
    :param to_str:是否转成str格式
    :param args:参数
    :param is_field:是否为表字段格式
    :param symbol:分隔符语法
    :param left:分隔符语法
    :param right:分隔符语法
    :return:

Definition at line 15 of file __init__.py.

Here is the caller graph for this function:

◆ parse_obj()

object aestate.dbs._mssql.ParseUtil.parse_obj ( dict  data,
object  instance 
)
static 
将数据解析成对象
注意事项:
    数据来源必须是DbUtil下查询出来的
:param data:单行数据
:param instance:参与解析的对象
:return:POJO对象

Definition at line 147 of file __init__.py.

◆ parse_pojo()

Tuple[list, list] aestate.dbs._mssql.ParseUtil.parse_pojo (   pojo)
static

Definition at line 132 of file __init__.py.

◆ parse_pojo_many()

List[tuple] aestate.dbs._mssql.ParseUtil.parse_pojo_many ( list  pojo_many)
static

Definition at line 300 of file __init__.py.

◆ parse_value()

def aestate.dbs._mssql.ParseUtil.parse_value (   self,
*  args,
**  kwargs 
) 
解析值格式,如:
    INSERT INTO `demo` (`index`, `title`, `selects`, `success`) VALUES (这里的就是值);
:param args:
:return:

Definition at line 63 of file __init__.py.

Here is the call graph for this function:
Here is the caller graph for this function:

◆ set_field()

def aestate.dbs._mssql.ParseUtil.set_field (   obj,
  key,
  value 
)
static 
当对象没有这个字段时，为对象设置一个字段

为了方便提高拓展性可解耦，框架内部务必使用此

方法或者set_field_compulsory()为操作管理类提供对象

Definition at line 250 of file __init__.py.

◆ set_field_compulsory()

None aestate.dbs._mssql.ParseUtil.set_field_compulsory (   obj,
str  key,
dict  data,
object  val 
)
static 
如果键存在于data中，为obj插入该值，反之插入val

Definition at line 263 of file __init__.py.

The documentation for this class was generated from the following file:
Generated by   doxygen 1.8.17