<repositories>
    <repository>
      <id>oss-snapshots</id>
      <url>https://oss.sonatype.org/content/repositories/snapshots</url>
      <releases>
        <enabled>false</enabled>
      </releases>
      <snapshots>
        <enabled>true</enabled>
      </snapshots>
    </repository>
  </repositories>

<dependency>
    <groupId>cn.dreampie</groupId>
    <artifactId>resty-route</artifactId>
    <version>1.0-SNAPSHOT</version>
</dependency>

//創(chuàng)建record的執(zhí)行器  針對sec_user表 并開啟緩存
Record recordDAO = new Record("sec_user",true);
//使用當前數(shù)據(jù)源和表數(shù)據(jù) new一個對象來保存數(shù)據(jù)
recordDAO.reNew().set("屬性", "值").save();
Record r1 = recordDAO.reNew().set("屬性", "值");
Record r2 = recordDAO.reNew().set("屬性", "值");
//批量保存
recordDAO.save(r1, r2);
//更新
r2.set("屬性", "值").update()
//查詢?nèi)?
List<Record> records = recordDAO.findAll();
//條件查詢
recordDAO.findBy(where,paras)
//分頁查詢
Page<Record> records = recordDAO.paginateAll();
//根據(jù)id刪除
recordDAO.deleteById("1");
//本次查詢放棄使用cache 
recordDAO.unCache().findBy(where,paras);
//把record的數(shù)據(jù)源切換到dsName數(shù)據(jù)源上
recordDAO.useDS(dsName).findBy(where,paras);

User dao=new User();
//本次查詢放棄使用cache 
dao.unCache().findBy(where,paras);
//把model的數(shù)據(jù)源切換到dsName數(shù)據(jù)源上
dao.useDS(dsName).findBy(where,paras);

//not must auto load
app.encoding=UTF-8
app.devMode=true
app.showRoute=true
app.cacheEnabled=true
//druid plugin auto load
//dsName is "default"  you can use everything
db.default.url=jdbc:mysql://127.0.0.1/example?useUnicode=true&characterEncoding=UTF-8
db.default.user=dev
db.default.password=dev1010
db.default.dialect=mysql
druid.default.initialSize=10
druid.default.maxPoolPreparedStatementPerConnectionSize=20
druid.default.timeBetweenConnectErrorMillis=1000
druid.default.filters=slf4j,stat,wall
//flyway database migration auto load
flyway.default.valid.clean=true
flyway.default.migration.auto=true
flyway.default.migration.initOnMigrate=true
//數(shù)據(jù)庫的配置精簡  自動從文件讀取參數(shù)  只需配置model掃描目錄 和dsName
public void configPlugin(PluginLoader pluginLoader) {
  //第一個數(shù)據(jù)庫
  ActiveRecordPlugin activeRecordPlugin = new ActiveRecordPlugin(new DruidDataSourceProvider("default"), true);
  activeRecordPlugin.addIncludePaths("cn.dreampie.resource");
  pluginLoader.add(activeRecordPlugin);
}

@GET("/users/:name")  
//在路徑中自定義解析的參數(shù) 如果有其他符合 也可以用 /users/{name}
// 參數(shù)名就是方法變量名  除路徑參數(shù)之外的參數(shù)也可以放在方法參數(shù)里  傳遞方式 user={json字符串}
public Map find(String name,User user) {
  // return Lister.of(name);
  return Maper.of("k1", "v1,name:" + name, "k2", "v2");
  //返回什么數(shù)據(jù)直接return，完全融入普通方法的方式
}

//批量保存
User u1 = new User().set("username", "test").set("providername", "test").set("password", "123456");
User u2 = new User().set("username", "test").set("providername", "test").set("password", "123456");
User.dao.save(u1,u2);
//普通保存
User u = new User().set("username", "test").set("providername", "test").set("password", "123456");
u.save();
//更新
u.update();
//條件更新
User.dao.updateBy(columns,where,paras);
User.dao.updateAll(columns,paras);
//刪除
u.deleted();
//條件刪除
User.dao.deleteBy(where,paras);
User.dao.deleteAll();
//查詢
User.dao.findById(id);
User.dao.findBy(where,paras);
User.dao.findAll();
//分頁
User.dao.paginateBy(pageNumber,pageSize,where,paras);
User.dao.paginateAll(pageNumber,pageSize);

Client client=null;//創(chuàng)建客戶端對象
//啟動resty-example項目，即可測試客戶端
String apiUrl = "http://localhost:8081/api/v1.0";
//如果不需要 使用賬號登陸
//client = new Client(apiUrl);
//如果有賬號權(quán)限限制  需要登陸
client = new Client(apiUrl, "/tests/login", "u", "123");
//該請求必須  登陸之后才能訪問  未登錄時返回 401  未認證
ClientRequest authRequest = new ClientRequest("/users", HttpMethod.GET);
ResponseData authResult = client.build(authRequest).ask();
System.out.println(authResult.getData());
//get
ClientRequest getRequest = new ClientRequest("/tests", HttpMethod.GET);
ResponseData getResult = client.build(getRequest).ask();
System.out.println(getResult.getData());
//post
ClientRequest postRequest = new ClientRequest("/tests", HttpMethod.POST);
postRequest.addParameter("test", Jsoner.toJSONString(Maper.of("a", "諤諤")));
ResponseData postResult = client.build(postRequest).ask();
System.out.println(postResult.getData());
//put
ClientRequest putRequest = new ClientRequest("/tests/x", HttpMethod.PUT);
ResponseData putResult = client.build(putRequest).ask();
System.out.println(putResult.getData());
//delete
ClientRequest deleteRequest = new ClientRequest("/tests/a", HttpMethod.DELETE);
ResponseData deleteResult = client.build(deleteRequest).ask();
System.out.println(deleteResult.getData());
//upload
ClientRequest uploadRequest = new ClientRequest("/tests/resty", HttpMethod.POST);
uploadRequest.addUploadFiles("resty", ClientTest.class.getResource("/resty.jar").getFile());
uploadRequest.addParameter("des", "test file  paras  測試筆");
ResponseData uploadResult = client.build(uploadRequest).ask();
System.out.println(uploadResult.getData());
//download  支持斷點續(xù)傳
ClientRequest downloadRequest = new ClientRequest("/tests/file", HttpMethod.GET);
downloadRequest.setDownloadFile(ClientTest.class.getResource("/resty.jar").getFile().replace(".jar", "x.jar"));
ResponseData downloadResult = client.build(downloadRequest).ask();
System.out.println(downloadResult.getData());

// 在resource里使用事務(wù),也就是controller里，rest的世界認為所以的請求都表示資源，所以這兒叫resource
@GET("/users")
@Transaction(name = {DS.DEFAULT_DS_NAME, "demo"}) //多數(shù)據(jù)源的事務(wù)，如果你只有一個數(shù)據(jù)庫  直接@Transaction 不需要參數(shù)
public User transaction() {
//TODO 用model執(zhí)行數(shù)據(jù)庫的操作  只要有操作拋出異常  兩個數(shù)據(jù)源 都會回滾  雖然不是分布式事務(wù)  也能保證代碼塊的數(shù)據(jù)執(zhí)行安全
}
// 如果你需要在service里實現(xiàn)事務(wù)，通過java動態(tài)代理（必須使用接口，jdk設(shè)計就是這樣）
public interface UserService {
  @Transaction(name = {DS.DEFAULT_DS_NAME, "demo"})//service里添加多數(shù)據(jù)源的事務(wù)，如果你只有一個數(shù)據(jù)庫  直接@Transaction 不需要參數(shù)
  public User save(User u);
}
// 在resource里使用service層的 事務(wù)
// @Transaction(name = {DS.DEFAULT_DS_NAME, "demo"})的注解需要寫在service的接口上
// 注意java的自動代理必須存在接口
// TransactionAspect 是事務(wù)切面 ，你也可以實現(xiàn)自己的切面比如日志的Aspect，實現(xiàn)Aspect接口
// 再private UserService userService = AspectFactory.newInstance(new UserServiceImpl(), new TransactionAspect(),new LogAspect());
private UserService userService = AspectFactory.newInstance(new UserServiceImpl(), new TransactionAspect());

public void configInterceptor(InterceptorLoader interceptorLoader) {  //權(quán)限攔截器 放在第一位 第一時間判斷 避免執(zhí)行不必要的代碼
  interceptorLoader.add(new SecurityInterceptor(new MyAuthenticateService()));
}
//實現(xiàn)接口
public class MyAuthenticateService implements AuthenticateService {  
//登陸時 通過name獲取用戶的密碼和權(quán)限信息
  public Principal findByName(String name) {
    DefaultPasswordService defaultPasswordService = new DefaultPasswordService();

    Principal principal = new Principal(name, defaultPasswordService.hash("123"), new HashSet<String>() {{
      add("api");
    }});    
    return principal;
  }  
  //基礎(chǔ)的權(quán)限總表  所以的url權(quán)限都放在這兒  你可以通過 文件或者數(shù)據(jù)庫或者直接代碼 來設(shè)置所有權(quán)限
  public Set<Credential> loadAllCredentials() {
      Set<Credential> credentials = new HashSet<Credential>();
      credentials.add(new Credential("GET", "/api/v1.0/users**", "users"));
      return credentials;
  }
}

public void configConstant(ConstantLoader constantLoader) {
  //啟用緩存并在要自動使用緩存的model上  開啟緩存@Table(name = "sec_user", cached = true)
  constantLoader.setCacheEnable(true);
}
@Table(name = "sec_user", cached = true)
public class User extends Model<User> {
public static User dao = new User();

}

@GET("/files")
public File file() {
  return new File(path);
}

@POST("/files")
@FILE(dir = "/upload/") //配置上傳文件的相關(guān)信息
public UploadedFile file(UploadedFile file) {    
  return file;
}

public void configConstant(ConstantLoader constantLoader) {
  // 通過后綴來返回不同的數(shù)據(jù)類型  你可以自定義自己的  render  如：FreemarkerRender
  // constantLoader.addRender("json", new JsonRender());
  //默認已添加json和text的支持，只需要把自定義的Render add即可
}