| ## Connect PG8000 to database | |
| conn = pg8000.connect(database=args['db_name'],user=args['db_user'],password=args['db_password'],host=args['db_host'],port=5432) | |
| cur = conn.cursor() | |
| # ... | |
| # Example upsert query | |
| cur.execute("INSERT INTO {} SELECT * FROM {} ON CONFLICT (id) DO UPDATE SET name = EXCLUDED.name".format('campaigns', 'tmp_staging_campaings')) | |
| # ... | |
| conn.commit() | |
| cur.close() | |
| conn.close() |
| { | |
| "type": "excalidraw", | |
| "version": 2, | |
| "source": "https://excalidraw.com", | |
| "elements": [ | |
| { | |
| "type": "rectangle", | |
| "version": 192, | |
| "versionNonce": 1899200910, | |
| "isDeleted": false, |
When using the sparkline chart in angular-nvds we might want to hide the end value when creating tiny sparlines
Answer to this question https://stackoverflow.com/questions/34864193/angular-nvd3-sparkline-and-trailing-currentvalue-number/53314759#53314759
just set the undocumented* option showLastValue
`$scope.options = { chart: { type: 'sparklinePlus',
| Credit to : https://github.com/kingkool68/generate-ssl-certs-for-local-development | |
| Here is the sample output after running the script: | |
| sudo ./generate-ssl.sh local.dev | |
| Password: | |
| Generating RSA private key, 2048 bit long modulus | |
| ..........+++ | |
| ..............................................+++ |
| <iframe src="data:text/html;charset=utf-8,%3Cbody%3E%3Cscript%20src%3D%22https%3A%2F%2Fgist.github.com%2Fef4%2Ffe2e8e5b6e75266e3c2d.js%22%3E%3C%2Fscript%3E%3C%2Fbody%3E"> |
| INSTALLATION | |
| We've created a one-liner that automates the installation procedure. To get started with this display, simply execute curl -L http://coreelec.io/2q | bash | |
| If you want to see what this script does before running, save it to a file with curl -L http://coreelec.io/2q >> lcd35-installer | |
| You can roll back to using the regular HDMI output at any time by executing the included LCD_hdmi script. | |
| https://core-electronics.com.au/3-5inch-display-module-touch-lcd-with-stylus-for-raspberry-pi-3.html | |
| To rotate your display, simply enter display_rotate or lcd_rotate at the bottom of your config file: |
| function generateUUID() { // Public Domain/MIT | |
| var d = new Date().getTime(); | |
| if (typeof performance !== 'undefined' && typeof performance.now === 'function'){ | |
| d += performance.now(); //use high-precision timer if available | |
| } | |
| return 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function (c) { | |
| var r = (d + Math.random() * 16) % 16 | 0; | |
| d = Math.floor(d / 16); | |
| return (c === 'x' ? r : (r & 0x3 | 0x8)).toString(16); | |
| }); |