mysqlToKafuka.php 879 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. <?php
  2. namespace catchAdmin\api\service;
  3. use think\facade\Db;
  4. //脚本衢州 从mysql中存到kafka/redis中
  5. class mysqlToKafuka
  6. {
  7. //mysql 监听器
  8. public function sql_monitor(){
  9. $table="test";
  10. $list=Db::name($table)->where("status",1)->select();
  11. foreach($list as $key=>$item){
  12. $table_name=$item["table_name"];
  13. $type=$item["type"];
  14. $table_id=$item["table_id"];
  15. }
  16. }
  17. /**
  18. * 业务处理
  19. *
  20. * @param [type] $table_name
  21. * @param [type] $table_id
  22. * @param [type] $type
  23. * @return void
  24. */
  25. public function Operation($table_name,$table_id,$type){
  26. switch($table_name)
  27. {
  28. case "fjd_zcdj":
  29. }
  30. }
  31. public function toKafuka($data){
  32. }
  33. public function toRedis($data){
  34. }
  35. }