# Fringe API Connectors
This API package GSuite and GCP API connections into classes with simpler executions.
## Requirements
- Oauth Credentials for GSuite services
- Service Account for GCP services
## Defaults
- scopes:
```python
scopes = [
'https://www.googleapis.com/auth/drive',
'https://www.googleapis.com/auth/drive.file',
'https://www.googleapis.com/auth/spreadsheets',
'https://mail.google.com/'
]
```
## Classes & Functions
### import fringe_connector.api
- `GSuite()` - authenticates using the Oauth credentials .json file
- `GSheets()`- creates service using GSuite class upon instantiation
- `get()` - gets the values of a specified range
- `update()` - updates a specified range with the provide set of values
- `append()` - appends values to the end of a range
- `getColumnNumber()` - returns numerical column number of letter column
- `getIndexesFromRange()` - returns numerical indexes of alphanumeric range
- `create()` - creates a new spreadsheet
- `GMail()` - creates service using GSuite class upon instantiation
- `fetchEmails()`
- `sendEmail()`
- `GDrive()`- creates service using GSuite class upon instantiation
- `moveFile()`
- `uploadFile()`
- `GSlides()` - creates service using GSuite class upon instantiation
- `BigQuery()` creates service using Service Account .json upon instantiation
- `loadTable()` - creates table with data
- `createTable()` - creates an empty table
- `query()` - custom defined query. Returns results of query or loads results at the defined destination table
- `updateSchema()` - updates schema of table
- `getTableProperties()` - returns parsed table properties
- `deleteTable()`
- `copyTable()`
- `deleteDataset()`
- `createDataset()`
- `getDatasetTables()`
### import fringe_web_driver
- `WebDriver()` - default instantiation with a crome web driver. Requires a chrome web driver in PATH.
- `quit()`
- `downloadFile()` - works with chrome web driver. Buggy with Firefox web driver. Returns the filename of the downloaded file.
Raw data
{
"_id": null,
"home_page": "https://pypi.org/project/insomnyak-connector/",
"name": "fringe-connector",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.7.3",
"maintainer_email": "",
"keywords": "gcp gsuite gmail gsheets bigquery gdrive",
"author": "Rene Serulle",
"author_email": "rene@insomnyak.com",
"download_url": "https://files.pythonhosted.org/packages/c8/07/c913a3141f098a79d132a767c3953bff53f7f8e725063443411d30d48989/fringe_connector-0.0.110.tar.gz",
"platform": null,
"description": "# Fringe API Connectors\nThis API package GSuite and GCP API connections into classes with simpler executions. \n\n## Requirements\n- Oauth Credentials for GSuite services\n- Service Account for GCP services\n\n## Defaults\n- scopes:\n```python\nscopes = [\n 'https://www.googleapis.com/auth/drive',\n 'https://www.googleapis.com/auth/drive.file',\n 'https://www.googleapis.com/auth/spreadsheets',\n 'https://mail.google.com/'\n]\n```\n\n## Classes & Functions\n### import fringe_connector.api\n- `GSuite()` - authenticates using the Oauth credentials .json file\n- `GSheets()`- creates service using GSuite class upon instantiation\n - `get()` - gets the values of a specified range\n - `update()` - updates a specified range with the provide set of values\n - `append()` - appends values to the end of a range\n - `getColumnNumber()` - returns numerical column number of letter column\n - `getIndexesFromRange()` - returns numerical indexes of alphanumeric range\n - `create()` - creates a new spreadsheet\n- `GMail()` - creates service using GSuite class upon instantiation\n - `fetchEmails()`\n - `sendEmail()`\n- `GDrive()`- creates service using GSuite class upon instantiation\n - `moveFile()`\n - `uploadFile()`\n- `GSlides()` - creates service using GSuite class upon instantiation\n- `BigQuery()` creates service using Service Account .json upon instantiation\n - `loadTable()` - creates table with data\n - `createTable()` - creates an empty table\n - `query()` - custom defined query. Returns results of query or loads results at the defined destination table\n - `updateSchema()` - updates schema of table\n - `getTableProperties()` - returns parsed table properties\n - `deleteTable()`\n - `copyTable()`\n - `deleteDataset()`\n - `createDataset()`\n - `getDatasetTables()`\n\n### import fringe_web_driver\n- `WebDriver()` - default instantiation with a crome web driver. Requires a chrome web driver in PATH.\n - `quit()`\n - `downloadFile()` - works with chrome web driver. Buggy with Firefox web driver. Returns the filename of the downloaded file. \n",
"bugtrack_url": null,
"license": "",
"summary": "Suite of prebuilt connectors to other APIs",
"version": "0.0.110",
"project_urls": {
"Homepage": "https://pypi.org/project/insomnyak-connector/"
},
"split_keywords": [
"gcp",
"gsuite",
"gmail",
"gsheets",
"bigquery",
"gdrive"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "5895a08ebd32d89829cf0d253a81f9a494a547cbf284314eaef315c69ec8965e",
"md5": "9292718d39be3d2a028376d4d5077257",
"sha256": "1b6a09115aeab31b148cdde081b7ccc817f61f6c4d2fe3954298cb7f89902cf9"
},
"downloads": -1,
"filename": "fringe_connector-0.0.110-py3-none-any.whl",
"has_sig": false,
"md5_digest": "9292718d39be3d2a028376d4d5077257",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7.3",
"size": 29893,
"upload_time": "2023-08-11T16:28:24",
"upload_time_iso_8601": "2023-08-11T16:28:24.767997Z",
"url": "https://files.pythonhosted.org/packages/58/95/a08ebd32d89829cf0d253a81f9a494a547cbf284314eaef315c69ec8965e/fringe_connector-0.0.110-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "c807c913a3141f098a79d132a767c3953bff53f7f8e725063443411d30d48989",
"md5": "b3fe0eeb450337a2de2440a2a7d4a830",
"sha256": "f9627e8d3bf9a002146acf21e2a2a3783752eba1a227d0f99adeec422140819d"
},
"downloads": -1,
"filename": "fringe_connector-0.0.110.tar.gz",
"has_sig": false,
"md5_digest": "b3fe0eeb450337a2de2440a2a7d4a830",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7.3",
"size": 16063,
"upload_time": "2023-08-11T16:28:26",
"upload_time_iso_8601": "2023-08-11T16:28:26.384876Z",
"url": "https://files.pythonhosted.org/packages/c8/07/c913a3141f098a79d132a767c3953bff53f7f8e725063443411d30d48989/fringe_connector-0.0.110.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-08-11 16:28:26",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "fringe-connector"
}
JSON