Code is there to explain the comments to the computer.
db-fw's Introduction
db-fw's People
db-fw's Issues
Vacation fields not consistent in VacationView
{
"ID":1,
"VacationType":"Kompensation",
"StudentID":4,
"Fullname":"Juliette Boulatova",
"FromDate":"2022-07-03 10:21:37",
"toDate":"2022-07-07 10:21:37"}
error in constructor
[08-Apr-2022 07:01:34 UTC] PHP Fatal error: Uncaught Error: Call to a member function setFetchMode() on bool in D:\Projekte\pm\classes\DB\PersistTrait.php:161
Stack trace:
#0 D:\Projekte\pm\classes\DB\PersistTrait.php(562): NeueMedien\test->thaw(1)
#1 D:\Projekte\pm\api\index.php(139): NeueMedien\test->__construct(1)
#2 D:\Projekte\pm\api\index.php(25): NeueMedien\doDelete(Array)
#3 {main}
thrown in D:\Projekte\pm\classes\DB\PersistTrait.php on line 161
better error handling in API
Enhance 500 error message with information from exceptions. Most error are due to typos in fields or filter.
User string[] buffer for insert and updates
inserts and updates need strings.
create ajax interface
Allow password types
These should be converted with password_hash(). Add a function to do password_verify(). When searching for a user/pass combination.
Hash function is a class variable.
float is not recognized
Problem is the regexp. /(.)((.))/
FR: No PDO EXCEPTION
PDO::ATTR_ERRORMODE = PDO::ERRMODE_WARNING
Check all interaction with PDOStatement for error handling.
Bug on doPut test
Uncaught Error: Object of class DateTime could not be converted to string in D:\Projekten\dw-fw\classes\DB\PersistTrait.php:553
persist abstract class
make persist an abstract class
implement the db dependent imp as trait DBPersist
Feature add Time to DateTime
Currently on Y-m-d is supported; add Y-m-d H:m:s support
Add PHP Doc for created classes
For ease of programming add php doc for all properties.
test for freeze
freeze is not finished yet
add config file
Database connection
Default namespace for discovered classes
NULL values are converted to 0 for float
The should throw an error
split persisten trait
one for CRUD (freeze/thaw/update/delete)
and one for iteratator findFirst/-Next, Where and Iterator functions.
add simple rest api get
Check fieldnames before checking type
add getJson createFromJson to PersistInterface
These are part of contract
Bug on doPut
PHP Fatal error: Uncaught Error: Typed property NeueMedien\test::$test_ID must not be accessed before initialization in D:\Projekten\dw-fw\classes\DB\PersistTrait.php:139
Other types for PK
Currently PK is int. make it other types as well
Add rest for search function
doGet /test/Name='Aaa'
as $Name = "*Aaa"
Decode url search parameters
for diagnostic data create one createResponse method
Containing a int backed enum with all possible 400-599 responses.
https://developer.mozilla.org/en-US/docs/Web/HTTP/Status
https://github.com/symfony/http-foundation/blob/6.2/Response.php
Turn the API into a class
a Singleton wich is setup with
- list of allowed routes.
change Start/End to dateFrom dateTo
in reservation, vacation and tasks?
needs database change
Flexible REST parameters
https://www.moesif.com/blog/technical/api-design/REST-API-Design-Filtering-Sorting-and-Pagination/
student?name=[like]*a*&lg=[gte]2021
[eq] or none = exact match
[gt] greater
[gte] greater or equal
[lt] lower
[lte] lower or equal
[like] like with * als joker
Multi column keys
Keys currently are single columns.
Make all generated classes final
Overriding is not tested and probably won't work.
Do not convert DateTime values
The setter now accepts null and string (when set from sql results) but it could also be a \DateTime in which case nothing has to be converted.
Add trait to format JSON
create a json string of the current record. preferable als second trait.
help text missing on admin_show_overview.php
<div id="help-text">
<h1>ADMIN - Hilfe<span id="help-text-close"></span></h1>
<p>Hilfe Text für Admin Report</p>
</div>
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.