export interface IUser extends mongoose.Document {
name: string;
somethingElse?: number;
};
export const UserSchema = new mongoose.Schema({
name: {type:String, required: true},
somethingElse: Number,
});
const User = mongoose.model<IUser>('User', UserSchema);
export default User;
References
https://stackoverflow.com/questions/34482136/mongoose-the-typescript-way
npm install typescript -s
Inside our package.json we will put a script called tsc:
"scripts": {
"tsc": "tsc"
},
npm run tsc -- --init
Press Alt+F11 then Insert>Module :
Function removeSpecialCharacters(sInput As String) As String
Dim s As String, temp As String, i As Long
Dim C As String
s = sInput
If s = "" Then Exit Function
temp = ""
For i = 1 To Len(s)
C = Mid(s, i, 1)
If AscW(C) > 31 And AscW(C) < 127 Then
temp = temp & C
End If
Next i
removeSpecialCharacters = temp
End Function
import sys
import os
from PySide2.QtWidgets import QApplication, QWidget, QPushButton
from PySide2.QtCore import QFile
from PySide2.QtUiTools import QUiLoader
class main(QWidget):
def __init__(self):
super(main, self).__init__()
self.load_ui()
def load_ui(self):
loader = QUiLoader()
path = os.path.join(os.path.dirname(__file__), "form.ui")
ui_file = QFile(path)
ui_file.open(QFile.ReadOnly)
self.window:QWidget = loader.load(ui_file, self)
ui_file.close()
# pushButton is the name of button control
self.pushButton:QPushButton = self.window.findChild(QPushButton,"pushButton")
self.pushButton.clicked.connect(self.clicked)
def clicked(self):
print("Hello")
if __name__ == "__main__":
app = QApplication([])
widget = main()
widget.show()
sys.exit(app.exec_())
References
https://www.blog.pythonlibrary.org/2018/05/30/loading-ui-files-in-qt-for-python/
import sys
import os
from PySide2.QtWidgets import QApplication, QWidget
from PySide2.QtCore import QFile
from PySide2.QtUiTools import QUiLoader
class main(QWidget):
def __init__(self):
super(main, self).__init__()
self.load_ui()
def load_ui(self):
loader = QUiLoader()
path = os.path.join(os.path.dirname(__file__), "form.ui")
ui_file = QFile(path)
ui_file.open(QFile.ReadOnly)
loader.load(ui_file, self)
ui_file.close()
if __name__ == "__main__":
app = QApplication([])
widget = main()
widget.show()
sys.exit(app.exec_())
=IF(A1="red",true result,false result)
References
https://exceljet.net/formula/if-cell-equals
=B6-TRUNC(B6)
References
https://exceljet.net/formula/get-decimal-part-of-a-number
=COUNTIF(D5:D12,">100") // count sales over 100 =COUNTIF(B5:B12,"jim") // count name = "jim" =COUNTIF(C5:C12,"ca") // count state = "ca" =COUNTIF(A1:A10,100) // count cells equal to 100 =COUNTIF(A1:A10,"<"&B1) // count cells less than B1
References
https://exceljet.net/excel-functions/excel-countif-function
MP4 TO MP4 (MEDIUM) ffmpeg -i input.mp4 -b 1000000 output.mp4 M2TS TO MP4 ffmpeg -i input.m2ts -vcodec libx264 -crf 20 -acodec ac3 -vf "yadif" output.mp4 MP4 TO WEBM (HIGH) ffmpeg -i input.mp4 -aq 5 -ac 2 -qmax 25 -threads 2 output.webm MP4 TO WEBM (MEDIUM) ffmpeg -i input.mp4 -aq 5 -ac 2 -qmax 35 -threads 2 output.webm MP4 TO OGV (HIGH) ffmpeg -i input.mp4 -vcodec libtheora -acodec libvorbis -q:v 6 -q:a 5 output.ogv MP4 TO OGV (MEDIUM) ffmpeg -i input.mp4 -vcodec libtheora -acodec libvorbis -q:v 2 -q:a 4 output.ogv
References
https://gist.github.com/vielhuber/cf918eed2b5cc9eaa63f
import cv2
img = cv2.imread("lenna.png")
crop_img = img[y:y+h, x:x+w]
cv2.imshow("cropped", crop_img)
cv2.waitKey(0)
References
https://stackoverflow.com/questions/15589517/how-to-crop-an-image-in-opencv-using-python