Changeset 84 for authorization/trunk
- Timestamp:
- 07/13/08 00:08:43 (4 months ago)
- Files:
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
authorization/trunk/pom.xml
r62 r84 109 109 <groupId>org.restafarian</groupId> 110 110 <artifactId>core</artifactId> 111 <version>1. 1</version>111 <version>1.2</version> 112 112 </dependency> 113 113 <dependency> authorization/trunk/src/main/java/org/restafarian/authorization/data/managers/AuthorizationManager.java
r14 r84 621 621 622 622 buffer.append(" select\n"); 623 buffer.append(" 624 buffer.append(" 625 buffer.append(" 626 buffer.append(" 627 buffer.append(" 628 buffer.append(" 629 buffer.append(" 630 buffer.append(" 631 buffer.append(" 632 buffer.append(" 633 buffer.append(" 634 buffer.append(" 635 buffer.append(" 636 buffer.append(" 637 buffer.append(" 638 buffer.append(" 639 buffer.append(" 623 buffer.append(" a.id,\n"); 624 buffer.append(" a.active,\n"); 625 buffer.append(" a.context,\n"); 626 buffer.append(" a.object,\n"); 627 buffer.append(" a.method,\n"); 628 buffer.append(" a.qualifier,\n"); 629 buffer.append(" a.userId,\n"); 630 buffer.append(" b.name as userName,\n"); 631 buffer.append(" b.uri as userUri,\n"); 632 buffer.append(" a.activationDate,\n"); 633 buffer.append(" a.activatedBy,\n"); 634 buffer.append(" c.name as activatedByName,\n"); 635 buffer.append(" c.uri as activatedByUri,\n"); 636 buffer.append(" a.deactivationDate,\n"); 637 buffer.append(" a.deactivatedBy,\n"); 638 buffer.append(" d.name as deactivatedByName,\n"); 639 buffer.append(" d.uri as deactivatedByUri\n"); 640 640 buffer.append(" from\n"); 641 buffer.append(" 642 buffer.append(" 643 buffer.append(" 644 buffer.append(" 641 buffer.append(" authorization a\n"); 642 buffer.append(" left outer join user b on a.userId = b.id\n"); 643 buffer.append(" left outer join user c on a.activatedBy = c.id\n"); 644 buffer.append(" left outer join user d on a.deactivatedBy = d.id\n"); 645 645 buffer.append(" where\n"); 646 buffer.append(" 646 buffer.append(" a.id = "); 647 647 buffer.append(id); 648 648 … … 664 664 String userId = (String) ids.get("userId"); 665 665 buffer.append(" select\n"); 666 buffer.append(" 667 buffer.append(" 668 buffer.append(" 669 buffer.append(" 670 buffer.append(" 671 buffer.append(" 672 buffer.append(" 673 buffer.append(" 674 buffer.append(" 675 buffer.append(" 676 buffer.append(" 677 buffer.append(" 678 buffer.append(" 679 buffer.append(" 680 buffer.append(" 681 buffer.append(" 682 buffer.append(" 666 buffer.append(" a.id,\n"); 667 buffer.append(" a.active,\n"); 668 buffer.append(" a.context,\n"); 669 buffer.append(" a.object,\n"); 670 buffer.append(" a.method,\n"); 671 buffer.append(" a.qualifier,\n"); 672 buffer.append(" a.userId,\n"); 673 buffer.append(" b.name as userName,\n"); 674 buffer.append(" b.uri as userUri,\n"); 675 buffer.append(" a.activationDate,\n"); 676 buffer.append(" a.activatedBy,\n"); 677 buffer.append(" c.name as activatedByName,\n"); 678 buffer.append(" c.uri as activatedByUri,\n"); 679 buffer.append(" a.deactivationDate,\n"); 680 buffer.append(" a.deactivatedBy,\n"); 681 buffer.append(" d.name as deactivatedByName,\n"); 682 buffer.append(" d.uri as deactivatedByUri\n"); 683 683 buffer.append(" from\n"); 684 buffer.append(" 685 buffer.append(" 686 buffer.append(" 687 buffer.append(" 684 buffer.append(" authorization a\n"); 685 buffer.append(" left outer join user b on a.userId = b.id\n"); 686 buffer.append(" left outer join user c on a.activatedBy = c.id\n"); 687 buffer.append(" left outer join user d on a.deactivatedBy = d.id\n"); 688 688 buffer.append(" where\n"); 689 buffer.append(" 689 buffer.append(" a.active = 1"); 690 690 if (context != null && context.length() > 0 && !context.equals("*")) { 691 691 buffer.append(" and\n"); 692 buffer.append(" 692 buffer.append(" a.context = '"); 693 693 buffer.append(ids.get("context")); 694 694 buffer.append("'"); … … 696 696 if (object != null && object.length() > 0 && !object.equals("*")) { 697 697 buffer.append(" and\n"); 698 buffer.append(" 698 buffer.append(" a.object = '"); 699 699 buffer.append(ids.get("object")); 700 700 buffer.append("'"); … … 702 702 if (method != null && method.length() > 0 && !method.equals("*")) { 703 703 buffer.append(" and\n"); 704 buffer.append(" 704 buffer.append(" a.method = '"); 705 705 buffer.append(ids.get("method")); 706 706 buffer.append("'"); … … 708 708 if (qualifier != null && qualifier.length() > 0 && !qualifier.equals("*")) { 709 709 buffer.append(" and\n"); 710 buffer.append(" 710 buffer.append(" a.qualifier = '"); 711 711 buffer.append(ids.get("qualifier")); 712 712 buffer.append("'"); … … 714 714 if (userId != null && userId.length() > 0 && !userId.equals("*")) { 715 715 buffer.append(" and\n"); 716 buffer.append(" 716 buffer.append(" a.userId = '"); 717 717 buffer.append(ids.get("userId")); 718 718 buffer.append("'"); … … 767 767 768 768 buffer.append(" select\n"); 769 buffer.append(" 770 buffer.append(" 771 buffer.append(" 772 buffer.append(" 773 buffer.append(" 774 buffer.append(" 775 buffer.append(" 776 buffer.append(" 777 buffer.append(" 778 buffer.append(" 779 buffer.append(" 780 buffer.append(" 781 buffer.append(" 782 buffer.append(" 783 buffer.append(" 784 buffer.append(" 785 buffer.append(" 769 buffer.append(" a.id,\n"); 770 buffer.append(" a.active,\n"); 771 buffer.append(" a.context,\n"); 772 buffer.append(" a.object,\n"); 773 buffer.append(" a.method,\n"); 774 buffer.append(" a.qualifier,\n"); 775 buffer.append(" a.userId,\n"); 776 buffer.append(" b.name as userName,\n"); 777 buffer.append(" b.uri as userUri,\n"); 778 buffer.append(" a.activationDate,\n"); 779 buffer.append(" a.activatedBy,\n"); 780 buffer.append(" c.name as activatedByName,\n"); 781 buffer.append(" c.uri as activatedByUri,\n"); 782 buffer.append(" a.deactivationDate,\n"); 783 buffer.append(" a.deactivatedBy,\n"); 784 buffer.append(" d.name as deactivatedByName,\n"); 785 buffer.append(" d.uri as deactivatedByUri\n"); 786 786 buffer.append(" from\n"); 787 buffer.append(" 788 buffer.append(" 789 buffer.append(" 790 buffer.append(" 787 buffer.append(" authorization a\n"); 788 buffer.append(" left outer join user b on a.userId = b.id\n"); 789 buffer.append(" left outer join user c on a.activatedBy = c.id\n"); 790 buffer.append(" left outer join user d on a.deactivatedBy = d.id\n"); 791 791 buffer.append(" where\n"); 792 buffer.append(" 792 buffer.append(" a.active = 1"); 793 793 if (context != null) { 794 794 buffer.append(" and\n"); 795 buffer.append(" 795 buffer.append(" a.context = '"); 796 796 buffer.append(context); 797 797 buffer.append("'"); … … 799 799 if (object != null) { 800 800 buffer.append(" and\n"); 801 buffer.append(" 801 buffer.append(" a.object = '"); 802 802 buffer.append(object); 803 803 buffer.append("'"); … … 805 805 if (method != null) { 806 806 buffer.append(" and\n"); 807 buffer.append(" 807 buffer.append(" a.method = '"); 808 808 buffer.append(method); 809 809 buffer.append("'"); … … 811 811 if (qualifier != null) { 812 812 buffer.append(" and\n"); 813 buffer.append(" 813 buffer.append(" a.qualifier = '"); 814 814 buffer.append(qualifier); 815 815 buffer.append("'"); … … 817 817 if (userId != null) { 818 818 buffer.append(" and\n"); 819 buffer.append(" 819 buffer.append(" a.userId = '"); 820 820 buffer.append(userId); 821 821 buffer.append("'"); … … 823 823 buffer.append("\n"); 824 824 buffer.append(" order by\n"); 825 buffer.append(" 826 buffer.append(" 827 buffer.append(" 828 buffer.append(" 829 buffer.append(" 825 buffer.append(" a.context,\n"); 826 buffer.append(" a.object,\n"); 827 buffer.append(" a.method,\n"); 828 buffer.append(" a.qualifier,\n"); 829 buffer.append(" a.userId"); 830 830 831 831 return buffer.toString();
