Craig Finch craigafinch
craigafinch
/ test_google_bigtable_grpc.php
Created
June 5, 2020 20:03
A minimal test script to ensure that a PHP server can access data in Google BigTable (tests scopes, credentials, GRPC, and protobuf)
This file contains hidden or 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
| <?php | |
| require 'vendor/autoload.php'; | |
| use Google\Cloud\Bigtable\BigtableClient; | |
| $project_id = 'my-project-id'; | |
| $instance_id = 'my-instance-id'; | |
| $table_id = 'my-table-id'; | |
| $credential_file_path = './credential.json'; | |
| $transport = 'grpc'; |
craigafinch
/ Gmail: filter to select old email
Created
April 3, 2019 15:15
This file contains hidden or 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
| label:audit before:2019/04/01 |
craigafinch
/ stackdriver-instance-log-filter.txt
Last active
March 27, 2018 13:40
Google Stackdriver logging advanced filter to view logs across multiple Compute Engine instances by instance name
This file contains hidden or 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
| resource.type="gce_instance" | |
| logName="projects/my-project-name/logs/apache-error" | |
| labels."compute.googleapis.com/resource_name":"-web-" | |
| textPayload:"execution time" |
craigafinch
/ mysql2cloudsql.py
Created
January 4, 2018 03:09
Export data from MySQL in a form suitable for import into Google Cloud SQL
This file contains hidden or 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
| #!/usr/bin/env python | |
| import subprocess | |
| import os | |
| import datetime | |
| # Get list of views from MySQL | |
| getViews = subprocess.Popen(['mysql', 'core'], stdin=subprocess.PIPE, stdout=subprocess.PIPE) | |
| views = getViews.communicate("SHOW FULL TABLES IN core WHERE TABLE_TYPE LIKE 'VIEW';")[0].strip() |
craigafinch
/ gcs.service
Last active
December 3, 2024 18:13
A systemd service to manage a Google Cloud Storage bucket mounted with GCSFuse
This file contains hidden or 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
| # https://github.com/GoogleCloudPlatform/gcsfuse | |
| [Unit] | |
| Description=Google Cloud Storage FUSE mounter | |
| After=local-fs.target network-online.target google.service sys-fs-fuse-connections.mount | |
| Before=shutdown.target | |
| [Service] | |
| Type=forking | |
| User=apache |
craigafinch
/ fabfile.py
Last active
September 25, 2017 10:01
— forked from alexaivars/fabfile.py
Use fabric with a vagrant instance
This file contains hidden or 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
| from fabric.api import env, local, run | |
| def vagrant(): | |
| """USAGE: | |
| fab vagrant uname | |
| Note that the command to run Fabric might be different on different | |
| platforms. | |
| """ | |
| # change from the default user to 'vagrant' |