命令 | 说明 + 示例 | |
---|---|---|
ds | 删除括号 | |
例 | ds " |
"Hello world!" =>Hello world! |
cs | 替换括号 | |
例 | cs "( |
"Hello world!" =>(Hello world!) |
cS | 替换括号,括号内文本做新一行 | |
例 | cS "{ |
"Hello world!" => { Hello world! } |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH orders AS ( | |
SELECT review, channel, t.product._id pid, t.product.martspec, t.product.costprice, t.product.price, "create" | |
FROM (SELECT * FROM db_orders WHERE "create" BETWEEN timestamp '2020-11-01 00:00:00' AND timestamp '2020-11-30 23:59:00' AND paid = TRUE) orders | |
CROSS JOIN unnest(products) AS t(product) | |
) | |
-- 2018-03-21 12:29:05 | |
, reviews AS ( | |
SELECT r.name reviewName, c.name channelName, m._id mid, r._id rid | |
FROM db_reviews r |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const express = require('express') | |
const request = require('request') | |
const jwt = require('jsonwebtoken') | |
const jose = require('jose') | |
const app = express() | |
let client_id = "AppBundleID" // Maybe from client | |
function generateClientSecret() { | |
let private_key = "-----BEGIN PRIVATE KEY-----\n......\n-----END PRIVATE KEY-----" // Should store in a safe place on server side |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function findAny(collection, value) { | |
var cursor = db[collection].find() | |
while (cursor.hasNext()) { | |
var o = cursor.next() | |
if (Object.keys(o).filter(key => o[key] == value).length) { | |
print(tojson(o)) | |
} | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT date,id,name,if(defalutinterest_num is null,0,defalutinterest_num), | |
if(one_unsubscribe_num is null,0,one_unsubscribe_num), | |
if(three_unsubscribe_sum is null,0,three_unsubscribe_sum), | |
if(seven_unsubscribe_sum is null,0,seven_unsubscribe_sum), | |
if(avg_quguan_rate is null,0,avg_quguan_rate), | |
if(next_active_rate is null,0,next_active_rate), | |
if(valid_num is null,0,valid_num), | |
if(valid_num /defalutinterest_num is null,0,valid_num /defalutinterest_num), | |
if(nextread_num is null,0,nextread_num), | |
if(nextread_num/valid_num is null,0,nextread_num/valid_num), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
2023.8.28 | |
据多名网友回复,此方法已失效。 | |
最新解决办法请参考此贴:[v2ex: 请问 github 的两步验证(two-factor authentication)大家是怎么做的?](https://www.v2ex.com/t/967533) | |
https://www.v2ex.com/t/967533 | |
--- |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package akka.http.scaladsl | |
import java.io.File | |
import akka.http.scaladsl.unmarshalling.Unmarshal | |
import akka.util.ByteString | |
import scala.concurrent.duration._ | |
import akka.actor.ActorSystem |
Update: For those interested, here's the version for updating from Android 5.1.0 (LMY47D/LMY47I) to Android 5.1.1 (LMY48B):
https://gist.github.com/eyecatchup/dab5cf7977008e504213
UPDATE `NEXUS 5`
SET `VERSION`='5.0.1', `BUILD`='LRX22C', `RECOVERY`='CUSTOM', `ROOTED`=1
WHERE `VERSION`='5.0' && `BUILD`='LRX21O' && `RECOVERY`='CUSTOM' && `ROOTED`=1
&& `WANNA_KEEP_USERDATA`=1;
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
#Modify this with your IP range | |
MY_IP_RANGE="192\.168\.1" | |
#You usually wouldn't have to modify this | |
PORT_BASE=5555 | |
#List the devices on the screen for your viewing pleasure | |
adb devices |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
* Copyright (C) 2014 Antonio Leiva Gordillo. | |
* | |
* Licensed under the Apache License, Version 2.0 (the "License"); | |
* you may not use this file except in compliance with the License. | |
* You may obtain a copy of the License at | |
* | |
* http://www.apache.org/licenses/LICENSE-2.0 | |
* | |
* Unless required by applicable law or agreed to in writing, software |
NewerOlder