-
Notifications
You must be signed in to change notification settings - Fork 5
/
notes.txt
112 lines (70 loc) · 3.74 KB
/
notes.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
Blog
http://sourceforge.net/u/sproketboy/blog/2012/04/simple-logging-wrapper-to-avoid-runtime-dependencies/
http://logwrapper.blogspot.ca/ (blocked by dzone)
*******
connection.getTypeMap() // interesting - might be worth checking into.
https://docs.oracle.com/javase/tutorial/jdbc/basics/sqlcustommapping.html
Not really useful for Persism - used with a CREATE TYPE SQL command.
******
SVN
https://persism.svn.sourceforge.net/svnroot/persism/
GIT
http://eikke.com/importing-a-git-tree-into-a-subversion-repository/
https://www.cis.upenn.edu/~bcpierce/courses/629/jdkdocs/guide/jdbc/getstart/mapping.doc.html
https://andresalmiray.com/publishing-to-maven-central-using-apache-maven/
MAVEN:
https://www.youtube.com/watch?v=bxP9IuJbcDQ
http://tutorials.jenkov.com/maven/publish-to-central-maven-repository.html
https://mkyong.com/maven/maven-jacoco-code-coverage-example/
https://duckduckgo.com/?q=maven+generate+code+coverage
MULTI JAVA
https://maven.apache.org/plugins/maven-compiler-plugin/examples/set-compiler-source-and-target.html
https://maven.apache.org/plugins/maven-jar-plugin/usage.html
https://maven.apache.org/plugins/maven-jar-plugin/
https://www.google.com/search?q=maven-jar-plugin+build+for+Java+8&oq=maven-jar-plugin+build+for+Java+8&aqs=chrome..69i57j33i22i29i30.4055j0j4&sourceid=chrome&ie=UTF-8
https://github.com/r2dbc/r2dbc-mssql/issues/36
https://stackoverflow.com/questions/1074843/is-there-an-oracle-equivalent-to-sql-servers-output-inserted
https://stackoverflow.com/questions/5469416/mysql-insert-with-output-like-mssql
SQL https://docs.microsoft.com/en-us/sql/t-sql/statements/insert-transact-sql?view=sql-server-ver15
MySQL https://dev.mysql.com/doc/refman/8.0/en/insert.html
Oracle https://docs.oracle.com/cd/B14117_01/appdev.101/b10807/13_elems025.htm
PostgreSQL https://www.postgresql.org/docs/9.5/sql-insert.html
// JTDS 1.2.5 for Java 6 for now
// JTDS 1.3.1 for Java 8 (see lib folder)
DATA TYPES
https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT012
https://db.apache.org/derby/docs/10.7/ref/crefsqlj31068.html
http://www.h2database.com/html/datatypes.html
Blob support only up to int max size (2,147,483,647)
Oracle not on maven...
https://stackoverflow.com/questions/9898499/oracle-jdbc-ojdbc6-jar-as-a-maven-dependency
mvn install:install-file -Dfile=persism-1.0.3b.jar -DgroupId=io.github.sproket -DartifactId=persism -Dversion=1.0.3b -Dpackaging=jar
mvn install:install-file -Dfile=persism-2.2.1a.jar -DgroupId=io.github.sproket -DartifactId=persism -Dversion=2.2.1a -Dpackaging=jar
Insert Records that the DB may generate autoinc or columns have defaults
Options:
1 FAIL with a nice error message
2 WARN that the Record is out of date since the insert
3 Change return for insert (others?) to return Object containing the new Record + the int count of rows changed?
4 Add a new insertRecord method (and updateRecord) etc....
notest
mvn install -Dmaven.test.skip
C:\Users\Dan\WebstormProjects\Persism\coverage\persism2
CODE COVERAGE
code coverage MetaData
DONE Add Table Mailbox - for Mailboxes "es" test
DONE Multiple view same name different schema names
DONE Test variable update statements + maybe insert statements
code coverage SessionHelper
* log.warnNoDuplicates("parent not found:").....
code coverage Session
DONE throw new PersismException("Could not retrieve value from column "... from field with no setter
code coverage Reader
DONE case for byte as boolean or byte as byte...? (not all dbs support this. do MySQL only)
code coverage Convertor
NO String to Time
NO String to LocalTime
NO util.Date to Time
NO sql.Date to Time
NO sql.Date to LocalTime
* ZonedDateTimeType or similar for warning coverage
* direct Clob or Blob fields for warning coverage