This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
drop table if exists medicines_import; | |
CREATE TABLE medicines_import ( | |
country text NOT NULL, | |
code text NOT NULL, | |
name text NOT NULL, | |
quantity int4 NOT NULL, | |
unit text NOT NULL, | |
CONSTRAINT medicines_pkey PRIMARY KEY (code, country) | |
); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
xsv join --no-case PRODUCTNDC product.txt PRODUCTNDC package.txt -d '\t' \ | |
|xsv select NDCPACKAGECODE,PROPRIETARYNAME,PACKAGEDESCRIPTION,DOSAGEFORMNAME \ | |
|xsv sample 10 \ | |
|xsv table |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import org.junit.Test | |
import java.time.* | |
import java.time.format.DateTimeFormatter | |
import java.time.format.FormatStyle | |
import java.time.temporal.ChronoField | |
import java.time.temporal.ChronoUnit | |
import java.time.temporal.TemporalAdjusters | |
import java.util.* | |
import kotlin.time.days | |
import kotlin.time.minutes |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
private val accentRegex = Regex("\\p{InCombiningDiacriticalMarks}+") | |
Normalizer.normalize("camión", Normalizer.Form.NFD) | |
.replace(accentRegex, "") | |
.toLowerCase(Locale.getDefault()) | |
.split(" ") |
OlderNewer