Git Product home page Git Product logo

google-sheets-tt's Introduction

Google Sheet reader and saver bot

This is BlogSite where i'll put my tutorials for other developers

Link on sheet: https://docs.google.com/spreadsheets/d/1Y9pLQIA8D0FuoyY5UM3Syqi5jyw-s3bqRHnLFyGnrPg/edit#gid=1950829608

Start project without docker

Hello, in the first, you sould clone rep:

  • Cloning repository:
git clone https://github.com/AktanKasymaliev/google-sheets-tt.git
  • Download virtual enviroment:
pip install python3-venv 
Setting enviroment: python3 -m venv venv
Activating: . venv/bin/activate
  • Install all requirements:
pip install -r requirements.txt
  • Create a file settings.ini on self project level, copy under text, and add your value:
[SYSTEM]
NAME=<db>
PASSWORD=<db>
HOST=<db>
PORT=<db>
USER=<db>
TG_TOKEN=<token>
CHAT_ID=<id>
  • This project working on Postgresql, so install him:
sudo apt-get update
sudo apt-get install python3-pip python3-dev libpq-dev postgres postgres-contrib (MacOS) / 
sudo apt-get install postgresql postgresql-contrib (Ubuntu)
sudo -u postgres psql
  • Enter in your postgresql, and create database:
sudo -u postgres psql
CREATE DATABASE <database name> owner <user>;
  • And finally start project: python schedule_job.py

Start project with Docker:

  • Create a file settings.ini on self project level, copy under text, and add your telegram bot token and your chat id value:
[SYSTEM]
NAME=postgres
PASSWORD=postgres
HOST=db
USER=postgres
TG_TOKEN=<token>
CHAT_ID=<id>
  • And finally start project: docker-compose up --build

google-sheets-tt's People

Contributors

aktankasymaliev avatar

Watchers

 avatar

google-sheets-tt's Issues

Slow code at first running!

When you start script for the first time, code will work slow
Solution:

  1. Add asyncio for asynchronization all processes
  2. Use code that do less work by O()

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.