job_jdbc_datasouce.py 2.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
  1. from typing import List
  2. from pydantic import BaseModel
  3. class JobJdbcDatasourceBase(BaseModel):
  4. # 数据源名称
  5. datasource_name: str
  6. # 数据源
  7. datasource: str
  8. # 数据库名
  9. database_name: str
  10. # 数据库用户名
  11. jdbc_username: str
  12. # 数据库密码
  13. jdbc_password: str
  14. # jdbc url
  15. jdbc_url: str
  16. # 备注
  17. comments: str
  18. # 标签
  19. tag: str
  20. class Config:
  21. schema_extra = {
  22. # "example": {
  23. # "datasource_name": 'test',
  24. # "datasource": "mysql",
  25. # "database_name": 'datax_web',
  26. # "jdbc_username": 'root',
  27. # "jdbc_password": 'happylay',
  28. # "jdbc_url": '192.168.199.107:10086',
  29. # "comments": 'This is a very nice Item',
  30. # "tag": '线下'
  31. # }
  32. "example": {
  33. "datasource_name": 'testhive',
  34. "datasource": "hive",
  35. "database_name": 'default',
  36. "jdbc_username": '',
  37. "jdbc_password": '',
  38. "jdbc_url": '192.168.199.107:10000',
  39. "comments": 'This is a very nice Item',
  40. "tag": '线下',
  41. }
  42. }
  43. class JobJdbcDatasourceCreate(JobJdbcDatasourceBase):
  44. pass
  45. class JobJdbcDatasourceUpdate(JobJdbcDatasourceBase):
  46. status: int = 1
  47. class Config:
  48. schema_extra = {
  49. # "example": {
  50. # "datasource_name": 'test',
  51. # "datasource": "mysql",
  52. # "database_name": 'datax_web',
  53. # "jdbc_username": 'root',
  54. # "jdbc_password": 'happylay',
  55. # "jdbc_url": '192.168.199.107:10086',
  56. # "comments": 'This is a very nice Item',
  57. # "tag": '线下',
  58. # "status": 1,
  59. # }
  60. "example": {
  61. "datasource_name": 'testhive',
  62. "datasource": "hive",
  63. "database_name": 'default',
  64. "jdbc_username": '',
  65. "jdbc_password": '',
  66. "jdbc_url": '192.168.199.107:10000',
  67. "comments": 'This is a very nice Item',
  68. "tag": '线下',
  69. "status": 1,
  70. }
  71. }
  72. class JobJdbcDatasource(JobJdbcDatasourceBase):
  73. id: int
  74. status: int
  75. create_time: int
  76. create_by: str
  77. update_time: int
  78. update_by: str
  79. jdbc_url: str
  80. jdbc_driver_class: str
  81. class Config:
  82. orm_mode = True