Guest User

Untitled

a guest
Jul 16th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. package MyProj::Data::DB;
  2.  
  3. use strict;
  4. use warnings;
  5. use utf8;
  6. use DBIx::Sunny::Declare;
  7. # export new select* query* master* slave*..
  8.  
  9. select_row 'member',
  10. id => { isa => 'Int', .. },
  11. "SELECT * FROM member WHERE id = %(id)d";
  12.  
  13. query 'create_member',
  14. user_id => { isa => 'Str' },
  15. ...
  16. "INSERT INTO member (user_id, name) VALUES (%(user_id)s, %(name)s)";
  17.  
  18. 1;
  19.  
  20. package main;
  21.  
  22. my $db = MyProj::Data::DB->new(
  23. master => [..],
  24. slave => [..]
  25. );
  26.  
  27. my $member = $db->member( user_id =>368 );
  28.  
  29. $db->create_member(
  30. user_id => 'kazeburo',
  31. name => 'Masahiro Nagano'
  32. );
Add Comment
Please, Sign In to add comment