<!--
Copyright 2020 Pipin Fitriadi <pipinfitriadi@gmail.com>
Licensed under the Microsoft Reference Source License (MS-RSL)
This license governs use of the accompanying software. If you use the
software, you accept this license. If you do not accept the license, do not
use the software.
1. Definitions
The terms "reproduce," "reproduction" and "distribution" have the same
meaning here as under U.S. copyright law.
"You" means the licensee of the software.
"Your company" means the company you worked for when you downloaded the
software.
"Reference use" means use of the software within your company as a reference,
in read only form, for the sole purposes of debugging your products,
maintaining your products, or enhancing the interoperability of your
products with the software, and specifically excludes the right to
distribute the software outside of your company.
"Licensed patents" means any Licensor patent claims which read directly on
the software as distributed by the Licensor under this license.
2. Grant of Rights
(A) Copyright Grant- Subject to the terms of this license, the Licensor
grants you a non-transferable, non-exclusive, worldwide, royalty-free
copyright license to reproduce the software for reference use.
(B) Patent Grant- Subject to the terms of this license, the Licensor grants
you a non-transferable, non-exclusive, worldwide, royalty-free patent
license under licensed patents for reference use.
3. Limitations
(A) No Trademark License- This license does not grant you any rights to use
the Licensor's name, logo, or trademarks.
(B) If you begin patent litigation against the Licensor over patents that
you think may apply to the software (including a cross-claim or counterclaim
in a lawsuit), your license to the software ends automatically.
(C) The software is licensed "as-is." You bear the risk of using it. The
Licensor gives no express warranties, guarantees or conditions. You may have
additional consumer rights under your local laws which this license cannot
change. To the extent permitted under your local laws, the Licensor excludes
the implied warranties of merchantability, fitness for a particular purpose
and non-infringement.
-->
# VOXROW
Daftar isi:
<!-- TOC -->
- [VOXROW](#voxrow)
- [Instalasi dan Cara Penggunaan VOXROW](#instalasi-dan-cara-penggunaan-voxrow)
- [MacOS Hanya Jika _Error_](#macos-hanya-jika-error)
- [_Server_](#server)
- [_Source-code_](#source-code)
- [_Editor_](#editor)
- [Repositori Git](#repositori-git)
- [Tata Cara Penulisan _Markdown_](#tata-cara-penulisan-markdown)
- [Python](#python)
- [Lisensi](#lisensi)
<!-- /TOC -->
---
## Instalasi dan Cara Penggunaan VOXROW
```shell
$ pip install voxrow
```
> Contoh cara penggunaan VOXROW dapat dilihat di [`example/example.ipynb`](https://gitlab.com/voxrow/library/-/blob/master/example/example.ipynb).
### MacOS (Hanya Jika _Error_)
Pastikan `clang` sudah terinstal. Jika tidak, maka jalankan perintah berikut ini:
```shell
$ xcode-select --install
```
Instal VOXROW dengan perintah berikut ini:
```shell
$ brew install openssl@3 rust && env LDFLAGS="-L$(brew --prefix openssl@3)/lib" CFLAGS="-I$(brew --prefix openssl@3)/include" pip install "voxrow[query]"
```
## _Server_
Disarankan untuk menggunakan [Ubuntu 18.04 x64](https://ubuntu.com/download/desktop)
(_CPU_ minimal 1 vCore, _RAM_ minimal 512 MB, _Storage_ minimal 10 GB SSD, dan _Bandwidth_
minimal 500 GB), supaya memudahkan pengelolaan _server_ dengan mengunakan _script_
VOXROW. Adapun langkah yang harus dipersiapkan adalah sebagai berikut:
1. Pastikan telah ada _source-code_ VOXROW di komputer lokal dan _server_. Dapat
dipergunakan perintah [Git](https://git-scm.com/) berikut ini:
```shell
$ git clone --recurse-submodules -j8 https://gitlab.com/voxrow/library.git
```
> Jangan jalankan perintah ini di _folder_ `root/` milik _server_!
2. Masuk ke _folder_ `server/`:
```shell
$ cd voxrow/src/server/
```
3. Pastikan [GNU Make](https://www.gnu.org/software/make/) sudah ada, dengan
menjalankan perintah ini:
```shell
$ . install/make_gnu.sh
```
> _Script_ ini hanya dapat dipergunakan di Ubuntu Linux, instalasi untuk OS
selain ini silahkan cari di internet.
4. Jalankan perintah di komputer lokal dan _server_ sebagai berikut:
- Komputer lokal:
Pastikan terlebih dahulu bahwa _SSH Key Pair_ sudah dibuat, baca baik-baik
instruksi dalam prosesnya! Berikut ini adalah perintahnya:
```shell
$ sudo ssh-keygen
```
Salin _public key_ komputer lokal ke _server_ dengan perintah ini:
```shell
$ make local_ssh_key_to_server
```
Ikuti instruksi yang dimintakan saat proses berjalan.
> Masukkan alamat _server_ dan _username_ `root`.
- _Server_:
> Pastikan anda masuk sebagai _username_ `root`!
```shell
$ make
```
Ikuti instruksi yang dimintakan saat proses berjalan. Setelah proses berakhir
_server_ akan _reboot_. Selesai _reboot_ masuk kembali dengan _username_
baru yang telah dibuat.
[GitLab CI/CD](https://docs.gitlab.com/ee/ci/) dipergunakan untuk mempermudah
proses _release_ aplikasi. Registrasi [GitLab Runner](https://docs.gitlab.com/runner/)
di _private server_ perlu dilakukan untuk proses [CI/CD](https://en.wikipedia.org/wiki/CI/CD),
berikut adalah perintahnya:
```shell
$ make register_runner
```
Setelah seluruh proses selesai dijalankan, maka hapuslah _source-code_
VOXROW dari _server_, karena sudah tidak diperlukan lagi. Perintahnya
adalah sebagai berikut:
```shell
$ sudo rm -rf voxrow/
```
---
## _Source-code_
> Sebagai catatan beberapa perintah aplikasi di komputer lokal ini dapat berjalan
dengan baik di OS MacOS dan Linux. Adapun untuk OS Windows perlu dilakukan sedikit
penyesuaian.
### _Editor_
[VSCode](https://code.visualstudio.com/) (Visual Studio Code) dipergunakan untuk
memudahkan dalam penulisan _source-code_.
Beberapa _extension_ VSCode dipasangkan untuk memudahkan penulisan _source-code_,
antara lain:
- [_Auto Markdown TOC_](https://marketplace.visualstudio.com/items?itemName=huntertran.auto-markdown-toc)
- [_Markdownlint_](https://marketplace.visualstudio.com/items?itemName=DavidAnson.vscode-markdownlint)
- [_Python extension for Visual Studio Code_](https://marketplace.visualstudio.com/items?itemName=ms-python.python)
- [Jinja](https://marketplace.visualstudio.com/items?itemName=wholroyd.jinja)
- [Better TOML](https://marketplace.visualstudio.com/items?itemName=bungcip.better-toml)
### Repositori Git
Git GUI [Sourcetree](https://www.sourcetreeapp.com/) dapat
dipergunakan untuk memudahkan pengelolaan repositori, pada sistem operasi Windows
atau MacOS.
_Branching model_ [Git-Flow](https://github.com/nvie/gitflow) dari Vincent Driessen
dipergunakan untuk memudahkan pengelolaan _feature_, _release_, dan _hotfix_ di
dalam repositori.
### Tata Cara Penulisan _Markdown_
Beberapa sumber ini dapat dijadikan acuan tata cara penulisan _markdown_:
- [_GitLab: List of supported languages and lexers_](https://github.com/rouge-ruby/rouge/wiki/List-of-supported-languages-and-lexers)
- [_GitLab Markdown_](https://docs.gitlab.com/ee/user/markdown.html)
- [_Wikipedia: Markdown_](https://en.m.wikipedia.org/wiki/Markdown)
- [Berkas readme.md yang dibuat oleh Ben Strahan](https://gist.github.com/benstr/8744304#file-readme-md)
### Python
Dipergunakan [Python 3.8.0](https://www.python.org/downloads/release/python-380/)
(versi minimal).
Dalam mengembangkan _source-code_ di komputer lokal, maka pertamakali perlu dibuat
_environtment_ python dengan langkah berikut ini:
1. Pastikan versi python yang dipergunakan sudah sesuai.
```shell
$ python3 -V
````
2. Buat _environtment_ python.
```shell
$ python3 -m venv venv
````
Instruksi terkait _environtment_ python yang dapat dipergunakan antara lain:
- Aktivasi:
```shell
$ . venv/bin/activate
```
> Kembangkan _source-code_ dengan kondisi _environtment_ python sedang teraktivasi.
- Deaktivasi:
```shell
(venv) $ deactivate
```
3. Pastikan [pustaka pendukung](requirements.txt) terpasang di _environtment_ python.
```shell
(venv) $ pip install --upgrade pip && pip install -r requirements.txt
```
---
## Lisensi
Lisensi yang dipergunakan adalah [MS-RSL](LICENSE) (Microsoft Reference Source License).
Raw data
{
"_id": null,
"home_page": "",
"name": "voxrow",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.7.13",
"maintainer_email": "",
"keywords": "voxrow,library,raw sql query,airflow,sqlalchemy",
"author": "",
"author_email": "Pipin Fitriadi <pipinfitriadi@gmail.com>",
"download_url": "https://files.pythonhosted.org/packages/11/61/1d972cf66a27b3f53dd008f101e3df061ce5917cfec199ebb257f7fe1bf3/voxrow-0.9.36.tar.gz",
"platform": null,
"description": "<!--\nCopyright 2020 Pipin Fitriadi <pipinfitriadi@gmail.com>\n\nLicensed under the Microsoft Reference Source License (MS-RSL)\n\nThis license governs use of the accompanying software. If you use the\nsoftware, you accept this license. If you do not accept the license, do not\nuse the software.\n\n1. Definitions\n\nThe terms \"reproduce,\" \"reproduction\" and \"distribution\" have the same\nmeaning here as under U.S. copyright law.\n\n\"You\" means the licensee of the software.\n\n\"Your company\" means the company you worked for when you downloaded the\nsoftware.\n\n\"Reference use\" means use of the software within your company as a reference,\nin read only form, for the sole purposes of debugging your products,\nmaintaining your products, or enhancing the interoperability of your\nproducts with the software, and specifically excludes the right to\ndistribute the software outside of your company.\n\n\"Licensed patents\" means any Licensor patent claims which read directly on\nthe software as distributed by the Licensor under this license.\n\n2. Grant of Rights\n\n(A) Copyright Grant- Subject to the terms of this license, the Licensor\ngrants you a non-transferable, non-exclusive, worldwide, royalty-free\ncopyright license to reproduce the software for reference use.\n\n(B) Patent Grant- Subject to the terms of this license, the Licensor grants\nyou a non-transferable, non-exclusive, worldwide, royalty-free patent\nlicense under licensed patents for reference use.\n\n3. Limitations\n\n(A) No Trademark License- This license does not grant you any rights to use\nthe Licensor's name, logo, or trademarks.\n\n(B) If you begin patent litigation against the Licensor over patents that\nyou think may apply to the software (including a cross-claim or counterclaim\nin a lawsuit), your license to the software ends automatically.\n\n(C) The software is licensed \"as-is.\" You bear the risk of using it. The\nLicensor gives no express warranties, guarantees or conditions. You may have\nadditional consumer rights under your local laws which this license cannot\nchange. To the extent permitted under your local laws, the Licensor excludes\nthe implied warranties of merchantability, fitness for a particular purpose\nand non-infringement.\n-->\n\n# VOXROW\n\nDaftar isi:\n\n<!-- TOC -->\n\n- [VOXROW](#voxrow)\n - [Instalasi dan Cara Penggunaan VOXROW](#instalasi-dan-cara-penggunaan-voxrow)\n - [MacOS Hanya Jika _Error_](#macos-hanya-jika-error)\n - [_Server_](#server)\n - [_Source-code_](#source-code)\n - [_Editor_](#editor)\n - [Repositori Git](#repositori-git)\n - [Tata Cara Penulisan _Markdown_](#tata-cara-penulisan-markdown)\n - [Python](#python)\n - [Lisensi](#lisensi)\n\n<!-- /TOC -->\n\n---\n\n## Instalasi dan Cara Penggunaan VOXROW\n\n```shell\n$ pip install voxrow\n```\n\n> Contoh cara penggunaan VOXROW dapat dilihat di [`example/example.ipynb`](https://gitlab.com/voxrow/library/-/blob/master/example/example.ipynb).\n\n### MacOS (Hanya Jika _Error_)\n\nPastikan `clang` sudah terinstal. Jika tidak, maka jalankan perintah berikut ini:\n\n```shell\n$ xcode-select --install\n```\n\nInstal VOXROW dengan perintah berikut ini:\n\n```shell\n$ brew install openssl@3 rust && env LDFLAGS=\"-L$(brew --prefix openssl@3)/lib\" CFLAGS=\"-I$(brew --prefix openssl@3)/include\" pip install \"voxrow[query]\"\n```\n\n## _Server_\n\nDisarankan untuk menggunakan [Ubuntu 18.04 x64](https://ubuntu.com/download/desktop)\n(_CPU_ minimal 1 vCore, _RAM_ minimal 512 MB, _Storage_ minimal 10 GB SSD, dan _Bandwidth_\nminimal 500 GB), supaya memudahkan pengelolaan _server_ dengan mengunakan _script_\nVOXROW. Adapun langkah yang harus dipersiapkan adalah sebagai berikut:\n\n1. Pastikan telah ada _source-code_ VOXROW di komputer lokal dan _server_. Dapat\ndipergunakan perintah [Git](https://git-scm.com/) berikut ini:\n\n ```shell\n $ git clone --recurse-submodules -j8 https://gitlab.com/voxrow/library.git\n ```\n\n > Jangan jalankan perintah ini di _folder_ `root/` milik _server_!\n\n2. Masuk ke _folder_ `server/`:\n\n ```shell\n $ cd voxrow/src/server/\n ```\n\n3. Pastikan [GNU Make](https://www.gnu.org/software/make/) sudah ada, dengan\nmenjalankan perintah ini:\n\n ```shell\n $ . install/make_gnu.sh\n ```\n\n > _Script_ ini hanya dapat dipergunakan di Ubuntu Linux, instalasi untuk OS\n selain ini silahkan cari di internet.\n\n4. Jalankan perintah di komputer lokal dan _server_ sebagai berikut:\n\n - Komputer lokal:\n\n Pastikan terlebih dahulu bahwa _SSH Key Pair_ sudah dibuat, baca baik-baik\n instruksi dalam prosesnya! Berikut ini adalah perintahnya:\n\n ```shell\n $ sudo ssh-keygen\n ```\n\n Salin _public key_ komputer lokal ke _server_ dengan perintah ini:\n\n ```shell\n $ make local_ssh_key_to_server\n ```\n\n Ikuti instruksi yang dimintakan saat proses berjalan.\n\n > Masukkan alamat _server_ dan _username_ `root`.\n\n - _Server_:\n\n > Pastikan anda masuk sebagai _username_ `root`!\n\n ```shell\n $ make\n ```\n\n Ikuti instruksi yang dimintakan saat proses berjalan. Setelah proses berakhir\n _server_ akan _reboot_. Selesai _reboot_ masuk kembali dengan _username_\n baru yang telah dibuat.\n\n [GitLab CI/CD](https://docs.gitlab.com/ee/ci/) dipergunakan untuk mempermudah\n proses _release_ aplikasi. Registrasi [GitLab Runner](https://docs.gitlab.com/runner/)\n di _private server_ perlu dilakukan untuk proses [CI/CD](https://en.wikipedia.org/wiki/CI/CD),\n berikut adalah perintahnya:\n\n ```shell\n $ make register_runner\n ```\n\n Setelah seluruh proses selesai dijalankan, maka hapuslah _source-code_\n VOXROW dari _server_, karena sudah tidak diperlukan lagi. Perintahnya\n adalah sebagai berikut:\n\n ```shell\n $ sudo rm -rf voxrow/\n ```\n\n---\n\n## _Source-code_\n\n> Sebagai catatan beberapa perintah aplikasi di komputer lokal ini dapat berjalan\ndengan baik di OS MacOS dan Linux. Adapun untuk OS Windows perlu dilakukan sedikit\npenyesuaian.\n\n### _Editor_\n\n[VSCode](https://code.visualstudio.com/) (Visual Studio Code) dipergunakan untuk\nmemudahkan dalam penulisan _source-code_.\n\nBeberapa _extension_ VSCode dipasangkan untuk memudahkan penulisan _source-code_,\nantara lain:\n\n- [_Auto Markdown TOC_](https://marketplace.visualstudio.com/items?itemName=huntertran.auto-markdown-toc)\n- [_Markdownlint_](https://marketplace.visualstudio.com/items?itemName=DavidAnson.vscode-markdownlint)\n- [_Python extension for Visual Studio Code_](https://marketplace.visualstudio.com/items?itemName=ms-python.python)\n- [Jinja](https://marketplace.visualstudio.com/items?itemName=wholroyd.jinja)\n- [Better TOML](https://marketplace.visualstudio.com/items?itemName=bungcip.better-toml)\n\n### Repositori Git\n\nGit GUI [Sourcetree](https://www.sourcetreeapp.com/) dapat\ndipergunakan untuk memudahkan pengelolaan repositori, pada sistem operasi Windows\natau MacOS.\n\n_Branching model_ [Git-Flow](https://github.com/nvie/gitflow) dari Vincent Driessen\ndipergunakan untuk memudahkan pengelolaan _feature_, _release_, dan _hotfix_ di\ndalam repositori.\n\n### Tata Cara Penulisan _Markdown_\n\nBeberapa sumber ini dapat dijadikan acuan tata cara penulisan _markdown_:\n\n- [_GitLab: List of supported languages and lexers_](https://github.com/rouge-ruby/rouge/wiki/List-of-supported-languages-and-lexers)\n- [_GitLab Markdown_](https://docs.gitlab.com/ee/user/markdown.html)\n- [_Wikipedia: Markdown_](https://en.m.wikipedia.org/wiki/Markdown)\n- [Berkas readme.md yang dibuat oleh Ben Strahan](https://gist.github.com/benstr/8744304#file-readme-md)\n\n### Python\n\nDipergunakan [Python 3.8.0](https://www.python.org/downloads/release/python-380/)\n(versi minimal).\n\nDalam mengembangkan _source-code_ di komputer lokal, maka pertamakali perlu dibuat\n_environtment_ python dengan langkah berikut ini:\n\n1. Pastikan versi python yang dipergunakan sudah sesuai.\n\n ```shell\n $ python3 -V\n ````\n\n2. Buat _environtment_ python.\n\n ```shell\n $ python3 -m venv venv\n ````\n\n Instruksi terkait _environtment_ python yang dapat dipergunakan antara lain:\n\n - Aktivasi:\n\n ```shell\n $ . venv/bin/activate\n ```\n\n > Kembangkan _source-code_ dengan kondisi _environtment_ python sedang teraktivasi.\n\n - Deaktivasi:\n\n ```shell\n (venv) $ deactivate\n ```\n\n3. Pastikan [pustaka pendukung](requirements.txt) terpasang di _environtment_ python.\n\n ```shell\n (venv) $ pip install --upgrade pip && pip install -r requirements.txt\n ```\n\n---\n\n## Lisensi\n\nLisensi yang dipergunakan adalah [MS-RSL](LICENSE) (Microsoft Reference Source License).\n",
"bugtrack_url": null,
"license": "MS-RSL",
"summary": "VOXROW's library",
"version": "0.9.36",
"project_urls": {
"Repository": "https://gitlab.com/voxrow/library"
},
"split_keywords": [
"voxrow",
"library",
"raw sql query",
"airflow",
"sqlalchemy"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "401a92512389b1c7abc1cb2b8a10a5ca5e2abff784058955e4585970fc2f223e",
"md5": "c2d39b1e746c9fa1cda7d0bef76ef1ef",
"sha256": "9327164ae971e2a5b7e0066a8813e6aabf9e0734eb530a6bf54692ab5b2b91c2"
},
"downloads": -1,
"filename": "voxrow-0.9.36-py3-none-any.whl",
"has_sig": false,
"md5_digest": "c2d39b1e746c9fa1cda7d0bef76ef1ef",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7.13",
"size": 76276,
"upload_time": "2023-11-27T09:41:35",
"upload_time_iso_8601": "2023-11-27T09:41:35.893869Z",
"url": "https://files.pythonhosted.org/packages/40/1a/92512389b1c7abc1cb2b8a10a5ca5e2abff784058955e4585970fc2f223e/voxrow-0.9.36-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "11611d972cf66a27b3f53dd008f101e3df061ce5917cfec199ebb257f7fe1bf3",
"md5": "c1395c838dc8d293e78f780b9ffa858e",
"sha256": "4016c6ba72e63e0e7c3079ba73a8435adc5acafdc5b025b0d5ffb8ad7af60265"
},
"downloads": -1,
"filename": "voxrow-0.9.36.tar.gz",
"has_sig": false,
"md5_digest": "c1395c838dc8d293e78f780b9ffa858e",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7.13",
"size": 44158,
"upload_time": "2023-11-27T09:41:37",
"upload_time_iso_8601": "2023-11-27T09:41:37.840149Z",
"url": "https://files.pythonhosted.org/packages/11/61/1d972cf66a27b3f53dd008f101e3df061ce5917cfec199ebb257f7fe1bf3/voxrow-0.9.36.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-11-27 09:41:37",
"github": false,
"gitlab": true,
"bitbucket": false,
"codeberg": false,
"gitlab_user": "voxrow",
"gitlab_project": "library",
"lcname": "voxrow"
}
JSON