- fork this repository
- clone and coding
- push and pull request to this repository
Database
:Sqlite3
orPostgreSQL
orMicrosoft SQL Server
with ORM (SQLAlchemy/Pydantic
)Programming Language
:Python 3
- user schema
{
"id": ?,
"userName":?,
"password": ?,
"email": ?,
"firstName": ?,
"lastName": ?,
"phoneNumber": ?,
"role": ?
}
- todolist schema
{
"id": ?,
"title":?,
"dueDate": ?,
"description": ?,
"userId": ?,
"completed": ?
}
- async/await
- pytest
- swagger ui
- add data to database
- show all data
- show data by id
- edit data and update to database
- delete data by id
- sort by last time created
- sort by last time updated
- select completed only
- show 5 data by page number
- show data by page number and limit data
- show x data by page number ; x = limit data
- dockerfile
- docker-compose
Database
: (Sqlite3
orPostgreSQL
orMicrosoft SQL Server
) andBigQuery
with ORM (SQLAlchemy/Pydantic
)Programming Language
:Python 3
- propertyType
{
"บ้านเดี่ยว": "S",
"บ้านแฝด": "D",
"บ้านเเฝด": "D",
"ทาวน์โฮม": "T",
"คอนโดมิเนี่ยม": "C",
"อาคารพาณิชย์": "B",
}
- bigquery-public-data.country_codes.country_codes
{
"country_name" : string,
"alpha_2_code" : string,
"alpha_3_code" : string
}
- main schema
- projects.csv to your database
{ }
- other schema
- import 2023-02-01_2023-02-28.csv to script
{ }
- async/await
- pytest
- swagger ui
- Aggregation data
2023-02-01_2023-02-28.csv
andprojects.csv
- group by and summary data
2023-02-01_2023-02-28.csv
byga:pagePathLevel1
andga:pagePathLevel2
- add country_name by cityCode (xxyy) from bigquery-public-data.country_codes.country_codes by start xx code
- example : 6644 (cityCode) -> 66yy -> Thailand (country_name)
- logoMediaId to logoMediaUrl (https://www.createder.com/media/xxxxx.jpg)
- filter by propertyType
- filter by country_name
- filter by cityCode
- filter price range
- dockerfile
- docker-compose
- NLP with PythaiNLP (custom corpus)
- OCR for Thai Language
- Search Engine with Elasticsearch and Kibana and PythaiNLP (custom corpus)
- Recommendation System with Image and Text
Good Luck!